Payroll is one of those areas that can be easily underestimated when scoping a QuickBooks Online cleanup project. The business uses a third-party payroll provider, employees are getting paid, and payroll taxes are being handled. It may be tempting to assume that the payroll activity is also being recorded correctly in QuickBooks Online.
Unfortunately, that is not always the case.
I encounter payroll recording problems frequently in cleanup projects. Some are relatively straightforward to correct, while others require substantial investigation, reconstruction, and reconciliation. The challenge during the initial review is recognizing the warning signs and evaluating the condition of the existing payroll records so that the potential work can be properly considered when scoping the project.
Payroll is often one of a business's largest expenses, yet the accounting side can receive surprisingly little attention when a third-party provider handles the processing. The provider may be doing everything correctly, but that does not mean the payroll activity has been properly recorded in QuickBooks Online.
For bookkeeping professionals reviewing a file for cleanup, recognizing the warning signs early can make a significant difference in understanding the work that may be required.
What I Look for During the Initial Review
When I review a QuickBooks Online file, I typically start with the Balance Sheet. I examine the account balances and drill down into the transactions, looking for unusual activity, inconsistencies, or balances that do not seem to make sense.
Payroll liability accounts are among those I pay attention to, particularly when they carry significant credit balances or debit balances. A credit balance may be perfectly legitimate if payroll taxes or other amounts remain outstanding. However, an unusually large balance, a debit balance, or an amount carried forward from prior periods without explanation deserves a closer look.
I review the activity in these accounts for the period I am evaluating. Are payroll liabilities being established consistently? Are payments being applied against them? Do the entries follow a recognizable pattern, or are there unexplained adjustments, missing periods, or changes in how transactions have been recorded?
At this stage, I am not trying to reconcile every payroll account. I am looking for indications of how payroll has been handled and whether the existing recording method appears reasonably consistent.
I take a similar approach with payroll expenses on the Profit and Loss.
Sometimes everything is recorded to a single payroll expense account, with no distinction between wages and employer payroll taxes. In other cases, wages and taxes may be separated, but there is no allocation between direct and indirect labor, no separate accounting for owner wages, or no recognition of benefits and reimbursements where appropriate.
Not every business needs an elaborate payroll expense structure. However, when important distinctions are missing, I want to understand whether that is simply how the accounts have been organized or whether the payroll activity itself has been recorded incorrectly.
Occasionally, the Profit and Loss looks fairly reasonable while the payroll liability accounts tell a different story. Other times, there are obvious problems on both reports.
These are warning signs, not necessarily conclusions. The purpose of this initial review is to identify potential issues and determine how much investigation may be needed during the cleanup.
What Those Warning Signs May Reveal
One of the most common problems I encounter is payroll being recorded directly from the bank withdrawals rather than from the payroll provider's reports.
For example, the net payroll payments may be coded to wages, while the entire payroll tax withdrawal is recorded as payroll tax expense. This approach accounts for the money leaving the bank, but it does not properly distinguish gross wages, employee withholdings, employer payroll taxes, and other payroll components.
Employee payroll tax withholdings are already included in gross wages. They are not additional payroll tax expenses for the employer. When they are recorded this way, total payroll expense may look reasonable, but wages are understated and payroll tax expense is overstated by the amount withheld. Because the totals appear to be in line, the problem is easy to miss. The split matters when wages need to agree with payroll reports and tax filings, or when owner compensation is being reviewed.
The issues become more involved when payroll includes employee benefit deductions, employer contributions, retirement plans, garnishments, or reimbursements. Some amounts affect expenses, others create or settle liabilities, and each needs to be accounted for appropriately.
I also encounter inconsistencies when a business changes payroll providers or bookkeepers during the year. Different recording methods may have been used, some payroll runs may have been entered correctly while others were not, or certain components may have been overlooked altogether.
Payroll integrations can create another set of problems. Many third-party providers offer integrations with QuickBooks Online, but the entries depend on proper account mapping and configuration. When that mapping is incorrect, the same errors may be repeated with every payroll run, sometimes for months before anyone notices.
This is why I pay attention to consistency during the initial review. A file with an established recording method and a few isolated errors presents a very different cleanup challenge from one where the payroll activity has been recorded inconsistently throughout the year.
Why the Underlying Transactions Matter
One example I encounter regularly involves health insurance benefits.
The payroll entries may correctly record the employee deductions and employer contributions, including the related liability and employer expense. However, when the health insurance premium is paid, the payment is recorded directly to health insurance expense rather than reducing the liability account.
Over time, the liability balance continues to grow on the Balance Sheet, while the Profit and Loss overstates health insurance expenses.
If nobody is reviewing the liability account, the problem may continue for months. I have also seen situations where the accumulated liability is addressed through a year-end adjusting entry that reduces the liability and expense.
A properly supported adjustment may correct the year-end financial statements, but there is value in examining the underlying transactions rather than simply adjusting the ending balance.
When reviewing the payroll activity alongside the actual insurance invoices and payments, I may discover additional problems. Perhaps a premium payment was made twice, a payment was missed, or the amounts deducted through payroll no longer agree with what the insurance company is charging.
These are issues that may not be apparent from a lump-sum adjustment to the account balances.
There is certainly a place for adjusting journal entries, and a thoroughly supported year-end reconciliation can uncover these same problems. My concern is when an adjustment is used to clear a balance without first determining what created it.
Correcting payroll transactionally helps establish what actually happened during the project period. It can also reveal errors that extend beyond the bookkeeping itself and may require the business owner's attention.
Reconciling Payroll Liability Accounts Is Part of the Work
Another important aspect of payroll cleanup is reconciling the related liability accounts. This is something I find is sometimes overlooked, even by experienced bookkeeping professionals.
Payroll liability accounts can be reconciled in QuickBooks Online, and doing so can be a valuable part of identifying discrepancies and supporting the balances.
The process involves comparing the amounts recorded from payroll with the supporting payroll reports, reviewing the related payments or settlements, and investigating any differences. The objective is not necessarily to bring every account to zero. It is to determine whether the remaining balance is supported and represents an appropriate amount.
Different payroll providers can complicate this process because they do not all collect and remit payroll taxes and other amounts in the same manner. Some collect the funds with each payroll run, while others collect certain amounts closer to their payment due dates. Depending on the arrangement, the accounting may also need to distinguish outstanding obligations from amounts already collected by the provider but not yet remitted.
Understanding how the provider handles these transactions is necessary before determining whether a liability balance is correct.
A completed reconciliation in QuickBooks Online does not, by itself, establish that an account is correct. The recorded activity still needs to be compared with reliable supporting information.
When liability accounts have not been reviewed or reconciled regularly, investigating the accumulated activity can be time-consuming, particularly if multiple accounts, payroll providers, or recording methods are involved.
Why Payroll Cleanup Can Take More Time Than Expected
There is a considerable difference between correcting a handful of payroll entries and reconstructing payroll activity for an extended period.
Regardless of how the accounts appear during the initial review, I obtain the relevant payroll reports and verify the recorded activity for the cleanup period. If the basic recording method is consistent and the entries are generally correct, the necessary corrections may be relatively limited.
When the activity is inconsistent, however, the work can become much more involved.
Depending on the issues identified, I may need to review payroll registers, payroll summaries, tax filing reports, employee deductions, employer contributions, funding information, and other supporting documents. Each payroll run may need to be compared with the entries recorded in QuickBooks Online to determine what was recorded correctly, what is missing, and what needs to be corrected.
In some cases, that means reconstructing the payroll entries and calculating the appropriate allocations among wages, employer taxes, benefits, reimbursements, and liabilities. Related payments must also be reviewed, and the affected liability and clearing accounts need to be reconciled.
When different payroll providers or recording methods have been used during the project period, the investigation can become even more complicated.
What makes this work time-consuming is not necessarily entering the corrections. It is determining what should have been recorded, identifying what actually happened, and resolving the differences.
A payroll recording problem that initially appears to involve one account may affect several others. And when the same error has been repeated across numerous payroll runs, the amount of work can increase considerably.
Do Not Overlook Payroll When Scoping a Cleanup
When reviewing a QuickBooks Online file for cleanup, it is natural to focus on bank reconciliations, income reporting, and other obvious bookkeeping issues. However, payroll deserves attention as well, particularly when it represents a significant portion of the business's expenses.
A practical starting point is to examine the payroll liability accounts on the Balance Sheet and the payroll expenses on the Profit and Loss. Look beyond the balances and expense totals to the underlying transactions. Inconsistencies, unusual balances, or changes in recording methods can provide valuable clues about the condition of the payroll records and the work that may be necessary.
The goal during the initial review is not to identify every correction, but to develop a reasonable understanding of the condition of the existing records and the potential work involved.
Payroll may be processed by a third-party provider, but recording that activity properly in QuickBooks Online is still an important part of the bookkeeping. Recognizing problems early, understanding their implications, and accounting for the investigation and reconciliation they may require are all part of properly scoping a cleanup project.
If you are working through a challenging payroll recording issue in QuickBooks Online and would benefit from another professional perspective, I offer one-on-one consultations to help bookkeeping and accounting professionals evaluate problems and determine appropriate next steps.
Valerie Armstrong is a QuickBooks Online cleanup specialist and founder of CleanUp Consultants, helping accounting, bookkeeping, and tax firms resolve challenging client files with confidence. With hundreds of cleanup projects completed over the last eight years, Valerie brings professional judgment, investigative thinking, and valuable experience to the work, collaborating with firms to provide clear, reliable QuickBooks Online files for their clients.