Working with Employee Records in QuickBooks Online

Payroll requires countless details about each employee. QuickBooks Online will walk you through the process of entering them.

If you’ve only been on the receiving end of a paycheck, you may not know just how much prep work went into your neatly-organized pay stubs. Those official-looking columns of numbers that described how much you earned and how much was taken out – and for what purpose – were the result of a tremendous amount of data entry when you were hired.

Now it’s your turn to discover how complex that record keeping task is. QuickBooks Online was designed for small businesspeople who weren’t schooled in the intricacies of double-entry accounting, so it simplifies the process of preparing for payroll as much as possible. Still, it will probably be the most challenging element of your web-based bookkeeping.

We can help you navigate these sometimes-choppy waters so that you’ll be ready to run your payroll with confidence. Here’s an overview, though, of one of the most critical steps: creating employee records comprehensively and accurately.

Just the Facts

The left vertical toolbar in QuickBooks Online contains a link for Employees. This is where you’ll add and edit staff records. Once you’re set up and have begun running payrolls, the page that this link opens will display your current year’s payroll cost totals. There will also be a list of employees and their pay rates and payment methods; you’ll be able to click on their entries to view and edit their record details.

To get started, though, you’ll click on Add Employee. This opens a page that asks for the individual’s:

  • Full name,
  • Withholdings (you’ll enter W-4 information here),
  • Pay frequency,
  • Pay type and amount (multiple options are available here besides salary and hourly),
  • Deductions (retirement, health care, etc.), and
  • Pay method (check or direct deposit).

QBOI 1115 image 1_zpsophzzzqo.jpg

Figure 1: QuickBooks Online and its payroll component contain many screens like this that employ common data entry conventions. The mechanics are easy, but 100 percent accuracy is required.

Some of these requests for information have a small pencil icon next to them. This means that there are additional screens where you can provide the needed details. In the example above, you’re defining pay types that will be available to the employee, like sick pay and vacation pay.

Depending on your company’s benefits, entering deduction information may be the most detailed and time-consuming task. QuickBooks Online first lets you choose between entering a deduction/contribution or garnishment. If it’s health insurance, for example, you’ll have to indicate how much money will be deducted from employees’ earnings each pay period (in dollars or a percentage) and what the company-paid contribution will be (if any). If there’s an annual maximum, you’ll also enter it here, and you’ll indicate whether the premium amount is taxable or pre-tax.

A sample check is displayed in the right column of this page. As you enter information, the check will be filled in with the correct amounts. If you don’t have a particular detail at hand, you can save what you’ve done and come back later to finish the record. And you can always return to edit data you’ve supplied.

When you’ve completed all of this and clicked Done, you’ll be back at the Employees screen. Click on the name of the staff person whose records you just created, and you’ll see something like this:

QBOI 1115 image 2_zpsfh54n2q0

Figure 2: Once you’ve created an employee’s record, you can view all of its details and edit it as needed.

There will undoubtedly be times when you’ll want to see your employee data in report form rather than clicking through numerous individual records. QuickBooks Online offers several report templates that accommodate this. You’ll click on Reports in the left vertical toolbar, and then All Reports | Manage Payroll. The most relevant here in terms of viewing employee-related information are:

  • Vacation and Sick Leave,
  • Employee Details,
  • Payroll Deductions/Contributions,
  • Workers’ Compensation, and
  • Employee Directory.

Running your first payroll can be daunting. We hope you’ll let us help you prepare for it.

About Brenda J. McGivern, CPA

Brenda McGivern started her own certified public accounting and management consulting firm in October 2001. The full service CPA firm provides tax and accounting solutions to meet the needs of today's small business and individual. Brenda McGivern has become a trusted advisor and valuable resource her clients rely on for timely, accurate assistance when they need it. Before starting the firm, she worked as an accountant for three years at a local firm and prior to that five years at a large international CPA firm in Boston. She has performed the following tax services: federal, state and local tax planning, international tax planning, estate and succession planning, mergers and acquisitions, capital retention and IRS representation. She has also coordinated assurance engagements, such as financial statement audits, reviews and compilations from the planning phase through the reporting phase. She has prepared and reviewed regulatory filings for numerous regulatory agencies including the Security and Exchange Commission. Prior to these positions she was selected from over 2,000 candidates into an eight-person intensive financial management program at an international technology company. The program consisted of graduate level classroom study and two six-month rotational assignments in financial operations. She graduated cum laude from the University of Massachusetts at Amherst and holds a Bachelors Degree in Business Administration with a concentration in accounting. McGivern also holds a license in Massachusetts as a Certified Public Accountant and is a member of the American Society of Certified Public Accountants and the Massachusetts Society of Certified Public Accountants. She resides in Stoughton, Massachusetts with her husband Brian, and their sons Sean, Ryan and Conor and their dog, Davis.
This entry was posted in Amended Tax Return, Business, business help, Business Owner, deductions, Employee Benefits, Financial Planning, guide, Inventory, invest, Investing, investment, Operations, Payroll, quickbooks help, QuickBooks Online, QuickBooks Tips, save money, save on taxes, saving money, Tax, tax advice, Tax Fraud, Uncategorized and tagged , , , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s