Bring account masters into a consistent format.
Use supported account import/export to prepare customer and supplier records. Check names, contact details, groups and opening information before applying bulk changes.
Party list and approved balances
Map account fields
Checked opening ledgers
Account import needs a balance date, not just a list of names.
Importing customers or suppliers prepares the account records used by billing and settlement. When opening balances are included, their debit or credit direction and effective date matter as much as the name and contact details.
Clean duplicate parties, select the correct account classification and test the supported mapping. Reconcile the imported opening totals with the approved source. If bill-wise tracking is required, establish how individual outstanding references will be brought into the supported workflow.
How to use it.
Bring account masters into a consistent format.
- 01
Get the supported account-sheet format
- 02
Validate a small sample of customer/supplier rows
- 03
Import and compare the resulting master records
What this looks like in your business.
A distributor cleans up spelling and contact details in its customer list before importing the records.
Good questions.
Clear answers.
Choose the workflow that fits your business and confirm its setup in a demonstration.
Is importing a party balance the same as importing old invoices?
No. An opening balance gives an amount at the start date. Historical transactions and individual unpaid bill references carry additional detail and require the appropriate supported import or opening-allocation process.
What setup should I confirm?
Do not assume every column or opening allocation is imported. Confirm the supported fields and keep a backup.
What else can help?
Excel item import and export
Prepare a catalogue once, then review the import.
Read the guide →Sales purchase and receipt import
Check imported transactions before trusting the totals.
Read the guide →EMI instalment sales
Keep instalment sales organised.
Read the guide →See it with a sample from your business.
Bring a sample bill or item list. We’ll show you the steps and answer your questions.