From receipts to the ledger: AutoCount, SQL Account, Xero, QuickBooks & Bukku

Six formats, one source

• AutoCount — Cash Purchase: DocNo, DocDate, CreditorCode, CreditorName, MainGLAccount, ItemDescription, TaxType, TaxRate, TaxAmount, Amount, TotalAmount, Ref, ProjNo (project).
• SQL Account — General Journal: Debit the expense account (+ Debit SST) and Credit Cash/Bank per document; total Debit always equals Credit; the Project column carries the project.
• Xero — supplier bills (ContactName, InvoiceNumber, InvoiceDate, AccountCode, TaxType, TaxAmount, TrackingName1/TrackingOption1 = project, Currency MYR) for the Bills import.
• QuickBooks Online — expenses (Date, Payee, Payment account, Category, Amount, Tax amount, Memo, Ref no., Class = project).
• Bukku — expenses (Date, Contact, Reference, Description, Account, Amount, Tax Code, Tax Amount, Total, Tag = project) for the Malaysian cloud accounting software.
• Generic CSV — Document No, Date, Supplier, Account Code/Name, Net Amount, Tax Code, Tax Rate %, Tax Amount, Total, Currency, Reference, Cost Centre: map it once in any ERP or corporate accounting system.
• The project / cost centre on a receipt (or the expense linked to it) fills each format's project column — every client's, branch's or event's cost goes straight into the books.
• Default account codes follow the Form B category (purchases, travel, promotion, entertainment…) — the accountant remaps inside the software; the columns stay the same.

SST split honestly

When a receipt shows SST (an "SST 8%" line or a tax amount), the tax component goes to the tax account and the net amount to the expense account; the rate is read from the receipt and checked against that year's official rate (rules that update themselves, not hard-coded). Receipts with no SST mention are exported without tax — nothing is estimated.

Companies & associations: claims and organisation-paid expenses

In a company, association or firm space, the export card on the Claims screen exports three sources: approved or paid claims (credited to staff claims payable); organisation-paid expenses — company card, bank transfer or office cash receipts and receipt-less expenses recorded in that space (credited to cash or bank); or both in one file with different document-number prefixes. The project / cost-centre column is in all six formats, every journal balances, and records in personal or family spaces are never included.

Excel beside every CSV

Every export — this accounting export, claims, reports, money in, projects and the audit pack — can also be downloaded as an Excel workbook (.xlsx) with the same columns: numbers stay numbers, dates stay dates, headers are frozen, and the audit pack comes as one multi-sheet workbook. Built on your device, with no external library.

For accountants & firms

• Invite the accountant as an auditor: read-only, sees the original receipts, downloads exports and the audit pack themselves — with their existing account (many clients, one login).
• Any date range — monthly, quarterly or yearly; the file is named by range.
• Mixed personal/business receipts: only the business share is exported, with the receipt number as reference.