Importing Payroll Records

Importing Payroll Records

Overview

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

Usage

  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 Wizard

      Data Import Wizard If you are trying to import transactions into Cloud Banking, please see this article. The Data Import Wizard is a powerful tool and feature that enables users to efficiently bring external data into their system. With this tool, ...

    • AccountingSuite™ Release Updates: Data Import Tool, Cloud Payroll, Cloud Banking, Multi-Currency: Jack Russell 3: 08/24/2023

      Data Import Tool improvements to the user interface and experience. In the Mapping Preview, the pagination buttons have been moved to the bottom of the page. You can now upload a new file without restarting the whole tool. Header fonts have been ...

    • 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 ...