Forum Discussion

Dan_RPS's avatar
Dan_RPS
Experienced Cover User
5 years ago

Tax Amount Variance - rounding issue

The tax amount variance repoort shows 1 cent variance for some of our sales.   May I know if any chance I can fix them, I tried to retype the sales figure but seems nothing changed.   Thanks in a...
  • CloverQ's avatar
    CloverQ
    5 years ago

    Hi Dan_RPS 

     

    If there are transactions showing on the Tax Amount Variance report, it usually means any tax amounts were manually changed in those transactions. It can also occur if the transaction were imported, and some figures in the import file were edited. 

     

    What you'll need to do is open each transaction listed on the report, and verify if the current tax amount is correct or not. You can click on the arrow next to the arrow next to the Tax amount > use 'Recalculate' to force the total tax amount to be recalculated. 

     

    If it's an item sale, please also verify if all the unit prices are correct. You can take a screenshot of the transaction details, then re-enter the same unit prices in the Price column. The reason behind it is that some import transactions may had item prices with more than 4 decimals, but AccountRight only allows/displays 4 decimal places for unit pricing. Manually over-typing the unit price will get rid of any possible hidden decimals.

     

    You can also try change the 'Tax inclusive' ticking of the transaction > Save > change it back (then overwrite the unit prices if needed) to force a system recalculation as well.

     

    I hope this helps. Please feel free to let us know how you go, and if you have any further questions.

CloverQ's avatar
CloverQ
Former Staff

Hi Dan_RPS 

 

If there are transactions showing on the Tax Amount Variance report, it usually means any tax amounts were manually changed in those transactions. It can also occur if the transaction were imported, and some figures in the import file were edited. 

 

What you'll need to do is open each transaction listed on the report, and verify if the current tax amount is correct or not. You can click on the arrow next to the arrow next to the Tax amount > use 'Recalculate' to force the total tax amount to be recalculated. 

 

If it's an item sale, please also verify if all the unit prices are correct. You can take a screenshot of the transaction details, then re-enter the same unit prices in the Price column. The reason behind it is that some import transactions may had item prices with more than 4 decimals, but AccountRight only allows/displays 4 decimal places for unit pricing. Manually over-typing the unit price will get rid of any possible hidden decimals.

 

You can also try change the 'Tax inclusive' ticking of the transaction > Save > change it back (then overwrite the unit prices if needed) to force a system recalculation as well.

 

I hope this helps. Please feel free to let us know how you go, and if you have any further questions.

Smiley70's avatar
Smiley70
Contributing User
5 years ago

These 1c variances when running the Company Data Auditor have been appearing since longer than I can remember in the new versions and not once has it ever been because there's been a manual adjustment or import transactions etc. Like many others, I have never mentioned it before for fear of sounding trivial. But when it's constantly the only red question mark when runnning the Data Auditor, it's a bummer!  ( These annoying 1c variances never occured on the old desktop versions.)

  • CloverQ's avatar
    CloverQ
    Former Staff
    5 years ago

    Hi Smiley70 

     

    The Company Data Auditor is merely picking up variances for that period selected, and prompting for a review of these transactions, the current tax amount may or may not need to be changed. 

     

    While I cannot tell what work flow/history your company file had in the past, I do suggest clicking into each transaction picked up in the variance report, force a tax recalculation by using the methods explained in my initial reply. This will ensure the tax calculation right now is correct, before closing off the period.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.