Rounding off in purchase invoice

ideas
#13

The current rounding as implemented works perfectly, as nothing is broke there is nothing to fix.

Rounding shouldn’t take into account the taxes as rounding is a financial adjustment to the Invoice’s total, it’s not an adjustment on the transactions making up the total. Taxes should remain true to the line item price.

How would you proportionally adjust the taxes if the invoice had both taxable and non-taxable items and the invoice total rounding was only small, say 0.09. If the taxable items added up to be 60% of the total, are you going to attempt to adjust the taxes for 60% of the 0.09.

1 Like
#14

As I am not registered for GST I constantly run into problems trying to get the purchase invoice totals to match.

Generally, the supplier will enter each unit price ex GST and the qty.
Each line will be totalled at the ex gst price
an ex gst total will be at the bottom of the invoice with a line below for the GST figure.
GST will be added as one figure (10% of the subtotal) to arrive at the invoice total.

As I don’t use GST in Manager, I have to enter each items value at the inc GST figure and have each line total be the total inc GST.

Rarely does my invoice total equal the suppliers invoice total and I spend many minutes tweeking figures here and there until I can get it to match. This often will involve changing multiple items pricing by small values. e.g. I may change a price of $191.565 to $191.56505 and this type of change may have to happen on multiple lines until I can get it to match.

This is VERY frustrating.

I would LOVE an easier, and quicker, solution to this issue.

Rounding the amounts
#15

If your version is earlier then 18.9.91 then you need to update.
A calculator has been added where you could enter the cost as - price x GST.

#16

Hi Brucanna,
I have the latest version installed but I don’t think you understand my issue.
I have no issue calculating the inc gst pricing, as that is actually stored as the buy price in each inventory item.
The problem is with the total invoice value.

I enter individual items at inc gst prices but suppliers enter them as ex gst prices.
The supplier adds gst as one line at the end. i.e. 10% of the total of all items purcahsed.

As an example.
I may have 50 lines on an invoice and each line is for multiple qty(such as 36 or more)
The total invoice value rarely matches exactly due to the way the GST is added at the end by teh supplier but to each item by me.
It can be hard to evenly adjust values to make the totals match and usually comes down to making price adjustments to item pricing by values like $0.000567 etc.

It would be great if I could just adjust the invoice total and the difference be evenly spread over all lines or applied to a rounding account, or something like that.

I hope this makes sense.
I know what I mean but think I am having trouble articulating it properly.

Thanks,
Greg

#17

Well you can do that, enter your 50 line items using your individual items at inc gst prices.
If your purchase invoice total varies from the suppliers sales invoice by a few cents, then add another line to your purchase invoice and select a self created Account called “Rounding” (*) and put that variance there.

0000000%20Bug%203
0000000 Bug 3.jpg945×198 18.9 KB

(*) You could use any other existing account, say Bank Charges, if you don’t want an extra account with very small amounts which can be both debits and credits.

PS: This topic is where the Supplier rounds their Sales Invoice, say to the nearest dollar - 180.33 becomes 180.00, rather then rounding due to calculation variance which is your situation.

#18

Is there any update on rounding off in purchase invoice ? @lubos

#19

Any hopes sooner to add a button for it…

#20

I just created a Chart of Account called Vat Rounding and just put a penny in or penny less into VAT Rounding account when the suppliers invoice and manager’s invoice don’t round the same way.

Far simpler this way than trying to work out what they have rounded an item to. At the end of the day, all you need to ensure is that the total at the bottom balances so that your payments in Manager and on your bank statements always match. The government doesn’t care about the penny/cent out on VAT or GST.

1 Like
#21

but its needed to maintain the book accurately.

#22

It is accurate. My invoice total and their total matches. Manager’s bank balance and my bank accounts tally and I have a record of the rounding in a COA. So everything is balanced and is recorded.

#23

that is a option users need to create. but rounding off button should be provided as default in sales invoice as well as purchase invoice

#24

The rounding option has long been present for sales invoices. You can make it default in the Settings tab under Form Defaults.

#25

i was just mentioning a point for him. this thread is about getting a rounding off check mark in purchase invoice too… i m in favor for it to be implemented.

#26

@lubos is there any chance of implementing rounding off in purchase invoice or any similar situation. like the option available in sales invoice.

#27

I have just encountered the issue of my purchase invoice not matching an invoice from a supplier due to differences in rounding. It looks to me like Manager rounds off line totals before adding them, whereas my supplier’s accounting system seems to have added the line items and then rounded off. Here’s an example:

Amount 15% VAT on amount VAT rounded
682.43 102.3645 102.36
2274.75 341.2125 341.21
Total 2957.18 443.577 443.57 (sum of above)

My supplier’s invoice gives a total VAT of $443.58, but Manager gives $443.57.

In this invoice there are other line items with different tax rates applied. I suspect that if all lines had the same tax applied, Manager would calculate the tax based on the total.

#28

You need to adjust the purchase invoice in Manager so that it agrees with your supplier. You can do this manually or play around with the tax inclusive and tax exclusive option so get the right option.

Most modern accounting system work like Manager ie calculate tax line by line and then total.

I don’t think the VAT authority will be after you for 1 cent

#29

Thanks. I agree that they probably won’t come after me for 1 cent, but it’s always nice to have everything perfectly balanced. I achieved what I needed by making my purchase invoice tax inclusive, as you suggest, which I discovered I had actually figured out previously on another invoice.

Anyway, my main reason for posting the above example was to present a real-life scenario in which the requested feature would be useful, I think, and to illustrate a potential source of the issue for some users.

#30

In Australia rounding has to be done on the total.
However it is also acceptable for:

  • Accounting software to define the precision is uses on the line items and round line items to program precision
  • For different compliant rounding to be used by supplier and customer

As a result in Australia Managers method is acceptable and the amounts do not need to equal the suppliers invoice. Entering prices as tax inclusive ensures bank reconciliation also balances.

#31

@lubos I also feel this is required.

Eg: my supplier’s purchase invoice total is:
image

while Manager’s purchase invoice is:
image

I think when done in Excel, it shows the same as supplier’s purchase invoice.

Unless, we manually do a calculation for tax included line items, is there a way to make the total same as supplier’s purchase invoice total?

I feel for a purchase invoice with lot of items, to create a manual tax included line item list to enter to Manager will take a lot of time. An easy solution is needed.

Thanks

#32

is the button being added in purchace invoice or not?