Excel to Accounting Formatter

Chart of Accounts

Paste your Chart of Accounts data (Tab-separated: Account Code, Account Name). This data is used for lookups in other tabs.

Receipts Import (from "SalesDB")

Paste raw receipts data below. Lines with zero amounts are skipped. Discount/Retention/Recoupment lines require the account in CoA & non-zero amount.

Payments Import (from "PurchaseDB")

Paste raw payments data below. Zero amount lines are skipped. Line 4 (WTax) requires ATC code & non-zero amount.