MosoFin · Payroll clearing reconciliation, in plain words

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.

The 20-second version

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.

Where the money goes

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.

Payroll recorded 36,600 net pay, 30 September Waiting room: clearing 2200 +36,600 −36,600 = nil after the run The bank pays staff 36,600 on the same day Held for others, September 2210 federal taxes 14,400 2230 401(k) 3,700 2240 state unemployment 150 owed until paid Paid on each due date IRS, 401(k) provider and the state
Example figures for a made-up company, Northbrook Trading, in dollars. The September figures include the bonus run of 15 September. Every tax figure comes from Northbrook's payroll provider report, and the page uses no tax rate. When you pay an amount that you owe, the payable in your books goes down by that amount1. Accountants call these accounts payroll control accounts.

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.

What a run finds

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:

DateWhat happenedReferenceAmountBalance after
Before 1 Oct 2025An old balance from earlier books. The twelve months show no detail for itnone23.4023.40
3 Feb 2026A direct deposit from the 30 January run came back because the account no longer existed. Nobody paid it againEE-03640.00663.40
30 Apr 2026Final pay in the April run, held because of a dispute about the final settlementEE-051,150.001,813.40
30 Jun 2026Payroll check #1987 from the 31 October 2025 run. Nobody cashed it, and it became void as staleEE-11410.002,223.40
4 Aug 2026A direct deposit from the 31 July run came backEE-071,250.003,473.40
6 Aug 2026Northbrook paid it again as check #2214EE-07−1,250.002,223.40
24 Sep 2026Manual entry JE-0912, memo "reclass contractor". No payroll run is behind itJE-09121,800.004,023.40
30 Sep 2026Balance in the books4,023.40
Example figures for a made-up company, in dollars. 23.40 + 640 + 1,150 + 410 + 1,250 − 1,250 + 1,800 = 4,023.40. EE-03, EE-05, EE-07 and EE-11 are reference numbers. The skill never shows a name, and it shows a person's item only by its reference.
01,0002,0003,0004,000 OctDecFebAprJunAug30 Sep 3 Feb 2026, EE-03: balance 663.40 30 Apr 2026, EE-05: balance 1,813.40 30 Jun 2026, EE-11: balance 2,223.40 4 Aug 2026, EE-07 deposit came back: balance 3,473.40 24 Sep 2026, JE-0912: balance 4,023.40 Lowest point 23.40: it never cleared EE-03 EE-05 EE-11 EE-07 out and back JE-0912 4,023.40
The clearing account balance at the end of each day. Pay runs that net to nil do not show. The line never touches nil in twelve months, so the account fails the behaviour test.

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.

This month1,800.00JE-0912, 6 days old
1 to 2 months0.00Nothing in this band
3 to 6 months1,560.00410 from June + 1,150 from April
Over 6 months663.40640 from February + 23.40 from before October 2025

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.

The mistake it catches

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: nil
Books on 30 September4,023.40
Expected0.00
Difference to explain4,023.40
Items found5
All 4,023.40 is in the list of items: 23.40 + 640 + 1,150 + 410 + 1,800. The status is "investigating".

The common shortcut

Start balance, plus pay recorded, less pay paid
2,223.40 + 40,800 − 40,8002,223.40
Books on 30 September4,023.40
Difference to explain1,800.00
Old itemsnot checked
JE-0912 explains the month. The 2,223.40 from earlier months looks normal, because the calculation started with it.

The 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 second mistake

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.

AccountStart+ Owed− PaidBooksWhat the skill says
2210 Federal payroll taxes12,60014,400027,000Agrees 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,4003,7003,4003,700Agrees, and holds one month. Due 7 October
2240 State unemployment−3001500−150Agrees, and is below zero. Northbrook paid 600 twice, on 30 July and 3 August
Example figures for a made-up company, in dollars. 12,600 + 14,400 − 0 = 27,000. 27,000 − 14,400 = 12,600, the August taxes, due 15 September and not paid.

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.

What it suggests

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.

ItemAmountSuggested treatmentWho acts
EE-03 and EE-11, unclaimed pay1,050.00Move 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 matterThe owner tries to contact each person, and decides on unclaimed property with an adviser
Origin unknown23.40Write 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 personThe owner approves
JE-09121,800.00If it is a contractor's bill, move it to accounts payable, 2000. If it is wages, the payroll records and filings are shortThe owner and the accountant decide
EE-05, disputed final pay1,150.00No entry. It stays under investigation until the dispute endsThe owner
2210, August taxes12,600A payment to make. No entryThe owner pays the IRS
2240, below zero−150A refund to claim from the state, or a prepayment. First get the state's statement of accountThe owner
Example figures for a made-up company, in dollars. Every line is a proposal. Account numbers 2260, 2000 and 7900 (other income) are the example's choice. If the owner posts the first three: 4,023.40 − 1,050.00 − 23.40 − 1,800.00 = 1,150.00 stays in 2200, the disputed final pay only.

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.

How a run starts

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.

  1. 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.
  2. 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.
  3. Which period?
    Required. Every read and every roll-forward uses it.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.

What you need

Connect your books, or upload seven items

Connected with MosoFin

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
Uploading instead

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.

What you get back

A workpaper with nine sheets

One sheet for each accountFour at Northbrook. Each has the books, the expected balance and its basis, the difference, the status, the age bands and the lowest point.
Master summaryEach account with its books, expected balance, difference, status and if an item is over your limit.
Bank tie-outNet pay for each pay date, and each tax and benefit payment for its deposit period. It says if it used the bank statement or your books.
Stale balancesEach old amount with its age, item count, probable cause, suggested treatment and if unclaimed property rules can apply.
Proposed entriesCorrections as proposals only, for a person to post.
CoverageFor each task, where the figures came from and on which date.

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.

What it never does

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.
Words you'll hear

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.
Sources

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

About this skill

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.