US Payroll Setup

US Payroll Setup FAQ

Background
Before Using Payroll
Setting Up Employees
Setting Up Vacation/Holiday Pay Entitlement
Adding a Payroll Category
Paying Payroll aLiabilities

Background

This article will cover the proper initial setup for using the Payroll feature in AccountEdge for the US.

Using the payroll feature, you can:

  • Process payroll for your employees
  • Track, pay and report employee accruals and entitlements
  • Pay accrued payroll liabilities
  • Print pay stubs and paychecks

Before Using Payroll

Before you start using the payroll features, you need to:

Enter general payroll information

To enter General Payroll Information:

  1. Go to the top menu bar and select Setup > Payroll & 1099 Information
  2. Verify that all information here is accurate
  3. You are responsible for making sure the FUTA and SUI rates are updated when necessary
Load tax tables To load tax tables:
  1. Click Setup > Payroll Updates
  2. Click Load Tax Tables
Payroll taxes are amounts withheld from employee payroll according to the rules established by the government taxation authorities. In this software, these calculation rules are stored in a tax table file that you load into your company file. If you intend to process payroll in AccountEdge Pro, you will need to be on the latest version of AccountEdge and enroll in the Payroll Tax Service to keep your tax tables current. Review payroll categories You can review your payroll categories by going to:
  1. Lists > Payroll Categories from the menu bar at the top of the screen
  2. Click on the Payroll Category list (Wages, Deductions, etc) you want to review
The components of an employee's pay, such as wages, accruals, deductions, expenses and withholding taxes, are called payroll categories. These are assigned on an employee's card to calculate payroll. It's a good idea to review the details of each payroll category to make sure it matches the way you do business.

Setting Up Employees

You'll need to create an employee card for each employee. On the employee's card, you'll store name, address and optional information, as well as payroll information. You'll start with setting the basic details and then the wage, deduction, expense and tax information. To create employee cards:
  1. Go to the top menu bar and select Lists > Cards to open the Cards List
  2. Click the Employee tab
  3. Click the New button and enter the employee's name and contact information
  4. Click on the Payroll Details tab
  5. Enter the Social Security #, Residence Code, Work Code, and other information that you have
Adjusting Wage Information
  1. Click on the Wages link on the left-hand side of the window
  2. Enter the Pay Basis (as Salary or Hourly)
  3. Enter the Annual Salary or the Hourly rate
  4. Enter the Pay Frequency
  5. Enter the Hours per Pay Period
  6. AccountEdge Pro will have set a default wage expense account; change this only if there is a specific need
  7. Select the applicable wage categories by placing a tick to the left of the wage category
Payroll withholding taxes will be based on the gross wages indicated on an employee's paycheck times the pay frequency indicated on the employee's card. This calculation is used to determine the annual gross wage and therefore, the tax bracket where applicable.
Adjusting Accrual Information
  1. Click on the Accruals link on the left-hand side of the window:
  2. Select the applicable accrual categories by placing a tick to the left of the accrual category
Click here to see more about setting up accruals
 
  Adjusting Deduction Information
  1. Click on the Deductions link on the left-hand side of the window:
  2. Select the applicable deduction categories by placing a tick to the left of the deduction category
  3. Enter Deductions other than withholding taxes
Adjusting Employer Expense Information
  1. Click on the Employer Expenses link on the left-hand side of the window:
  2. Select the applicable expenses by placing a tick to the left of the expense category. AccountEdge Pro will have selected the default expenses. You'll just need to verify them.
Adjusting Tax Information
  1. Click on the Taxes link on the left-hand side of the window
  2. Set the Marital Status, Allowances, and Extra Withheld for Federal
  3. Set the Allowances and Extra Withheld for State
  4. Verify AccountEdge Pro has selected the appropriate withholding taxes for the employee
Recurring Pay To setup recurring pay:
  1. Click on the Recurring Pay link on the left-hand side of the window
  2. If the employee is Salaried, or if the employee is Hourly and you are not using TimeSheets, recurring payroll values can be indicated in this window.
  3. You can adjust the figures as necessary
[Optional] Adjusting Time Billing Information
  1. Click on the Time Billing link on the left-hand side of the window.
  2. Enter the appropriate Time-Billing rate for the employee. Use of this rate is determined by selection on the Activity profile.

Vacation/Holiday Pay Entitlement

Vacation/Holiday Pay Entitlement is implemented using two or more, payroll categories. One category is made as an Accrual and the other category is made as a Wage. For example you may have a “Vacation Pay 4%” Accrual and a “Vacation Pay” Wage. The accrual categories accrue the entitlement, which is paid out with the vacation pay wage category. The accruals are added to a liability account, and subtracted from that liability account as they are paid out. You may have more than one accrual category.

Configuring Vacation Pay

Both the accrual and the wage paid out categories need to be associated with the employee (ticked). The vacation pay wage category is set up as a Hourly type of of wage even for salary employees. Usually the Pay Rate is set as the Regular Rate Multiplied by 1.0000 however you can change this as you want to. The option to Automatically Adjust Base Hourly or Base Salary Details can be checked if you pay out the vacation pay in replacement of their regular pay during vacation hours. If you pay your vacation pay during each pay period instead of just during a vacation, you most likely do not want to check this off. The Vacation Accrual category should be an Accrual type of payroll category. The Type of Accrual determines how much gets accrued and the Accrual Limit determines the maximum that can be accrued. The Linked Wages Category is where you select the Vacation Pay wage which when paid out will reduce the accrual balance. You can use the Exempt button to exclude wage categories before calculating the accrual amount. To set this up:
  1. Go to Lists > Card List from the menu bar at the top of the screen
  2. Select the Employee from the list.
  3. Click on the Wages link on the left-hand side of the window.
  4. Place a tick to the left of the vacation pay wage category to associate it with the employee.
  5. Click the arrow to the left of the vacation pay wage.
  6. Adjust the wage settings as needed (note that if you change anything about the wage category it will change it for all employees using that specific wage).
  7. Click OK when you are done adjusting the wage.
  8. Click on the Accruals link on the left-hand side of the window.
  9. Select the applicable accrual category by placing a tick to the left of the accrual category. This is the category used to calculate entitlement vacation pay.
  10. For each line, click in the Carry Over column if you need to add accrued amounts from a period before AccountEdge use. If, by agreement with your employees, the employees are to have accrued amounts available at a specific time such as first of the year, or an employee anniversary, you would add the amount in this window.
  11. Click the arrow to the left of the accrual category name to configure the accrual (note that if you change anything about the accrual category it will change it for all employees using that accrual).
  12. Set the Type of Accrual, Accrual Limit, and other details.
  13. Set the Linked Wages category as the vacation pay wage that when paid out will reduce the accrual balance.
  14. Click OK when you are complete

Paying Vacation Wages

If using timesheets, the vacation pay wage will appear as a line item; you could indicate the paid out hours on the timesheet. Whether you are using timesheets or not, the vacation pay wage will appear on the employee's stub.

When processing payroll in the Select and Edit Paycheck window, verify the vacation pay wage line item exists, and enter the hours (if desired), if not already entered. In any case, verify (or enter) the dollar amount you are paying out.

Paying the employee with the vacation pay wage category, will consume the value accrued by the vacation accrual.

Vacation Pay Accounting

The Accruals are expensed when they are paid. Both the employer and employee taxes are withheld when the accruals are paid out.

Add New Payroll Categories

To add a new payroll category:

  1. Go to Lists > Payroll Categories from the menu bar at the top of the screen
  2. Click on the specific category
  3. Click the New button
  4. Follow the steps to create the new payroll category (ie: enter a name, make any selections)

Paying Payroll Liabilities

Payroll liabilities comprise your employer expenses and amounts withheld from an employee's pay that must be paid to an appropriate authority or agency. Payroll liabilities are recorded when you process payroll. When you need to pay these amounts, you can use the Pay Liabilities feature.

To pay your payroll liabilities:

  1. Go to the Payroll module and click Pay Liabilities
  2. Specify how the payment is to be made. If you are paying the vendor electronically using Vendor Payments, select Group with Electronic Payments
  3. In the Pay from Account field, type or select the account you are making the payment from
  4. In the Vendor field, type or select the authority or agency to whom the withheld amount is being paid
  5. Select the type of liability you are paying from the Liability Type list. By default, all payroll categories for the selected liability type are included in the payment. If you do not want to include all payroll categories:
    • Click the search icon in the Payroll Categories field
    • Deselect categories by clicking in the select column next to each payroll category you want to exclude
    • Click OK
  6. In the Dated From and the Dated To fields, type the period in which the payroll liabilities were withheld. The payroll liabilities withheld during the specified period appear in the Payroll Category section.
  7. Click in the select column next to the payroll liability amounts you want to include with this payment
  8. The total of the selected liabilities appears in the Total Payment field
  9. Click Record