← AR Dashboard

Import AR Excel

Upload Final_AR_Management_System_v2.xlsx to import customers and invoices.

Smart Import — All Sheets

Automatically reads every sheet in your workbook: AR Invoices, Customers, Products, Journal Entries, Exchange Rates, Chart of Accounts, and more.

📂

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 AR-specific importer (Final_AR_Management_System_v2.xlsx only)

Drop your AR Excel file here

or click to browse · .xlsx / .xlsm

Reads "Client List" and "AR Monitoring" sheets

Import History

FileDateTotalSuccessUpdatedSkippedErrorsStatus
purchase-book.xlsx7/5/2026348001580COMPLETED
purchase-book.xlsx7/5/2026348158000COMPLETED
ar-collections.xlsx7/5/20264326010COMPLETED
APAging.xlsx7/4/202629320000COMPLETED