Chart of accounts cross-reference chart
The Chart of Accounts Cross Reference Chart retains the historical information between the current year and the prior year. This chart is automatically created when you rollover the Federal Chart of Accounts (COA).
- In the Income Tax menu bar, selectCharts.
- SelectFederal > Charts of Accounts Cross Reference.
- Select the chart in the list.
- Select the year in theCurrent Yearfrom the dropdown.
- Select thePrior YearandCurrent YearFederal COA. Prior-year charts that have been cross-referenced appear in blue. Each line shows the TRC/TCC in brackets that the account is mapped to, the account number, account description and the type of account (Balance Sheet - B/S or Income Statement - I/S).
The Federal COA Cross reference chart below was automatically created when the Federal COA was rolled over. The accounts are cross-referenced one to one.
When using a new chart of accounts or condensing several prior year charts into a current year chart, you must cross-reference the accounts either manually or by importing them.
Manually Cross-referencing to a Current Year Account
- Select the account(s) from the prior year.
- Select the account in the current year and selectMap. Cross-referencing allows you to map one account to one account or many accounts to one account. The prior year accounts with balances appear with a blue triangle.
Importing Data into the chart
The import file should have the
Prior Year
account in one column and the Current
Year
account to cross-reference to in another column.- Create an import template by clickingExportat the bottom of theChart of Accounts Cross Referencescreen and saving the file as a .csv file.
- Enter your data and then import the file back into the application by clickingImport.noteYou can only cross-reference balance sheet accounts to balance sheet accounts and income statement accounts to income statement accounts.
- The import process provides you with a log if there are any problems in the import file.noteIf an account is used in a tax adjustment that has been previously cross referenced, you must unmap the tax adjustment first before deleting the Chart of Accounts Cross Reference Chart.