Smart Import — All Sheets

Automatically reads every sheet: AP Invoices, Vendors, Journal Entries, Chart of Accounts, Exchange Rates, and more. Works with any Excel file.

📂

Drop your Excel file here

Supports .xlsx / .xlsm / .xls — all sheets are scanned automatically

Auto-detected sheet types

AP InvoicesAR InvoicesJournal EntriesCustomersProductsVendorsChart of AccountsExchange Rates

Sheet names and column headers are recognized automatically — no manual mapping needed.

Journal Entry sheet requirements

Sheet name should contain JE, Journal, or JV. Required columns: Date, Account Code (or Account Name), Debit, Credit. Optional: JE No. / Ref No., Description, Currency, Rate. Entries must be balanced (Debit = Credit).

Legacy AP importer (AP_Bookkeeping_System_v3.xlsm only)

Import from AP Bookkeeping System

Reads your AP_Bookkeeping_System_v3.xlsm file directly. Groups rows by VP No., auto-creates vendors, maps statuses, and records check payments.

Drop your .xlsm file here or click to browse

Supports .xlsx, .xlsm, .csv

Generic Excel Import (manual column mapping)

1. Upload
2. Map Columns
3. Validate
4. Summary
5. Done

Drop your Excel file here

Supports .xlsx, .xlsm, .csv — original file is never modified

Recent Imports

FileDateTotalNewUpdatedSkippedErrorsStatus
purchase-book.xlsxJul 05, 2026348001580COMPLETED
purchase-book.xlsxJul 05, 2026348158000COMPLETED
ar-collections.xlsxJul 05, 20264326010COMPLETED
APAging.xlsxJul 04, 202629320000COMPLETED