cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
heather12
Level 2

Hi. Is there a way to create a profit and loss report that shows gross (inc VAT)?

 
2 REPLIES 2
Kristine Mae
Moderator

Hi. Is there a way to create a profit and loss report that shows gross (inc VAT)?

Hello there, Heather12.

 

The VAT amount will not show on the Profit and Loss report. This is because the VAT Control and VAT Suspense accounts are both liabilities. You can pull up the Transaction Detail by Account report instead. Customise to it show all income and expense accounts, add the VAT column, then export it to manually calculate the gross amount.

 

Here's how:

  1. Click Reports, then enter Transaction Detail by Account in the Find report by name field.
  2. Click Customise.
  3. Click Rows/Columns, then click Change columns.
  4. Choose Tax amount.
  5. Click Filter.
  6. Click the Distribution Account drop-down arrow, then choose All Income/Expense Accounts.
  7. Click Run report.
  8. Click the Export icon, then choose Export to Excel.

I've attached a screenshot as your reference.

 

We're just here if you need more of our help. Have a good day! 

 

heather12
Level 2

Hi. Is there a way to create a profit and loss report that shows gross (inc VAT)?

Great, thanks Kristine Mae. I'll have a play around!

Need to get in touch?

Contact us