Setting up Payroll Tracking

There are several steps that are required to set up payroll tracking in FIMS.

  • Create a few special Operating Fund accounts in General Ledger, including the following:
    • Payroll Expense
    • Salaries Payable (you can also use Account Payable)
    • Expense Accounts for Employer’s Contributions (for example, to Social Security, Medicare, or benefit packages)
    • Payable Accounts for Withholding Amounts (for example, Federal and State taxes and Health Insurance).
  • Create a Vendor record for each employee.
  • Create a Vendor record for each agent to whom you periodically send the accumulated withholding amounts.

Entering Payroll in Accounts Payable

When payroll checks are paid, the following occurs in General Ledger:

  • The Checking Account balance is reduced by the net pay amount.
  • The Payroll Expense Account will have a debit (increase) equal to the gross pay amount
  • Each Payable Account that is accumulating the withheld amount will have a credit (increase). The combined credits should equal the difference between gross pay and net pay.
To accomplish this in Item Entry you must be flexible in the use of Expense account field. You must also create several line items to record the payroll Voucher:
  • Enter the Gross Pay on the first Line Item, and enter the Payroll Expense account in the Expense field.
  • Enter the Federal Taxes withholding amount on the second Line Item. Make sure you enter the amount as a negative number (place a minus sign in front of it). Enter the appropriate payable account in the Expense field.

Note: Because the withholding amount is entered as a negative amount, FIMS will make a credit entry to the payable account.

  • Create additional Line Items with negative entries to record additional withholding amounts (for example, deductions for FICA, State Taxes and Health Insurance). As with the second line item, enter payable accounts in the Expense fields for each of these withholding amounts.

The net pay (after deductions) appears in the Voucher Total field.

Note: after these Vouchers are created for the first payroll payment, you can use Allow Voucher Recall to copy the Line Items for subsequent checks.

Paying Taxes and Benefit Premiums

When you use Accounts Payable to pay taxes or premiums, you must be flexible in your use of the Expense field on the Line Items tab.

The goal is to reduce the appropriate payable account(s) by the amount of the payment. For example, if the premium is due on group Health Insurance that is paid through a combination of employee withholding and employer payment, you would create one Line Item for the employee contribution and one for the employer contribution.

  • Enter the employee’s contribution on the first Line Item. Make sure to enter the amount as a positive number, and enter the payable account in the Expense field.
  • Enter the organization’s contribution on the second Line Item and enter the appropriate expense account in the Expense field.