VAT rounding in Other Payment

SUGGESTED

I'm struggling to accurately enter an expense in 'Other payments'. 

My receipt has inc and exc VAT amounts shown, so I've entered those and all is correct - until I get to the total paid, which is a penny out. Obviously Sage is not recording rounding the same as the supplier. 

On a regular purchase invoice entry the numbers can be manually adjusted to account for these rounding discrepancies, but not in an expense by Other Payment. Every time I change the figure in a net amount, VAT amount or the line total, another column changes automatically too, so it's still incorrect. 

I also cannot save it with a separate line for the adjustment as it needs to be a minus figure, which is not allowed!

Why is this? They really are a one-off supplier, cash purchase, so I didn't want to have to add them as a new supplier, but it looks like I will have to in order to get around it... unless I'm just having an off day and can't see what's staring me in the face Laughing

  • 0
    SUGGESTED

    Hi ,

    Thanks for using Sage City.

    Apologies for any delay in responding to your query.

    The program does round (as SBC only goes up to two decimal places) however you should be able to enter the Vat column and adjust this manually on the transaction. 

    You can also view more guides available on our help centre here;

    help.accounting.sage.com/.../Home.html

    Regards,
    Rob
    Sage UKI

  • 0 in reply to Rob Smith.

    Hi Rob, 

    Yes, I can change it; however, as explained in my original post, when doing this on the 'Other Payment' screen it will automatically change the total too - not what I want when I only need to adjust VAT by a penny. 

    E.g. I have been given a receipt:

    • Item 1 @ £5.63 (+ VAT £1.12) = £6.75
    • Item 2 @ £1.67 (+ VAT £0.33) = £2.00
    • Invoice total £ 8.75


    The receipt shows the VAT on Item 1 rounded down to 1.12 (from 1.126) but Sage wants it to be 1.13. Fine, that's what I would expect and on a purchase invoice I would adjust the 1.13 back to 1.12 and all is well. 

    BUT in the Other Payments screen this does not happen. I change the VAT from 1.13 to 1.12 and the line total automatically changes to 6.76 making my receipt total 8.76. I change the line total and the VAT automatically adjusts itself again, always leaving me a penny out. 

  • 0 in reply to Annie W
    SUGGESTED

    Hi ,

    Thanks for using Sage City.

    Thank you for the information, I have tested the other payment issue in our data and can adjust this, this lowers the total to what I'd expect, this is the other payment in test data.

    I would advise to test this in another browser to eliminate any browser auto fill issues.

    You can also view more guides available on our help center here;

    help.accounting.sage.com/.../Home.html

    Regards,
    Rob
    Sage UKI