cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - intuit.me/31Nl3My
lkoups
Level 3

Report showing VAT income and non VAT income

Hello, I am looking for a report that will show me income that is VATable over a period of time and income that doesn't attract vat- is it possible to get in one report? I can do this by creating a P&L report and then a separate VAT 100 report but ideally I want on one report. Thanks!

Solved
Best answer January 11, 2021

Accepted Solutions
lkoups
Level 3

Report showing VAT income and non VAT income

Perfect- exactly what I need! Thank you

View solution in original post

8 REPLIES 8
BettyJaneB
QuickBooks Team

Report showing VAT income and non VAT income

I'll be your guide in creating one report for VAT and non-VAT income, @lkoups.

 

You can export the P&L and VAT 100 reports to Excel  separately. This way, you'll be able to modify it from there to generate one report for VAT and non-VAT income.

 

To export a report, just click on the export button at the top of the report and choose Export to Excel. Please see the sample snip for your reference:

 

To learn more about the different reports that you can pull up and customise in QuickBooks Online, feel free to check out this link: Learn which reports are available for your version of QuickBooks Online.

 

Moreover, I know how beneficial it would be to run a single report automatically that contains the VAT and non-VAT income in QBO. Our developers are continuously considering new features to be added to the system to cope with your business needs.

 

I encourage you to visit our QuickBooks Online Blog site to be updated with our latest product news and enhancements. 

 

Let me know if there's anything else that you need. I'll be right here to assist you. Stay safe!

lkoups
Level 3

Report showing VAT income and non VAT income

Thank you- if I export to excel, how do I prevent overlap? For example, the P&L will include the VATable elements as well? Thanks

Rose-A
Moderator

Report showing VAT income and non VAT income

Exporting the Profit and Loss report will not include the VATable elements, lkoups.

 

The Profit and Loss report will only show all your income and expense accounts. As long as you're pulling up the correct and accurate reports, this will not overlap the details when exporting them into Excel.

z.PNG

 

I recommend customising the report to get the specific details you need. You can also memorise it to save its current customisation settings. It serves as your record and helps you quickly access it for future use.

 

I'll be around to help you if you have additional questions regarding exporting reports in QuickBooks Online. I want to make sure I've got you covered. Have a good one.

lkoups
Level 3

Report showing VAT income and non VAT income

Thanks- so the P&L for income will show a total amount that will include invoices that have a VAT element and the VAT 100 will show the amount for the P&L that are VATable?

katherinejoyceO
QuickBooks Team

Report showing VAT income and non VAT income

Hello @lkoups,

 

As mentioned by my peer @RoseMarjorieA, the Profit and Loss report will not include the VATAble elements. 

 

To produce a VAT Detail report, you can go to ReportsAll ReportsManage VAT, and select the VAT Detail Report.

 

You can also view it from the VAT center. Just go to VATPrepare Return, hover over the amounts, and click on View Transactions.

 

For future reference, you'll want to filter your report to show details that matter to you and your business. Read through this article for more insights: Common custom reports in QuickBooks Online.

 

Let me know if you have additional questions. I'm always delighted to help. 

 

 

lkoups
Level 3

Report showing VAT income and non VAT income

Sorry, I’m a bit confused about your reply. I thought that the profit and loss would include the income portion of the VAT element and would not exclude it? The VAT 100 revolt would include the income and the VAT element. The profit and loss shows income and doesn’t distinguish whether it is VAT or not VAT

Adrian_A
Moderator

Report showing VAT income and non VAT income

I appreciate you for getting back to us, lkoups.

 

We can customize the Profit and Loss report to include whether the transactions are taxable or not. Let me guide you with these steps:

 

  1. Click the Reports tab.
  2. Enter and select Profit and Loss Detail.
  3. Click the Customise button.
  4. Go to the Rows/Columns drop-down.
  5. Tick the VAT Code and Tax Amount.
  6. Click Run report.

 

If you want to save the same set of customization, you can memorize it.

 

I'm just a post-away if there's anything that I can help. Keep safe!

lkoups
Level 3

Report showing VAT income and non VAT income

Perfect- exactly what I need! Thank you

View solution in original post

Need to get in touch?

Contact us