Hi,

 

I'm trying to import Sales Receipts with VAT inclusive amounts but am coming up against what I think is a rounding issue.

 

I have the mapping set to TaxInclusive and 20.0% S, and have read the article which shows the 'convert gross to net' workaround is necessary otherwise QBO adds on VAT to the already inclusive amount. Good idea but there seems to be a rounding error, for example an item with an amount of £5.49 is importing as £5.50.

 

I can only assume that Axis is converting the gross to net and then rounding before QBO changes it back to gross from the rounded amount?

 

I.e. £5.49 / 1.2 = 4.575

 

4.575 rounded to 2 decimal places is 4.58

 

4.58 x 1.2 = 5.496

 

5.496 rounded is £5.50.

 

Any advice on how to avoid this issue please?

 

Kind regards

Luke