Skip to main content
U
userleanadeklerk1412
March 17, 2022
Question

When I run a report on my VAT expenses acc for a specific period, that total amount does not show in my VAT report under expenses, only my VAT Sales. What should I do?

  • March 17, 2022
  • 1 reply
  • 0 views
When I run a report on the VAT Expense account, the total amount does not show in the VAT report under expenses, only my Sales do show. Keep in mind this is my first VAT report. So I am not sure if I have ticked all the boxes for the expenses to show.

1 reply

E
Ethel_A12
March 17, 2022

Hello there, @userleanadeklerk1412. I'll be sharing the steps to customize a report in QuickBooks Online.

 

You can run either a VAT Summary Report or a VAT Detail Report. Then you can customize the Report to include the details you want to show in the Report.

 

To personalize your Report, you can use different filters. The filters on most reports are the same. Some filters are available exclusively on specific reports.

 

Here's a rundown of what you can change:

 

  • General section: Change the accounting method, reporting period, and number format.
  • Rows/Columns section: Choose which rows and columns display on the Report.
  • Filter section: Select which customers, distribution accounts, suppliers, accounts, and products appear on the Report.
  • Header/Footer section: Choose what goes in the header and footer.

 

You can also memorize the customization to use the same format in the future. Check on this article for the detailed steps: Memorize reports in QuickBooks Online.

 

Let me know if you have additional questions about customizing a report in QuickBooks Online. You can click the Reply button below. I'm always around to help.

U
userleanadeklerk1412Author
March 23, 2022

Hi Ethel, thanks for your reply.  My problem actually is that, on my VAT detail report, only my sales are showing on the VAT report and not my purchases. At Supplier "All" is ticked.. But no Supplier VAT amounts are showing.  Also when I click on VAT on the left pane and the VAT return pops up - there is only an amount under "collected on sales" but R0 under "paid in purchases". However, when I click on Accounting in the left bar and I go to Chart of Accounts, VAT Expense and I run the report of the VAT Expense account, there is a total amount at the bottom of the report and I can see that the VAT for the expenses pulled through.  But it is not recording on the VAT return.  So this baffles me.  Why does my VAT Expenses not reflect on the VAT Report?  I so hope you can help me as this is my VAT report that I need to submit and am a bit lost.

C
Carneil_C
March 23, 2022

Thanks for getting back to us in the Community, @userleanadeklerk1412. I’ll help you with concern about your VAT expenses not showing up in your VAT Detail report in QuickBooks Online.

 

To see the expenses of your VAT Detail report, check if you’ve ticked and set up your sales rate and purchase rate when setting up your tax rates.

Here’s how:

  1. In the Tax Centre, select Add Tax.
  2. Choose which type of tax rate you want to set up.
  3. Enter the details of your tax rate
  4. Tick the This tax is collected on sales and This tax is collected on purchases box.
  5. Fill in the sales rate and purchase rate.
  6. Select Save when finished.


From there, you can run again the VAT Detail report.

 

Otherwise, I appreciate any details you can provide, like attaching a screenshot on this post. This way, I can provide you with the best resolution.

 

Here's an article you can refer to for more details on how to set up sales VAT rates and use them on forms.

 

Additionally, these are some good references that you can check out to learn more about VAT:

Keep me posted if you still have questions or concerns about taxes in QBO. I'll be around for you. Have a great day!

Terms & ConditionsAccessibility statement