Spreadsheet import overview

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

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

Customers

Employees

Form 1095-C

Invoice items

Vendors

Transaction data

Accounts payable transactions

Accounts receivable transactions

Time entry (for live payroll processing only)

After-the-fact (handwritten) payroll checks

Transactions

Related topics

Sample files for spreadsheet import

Affordable Care Act reporting

Top of page

Share This