Use this article to update (or refresh) the trial balance in your workpaper when the client's data has changed, especially after edits made directly in the client's file.
How to Update the Trial Balance
Navigate to the Trial Balance page in your workpaper.
Click Update in the top-right corner of the page.
Follow the steps below for your trial balance source.
Updating a Trial Balance Integrated with Xero
If your trial balance is connected to Xero, clicking Update refreshes the trial balance automatically with the latest data from Xero. No further action is required. The trial balance updates immediately, and the new figures display on the Trial Balance page.
⚠️ If you're getting an error see:
Updating a Manual (CSV) Trial Balance
If your trial balance is managed manually, clicking Update takes you to a page where you can download a CSV template and upload your updated CSV file.
Click Update on the Trial Balance page.
Download the CSV template, if you don't already have one.
Update the CSV file with your client's current figures.
Upload the completed CSV file.
Once uploaded, the trial balance updates with the figures from your CSV file.
CSV Requirements
If your trial balance is managed manually via CSV, your file must contain the following five columns.
Field | Description |
Account Code * | The account code. This must match an account code in the entity's chart of accounts. |
Debit TY | The debit amount for the current period, or blank. |
Credit TY | The credit amount for the current period, or blank. |
Debit LY | The debit amount for the prior period, or blank. |
Credit LY | The credit amount for the prior period, or blank. |
Fields marked with an asterisk (*) are mandatory.
Account Code is the only mandatory field. Every account code in your CSV file must match an existing account code in the entity's chart of accounts. If a code doesn't match, update the chart of accounts before uploading your CSV file.
To find or update an account code:
Navigate to the entity.
Select Chart of Accounts.
Find the account code you need.
Update the code here if it doesn't match your CSV file.