Open Platform Migration Studio
Migration studio: your old data, in the new system, checked before it lands
Upload a spreadsheet or an export. Adon ERP matches your columns to its fields, checks every row, and tells you how many are good, before it writes anything.
Now onboarding companies in Dhaka.
Open Platform / Migration Studio
Migration studio
- ✓Upload
- 2Map columns
- 3Check
- 4Import
Column mapping
customers.xlsx- Customer Name→Customer name100%
- Cust_ID→Reference ID100%
- Phone No→Phone96%
- Addr→Billing address88%
- Credit Days→Payment terms72%
Row check
- Rows read
- 1,248
- Valid
- 1,231
- Flagged
- 17
Flagged rows are listed with the reason, such as a missing name or a duplicate reference. Fix them, or import the valid rows and keep the rest for later.
Import valid rowsDownload flagged rows
An import, in four steps
The path is short, and you can stop at any step.
- Upload
Bring the file
Excel, CSV or an export from another accounting system.
- Map
Match the columns
Each column in your file is matched to a field, with a confidence. Low matches are for you to confirm.
- Check
Then import
Every row is checked. Valid rows can be imported, and flagged rows are returned with the reason.
What the page shows
- The steps
- Upload, map columns, check and import, with the current one highlighted.
- Column mapping
- Your column, the field it maps to, and the confidence.
- Row check
- Rows read, valid and flagged.
- The reasons
- Why a row was flagged.
- Download
- A file of flagged rows to correct.
Migration fills the lists the rest of the system uses
It writes customers, vendors, items and opening balances, and nothing else changes.
What it needs
- Chart of Accounts
Accounts for opening balances.
- Items / Products
Imported items.
What it fills
- Customers
Imported customers.
- Vendors
Imported vendors.
- Journal Entries
Opening entries.
Where it shows up
- Financial Reports
Opening balances in reports.
- Export / Takeout
Take data out when you need to.
Moving from spreadsheets and older systems
Most companies arrive with Excel sheets, and some with an older package. The studio is built for messy columns and half-clean data.
Excel and CSV first
The file you already have.
Messy columns tolerated
A column called Addr maps to Billing address.
Checked before written
Nothing is imported until the rows pass.
Done in stages
Customers today, items tomorrow.
One import, from file to list
A sample customer import, the way it usually runs.
A customer sheet with 1,248 rows is uploaded.
Columns are matched, and Credit Days needs a confirmation.
1,231 rows are valid and 17 are flagged.
The valid rows are imported.
The 17 are corrected and imported on a second pass.
How different trades use the migration studio
- Retail
Item and customer lists from spreadsheets.
- Food & Hospitality
Menu and supplier lists.
- Real Estate
Projects and tenants.
- Consulting
Clients and engagements.
- Manufacturing
Items, BOMs and suppliers.
- Health & Fitness
Members and stock.
- Trades
Customers and parts.
- Others
Donors and programmes.
Questions we get about migration
What can I import?
Customers, vendors, items, accounts and opening balances, from Excel, CSV or another system.
Does it write anything before I confirm?
No. It checks first.
What if some rows are wrong?
They are flagged with the reason. Import the valid ones and fix the rest.
Do I need to rename my columns?
No. They are matched for you.
Can I import in stages?
Yes.
Where is Adon ERP available?
We are currently onboarding companies in Dhaka. Book a demo and we will walk through it with sample data.
Bring your current customer or item sheet. We will import it in the demo.
A live demo in English or Bangla, using sample books close to your own trade, with time for your accountant’s questions.