To successfully import a trial balance from an Excel file, your import spreadsheet must:

• Be a Microsoft Excel 2013 or newer .XLSX file that contains only one worksheet.
• Begin your accounts on Row 2 of the worksheet. Row 1 must be blank or used for header information.
• Have the following information in the first 4 to 6 columns of the worksheet, in this order:
  • Account Number (optional)
    • If you do not use account numbers, then leave column A blank.
  • Account Name (required)
  • Current Period Debit Balance (required)
  • Current Period Credit Balance (required)
  • Prior Period Debit Balance (optional)
  • Prior Period Credit Balance (optional)
• Have no subtotals or extraneous information below or to the right of the data.
• Have only one instance of each account number and account name.
• Any accounts with a zero balance, the cells should remain blank.

To perform your import, do the following:

1. Click the engagement on the Engagement List page.
2. Do one of the following:
   • For a non-consolidated engagement, click on the navigation bar and select Trial Balance.
   • For a consolidated engagement, click View next to the subsidiary you want to work with. You can also click  on the navigation bar and select Trial Balance, then clickin the gray navigation bar and select the entity you want to work with.
3. Click Microsoft Excel and browse to the file.
4. Select the Excel file, and then click Open.