Importing trial balance from MYOB Acumatica
If you use MYOB Acumatica, you can import your trial balance directly into MYOB Client Accounting.
Follow the steps to import:
Export the trial balance from Acumatica
Format and save the file as CSV format
Upload the CSV file to MYOB Client Accounting
Add the first year's data
Add the second year’s data
1. Export the Trial balance from Acumatica
Log in to MYOB Acumatica
Type trial in the search bar at the top.
Select the Summary Trial Balance report for the earliest financial year you want to import.
You'll need two years of data to show prior-year comparisons. Start with the earliest year.
Export the report to Excel.
2. Format the exported file
Open the exported Excel file.
Fix the spreadsheet by removing:
Header rows (e.g. report titles, filters)
Blank rows
Subtotals and grouped totals
The Net Income YTD row (this is calculated automatically in Client Accounting)
Reverse the signs for:
Liabilities
Income
Use a formula like =-[cell] to automate the reversal.
Make sure each row includes:
Account (code or identifier)
Description (account name)
Ending Balance (adjusted for sign if a Liability or income account)
Save it as a CSV (.csv) file.
3a. Import your first year into MYOB Client Accounting
Log in to MYOB Practice Compliance.
Go to the Client workspace > Financial Statement section to link the client
After linking the client, you need to Import the csv data manually
Map the columns as follows:
Acumatica | MYOB Client Accounting |
|---|---|
Account | Account Number |
Description | Account Name |
Ending Balance | Value |
Complete the import for the first year.
3b. Add the second year's data
Once your first year is imported and accounts are mapped:
Log in to MYOB Acumatica.
Search and export the Trial Balance for the next financial year.
Format the file using the same steps as above.
In MYOB Client Accounting, click Add Period.
Upload your second year’s CSV file.
This time, you’ll only be prompted to map any new accounts that didn’t exist in the first import.