Importing payroll into AccountingSuite™

Importing Payroll Records


AccountingSuiteâ„¢'s  Payroll Import Feature allows you to import records from a third-party payroll processor.


  1. Obtain a processed export file from the third party payroll processor.  
  2. Navigate to Accounting / Payroll Import.
  3. Choose the Payroll service (SurePayroll, ADP, PrimePay or Generic for others).
  4. Click the ellipses to choose your payroll import file from your workstation.
  5. Click ok.   The mapping table will populate.
  6. Choose the character used in the file to separate fields.
  7. If your file has a header row, check the checkbox labeled Has Header Row
  8. In the mapping table, choose the ACS field for each column in the import file by clicking in the field and choosing an option from the down list.
  9. Click Save Mapping.
  10. Click Continue.

  11. Review the table in the next screen to ensure that the columns and data match.
  12. If there are any incorrect records, you can resolve them in the table.     Choose Incorrect from the Show toggle.
  13. Click Continue.

  14. Map the G/L Account in AccountingSuiteâ„¢ with the Account number from the import file.
  15. Click Continue.

  16. The journal entry is created and may be reviewed.

Last Updated  11/13/2020 - JML

    • Related Articles

    • Importing Payroll using the Gusto Integration

      Importing Payroll Pick a Payrun to import and click the import link on the line. On the Select Employees screen verify the information and click Next . Click Next . Verify that the transactions on the screen are correct. Click Import . Confirm the ...
    • Data Import Tool

      Importing Data Please note : We are in the process of improving this tool, so you may see some things not mentioned here! There is more detailed documentation in the works. If you are trying to import transactions into Cloud Banking, please see this ...
    • Importing Items

      Importing Items When setting up either product or service based companies, creating items in inventory allow you to put them on Sales and Purchases Orders, Sales Invoices and Bills, and Time-tracking records. Wait! Time-tracking records? Why would ...
    • Setting up the Gusto Connection

      Setting up the Gusto Connection The first step after making the connection is to complete settings. Select the company from the drop down menu. Enter the beginning date of the oldest payroll period that you’d like to work with in the Enter Payroll ...
    • Importing Customer, Vendor and Inventory Item Data

      Importing Customer, Vendor and Inventory Item Data Leave the importing to us! We will import your Customers and Vendors from your old accounting package, free of charge. Here’s what you need to know and what you need to do to make this happen. Your ...