Rounding issue when I enter an invoice

Junliang Chen

Hi Guys

I am running a franchise bussiness and using Reckon Accounting Hosted Edition Software as required.
Basically I have to "enter invoices" and "receive payment" for all my jobs and to match franchise RCTI sheet.
Today when I entered an invoice of net payment $138.65, Reckon automatically apply tax of $13.87, then total gross amount is $152.52. if I use this amount then my account that month ending will be $0.01 rounding difference with my RCTI amount,
However I've calculated by muself, it should be $152.515, and if I use of $152.51 amount, then it perfectly match my RCTI amount.

Does anyone know how to "fix" or "configurate" setting to use of $152.51 amount?!

I've searched this forum and found someone mentioned to 'edit' tax amount, I've done that but my tax amount column still greyed out and can't be edited.

Thanks a lot

Jacqui Allen

Select amount include GST on the form and enter the gross amount

Linda ABC

If Jacqui's suggestion doesnt work - create a rounding item and then use this to balance out the invoice/RCTI... In the past 17 years we have all had to learn that gst doesnt always match from system to system - it all comes down to whether the system multiplies out the qty x rate and then adds gst or if it multiplies the rate x the gst and then by the quantity... and it depends very much on the size of the rate...  and qty values... its not worth stressing over - just use the GST inc method or a rounding item and then get on with life..

Junliang Chen

Thanks very much, it fixed my issue:)

Junliang Chen

Thanks very much and appreciated for your help, it was very stressful as I don't know Reckon very well, I knew the issue but didn't know how to fix it:)
Thanks again

Toni_9025747

I have this issue all the time, with my GST amounts always being .01 cent out from my supplier invoices and do not enter with Gross Amounts due to most supplier invoices showing exclusive amounts only.

You are able to edit your tax amount with the following steps:

 - Select the EDIT menu
-  From the drop down menu Select: Preferences (a box will open up)
-  Select:Tax
- Your will see 2 tabs: Select: Company Preferences (only available in single user mode)
-  Do you want to edit your tax amounts - Check: YES
- OK 
Your tax amount coloum will no longer be GREYED OUT.

Wendy Veal

My preferences are selected as above but my gst column is still greyed I would prefer to change the tax amount for for rounding but I am forced to change the invoice gross. Is this what people are generally doing?

Toni_9025747

See pic below as per my settings to see if there are any variances in your setup or as explained above , entering Gross amounts which will stop rounding issues.  (for me entering Gross amounts would mean more time spent on each supplier invoice, easier to change the GST amount by 1 cent)

Wendy Veal

Thanks Toni
I have gross (not net) selected in sales figures which i don't think should matter but I don't have a default tax code selected. As soon as i can get into single user mode i'll try matching yours as above and see how it goes.