Why Your Payroll Total Never Matches the Bank, and How to Reconcile It

What actually leaves your bank on a payroll day

Most owners look at the payroll report, see the gross wages, then look at the bank and see a smaller number. They think something is wrong. Usually nothing is wrong. The bank total is just a different set of numbers.

On a pay day, the cash that leaves your bank is the take home pay for your workers. That is the gross pay minus the amounts taken out. The amounts taken out do not leave your bank on pay day. They leave later, on the day you send them to the agencies.

On top of the take home pay, your bank may also show the employer costs on the same day, or on a different day. And there can be a fee from your payroll provider. So the number that leaves the bank is take home pay, plus maybe employer costs, plus maybe a fee. It is almost never the gross wages number.

Here is what can leave the bank around a pay run.

• Take home pay for each worker.
• Employer costs, sometimes on the same day.
• A fee from your payroll provider.
• Tax payments sent to the agencies on a later day.

Dates and rules change. Confirm what leaves your bank on pay day with your payroll provider, your CPA, or the agency.

The usual reasons the numbers do not match

Once you know that several things move on different days, the reasons the totals differ start to make sense. Here are the common ones.

Timing is the biggest reason. The gross wages are recorded in the books on the day the pay is earned or the day your CPA tells you to use. The cash leaves the bank on pay day. The tax payments leave the bank on their own dates. Three different days, three different numbers.

Taxes paid on a different day are the next reason. The amounts taken from the worker and the employer costs are held, then sent to the agencies on a set schedule. That schedule is not pay day. So the bank shows the tax payment as a separate withdrawal, often in a different week or month.

Fees add a small line you might forget. Your payroll provider may charge a fee per run or per month. That fee leaves the bank too, and it is not part of the wages.

Corrections happen when a pay run is fixed after the fact. A wrong rate, a missed hour, or a returned check can change the numbers. When a correction runs, the bank shows a second withdrawal or a deposit that the first report did not have.

Here are the common reasons the totals differ.

• Timing, because pay, taxes and fees move on different days.
• Taxes sent to the agencies on their own dates.
• Fees from your payroll provider.
• Corrections that change the numbers after the run.

Ask your payroll provider what fees and tax dates apply to your setup.

A simple monthly reconciliation in five steps

Reconciliation just means checking that your books and your bank tell the same story. You do not need fancy tools. You need the payroll report, the bank statement, and a few minutes.

Step one. Get the payroll report for the month. This shows the gross wages, the amounts taken out, the employer costs, and the take home pay for each run.

Step two. Get the bank statement for the same month. Mark every withdrawal that came from payroll. That includes the take home pay, the tax payments sent to the agencies, and any fees.

Step three. Match each payroll report total to a bank withdrawal. The take home pay should match a pay day withdrawal. The tax payments should match the agency withdrawals. The fees should match the provider withdrawals.

Step four. Find the items that do not match yet. A tax payment sent near the end of one month might clear the bank in the next month. A correction might sit in one report but not the other. Note each one and why it differs.

Step five. Write down what is still outstanding. These are the amounts that belong to the month but have not cleared the bank yet. Next month, check that they cleared. When they do, the books and the bank agree.

Here is the five step reconciliation.

• Get the payroll report for the month.
• Get the bank statement and mark the payroll withdrawals.
• Match each report total to a bank withdrawal.
• Find the items that do not match yet.
• Write down what is still outstanding.

Your CPA decides the accounting method and we keep the books consistent with it. The point is to do the same steps every month so nothing hides. We are QuickBooks Online Accountants, or QBOA, and we work in QuickBooks Online and Xero. We keep the payroll lines in the same software your books live in.

Red flags to look for

Most gaps are timing. A few are real problems. Here is what should make you stop and look closer.

A withdrawal with no matching report line. If the bank shows a payroll withdrawal that is not on any report, find out what it is. It could be a fee you forgot, or it could be a charge that does not belong.

A report line with no matching withdrawal. If the report shows take home pay but the bank never sent it, the pay run may have failed. Your worker may not have been paid.

The same amount twice. Two withdrawals for the same total can mean a run was sent twice. That drains the bank and overpays the taxes.

A growing gap each month. If the difference gets bigger every month, something is not being recorded. A fee, a correction, or a tax payment is landing in the wrong place.

Here are the red flags.

• A withdrawal with no matching report line.
• A report line with no matching withdrawal.
• The same amount taken out twice.
• A gap that grows each month.

When you see one of these, stop and trace it before you move on. Ask your payroll provider or your CPA for help.

Made up example for teaching

One pay run traced from the report to the bank

A small shop runs payroll every two weeks. The numbers below are made up and round so the math is easy to follow. They are not real rates or real rules. Confirm the real amounts with your payroll provider or your CPA.

The payroll report for one run shows gross wages of two thousand dollars. The amounts taken from the workers are four hundred dollars. The employer costs are two hundred dollars. The take home pay is sixteen hundred dollars.

On pay day, the bank shows one withdrawal of sixteen hundred dollars. That is the take home pay. The gross wages of two thousand dollars are in the books, but only sixteen hundred left the bank.

Later in the month, the bank shows a second withdrawal of six hundred dollars. That is the amounts taken from the workers plus the employer costs, sent to the agencies together. Now the books and the bank agree. The wages line shows two thousand dollars. The liability accounts show the six hundred that was held and then sent. The bank shows sixteen hundred plus six hundred, which is two thousand two hundred, the wages plus the employer costs.

The owner uses their own payroll provider to run the pay, take out the right amounts, send the pay checks, and send the filings. We keep the books. Each line lands where it belongs, and the reconciliation that month is just a match.

This is a made up example for teaching. Your numbers and your setup are your own. Confirm the dates and rules that apply to you with your payroll provider, your CPA, or the agency.

Common questions

Why does my bank total not match my payroll report? Because the bank only shows the cash that left, and payroll moves cash on more than one day. Take home pay leaves on pay day. Taxes leave on their own dates. Fees may leave on another day. The report shows the full picture, the bank shows pieces.

Do I need to reconcile payroll every month? Yes. A monthly check catches timing gaps before they grow, and it catches real mistakes early. It takes a few minutes once you have the report and the bank statement.

What if a withdrawal has no matching report line? Stop and trace it. It could be a fee you forgot, or it could be a charge that does not belong. Ask your payroll provider what the withdrawal was.

Do you run the payroll? We offer monthly payroll with pay runs every pay period, pay checks, filings and a clean tie to your books. You can read more on our payroll page or reach us on our contact page.