Fixed discount line allocation review
Distribute one agreed fixed discount across eligible lines in exact cents. See which line receives a residual cent and keep excluded lines unchanged.
Free to use · Fictional examples · Local calculationReview entered records
AUD pre-GST line amounts. One row: internal_code | original_amount | yes_or_no. Use yes only for independently verified eligible lines. No header, commas or personal details; maximum 100 rows.
Confirm the scope, then run the review.
Worked example: account for the last cent
Three fictional eligible lines of AUD 10 share an agreed AUD 1 discount. Each exact share is one-third of a dollar. The review first assigns AUD 0.33 to each, then gives the remaining cent to LINE-A. The discounts are 0.34,0.33,0.33 and sum to exactly 1.00. A separate ineligible AUD 5 delivery line keeps its original amount. The complete net total is AUD 34.
Reordering these rows does not change the winner: exact equal remainders are resolved by the internal code in ascending character order. Changing a code can change a tied result, so retain the same codes and the agreed allocation policy.
Method: proportions with a visible residual
Sum the eligible line amounts, calculate each exact proportional discount, and initially keep only whole cents. Sort the remaining fractions from largest to smallest and distribute one cent at a time until the allocated discount matches the agreed total. The report shows each original amount, eligibility, discount and net amount. It rejects a discount greater than the eligible subtotal, duplicate codes and invalid flags.
Check the commercial and tax scope first
This independent largest-remainder method is one explicit allocation policy. Intuit’s US help illustrates why fixed-discount scope and item placement matter, but it does not prescribe this residual-cent method or Australian GST treatment. Your accounting system or agreement may allocate differently. Do not use the output as an automatic tax adjustment, credit note or import file.
Use one consistently verified pre-GST basis. The page does not infer which lines are taxable, eligible, already discounted or returned. Quantity/rate calculations must be checked before entering the line amounts. Existing invoice-level discounts must not be applied again to the resulting net lines. If an already issued document needs correction, resolve the required process separately.
Verify before preparing a document
Resolve the allocated amounts with the original records. Manually prepare a genuine new document in the existing invoice tool only after checking eligibility, GST and any prior discount.
Inputs are processed locally without upload, account storage or invoice-draft writes. Your browser may restore form values; protect your device and keep your own copy. Editing any input clears the prior result. A review download is working notes, not an invoice, receipt or successful invoice export.
Open the original tool for a verified documentStart the original tool without signing in. Free output has branding and usage limits. This review does not automatically create an invoice or submit a payment.
Sources and scope
Intuit’s own help describes proportional allocation of a fixed discount and the importance of item eligibility. It is US product documentation used for workflow context; this AUD worksheet and cent-residual policy are independent.
Sources and fictional examples reviewed 6 November 2026.