If your client uses a cloud-based ledger like MYOB Business or QuickBooks, you can sync this file so you can then view your client's balance, make adjustments and generate financial reports in Client Accounting.
You can also add the client data from an Excel or CSV file.
Choose a data source based on your needs
Sync: Choose this method for cloud-based ledger like MYOB Business or QuickBooks.
Upload file: If your client's data is in Excel or CSV format.
Empty period: If you want to start from scratch with an empty file.
Data source | Description | Details |
Sync | Switch from manual uploading to an automatic synchronisation Use this option to choose a date to start the sync from. | Moving from manual file uploads to a live sync and works well if you’ve purged transactions in MYOB AccountRight and have more than 2 years of comparative data. Let you choose a sync start date, so earlier manually uploaded data stays unchanged. From that date onward, bookkeeping changes sync automatically. If the file already has data, transactions after the selected date will be overwritten with new synced data. Only transaction data is replaced, workpaper details and reports don’t change. Available when you setup the client for the first time. |
Replace the data with a synchronisation Syncs all data. | Best when the existing imported data is incorrect or out‑of‑date, and you want to fully refresh it from the ledger. All existing balances in the file are overwritten by the synced data. Reconciliations, details and reports are kept, but make sure to review after the refresh. Syncs data overnight or on manual refresh. Pulls through all periods and transactions. Best for newer files with one or two years of comparative data. | |
Upload file using CSV or Excel formats | Imports a snapshot of a trial balance from a CSV/Excel file | Data is uploaded once. |
Create an empty period | Starts the period with no data | No sync. You can choose to set up a sync or upload data later. |
Choose a method to sync data
Follow the steps from one of the help topics below.
Sync a cloud-based ledger - Add a cloud-based ledger like MYOB Business so any changes made to the source ledger will automatically synchronise overnight.
Import client data using Excel or CSV format - This is a manual upload without automatic syncing of data. You can change this anytime to sync data.
Importing trial balance from MYOB Acumatica: If you use MYOB Acumatica, you can import your trial balance directly into Client Accounting.
Having issues with sync?
Troubleshooting sync issues: Having issues with syncing? Check this page for details.
Updating synchronisation settings: See how to change from manual upload to automatic sync and vice versa.
Next step - Review account mapping
Once your client's ledger data is connected, your next step is to verify the account mapping.
Map the chart of accounts to a standardised chart, use and verify AI mapping proposals.