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 ...
    • Data Import Tool - New for Lists!

      Highlights Explore the new features of our rebuilt Data Import Tool for Lists! (Transactions will be coming soon!) Import multiple data import types for Lists in the same import session, using one or many files - your choice! Example: Import ...
    • AccountingSuite™ Release Updates, Imo-Inu 2, Data Import Tool - New for Lists!

      AccountingSuite™ Release Update, Imo-Inu 2, Data Import Tool - New! Announcing AccountingSuite™'s rebuilt Data Import Tool for Lists! (Transactions will be coming soon!) ​ Import multiple data import types for Lists in the same import session, using ...