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?

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.

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.

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:

• VAT Detail Report.
• Set up and use VAT in QuickBooks Online.
  
  

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

Hi there, I am unable to add my screen shots here , when I post it, it returns with a authentication error message.

Can I attach more than I file?

Can I send you a direct email as I cannot attach my screenshots here?

Thanks for taking the time to add a screenshot to this thread, @userleanadeklerk1412.

Let me join in this conversation and help you accomplish your task in QuickBooks. 

Sometimes too much cache stored in a browser can cause the authentication error message. This might also be the reason why the VAT detail report isn't showing the supplier's VAT amounts. 

To verify, let's run some basic troubleshooting steps. Let's start by accessing your account using a private window. This doesn't save your browser's history and will help us isolate the issue. Simply press the following shortcut keys to access this mode: 

• Ctrl + Shift + N (Google Chrome).
• Ctrl + Shift + P (Firefox).
• Control + Option + P (Safari).

If you're able to add the screenshot or see the VAT amounts, go back to your regular browser and clear its cache. Alternatively, you can use other supported browsers if the issue persists. 

Additionally, you can customise reports in QuickBooks. This way, it would be easy for you to review the details that matter the most to your business. 

Let me know if there's anything else that you need about this or with QuickBooks. I'll be around to lend a helping hand. Have a good one!

Did you receive my screen shot?

Hello there, userleanadeklerk1412.

We haven't received a screenshot. I suggest sending us again together with your reply on this thread. This way, we'll have a better picture of what happened.

In the meantime, to learn more about running reports in QuickBooks Online (QBO), see the below articles:

• Run reports in QuickBooks Online
• Customise reports in QuickBooks Online

For future reference for tips and related articles about the "How Do I" steps in QBO, visit our QuickBooks Community help website.

Looking forward to hearing from you. Take and have a great day.

Hi Reymond, Thanks for your help.  I did all that but part of my info is not showing.  I need someone to help me with the setup of my VAT. because there is something I am missing.  

I appreciate your time and providing the screenshot, @userleanadeklerk1412.

Based on the screenshot, you've shared we can check the Accounting method and set them up as Accrual. Then, try to pull up the same report if there are any changes and the VAT will show. For more details about accounting methods, see this article: Choose between cash and accrual accounting methods in reports.

If the issue persists, I'd suggest contacting our Customer Support Team. They can pull up your account and help you fix these transactions.

Here's how to reach them:

1. Sign in to your QuickBooks Online (QBO) company.
2. Go to the Help menu.
3. In QB Assistant, enter the topic you need help with. You can also enter questions.
4. Select Contact Us to connect with a live support agent.
5. Choose the Start a chat option.

I'm also sharing these great articles with some reports to help you with VAT processing in QBO:

• VAT Feature Update FAQ
• Tax Center QBO
• Reports in QuickBooks Online

Please know that I'll be right here to help you if you have any other questions about running reports in QBDT. I'll be always happy to help you. Stay safe, @userleanadeklerk1412.