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


Employees: Importing new employees and earnings

Employees: Updating employee information

Form 1095-C

Invoice items


Transaction data

Accounts payable transactions

Accounts receivable transactions

Time entry (for live payroll processing only)

After-the-fact (handwritten) payroll checks


Related topics

Sample files for spreadsheet import

Affordable Care Act reporting

Top of page