Rounding problem

Yes, it does. If you read the Guide @dcVest linked to above, you will see that there are two approaches. The Guide explains why both are correct and discusses the differences between them and the effects of those differences. Then it tells you how to make your purchase invoice match the supplier’s sales invoice. This is not a bug. It is the reality of dealing with the need to round numbers that occurs in every accounting system, whether automatic or manual.

Manager is a Double Entry accounting system. That means that every line item on the invoice also appears in an Expense account (or in your example maybe 11 different Expense accounts).

If you went into that expense account (or each of the up to 11 accounts), wrote down the amount shown, and then totaled those amounts, the total would be 20.11.

So if Manager did as you suggested and only rounded the total when updating/creating, the purchase invoice would show a total of 20.12. However adding up the amount in each expense account totals 20.11. Your suggestion would break the double entry accounting system.

The only way to avoid having two different totals is to round each line item and then sum the rounded amounts, as Manager does. You will find that all other accounting software do the same. Mathematically there is no other option.

It should also be noted that you are having this problem because you are calculating a percentage when creating the purchase invoice, and not just putting in a line amount. Nothing wrong with that. But there is no certainty that your supplier is doing things the same way…

Take a look at Manager’s Sales Invoices. Manager provides 2 ways to round the invoice. If you send an invoice to your customer and choose one of the rounding methods, your customer faces the same problem that you are facing: he has to make his system match your invoice. It happens.

1 Like