Business - Importing Financial Data (.csv)

Follow the instructions below to import Income Statement and Balance Sheet information into an existing business return in CrossLink.

1. Within QuickBooks, go to Reports, then Accountant Reports to create the files for CrossLink import. The steps for obtaining the desired reports differ depending on your particular version of QuickBooks. The following steps are specific to QuickBooks Online but can be adapted to your particular version.

2. For the Income Statement (while within QuickBooks), choose the Profit and Loss report. Choose to run the report for this year with totals only. Run the report, then export it to Excel.

3. Open the report in Excel, and Save As a comma-separated value (.csv) file for import into CrossLink.

4. For the Balance Sheet (while within QuickBooks), choose the Balance Sheet report. Choose to run the report for this year with totals only. Run the report, then export the report to Excel.

5. Open the report in Excel, and Save As a comma-separated value (.csv) file for import into CrossLink.

6. The data from the created reports can now be imported into the CrossLink business return to populate the Balance Sheet and Income Statement. While inside a business return, select Return, then select Import Financial Data.

7. On the following screen, select Yes to accept the condition that the imported data will replace any information already present on the Balance Sheet or Income Statement.

Open

8. On the following dialog box, select either the Balance Sheet or Income Statement Select the Browse button and navigate to the location of the .csv file(s) saved in the previous step. Select OK to complete the process.

Open

9. Repeat this process to import both Income Statement and Balance Sheet information. Each must be separately imported.

10. Once the data has been imported, the Imported Income Statement Information and Imported Balance Sheet Information worksheets will appear in the Attached Forms list. If no information appears in these worksheets, review the data file you created. It must be properly formatted as a .csv file.

11. Once the data has been imported into the return, navigate to the Tax Line Mapping column on each of the Import Worksheets. Choose the appropriate tax line mapping for the item of income or expense (Income Statement) or asset, liability, or equity item (Balance Sheet).

12. Any data included in the Tax Line Mapping field that is not in the F3 list will be ignored in data processing. Any line that does not have a value in the Tax Line Mapping field will also be ignored. Do not choose a value for Tax Line Mapping for any row that corresponds to a “Total” value on the .csv Report.

13. When all applicable fields have been mapped to a Tax Line Mapping, press the Recalc button to refresh all data within the return based on the information mapped on these worksheets.

14. If any of the tax line mappings need to be changed for any item, navigate to the applicable line on the Imported Information worksheet(s), update the Tax Line Mapping, and press the Recalc button to refresh all data within the return based on the updated information.