Importing Payroll Data

User can now import payroll data into Abacus Accounting, which saves them time because they will not have to enter the payroll data manually. Data is imported using a text file (comma, pipe, or tab separated).

  1. Select G/L > Import Monthly Payroll from csv file.

  2. The Importing Monthly Payroll Data window opens. The window maps the accounts to include payroll entries. Change the accounts as needed.

    NOTE: The account mapping is copied from the Default Accounts window's Payroll Accounts tab (File > Setup > Default G/L Accounts). Any changes made to the Importing Monthly Payroll Data window are made to the Default Accounts window's Payroll Accounts tab and vice versa.

  3. At the bottom of the Importing Monthly Payroll Data window:

    1. For Input File, select the text file with the payroll data.

    2. For Values separated by, select Comma, Pipe, or Tab.

    3. For Pay Period from, enter a start and end date for the payroll pay period.

    4. For Posting Date, enter the date the payroll data should be posted.

    5. Click Proceed.

  4. Abacus Accounting reads the import text file. Click OK.

  5. The payroll general ledger entries are created.