3rd Party Payroll Service

Posting G/L Transactions From a 3rd Party Payroll Service

The accounting transaction should be posted to EBMS to update the financial statements within EBMS.  The financial transactions that must be processed after each payroll are as follows"

  • Credit the checking account for the amount paid to the workers or to the 3rd party payroll service:   Crediting the bank account is necessary to reduce the checking account balance to cover the cost of payroll.

  • Credit the checking account for any tax payments:  This step reduces the bank account.

  • Debit the payroll payable account for ALL gross payroll costs:   Do not expense the gross payroll accounts within EBMS since the expense accounts were debited when the time was entered into the EBMS software.   See Processing 3rd Party Pay.

  • Debit the specific tax expense account for all company tax liabilities.   Note that worker taxes and other deductions are not included in the expense costs.    

Importing 3rd Party Payroll Transactions into an EBMS Journal:

EBMS includes the tools to map the CSV file from the 3rd party payroll processor to the payroll journal entry import.  

Complete the following steps to import labor accounting transactions from a file supplied by the 3rd party payroll processor:

  1. Download the CSV file from your 3rd party payroll processor

  2. Open a new labor journal by selecting Labor > Journal from the main EBMS menu

  3. Click New to open a new journal screen.

  4. Select Process > Import detail from file… option: Review the [Main Documentation] Optional Features > Import Document Details documentation for detailed instructions.

  5. Select the CSV file to import as shown below:

  6. Process the journal to update accounting information.   Review [Financials] Journals > Creating Journal Entries for more details on creating and processing journals.

Manual Entry of 3rd Party Payroll Journal:

These accounting transactions can be entered within a payroll journal within EBMS manually using the information supplied by the 3rd party service. Complete the following steps to post the payroll transaction to the EBMS general ledger system:

  1. Open a new payroll journal by selecting Labor > Journal Entry from the main EBMS menu.
  2. Set the journal Date to the processing date from the payroll service.
  3. Enter any notes to the journal Note such as the payroll service and any other details.
  4. Enter journal detail lines for the gross pay as outlined below:  Ignore the Employee ID and Reference2 entries if a single journal entry is entered because pay is processed through the 3rd party rather than individual worker pay checks.
  5. Enter journal detail lines for each company tax payable.
    Ignore the Reference2, Payment Flag, Taxable Gross, and Gross Pay entries if the tax records do not exist within EBMS.

    Debit

    Credit

    Credit/Debit Amount

    Employee ID

    Reference2

    Payment Flag

    Track1

    Track2

     

    Employee's gross pay transactions

     

     

     

    Payroll Payable G/L

    Checking         Account G/L

    Gross Pay

    Employee ID

    Check No.

    N/A

    Work Weeks

    Bank GL Account

     

    Note that adjusting the gross pay within a journal will not add gross pay-by-pay-type in Worker Pay tab > View Years. The gross pay totals by pay type cannot be adjusted since these totals are determined based on the pay date rather than the timecard detail date.

     

    Company Tax transactions

    Payroll tax Expense G/L

    Checking Account G/L

    Payroll tax

    Employee ID

    Tax ID

    Optional

    C (Company)

    Optional

    Taxable Gross

    Optional

    Gross Pay

    Optional

  6. Process the journal by selecting Process > Process from the journal menu.   
Review [Financials] Journals > Creating Journal Entries for more information on entering and processing journals.