Skip to main content
E
elliotmch
July 21, 2023
Question

VAT issues with invoices and sales receipts

  • July 21, 2023
  • 1 reply
  • 0 views

When creating a Sales Invoice where amounts are 'inclusive of VAT', the VAT is calculated by Quickbooks by rounding down rather than up.  e.g.

 

In Quickbooks

Rate:       £474.99

Quantity: 1

VAT:         20%

VAT Total: £79.16 

 

However, the VAT is actually £79.165 so should be rounded up to £79.17.

Therefore the totals do not match my Sales System receipts (Shopify) which correctly rounds VAT up.

 

Solution please?

 

 

1 reply

LieraMarie_A
LieraMarie_A
July 21, 2023

Hello there, @elliotmch. I understand the importance of having accurate calculations for your invoices and sales receipts.

 

To address this, you'll want to manually calculate and enter the VAT amount with the appropriate rounding. This help ensure your VAT amounts align with your Shopify sales system receipts. 

 

Here's how you can do it:

 

  1. Calculate the VAT amount manually.
  2. Round the calculated VAT amount to the nearest two decimal places.
  3. Enter the rounded VAT amount (£79.16) directly into the VAT field when creating the invoice.

 

Additionally, you can make VAT adjustments in QBO to correct errors in VAT-related transactions in your accounting records. 

 

If you need further assistance or have any additional questions about recording adjustments, please don't hesitate to ask. We're always around to help.

Terms & ConditionsAccessibility statement