Migration Template Reference

Last updated: 2026-07-09 Summary:

The XLSX template has seven worksheets, filled in dependency order: Accounts → Customers → Vendors → Products → OpeningBalances → OpenInvoices → OpenBills.
Dates are YYYY-MM-DD; amounts use a plain decimal point; files must be under 10 MB.
A CSV imports the Accounts sheet only; the XLSX imports all seven.

Download the template from the Migration wizard: on the Source step, choose eKapital template (CSV/XLSX) and click Download template (.xlsx) (ekapital-migration-template.xlsx). Each sheet ships with one example row. Column (header) names are exact — the importer reads them verbatim.

Worksheets, in fill order

Fill the sheets top to bottom: parties before the open items that reference them, accounts before the opening balances that post to them.

#	Worksheet	Imports	Depends on
1	`Accounts`	Chart of accounts	—
2	`Customers`	Customer contacts	—
3	`Vendors`	Vendor contacts	—
4	`Products`	Product/service catalog	—
5	`OpeningBalances`	Opening balance per account	Accounts
6	`OpenInvoices`	Unpaid customer invoices	Customers
7	`OpenBills`	Unpaid vendor bills	Vendors

Columns per worksheet

Accounts

Column	Required	Notes
`AccountNumber`	Yes	Your account code, e.g. `1000`.
`AccountName`	Yes	e.g. `Cash on Hand`.
`AccountType`	Optional	A hint (e.g. `Cash and Cash Equivalents`). A recognized value pre-resolves the account in the Classify step; blank falls back to the wizard’s suggestion.
`Description`	Optional	Free text.

Customers / Vendors

Column	Required	Notes
`Name`	Yes	Used to match open invoices/bills to this party.
`TIN`	Optional	Philippine TIN; flagged for later if missing or invalid, never blocked.

Products

Column	Required	Notes
`Name`	Yes	Imports as a catalog entry.
`SKU`	Optional	Product/service code.

Products import as catalog entries only. Pricing, income/expense accounts, and opening stock are set up after the import — there is no opening-quantity column today.

OpeningBalances

Column	Required	Notes
`AccountNumber`	Yes	Must match an account in the chart (imported above or already present).
`Debit`	One of Debit/Credit	Debit balance; leave the other column blank.
`Credit`	One of Debit/Credit	Credit balance.

Debits must equal credits across the whole sheet. All rows post as one balanced opening journal entry on your as-of date; the residual lands in Opening Balance Equity.

OpenInvoices / OpenBills

Column	Required	Notes
`CustomerName` (OpenInvoices) / `VendorName` (OpenBills)	Yes	Must match exactly one party `Name` in the same file.
`Reference`	Optional	Your original document number, e.g. `INV-1001`.
`Gross`	Yes	Total amount, VAT-inclusive. Must be positive.
`Vat`	Optional	Already-declared VAT portion (0 if none).
`Net`	Optional	VAT-exclusive amount. If omitted, computed as `Gross − Vat`. Must satisfy `Net + Vat = Gross`.
`InvoiceDate` (OpenInvoices) / `BillDate` (OpenBills)	Yes	Cutover date the document posts on.
`DueDate`	Optional	Drives aging; defaults to the document date.

Formats

Dates: ISO YYYY-MM-DD (e.g. 2026-01-15).
Amounts: plain decimal point, no thousands separators (e.g. 50000.00).
Currency: amounts import in your company’s base currency. Per-currency import is not supported today.

Upload limits

Maximum file size: 10 MB.
Accepted types: CSV and XLSX only. A renamed PDF or image is rejected.
CSV scope: the Accounts sheet only. Use XLSX to import customers, vendors, products, opening balances, and open items.