Export invoices to accounting

Two bits of accounting export setup make every later export clean. Both are one-time jobs, best done with your accountant on the phone so you use their codes, not your guesses.

1. 1

   Map your SST rates to tax codes

   In Settings → Quotations & invoices, set the tax code your accountant uses for each SST rate. Do this for SQL Account, AutoCount, or both.

2. 2

   Add customer codes

   AutoCount invoice exports match customers by code and nothing else. Set the AutoCount customer code on each customer, or their invoices will be skipped.

3. 3

   Connect Bukku, if you use it

   Bukku invoice push needs an access token and your subdomain from Bukku's own Control Panel, plus a default income account and tax code for pushed lines.

Open Invoices, tick the invoices you want, and a toolbar appears above the list with your accounting export options:

1. 1

   SQL Account

   Downloads an Excel file of the invoices and their payments, ready for SQL Account import.

2. 2

   AutoCount

   Same thing for AutoCount. The invoice export result tells you how many were exported and how many were skipped for a missing customer code.

3. 3

   Push to Bukku

   Sends the selected invoices into Bukku over its API — no file to pass around.

4. 4

   Export

   A plain CSV with one summary row per invoice, for any other system or for Excel.

Filter the Invoices list to last month, select all, export, and send the accounting file across. Because the tax codes and customer codes are already mapped, the same invoice export routine works every month without extra thought. If the numbers look off, check the invoice itself first — see Get paid and record payments.