Bills - Automatically calculate Unit Price from a Quantity and Line Total
I have a bill to enter from a supplier with around 40 line items.
The supplier does not list unit prices on their invoice, so i do not have accurate unit prices to enter for each line item to match the line item total.
This means i have to calculate and enter each line item unit price individually in order to match each line item total.
If i could enter the line item total and qty, with xero automatically calculate/enter the unit price, this will make entry of these bills significantly quicker.
Stephen Norton
shared this idea
-
Keith Gatenby
commented
I deal with the farming community who still hadwrite their statements with dated entries. Eg Fuel.
I need to get a caclulator for EVERY entry and calculate dolars per litre. Cannot add just the number one in the quantity column as I need to report to the ATO for deisel fuel rebate each BAS. The caclulator often does not get the total correct as the rounding is different and my accounts do not add up correctly.With MYOB I was able to wipe the price per unit, insert the total amount and it would calculate the price per litre from the quantity I had entered.
This is a situation that is very backward from MYOB compared to other areas bering very forward.
I am with Abigail, this needs more votes
-
Abigail Westcott
commented
I wish this had more than 2 votes, I hate having to drag out a calculator as often as I do in the modern day and age.