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
Data source options available
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 |
Decide which client data to sync
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