← All resources

Taxes · 4 min read

GST and QST on construction invoices: keeping Xero equal to the PDF

How NamaCor computes the two taxes, rounds them, freezes the rates and allocates them per line so nothing is off by a cent.

The most common reason an invoice in Xero does not match the PDF the client received is rounding. Two taxes, computed differently, rounded at different levels, disagree by a cent, and the accountant spends an hour on it. NamaCor removes the problem at the source.

How the taxes are computed

  • GST at 5 % and QST at 9.975 % are computed independently on the taxable subtotal. They are not compounded.
  • Each tax is rounded to the cent at the document level, not line by line.
  • The rates are frozen on each document when it is created. A future rate change never alters an issued invoice.

How they reach Xero

Xero computes tax per line. To make Xero's totals equal the PDF, NamaCor allocates the document's tax amounts across the lines and lets the last line absorb the rounding. The result: the invoice total in Xero equals the invoice total on paper, to the cent, every time. The same logic applies to supplier bills, which are sent as one line at the subtotal with the document's exact GST and QST.

Exempt lines

Sales items carry a taxable flag. Exempt lines use the exempt tax codes you mapped in Settings, so a deposit, a holdback release or an exempt service is handled correctly on both sides.

Split bills

When one supplier bill is split across projects, GST and QST are prorated across the taxable parts and the last part absorbs the rounding. The parts must equal the subtotal, and Xero receives a single bill with one line per part.

Amounts are displayed the Canadian way, 1 234,56 $, and dates as YYYY-MM-DD. The maths is tested with unit tests on every change.