Amounts, roundings and totals
When you push e-commerce sales into an accounting system, the numbers must match to the cent. The sum of your revenue lines, fees, and VAT must equal the order total, and the resulting entry must balance. This guide explains how the Unified API exposes e-commerce order amounts, and the method we recommend to keep them correct once booked. The sections below cover the decimal precision of the amounts you receive, the rounding rule to apply, how to handle VAT, how to split a global discount, the e-commerce‑specific points on fees and refunds, and the final reconciliation check.This guide describes the recommended method, not a constraint the API enforces. When you consume the e-commerce Unified API and write the result into accounting yourself, you are responsible for rounding. If you post through Chift’s accounting Unified API, see also Invoice amounts validation.
🔢 1. Decimal precision
The API response may return e-commerce amounts with more than 2 decimals. For example,unit_price and untaxed_amount can carry up to 4 decimals. The API frequently derives net amounts from a gross total or a discount, and it keeps that finer precision.
Treat every monetary value from the API as raw input. Do not assume it is already at 2 decimals. Do not compare two amounts for equality before you round both.
🧮 2. Rounding rule
Apply a single, consistent rounding rule to every amount before you book it: 2 decimals, round half up. Examples:- an
untaxed_amountof19.6694becomes19.67 - a computed net of
2.5950413…becomes2.60
Avoid “banker’s rounding” (round half to even), which is the default in some languages and libraries. It drifts from amounts that use standard commercial rounding.
🧾 3. Handle VAT per rate
Reuse the tax amounts the API provides. Do not recompute them. Each line (lines) and each fee (other_fees) exposes its own untaxed_amount, tax_amount, total, tax_rate, and tax_id. This avoids a rounding error that the source system does not have. At order level, you also have untaxed_amount, tax_amount, and total.
If you must derive VAT from a gross (tax‑inclusive) amount and a rate, use the remainder method so that net + VAT always equals the exact gross:
gross = 3.14, tax_rate = 21
net = round(3.14 / 1.21, 2) = 2.60vat = 3.14 − 2.60 = 0.54.
tax_rate before you compute net and VAT. Never compute on a single global total, which would hide compensating rounding differences between rates. Note that the API returns tax_rate rounded to 2 decimals (for example, 21.0).
➗ 4. Splitting a global discount
The order exposesdiscount_amount at order level. Line and fee discounts appear in each element’s discounts array. When a discount applies to the whole order rather than to a single line, spread it across the VAT rates pro rata of each rate’s base. To avoid a missing cent, give the remainder to the last bucket rather than round it separately:
📦 5. Fees and refunds
Three e-commerce‑specific points determine whether your revenue matches the order total:- Include fees. Each
other_feesentry (for example, shipping) has its owntax_rate/tax_idand base, and belongs to the order total. Book them per rate, like any revenue line. Thetotal_without_fees/untaxed_amount_without_feesfields let you separate goods from fees when needed. totalexcludes refunds and returns. Thetotal,tax_amount, anduntaxed_amountfields hold the order before refunds and returns. Thecurrent_total,current_tax_amount, andcurrent_untaxed_amountfields hold the amounts after returns and removals. Use the set that matches what you intend to book. Do not mix the two.- Treat refunds separately.
refunded_amount,detailed_refunds, andreturnsdescribe money given back. Book refunds as their own entry (or as reverse lines) per VAT rate. Never net a refund inside the original sale’s VAT base.
The net (HT) of a line is
untaxed_amount, or equivalently total − tax_amount once you round both to 2 decimals. Pick one convention and apply it consistently across all lines.✅ 6. Reconcile and balance
After you round each amount per rate to 2 decimals separately, a residual difference of a few cents can remain between the sum of your booked lines (net + VAT) and the ordertotal. Book that residue on a rounding account so the entry balances (debit = credit):
- a gain account for a positive difference (for example,
758); - a loss account for a negative difference (for example,
658).
A residue of a cent or two is normal rounding and belongs on the rounding account. A difference larger than ~1 € is not a rounding issue — it signals inconsistent source data (or the wrong
total vs current_total set). Stop and investigate rather than absorb it.In short
Round every amount to 2 decimals half‑up, reuse the VAT the API provides, reason per rate, split global discounts with the remainder on the last bucket, include fees and keep refunds/returns separate (watchtotal vs current_total), and close each entry with a reconciliation that sends any residual cent to a rounding account. This is what keeps your accounting totals equal to the original e-commerce amounts.