MosoFin · Payroll journal entries, in plain words

Payroll costs us more than we pay out on payday. How do we book each dollar?

Payroll costs a business more than the staff receive. This skill reads your payroll register and builds the journal entries that record the run. Every dollar goes to the correct account, and a person posts the entries.

The 20-second version

You give it the register for one pay run. It finds three amounts: the pay that your staff earn, the part that goes to other people for them, and your own extra costs. It builds two entries and ties every line to the register. It compares the run with the last runs. It never posts an entry and never shows one person's pay.

Where the money goes

Three amounts, and only one of them reaches your staff

Northbrook Trading pays 12 people each month: 4 in the warehouse and 8 in the office. For September 2026, the staff earn $48,000 before deductions. Accountants call this gross pay. Gross pay is the cost of the work. The staff do not receive all of it.

Gross pay, the cost 48,000 what the staff earn Net pay, to the staff 36,600 through clearing 2200 The bank pays 36,600 on the pay date Withheld for others: 11,400 Federal income tax 5,550 Staff social security, Medicare 3,450 Staff 401(k) 2,400 On top: employer costs 4,600 3,450 + 1,000 + 150 not taken from pay Total cost of the run 52,600 48,000 + 4,600 4,383.33 a head 52,600 ÷ 12
Example figures for a made-up company, in dollars. Every tax amount comes from the register of PayrollCo, Northbrook's payroll provider. This page applies no tax rate. The wages that a tax applies to can differ from gross pay, for example after pre-tax benefit deductions. Ask your accountant how this applies to you.

The first part is net pay: 48,000 − 5,550 − 3,450 − 2,400 = 36,600. This is the take-home pay. The bank pays it to the staff.

The second part is the withholdings: 11,400 that Northbrook takes from pay for other people. An accounting textbook records each deduction as a separate amount that you owe1. The tax goes to the IRS. The 401(k) money goes to the retirement plan. US rules make the staff's 401(k) money plan assets, and the employer must deposit it within a time limit2.

The third part is the employer costs: 4,600 that Northbrook owes in addition to gross pay. In the US, the employer pays its own share of social security and Medicare, and the staff pay a separate share3. So Northbrook's own share is a cost on top of pay. It is not a deduction from pay. The run costs 52,600, and the staff take home 36,600.

The mistake it catches

An entry that balances and is wrong

The skill calls this error the most common one: an employer cost booked as an employee deduction, or the reverse. The entry still balances, so the books accept it. The skill uses two separate entries to find it. Then it compares each line with the matching column total in the register.

Two entries, tied to the register

What the skill proposes for September
Wages, entry 148,000.00
Employer costs, entry 24,600.00
Register gross pay48,000.00
Total expense52,600.00
Each entry balances. Wages agree with the register: 48,000 against 48,000. The employer's 3,450 is in the employer payroll tax account.

One entry, copied from last month

A draft that adds the employer's share to wages
Wages51,450.00
Employer payroll taxes0.00
Register gross pay48,000.00
Total expense52,600.00
The draft balances, and the total expense is correct. The split is wrong. Wages are 51,450 − 48,000 = 3,450 too high. That 3,450 is the employer's own share of social security and Medicare, booked as if it were pay.

A check that the entry balances does not find this error. The draft's debits equal its credits: 12,450 + 2,400 + 36,600 = 51,450. The line tie finds it, because the wages line does not agree with the register's gross pay. The skill reports the difference as the mixing error or a mapping error. It reports it before anybody posts the entry.

Wages too high$3,45051,450 − 48,000
Employer taxes missing$3,450The account shows 0. The register shows 3,450
Total expense$52,600The same in both. So the total alone hides the error
Departments and month end

Split the cost, and add the overtime that is not paid yet

Northbrook splits the cost by headcount. That basis is the owner's decision, and the skill never chooses it. Only the cost is split. The amounts owed to others stay as one total.

Warehouse, 4 people$17,533.3316,000 wages + 1,200 taxes + 333.33 match
Office, 8 people$35,066.6732,000 + 2,400 + 666.67. The extra cent goes here, so the split adds to the total
Sum$52,600.0017,533.33 + 35,066.67

Northbrook pays overtime one month late. The staff earn overtime from 21 to 30 September, and Northbrook pays it in the October run. A cost that you owe at the period end but have not paid is an accrued expense. Wages are a common example4. The skill proposes one estimate for this, labelled ESTIMATE.

Overtime earned, not paid$2,500.006,250 ÷ 20 working days = 312.50 a day × 8 days
Employer part$179.692,500 × 3,450 ÷ 48,000, the ratio in the last run
ESTIMATE$2,679.69Recorded on 30 September, reversed on 1 October

An accrual for the wages only is too low. It leaves out the employer costs on those wages, here 179.69. The entry reverses on 1 October, so the October run does not count the cost two times.

Before you post anything, the skill compares the run with June, July and August. Gross pay is the same, 48,000, in each month. Income tax withheld falls by 150, which is less than Northbrook's 5% limit. Office cost increases by 2,000, because the software project stopped. Until August, 2,000 of office pay each month went to the project as an asset. The skill flags this change, and the bonus run of 15 September, for you to explain.

Who pays the bill

Your payroll provider pays the staff, and the debt stays yours

PayrollCo calculates the pay and takes the net pay of 36,600 from Northbrook's bank on the pay date. That amount goes through the payroll clearing account 2200, so the account is at nil after the run. PayrollCo sends its fee as a separate bill. Northbrook deposits the federal taxes itself.

A provider does not take over your payroll tax debt. If the provider does not deposit the tax, the IRS can charge penalties and interest to the employer5. So the skill keeps every amount owed in Northbrook's own accounts. Some providers take one lump sum for pay, taxes and their fee. The skill books that sum one part at a time, never as one expense.

The clearing account already held 2,223.40 from earlier months. That balance is not from this run. The skill leaves it for the payroll clearing reconciliation. After you post the entries, the payroll reconciliation checks the quarter against the bank and the tax filings.

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.

  1. Use MosoFin for this run, or upload the data yourself?
    MosoFin is the connection to your books. With it, the skill reads your accounts 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 pay run? In a group, which company pays these people?
    Each company gets its own entries, against its own accounts. The skill never chooses the company for you.
  3. The pay period and the pay date. And do you keep the books on a cash basis or an accrual basis?
    These decide if a month-end accrual is necessary.
  4. The payroll register or report for the run.
    Every amount comes from it. Without a register, the skill has nothing to build from, and it says so.
  5. Your employer costs: your tax share, retirement match and benefit costs.
    They are extra cost and extra debt, not deductions. They are usually in the register. If they are missing, the skill says that the cost is incomplete.
  6. Do you use a payroll clearing account?
    This changes where net pay goes. On the MosoFin path, the skill looks for one and then asks you to agree.
  7. If you split the cost by department: on what basis? Hours, headcount or direct assignment?
    A list of departments in your books does not tell how to split the cost. The basis is your decision.
  8. Is any pay in this run part of an asset, for example software that you build?
    That pay goes to an asset account, not to expense. The register does not show it, so the skill always asks.

Then it reads the plan back and waits for your yes. This is the skill's own example, word for word. The skill's example pays the September run on Friday 25 September, and this page follows it. Our other payroll pages pay it on Wednesday 30 September. The amounts are the same.

"Building the payroll journal for Northbrook Trading's monthly run for September (pay period 1–30 September, pay date 25 September), from the register you uploaded, against the chart read from your Mosofin connection. Net pay through the payroll clearing account; wages and employer costs split by department on headcount; no capitalised labour. Shall I go ahead?"

Then it names the file and reports what it read: the period, 12 people paid, and the totals for each part of pay. It never repeats one person's line.

What you need

Connect your books, or upload the register and your accounts

Connected with MosoFin

Say yes, then give it the register

  • It reads back the workspace and the company file by name, and waits for your yes
  • It reads your list of accounts, your departments, the last payroll entries, and the balances of the payroll accounts
  • It reads the register only if a payroll system is also connected. If not, you upload the register, and the skill labels it as supplied by you
  • You still give it the split basis and any pay that goes to an asset. Your books never answer these
Uploading instead

Bring the register and your list of accounts

  • Payroll register for the run, with totals for gross pay, each withholding and net pay. CSV, XLSX or PDF, required
  • Employer costs, if they are not in the register. CSV, XLSX or PDF
  • Chart of accounts, CSV or XLSX. Without it, each account name carries a label that says it needs a real account
  • Company name, country, currency, fiscal year, pay period, pay date, cash or accrual basis, and if you use a clearing account. Typed in the chat
  • The split basis and any pay that goes to an asset, typed in the chat, if they apply
  • Last payroll entries and the balances of the payroll accounts, recommended, CSV or XLSX
  • Bank and timing details, recommended. If a provider takes one lump sum, its statement. PDF, CSV or XLSX
What you get back

The proposed entries, and a workpaper with eight sheets

Every entry carries this mark from the skill:

PROPOSED — NOT POSTED
Journal entriesThe pay entry and the employer entry, kept separate, with the funding and the month-end estimate.
Gross to netGross pay, each withholding and net pay, with the check that they agree.
Employer costsEach extra cost on top of pay.
Department splitEach department's share, with the sum checked against the total.
Amounts owedWhat you owe to the IRS, the plan and the state, and when.
ValidationEach check and its result, from balance to the line tie.
Run comparisonThis run against the last runs, by part of pay and per head.
CoverageWhat the skill read, and from where. It also shows what you supplied.

It asks before it makes the Excel file. After you approve the results, it offers to save your account map and your entry layout for the next run. It never saves an amount or any person's pay.

What it never does

Seven 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 intake items and say yes to the read-back.
  • Never writes, updates or deletes anything, in any system. Every entry is a proposal for a person to post.
  • Never shows or saves one person's pay. Payroll data is personal. The entries show accounts and departments only.
  • Never invents an account. An account that is not in your books stops the run. It never chooses an account, a split basis or an asset decision for you.
  • Never accepts an entry only because it balances. It keeps the employer entry separate and ties every line to the register.
  • Makes one estimate only: the month-end amount for pay that is not processed yet, labelled ESTIMATE.
Words you'll hear

Seven terms, in plain English

Payroll register
The provider's report of one pay run: gross pay, each deduction, net pay and the employer costs.
Gross pay
What the staff earn before deductions. It is the cost of their work.
Net pay
The take-home pay that the bank pays to the staff1.
Withholding
Money that you take from pay for somebody else, for example tax or a 401(k). You owe it to them until you pay it.
Employer costs
Costs that you owe on top of pay, for example your share of social security and Medicare3.
Payroll clearing account
A waiting room in your books for net pay. It returns to nil when the bank pays the staff.
Accrual
An entry for a cost that you owe at the period end but have not paid4.
Sources

Where the facts on this page come from

The sources are two sections of an accounting textbook, two IRS pages and a US Department of Labor page. 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 PayrollThe employee entry records gross pay as salaries expense and each deduction as a separate amount owed. Take-home pay stays as salaries payable until it is paid. The employer records its own taxes and benefits in a separate entry.
  2. U.S. Department of Labor, EBSA: ERISA Fiduciary Advisor, depositing participant contributionsEmployee 401(k) deferrals become plan assets when the employer can reasonably separate them from its own assets. There is a latest deposit date.
  3. IRS: Publication 15 (2026), (Circular E), Employer's Tax GuideThe employer and the employee each pay a share of social security and Medicare tax. The employer's share is its own tax.
  4. OpenStax: Principles of Accounting, Volume 1, 4.3 Record and Post the Common Types of Adjusting EntriesAn accrued expense belongs to a period, but the business has not paid it yet. Salaries are one example. When the wages are paid in the next period, the amount owed and the cash both decrease.
  5. IRS: Outsourcing payroll and third-party payersA payroll provider does not take over the employer's employment tax debt. If the provider does not deposit the tax, the IRS can charge penalties and interest to the employer.

No outside authority backs the two-entry rule, the line tie, the run comparison, the ESTIMATE rule or the eight sheets. They are the skill's own rules. The textbook accrues wages only. The rule that adds the employer costs to the accrual is the skill's rule. We made up Northbrook Trading, PayrollCo and every figure in the example for this page. The 5% limit and the cost ratio in the estimate are the example's choices, not a rule or a tax rate. All five sources are US sources.

About this skill

This page explains payroll-journal-entry-builder, 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 a bookkeeping-audit change followed on 27 October 2026. This page describes that version. Want the worked examples? Learn it step by step →