Spreadsheet import overview

Alerts and notices

Use the Spreadsheet Import wizard to import data from a spreadsheet in .XLS or .XLSX file format. During the import process, you will map the spreadsheet columns to data in Accounting CS. The application verifies the data based on the specified mappings.

Note: As a best practice for importing client data from a spreadsheet, be sure to clear all cell formulas and replace them with actual values before importing them into Accounting CS.

Special information

Types of data available for spreadsheet import

Setup data

Chart of Accounts



Form 1095-C

Invoice items


Transaction data

Account balances from QuickBooks

Account balances from Xero

Accounts payable transactions

Accounts receivable transactions

Time entry (for live payroll processing only)

After-the-fact (handwritten) payroll checks


Related topics

Conversion topics in Accounting CS

Sample files for spreadsheet import

Affordable Care Act reporting

Top of page