Tax doesnt round - doesnt match supplier invoice

Brad J Yesberg

I have a supplier Invoice that is $8.00. GST divided by 11 equals 0.727 or 0.73 as per the invoice. Reckon One shows the tax amount as 0.72 and therefor does not match my records and supplier invoice. How do I fix this? Thanks in advance

Qwerty

01/03/17

Hi Brad,

I believe it will be due to your configuration. For example when I enter a bill and specify a gross amount of $8.00 my tax amount is $0.73.

Gross amount $8.00
Tax amount $0.73
Net amount $7.27



Q1: Is your bill set to use gross amounts or net amounts? The bill header should indicate this.

Q2: Are you using an item or an account on the bill for this $8.00 entry?

Q3: Can you possibly upload an example screen shot?

Brad J Yesberg

Hi, the bill is set to use gross amounts.
I am using an item.
Screen shot attached.
Thank you for your help!lp.

Qwerty

It looks like both examples are doing correct calculations. The reason why there is a 1 cent different is due to rounding. 

Single line example
Line 1 has a gross amount of $8.00. Tax for this line is 8 / 11 = 0.7272727272727273 (0.73 to the nearest cent)

Result = 0.73 tax, 7.27 net & 8.00 gross

Two line example
Line 1 has a gross amount of $5.00. Tax for this line is 5 / 11 = 0.4545454545454545 (0.45 to the nearest cent)
Line 2 has a gross amount of $3.00. Tax for this line is 3 / 11 =  0.2727272727272727 (0.27 to the nearest cent).

Result = 0.45 + 0.27 = 0.72 tax, 7.28 net & 8.00 gross

Brad J Yesberg

Hi Qwerty, Thank you. Yes the calculation is correct, the rounding is what the core issue is. 
As per my Reckon invoice, the GST paid is 0.73. My data entry must match my invoices. Reckon software should round accordingly to maths rules as per the invoice they sent me (and every supplier). 

Qwerty

My suggestions

a) Enter a single line bill to get a 0.73 tax amount

or

b) Edit the tax amounts on you bill entry 

Reckon One does have a setting where you can modify tax amounts. To enable this setting, click the cog icon (located top right of the application) > Settings > Tax settings > General > Enable the option 'Allow user to edit tax amounts'. 

Once enabled you can edit the tax amounts in your transactions.