Taxes charged on Invoices (Sales & Purchases) with more than one line of data

SOLVED

I am using Sage Pro and have an issue when doing Sales and/or Purchase invoices.  

In speaking with chat the problem appears when entering more than one line on an invoice.  Example: Using two lines enter 1st line total of 97.50 and second line total of 274.45 with 13% tax rate.  

The above shows taxes of 48.36 when the actual tax should be 48.35.  

When I adjust the tax to 48.35 then the invoices are printed with the message of HST, not included showing -0.01.  

Chat tells me this is because the lines are rounded individually.  Tried a test of showing the sub-total of 371.95 and then the tax was correct.

Was told to use a rounding line on the invoice but the tax was not adjusted to reflect the penny difference.

Is anyone else having this problem?  Should the rounding be only done on the sub-total as other program do?  Sage please help this rounding issue, as invoices showing HST not included does not look really professional.

  • 0

    I use ADP to upload my invoices and at time the tax is a few pennies off.  I go by what ADP gives me and adjust Sage accordingly as the client will pay what ADP tells them to pay. Yes it's a pain as I don't always catch it but its really easy to fix and only takes a few seconds. It's not a big deal if you add or deduct pennies to your Invoices.  It will all match at the end of the year.  Just click on the Looking Glass beside the Tax amount in the bottom of your Invoice and adjust the number.  Yes you will see -0.01 on your Invoice but that is ok. I have to do the same when I enter my Payables.  My rounding and the suppliers are not always matching. (In your Payable you can fix your tax on each lines if you prefer but I don't think it's doable in the Receivable Invoices. This way you will not see the -0.01 on your Invoice).

  • 0 in reply to LaChapa

    there is no right way / wrong way, some systems calculate tax by line, some systems calculate tax using the subtotal

    as long as they are consistent, both are acceptable

    calculating by line is useful if you have multiple taxes, which may or may not apply to each line

    if you are creating the original invoice, it won't matter, tax is what tax is

    if you are recording an existing invoice (manual or other system), you'll should be able to adjust one of the line by a penny (+/-) so the tax and invoice total matches the existing invoice

  • 0 in reply to Roger L

    I can adjust tax on a purchase invoice on the line however when using a sales invoice it does not show the tax total on the line so I cannot change it there to match the other programs used.  That is where my problem lies.  

    The only place to adjust on the sales invoice is the tax entry and then the hst, not included message appears and I do not want to send an invoice with that message on it.  Any suggestions?

  • 0 in reply to User2
    verified answer

    User2

    In both Purchase and Sales invoices, you can select any line and hit Ctrl-Y to adjust the taxes on each line.  In Sales this will prevent the 0.01 not included message from showing on the sales tax area of the printed invoices.  If you want to use the menus, in Purchases it's on the Purchase menu, in Sales it's on the...you guessed it, Sales menu called Tax Summary for line.  In Purchases when you have more than two taxes in the file, you can double-click the Amount column to get to the same place.

    Sage 50 does calculate tax per line and rounds off before adding it up.  Good or bad, right or wrong, that's the way it was originally programmed and the CRA is ok with it from what I understand, as long as it is consistent.

  • 0 in reply to Richard S. Ridings

    Thank you so much as I did not know about Ctrl-Y

  • 0 in reply to User2

    will give this a try too :)