How to Import Company Accounting Records into Your TaxAct Return:1120
TaxAct® customers can easily transfer their company accounting records into their corporation or partnership tax return by importing a trial balance report generated from their accounting software. This feature is currently only available in TaxAct 1065, 1120, and 1120S.
In order to do the import, you will need to generate a trial balance report (or similar report) for the full tax year in your accounting software. Next, you will need to select the option to export this report to a .CSV file. Save this file to your computer (e.g. Documents\TaxAct 2016). You are now ready to import your company accounting records into TaxAct. TaxAct will transfer the company records and help streamline the process by auto-mapping identifiable accounts.
The trial balance report must contain three columns: (1) account description, (2) debit and (3) credit. See the sample trial balance report below.
To import a Trial Balance .CSV file into your TaxAct return, follow the steps below:
- From within your TaxAct return (Online or Desktop), click on the Basic Info tab. On smaller devices, click the menu icon in the upper left-hand corner, then select Basic Info
- Click Import directly below the tabs
- If you were a TaxAct customer last year, you can save time by importing last year's return. Select Yes or No to the question Would you like to import last year's 2015 return?
- On the screen titled Accounting Records Import, click Import CSV File Now to start your accounting records import. Be sure all accounts have been adjusted for tax purposes prior to importing.
- Browse to locate the trail balance CSV file (previously exported from your accounting software), then click Open.
- Next, you will need to review and verify the Tax Line auto-mapped for each account listed. For those accounts not auto-mapped, you will need to select the appropriate tax classification from the drop-down menu.
- Certain accounts, such as items relating to depreciation or amortization, will need to be entered separately in TaxAct.
- It is suggested you print a summary to help you reconcile this federal return before clicking Import. Select the print icon in the upper right hand corner to print this summary.
- Important: All accounts must be assigned before clicking Import.
- Click Import to transfer the information into your return.
Verifying Account and Tax Line
It is the responsibility of the taxpayer (or preparer) to ensure the accounting records in their .CSV file match the appropriate Tax Line in the TaxAct program. If these do not accurately match, the program may not calculate your tax return correctly.
It is the responsibility of the taxpayer (or preparer) to ensure the accounting records in their .CSV file match the appropriate Tax Line in the TaxAct program. If these do not accurately match, the program may not calculate your tax return correctly.