Why does the payroll clearing account not return to zero, and what is stuck in it?
Each payroll creates amounts that you owe to your staff, the tax authority, the 401(k) or pension provider and sometimes a court. Each amount waits in its own account until you pay it. This skill finds what stays in those accounts, how old it is, and what it probably is.
You give it a month and the payroll files. It ages every balance in your payroll accounts and tests if each account behaves as it should. It finds the old amounts that never left, and says what each one probably is. It suggests a correction for each item. It never pays anything, never writes off money that a person owns, and never changes your books.
A waiting room for net pay, and a separate account for each amount you hold
When you record a payroll, the net pay for your staff goes into a waiting room in your books. When the bank pays your staff, the same amount leaves the waiting room. So after each pay run, the waiting room is empty again. Accountants call it the payroll clearing account.
So each payroll account has a correct shape. The clearing account must return to nil after each run. A tax account must hold about one month of taxes if you pay monthly. If an amount stays when it should leave, a payment did not occur, or an entry is wrong.
4,023.40 in Northbrook's clearing account, from five items
Northbrook pays its staff on the last business day of each month. A payroll provider calculates the pay. On Monday 19 October, the owner runs the skill for September 2026. The skill reads twelve months of entries on the clearing account, 2200, to Wednesday 30 September. Normal pay runs leave nothing. These movements did not net to nil:
| Date | What happened | Reference | Amount | Balance after |
|---|---|---|---|---|
| Before 1 Oct 2025 | An old balance from earlier books. The twelve months show no detail for it | none | 23.40 | 23.40 |
| 3 Feb 2026 | A direct deposit from the 30 January run came back because the account no longer existed. Nobody paid it again | EE-03 | 640.00 | 663.40 |
| 30 Apr 2026 | Final pay in the April run, held because of a dispute about the final settlement | EE-05 | 1,150.00 | 1,813.40 |
| 30 Jun 2026 | Payroll check #1987 from the 31 October 2025 run. Nobody cashed it, and it became void as stale | EE-11 | 410.00 | 2,223.40 |
| 4 Aug 2026 | A direct deposit from the 31 July run came back | EE-07 | 1,250.00 | 3,473.40 |
| 6 Aug 2026 | Northbrook paid it again as check #2214 | EE-07 | −1,250.00 | 2,223.40 |
| 24 Sep 2026 | Manual entry JE-0912, memo "reclass contractor". No payroll run is behind it | JE-0912 | 1,800.00 | 4,023.40 |
| 30 Sep 2026 | Balance in the books | 4,023.40 |
The skill then sorts the 4,023.40 by age, in months before September. It ages each item from the run or entry that its memo names. Where a memo names nothing, it uses the oldest first, and it states which method it used.
1,800 + 0 + 1,560 + 663.40 = 4,023.40. Four items are older than 60 days, the skill's limit for a clearing account. The skill reports them as a total first: 2,223.40 in four items, more than 60 days in payroll clearing. The oldest is from before October 2025. JE-0912 is only 6 days old. The skill still lists it, because a manual entry with no payroll run behind it does not belong in this account.
The owner's question, in one line: 2200 does not return to zero because 4,023.40 of five items never left it. Two are unpaid wages that people own (1,050.00). One is a disputed final pay (1,150.00). One is an entry with no pay run behind it (1,800.00). The last 23.40 has no known origin.
A month that looks explained, on top of 2,223.40 that nobody explained
The usual monthly check compares the account with last month. The balance went from 2,223.40 to 4,023.40, and JE-0912 explains the 1,800. The skill uses a different test. A clearing account must be nil after the run, so it compares the balance with nil.
What the skill does
Expected balance for a clearing account: nilThe common shortcut
Start balance, plus pay recorded, less pay paidThe skill also finds the lowest point of the balance in twelve months. At Northbrook that is 23.40. It is the part that never cleared at any time. The other 4,000.00 came into the account inside the twelve months, so the lowest point cannot show it. The age bands and the 60-day test show it. The skill reports all three results before any other work.
The federal tax account agrees with the books, and it holds two months
The same tests apply to each account for amounts that you hold for others. A tax account that you pay monthly must hold about one month of taxes at a month end. Northbrook deposits federal taxes monthly, by the 15th of the next month. If the 15th is not a business day, the deadline moves to the next business day2. Under Publication 15 (2026), an employer is a monthly depositor if its taxes for a lookback period were $50,000 or less2.
| Account | Start | + Owed | − Paid | Books | What the skill says |
|---|---|---|---|---|---|
| 2210 Federal payroll taxes | 12,600 | 14,400 | 0 | 27,000 | Agrees with the books. It should hold one month, 14,400. It holds 12,600 more, and no payment left in September |
| 2230 401(k) | 3,400 | 3,700 | 3,400 | 3,700 | Agrees, and holds one month. Due 7 October |
| 2240 State unemployment | −300 | 150 | 0 | −150 | Agrees, and is below zero. Northbrook paid 600 twice, on 30 July and 3 August |
The roll-forward of 2210 gives a difference of zero, so the account looks reconciled. The skill does not accept a zero difference as proof. The expected figure came from the same entries as the books, so the zero proves only the arithmetic. The behaviour test shows the problem: the account grew, and it did not drop in September. The September 14,400 is not due until Thursday 15 October. The skill documents it as timing and proposes no correction for it.
The 12,600 is only 30 days old on 30 September, so the age test does not catch it yet. The behaviour test does. The full tie-out of the register to the books and the bank belongs to a different skill, payroll reconciliation. Part of the 12,600 is money that Northbrook took from its staff's pay. In the US, a person who must pay that money and willfully does not pay it can be personally liable3. This page is not legal advice.
Unclaimed pay stays a debt to a person
An easy correction is to write off the whole 4,023.40 so that the account shows zero. The skill refuses that. 1,050.00 of it is pay that two people own: the deposit that came back (640) and the check that nobody cashed (410). That money belongs to the employee until it belongs to the state. For example, in California, payroll and wages become unclaimed property after one year, and a business that holds unclaimed property must report it each year4. Other states have different periods and rules. Before a report, California expects the holder to send a letter to the owner's last address5.
| Item | Amount | Suggested treatment | Who acts |
|---|---|---|---|
| EE-03 and EE-11, unclaimed pay | 1,050.00 | Move it out of clearing to a separate account for unclaimed wages, 2260. Never to income. The skill flags the unclaimed property duty as a compliance matter | The owner tries to contact each person, and decides on unclaimed property with an adviser |
| Origin unknown | 23.40 | Write it off to other income, under the 50.00 limit of the owner. Only after a request for older records, and only if nobody can identify a person | The owner approves |
| JE-0912 | 1,800.00 | If it is a contractor's bill, move it to accounts payable, 2000. If it is wages, the payroll records and filings are short | The owner and the accountant decide |
| EE-05, disputed final pay | 1,150.00 | No entry. It stays under investigation until the dispute ends | The owner |
| 2210, August taxes | 12,600 | A payment to make. No entry | The owner pays the IRS |
| 2240, below zero | −150 | A refund to claim from the state, or a prepayment. First get the state's statement of account | The owner |
An account for amounts you owe goes down only when you pay them, or when the creditor releases you. So the skill never writes off a tax or benefit balance without a statement from the authority or provider. A small write-off is a one-time step. If the same small write-off occurs each month, the skill reports it as a fault in the process.
Eight items, in one message
The skill asks these first, in one short batch. It asks only for what it cannot already see. Items E, F and H are requests for files.
- Use MosoFin for this run, or upload the data yourself?MosoFin is the connection to your books and the other platforms that you link. With it, the skill reads from there. Without it, you upload the files, and the checks are the same. It asks only if your account has the MosoFin tools.
- Which company, and which payroll accounts: clearing, suspense, and each account for amounts that you hold or owe?It does one reconciliation for each account, and each company has its own clearing account. On the MosoFin path, it shows the payroll accounts from your chart, and you approve the list. It never picks a company for you.
- Which period?Required. Every read and every roll-forward uses it.
- How often do you pay each amount that you hold: monthly, twice a week, each quarter?Required. The correct balance of each account depends on it. The skill never guesses it. Without it, the behaviour test has nothing to compare with.
- Please give the payroll register for the period.Required. The register is the report from your payroll software, and it shows what each run owed. If you cannot give it, the skill uses your payroll entries in its place and says so. Then the result proves only that the account moved as the entries say.
- Please give the bank statement for the period.The statement proves that the money left. Without it, the skill compares with the payments in your books and says so.
- What is your limit for a write-off, and who approves one?The limit separates a small leftover from one that needs a correction. The skill never sets a write-off for you.
- If you want a balance cleared, please give the statement of account from the tax authority, pension or benefit provider.Recommended, and required before any write-off on those accounts. A leftover on them is usually a payment to make or a refund to claim.
Northbrook's owner uploaded the files. The owner gave a limit of 50.00 and approves each write-off. The skill found one more account with payroll entries, 2250 Accrued payroll, and asked about it. The owner reviews 2250 with the month-end accruals, so the workpaper names it as excluded, with that reason. Then the skill reads the plan back and waits for a yes. The skill's own sample is for a UK company. For this US example, it reads like this:
"Reconciling the payroll control accounts of Northbrook Trading for September 2026 (payroll clearing 2200, federal payroll taxes 2210, 401(k) 2230 and state unemployment 2240) from the files you uploaded: GL detail for the last twelve months, trial balances at 31 August and 30 September, the September payroll register, the remittance records and the September bank statement. The accrual side uses the register. Federal taxes remitted monthly by the 15th, 401(k) monthly by the 7th, state unemployment quarterly. The bank tie-out is to the bank statement. Shall I go ahead?"
It never repeats one person's line back to you.
Connect your books, or upload seven items
It reads the books, and you supply the rest
- It reads back the workspace and the company file by name, and waits for your yes
- It checks if a payroll platform is also connected. If yes, it reads the register too. If no, it says so
- It shows the payroll accounts from your chart, and you approve the list
- It reads the balances of each account at both ends of the period. It also reads every entry and its age, the payroll entries, and the payments by payee and date
- It reads the payments, but not the authority's receipt. You still give it the payment schedules, the register if you have no payroll platform connection, the bank statement and the statements of account
The checklist that the skill gives you
- Entries on each payroll account for the period and the twelve months before it, CSV or XLSX. Also the balances at this and the last period end. A trial balance works. Required
- Payroll register for the period, CSV, XLSX or PDF. Required. Without it, your payroll entries are the stated substitute
- Payment records: payee, date, amount, CSV or XLSX. Required
- Company name, country or region, currency, the period, the account list and how often you pay each account, typed in the chat. Required
- Bank statement for the period, PDF or CSV. Recommended
- Benefit provider statements and last period's reconciliation, PDF, CSV or XLSX. Recommended
- Write-off limit, typed in the chat. Recommended
This was Northbrook's first run, so no earlier reconciliation existed. The workpaper says so and takes the start balance from the trial balance at 31 August. Net pay agreed with the bank statement on both September pay dates: 4,200.00 on 15 September and 36,600.00 on 30 September.
A workpaper with nine sheets
The summary has lines for the preparer and the reviewer, and the answer ends with a Data sources line. The skill asks before it makes an Excel file, Payroll_Recs_2026-09_Northbrook Trading.xlsx. If you say no, you get the same sheets as tables in the chat. After you approve the results, it offers to save your rules for the next run: account list, payment schedules, payroll calendar, write-off limit and payees. It never saves balances, ages, open items or anybody's pay.
Other jobs go to other skills. payroll-reconciliation does the full tie-out of the register to the books and the bank. journal-entry-builder builds the proposed entries. payroll-journal-entry-builder builds the payroll entry itself.
Six rules that never bend
- Never reads MosoFin without asking. A connected account is not permission to read it.
- Never reads anything before you answer the eight items and say yes to the read-back.
- Never writes, updates or deletes anything, in any system. Every entry it produces is a proposal for a person to post. It cannot pay a tax, send a letter to an employee or decide about unclaimed property.
- Payroll data is personal. It reconciles the balance, not the people. It reports totals and counts, names a person's item by a reference number only, and never saves anybody's pay.
- Never writes off what a person owns. Unclaimed pay never goes to income, and the skill flags unclaimed property as a compliance duty. It never sets a payment schedule, a write-off or an unclaimed property treatment for you.
- A nil balance is not a reconciled account. It always states the basis of each expected balance, and if it compared with the bank statement or with the payments in your books.
Seven terms, in plain English
- Payroll clearing account
- A waiting room in your books between "payroll recorded" and "payroll paid". It must return to nil after each pay run.
- Payroll control account
- Any account that holds a payroll amount until you pay it: clearing, taxes, 401(k) or pension, and court orders. Your books show each one as a payable1.
- Withholding
- Money that you take from pay for somebody else, for example tax or a 401(k). It is never the employer's money3.
- Remittance schedule
- How often you must pay a withholding to its owner. The authority sets it, and it decides the correct balance of the account2.
- Stale balance
- An amount that stays in a payroll account long after it should leave. For a clearing account, the skill uses 60 days.
- Never-clearing residual
- The lowest point that the balance reached in twelve months. It is the part that never left at any time.
- Unclaimed pay, and escheatment
- Pay that a person did not collect stays theirs. After a period in the law of the state, the holder reports it and gives it to the state4.
Where the facts on this page come from
The sources are an accounting textbook, two IRS pages and two pages from the California State Controller's Office. We found each one on 28 October 2026 in search results. We did not open the pages, so follow each link for today's wording. What the skill does comes from the skill's own files.
- OpenStax: Principles of Accounting, Volume 1, 12.5 Record Transactions Incurred in Preparing PayrollWhen a company pays wages that it owes, the payable goes down and so does cash. Payroll taxes, benefits and deductions follow the same pattern: they stay payables until the company pays them.
- IRS (US): Publication 15 (2026), (Circular E), Employer's Tax GuideThe deposit schedule comes from a lookback period. In the 2026 edition, $50,000 or less makes a monthly depositor. A monthly depositor deposits by the 15th of the next month, or the next business day.
- IRS (US): Employment taxes and the Trust Fund Recovery Penalty (TFRP)A person who must pay the taxes withheld from employees, and willfully does not pay them, can be personally liable. This is a US rule.
- California State Controller's Office (US, one state): Unclaimed Property, Holder Reporting, Frequently Asked QuestionsIn California, payroll, wages and commissions become unclaimed after one year, and most other property after three years. A business that holds unclaimed property reports it each year. Other states have different periods and rules.
- California State Controller's Office (US, one state): Holder Due DiligenceBefore a report, the holder sends a letter to the owner's address on record for property of $50 or more. If the owner replies, the holder pays the owner and does not give the property to the state.
No outside authority backs the age bands, the 60-day limit, the lowest-point test, the nine causes, the workpaper sheets or the order of the work. They are the skill's own rules. We made up Northbrook Trading and every figure in the example for this page. Every tax figure in it comes from Northbrook's payroll provider report. The page states no tax rate, no wage cap and no unclaimed property period for Northbrook.
This page explains payroll-clearing-reconciliation, from the MosoFin finance skills library, MosoFin/mosofin-finance-skills on GitHub. Read the skill on GitHub → The skill is in the card format on the main branch. It merged in PR #1 on 26 October 2026, and corrections from a bookkeeping audit followed on 27 October 2026. This page describes that version. The skill works in any country. This example is in the US, and it continues the payroll reconciliation example.