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!