Set up preliminary balances
When you first open Trial Balance, the Preliminary Balances screen appears.
- On the Preliminary balance screen, selectImporton the menu bar to import the chart of accounts.
- This opens the Import balances screen. You can drag a file to the open area, or selectBrowse for Fileto import a file.
- Select a file to export from the prior year’s Trial Balance Bridge.
- After you attach the file, clickNexton the Import balances screen. The filename of the attached file and its file size appear in the file area beneathBrowse for File.
- You can also import balances by using a template. You can create a new template or use an existing template for mapping.
- Map the column with the correct value (for example, Account number, Account description, etc.).
- ACCT_NUM *Account Number
- ACCT_DESC *Account Description
- TRC *TRC
- TCC *TCC
- TCC caption (description) TCC CAPTION
- PC number Activity number (1065 and 1120S) only
- PC description Activity description (1065 and 1120S) only
- PY_BAL à Prior Year account balance
- CY_BAL Account balance
- MRC MRC
- MCC MCC
- MCC CAPTION (description) MCC Caption
- SelectSaveto keep your mapping.
- After the mapping is saved, selectImport.
- Trial Balance will validate the import file and list any errors. If the Excel file is incorrect, it will show Import completed with errors on the top of the screen and list all errors on the screen.
- If you are using an audit package, you must perform the import in the preliminary balance.