We moved!
Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!
Accounting CS enables you to import data for a batch of after-the-fact payroll checks from a spreadsheet.
Be sure that the spreadsheet is closed and remains closed during the import process.
Be sure that the spreadsheet is not password protected.
- Choose Actions > Enter Batch Handwritten Payroll Checks.
- Select Spreadsheet in the Input type field. The application automatically opens the Enter Batch Handwritten Payroll Checks dialog.
- In the Check Details section, specify the check date and period beginning and ending dates.
- If necessary, select a different frequency and/or bank account.
- Click Next to open the Spreadsheet Import wizard.
- Browse to the spreadsheet with the payroll check data and select the appropriate worksheet, and then click Next.
- If you saved mapping information from a prior import as a mapping template, that template will be included in the drop-down list in the Template field. If applicable, select the appropriate template. If you do not have an appropriate template, you can add a new template or map the columns manually.
- Click Next to begin the import.
- The Import Diagnostics screen displays a list of the information that will be imported from the spreadsheet and the analysis results for the data. If necessary, you can click the Back button to make changes to any of the mapping and options screens. To print a list of the diagnostic messages, click the Print button.
- When you are satisfied with the data that will be imported, click the Finish button.
Sample spreadsheet file
The following sample spreadsheet file is available for you to download and review. The sample spreadsheet is set up with commonly used columns and some sample data. You can modify the formatting, column, and data to fit your needs.
Was this article helpful?
Thank you for the feedback!