Check quantities, unit prices and the copied subtotal

Start with the fictional example or checked records

Inputs are processed by this page without uploading to an account or saving them. Your browser may restore fields. Existing page/CTA analytics is separate and does not receive these input values.

Original fictional calculation · not a customer result

Worked example: the difference to inspect

The fictional first line is 3 × AUD80 = AUD240. The second is 1.5 × AUD120 = AUD180, although the copied line says AUD170. Expected subtotal is AUD420; the typed subtotal AUD410 is AUD10 lower. The first line is left untouched.

reference,quantity,unit_price,printed_line_total
DEMO-A,3,80.00,240.00
DEMO-B,1.5,120.00,170.00

410.00

Download fictional input · Download fictional result

Method and explicit boundaries

Each quantity allows three decimal places and each unit price two. Multiply using integer-scaled values, round each line half up to the nearest cent, then add those rounded lines. Compare both each copied line and the copied subtotal. A difference is entered minus expected, so a negative result means the entered amount is lower.

This worksheet is for undiscounted line extensions on one AUD price basis. It does not allocate a document discount, choose a tax rate or add GST. If your source system rounds the final sum instead of each line, a cent difference may be a method difference; inspect the actual preview rather than forcing a correction. Quantity precision is not a unit conversion: 1.5 hours is different from 1 hour 50 minutes.

Choose the existing template after resolving the result

Check mismatched lines against approved service records, then manually enter the correct quantities and prices in the original tool. Apply your actual discount and GST settings there, and compare the final customer PDF/image before sending.

• Australian invoice template
• Free/basic invoice template
• Invoice example

Start without signing in; free use has branding and usage limits. Review any optional membership against real repeat-use needs. Downloading a worksheet is not a successful invoice export.

Checks for different questions

• Reconcile entered GST and mixed price bases on a tax invoice
• Check overlapping service times before invoicing a job
• Compare ordered, completed and already-invoiced quantities

All worked examples and the download pack

Source and review date

Microsoft documents summing products of corresponding arrays. This worksheet adds original copied-value comparisons and explicit cent rounding; it is not an Excel file import or a claim that every invoice system uses the same rounding.

Read the official/primary source

Reviewed 17 October 2026. Exact Australian long-tail volume, indexing and paid outcomes remain unknown; a vendor document or deployment does not establish them.