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

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

All the reports I've tried either don't show the VAT element of the debtors/creditors or show a VAT element that either doesn't reconcile back to the debtors/creditors properly or ignores the part-paid element of some invoices. Necessary for cash basis VAT clients to reconcile their VAT accounts at year-end, I can't believe that QuickBooks doesn't have this report as standard.
Solved
Best answer October 07, 2020

Accepted Solutions
Ashleigh1
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hello Damon, 

 

Having had a look into this more for you, there is no exact report that will show you exactly what you need. 

 

We suggest you leave feedback in the main cogwheel in the product. 

View solution in original post

13 REPLIES 13
Ashleigh1
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hello Damonw-philipbar, 

 

Welcome to the Community page, 

 

 

Have you looked at the vat detailed report and customised it so it shows exactly what you are wanting to see? 

 

 

 

Damon W
Level 1

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi,

 

Thanks for the reply, that's the key problem. I don't know how to customize the report to show exactly what I am looking for. I've spent quite a while speaking to representatives from QuickBooks and haven't had anything of use from them as yet.

 

The VAT detailed report shows the VAT transactions for a given date range which isn't what I am looking for. I am looking for something that shows the VAT element on the outstanding invoices (both payable and receivable) at a specified date.

 

Let's say for example that my debtors as at 31/03/2020 were £6250. I need a report that shows the breakdown as follows (showing it as either a total, per supplier or per invoice would all be equally useful)

 

CustomerOutstanding BalanceVATNet
Customer A£2400£400£2000
Customer B£1800£200£1600
Customer C£700£0£700
Customer D£1350£225£1125
Total£6250£825£5425

 

As you can see, this shows the VAT due on the invoices outstanding at the year-end. Other software providers are able to provide this report with ease, I honestly can't believe that QuickBooks would struggle with it.

Ashleigh1
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hello Damon, 

 

Thanks for coming back to us, 

 

Try transaction list by customer report, again you can customise this report to show the specific things you want to look at. 

Damon W
Level 1

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi Ashleigh,

 

I have had a look at that report before and as I previously mentioned, the report doesn't show what I am looking for. This is (most likely) due to that report being transactional rather than based on the balance. I.e. if an invoice has been partially paid, then only part of the VAT is still outstanding which that report can't/won't show.

 

I am beginning to think that this isn't a function that QuickBooks offers sadly.

Ashleigh1
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hello Damon, 

 

Having had a look into this more for you, there is no exact report that will show you exactly what you need. 

 

We suggest you leave feedback in the main cogwheel in the product. 

View solution in original post

JackS
Moderator

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi there, for your information, we now have the ability to add the outstanding VAT to the aging reports in QuickBooks by customising the report and adding the column called 'Outstanding VAT'. 

samanne25
Level 1

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

When I click this item, nothing shows up on the report.  What do I do now???

GeorgiaC
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi samanne25, do you have open overdue transactions with VAT within the specified report period? 

samanne25
Level 1

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Yes, it doesn't matter what dates I put in, nothing comes up in the OS VAT column.

I need to know at the year end what the VAT on accs receivable & payable is and I've ended up having to manually go through each item.  Surely this needs to be a standard report???

GeorgiaC
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Thanks for getting back to me and checking that samanne25, we've raised a reported issue for this today and our technicians are tracking this on the following investigation - INV-62122 - Reports - the outstanding VAT option is not showing any values on any report. I've linked you to this so that you'll receive all updates going forward via email, if you have any further issues, please get back to us below. 👩‍💻

AB74
Level 2

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi

Outstanding VAT used to display on aged debtors and creditors detailed. With clients where I have enabled the DRC VAT codes, outstanding VAT no longer shows. With clients where DRC VAT is not relevant I can still see the outstanding VAT.

As DRC does not relate to all customers/suppliers, I still need to see outstanding VAT. Is this no longer possible? If not, is it an issue you seek to address?

ChristieAnn
QuickBooks Team

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi there, AB74.

 

Thank you for visiting again the QuickBooks Community. I'll be sharing some information and troubleshooting steps to ensure that the outstanding VAT shows in your QuickBooks Online.

 

The option to see the outstanding VAT in QuickBooks Online is still possible. You can always perform this by running the  Accounts receivable ageing detail or Accounts payable ageing detail report and customized it. 

 

 

If you're unable to view the outstanding VAT from the reports, a cache full of history and temp files might be its reason. I recommend logging in to your QuickBooks account using a private browser. This is to rule out the possibility of a webpage issue, and private browsing doesn't store local files or cache.

 

Use these keyboard shortcuts based on the browser you're using.

 

  • For Firefox or Microsoft Edge, press Ctrl + Shift + P.
  • For Chrome, press Ctrl + Shift + N.
  • For Safari, hold down Command + Shift + N.

 

If it works in incognito, I recommend clearing the cache of your regular browser. This removes the history or log of sites so you can start with a clean slate. You can check this article to see the steps: Clear cache and cookies to fix issues when using QuickBooks Online.

 

If the steps above didn't work, use another supported browser as alternatives.

 

Lastly, you can open this article to view different details about VAT exceptions and how it works: VAT exceptions and reports in QuickBooks Online.

 

If there’s anything else I can help you with outstanding VAT data, click the Reply button and post a comment. I’ll jump right back in to assist further. Have a good one.

AB74
Level 2

How would I generate a report that shows a breakdown of the VAT on debtors/creditors at a specified date? All the ones I've tried either don't show VAT or done reconcile.

Hi

It won't be anything to do with the cache etc as it was literally only happening with clients where the DRC VAT codes were enabled.

I have checked all clients this morning for confirmation, to find that they now all work. So whatever it was has righted itself at some point along the way.

Need to get in touch?

Contact us