I have a custom Transaction report which does not show VAT amounts or Invoice Total including VAT. How to change this so that it shows VAT included totals?

communityoil · ‎October 16, 2019

Just want this total (inc VAT) to see what to pay supplier

BettyJaneB · ‎October 16, 2019

Thanks for keeping me updated about the steps that you've tried, @communityoil.

You have the option to pull up the Transaction List by Supplier report then customise it to include the tax amount and the open balance. Doing this will provide you the total amount that you need to pay to your vendor.

Let me guide you on how to achieve this goal:

Click on Reports at the left pane.
On the search box, key in Transaction List by Supplier.
Enter the date range of the transactions that you wanted to show up.
Tick on the Setting icon on the upper right corner of the report.
Hit the Show More button to expand the customisation options.
Put a check-mark to the Open Balance and Tax Amount boxes.
Then press the Run report button.

On the other hand, running the Unpaid Bills report will also give you the same amount of information.

That should do the trick, communityoil.

Here are some resources that you can check out about customising reports in QuickBooks Online for your reference:

Please know that I'm just a post away should you have any other questions concerning QuickBooks. I'd be pleased to help you out. Take care!

View solution in original post

John C · ‎October 16, 2019

Hi communityoil

Not all reports allow you to add the VAT columns. If the report does allow you to add the columns you can do this by selecting the small cog icon located at the top of the report on the right hand side > show more and select Tax Amount and Net Amount > Save customisation > save.

communityoil · ‎October 16, 2019

John C

Thanks for your reply. I've added columns for Tax Amount and Net Amount as you suggested but still the Amount column shows pre-VAT and is totalled at bottom and the Tax Amount column shows the tax amount also totalled separately at bottom. All I am trying to show is the total amount that we need to pay to a selected supplier over a selected period of time. I know that I can add the pre-VAT and the Tax amounts together myself but surely the report should be capable of that. Is that not we are paying Intuit for? Please advise

BettyJaneB · ‎October 16, 2019

Thanks for keeping me updated about the steps that you've tried, @communityoil.

You have the option to pull up the Transaction List by Supplier report then customise it to include the tax amount and the open balance. Doing this will provide you the total amount that you need to pay to your vendor.

Let me guide you on how to achieve this goal:

Click on Reports at the left pane.
On the search box, key in Transaction List by Supplier.
Enter the date range of the transactions that you wanted to show up.
Tick on the Setting icon on the upper right corner of the report.
Hit the Show More button to expand the customisation options.
Put a check-mark to the Open Balance and Tax Amount boxes.
Then press the Run report button.

On the other hand, running the Unpaid Bills report will also give you the same amount of information.

That should do the trick, communityoil.

Here are some resources that you can check out about customising reports in QuickBooks Online for your reference:

Please know that I'm just a post away should you have any other questions concerning QuickBooks. I'd be pleased to help you out. Take care!

communityoil · ‎October 17, 2019

BettyJaneB,

Thanks for your response. Nearly made it! I tried Transaction List by supplier as suggested and the report produced each invoice total under the Open Balance and Amount columns over the chosen period. Great! However, there were no totals at the bottoms of each column. Must I add that up by hand? Please advise.

I also tried the Unpaid Bills Report but that will not allow a period of time, only an "as of" single date.

I'm sure you have the answer to getting column totals in reports. Wait to hear.

MirriamM · ‎October 17, 2019

Hello again, communityoil.

I appreciate you getting back to the Community and keeping us updated.

Right now, the option to have the totals to show at the bottom of each column isn't available. I understand how the workflow you're looking for is beneficial to your business. For the meantime, what you can do is to export the report. Then from there, you can manually enter the totals at the bottom of each column.

Though our Feedback Board has already closed, I can pass a request here on my end about this feature. For the time being, you can visit our blog and register to our Newsletter. This way, you’ll receive email updates about what new changes and features, and hopefully your suggestion would be one of them.

In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBO Self-Help.

If you have follow up questions concerning your QuickBooks Online account, please keep me posted. I am more than happy to further help.

Topics

Training

Community

Resources

I have a custom Transaction report which does not show VAT amounts or Invoice Total including VAT. How to change this so that it shows VAT included totals?