Payroll Journal Entry Template
Everything the register leaves out, plus the bridge from one gross figure to the four different taxable wage bases underneath it.
Free download · No account needed
Wage Base Bridge
[Entity] — quarter ended [__ ___ 20__]
One payroll goes in the left column. Five different taxable figures come out, and each adjustment lands only in the columns it actually touches.
| Step | Register gross | Income tax wages | Social security wages | Medicare wages | Additional Medicare | Unemployment wages |
|---|---|---|---|---|---|---|
| Gross per the register | — | — | — | — | — | — |
| Cafeteria plan deferrals | — | — | — | — | — | |
| Retirement plan deferrals | — | 0.00 | 0.00 | 0.00 | 0.00 | |
| Taxable fringe benefits | — | — | — | — | — | |
| Wages above each limit | 0.00 | — | 0.00 | — | — | |
| Taxable wages | — | — | — | — | — | — |
Why a register cannot become an entry on its own
| It balances by construction | Gross equals net plus deductions whether the payroll is right or not |
| The employer side is elsewhere | Usually on a company totals page nobody exports |
| It stops at the pay period | Days worked after it and paid later are the largest reconciling item there is |
Every step carries the publication section behind it, so a residual at the bottom is an error rather than a mystery.
A payroll register always balances. Gross equals net plus deductions, on every provider's report, in every cycle, whether or not the payroll is right. An entry copied from it inherits that property exactly: it posts, it agrees with itself, and it carries no information. Then the quarter closes, somebody compares gross wages to the filed return, finds a gap of six figures, and spends an afternoon discovering that the gap was correct all along.
One payroll produces at least four taxable wage figures and every one is right. Cafeteria plan deferrals come out of all of them. Elective 401(k) deferrals come out of income tax wages only and leave social security and Medicare wages untouched. Then social security stops at a limit and Medicare never does. Thornbury Instruments runs 1,842,600.00 of gross through a quarter and reports 1,630,660.00, 1,698,300.00, 1,759,600.00 and 88,400.00 on four lines of one return. The bridge names the authority on every step.
The entry also carries what the register never did. Employer taxes, the two working days earned after the last pay period ended, and a time off liability that rose 3,308.15 while hours fell, because a merit cycle revalues every hour already on the books. There is no employer share of the additional Medicare rate, so an accrual built off the total is always high. Run it beside the monthly close pack and the bank reconciliation pack.
What's in the pack
Wage Base Bridge sheet
Register gross walked down to income tax wages, social security wages, Medicare wages, additional Medicare wages and unemployment wages, with the publication section named against every step.
Register Summary sheet
One row per pay date with each deduction type in its own column, the employer share separated out, and the federal liability accumulated on that day rather than the deposit that followed.
Payroll Tax Tie-out sheet
A twenty one step reconciliation from ledger wage expense to the filed return and back out to employer tax expense, because the ledger is on wages earned and the return is on wages paid.
PTO Accrual sheet
The liability rolled by department at current pay rates, with the movement split between hours and rate so a merit cycle stops hiding inside a net number.
Bonus and Commission Accrual sheet
Every plan against its attainment at the reporting date, with the employer tax on the unpaid balance and the month each one actually pays.
Deposit Calendar sheet
Every pay date with its liability, the schedule rule that applies, and both dates where a federal holiday or the single-day threshold moved the deadline.
The Four Wage Bases
Why one payroll produces four taxable figures and all of them are right, with the two deductions that behave differently and the fringe benefits that never touch cash.
Payroll Close Procedure
Four steps per cycle, three per period end, three per quarter, and the one rule for a variance: it is explained by a bridge line or it is an error.
Accrual Basis Note
How the straddle is counted in working days, why the prior accrual reverses rather than gets adjusted, and why a threshold nobody has cleared accrues nothing.
Deposit Schedule Note
The lookback that sets your schedule, the single-day rule that overrides it, and why a state holiday your office was closed for does not move a federal deadline.
Space rule
The register is not the entry and gross is not a wage base. It governs every prompt here, and it is why nothing in this space rounds a wage base to make a tie-out close.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent build it from your own registers, or download the blank Word and CSV files instantly with no account.
- 2
Send both pages of the register
Employee detail and company totals. Add the last filed quarterly return, your time off balances and the current bonus plans. Wide multi-column provider PDFs are exactly what this expects.
- 3
Build the entry, then the accruals
Employer taxes on the entry, wages earned after the last pay period ended, time off at current rates, and bonuses against attainment rather than a target divided by twelve.
- 4
Bridge the gross to each base
Each adjustment lands only in the columns it touches. Once the bridge is built, the quarterly tie-out is a five minute check instead of an afternoon.
Frequently asked questions
Is this template free?
Yes, all of it. Word documents and CSV sheets, no signup, no card. Edit with AI is a separate optional route for people who would rather hand over a register than retype one. Everything else River publishes sits in the template library.
Why will my gross wages never equal the return?
Because they measure different things. Retirement plan deferrals reduce income tax wages and nothing else, cafeteria plan deferrals reduce every base, and taxable fringe benefits raise the bases without ever appearing as cash. The bridge turns that permanent gap into named lines. After filing, the quarterly filing reconciliation runs the same bridge backwards, against the deposits that cleared.
Can I use the register on its own to post payroll?
It will balance, and it will be missing the employer side, the wages earned after the pay period ended, and every liability nobody ran a payroll for. On the worked quarter that is 130,808.80 of employer tax alone, and the entry still posts.
Does one bonus run really change my deposit schedule?
Cross 100,000 of accumulated liability on any single day and the deposit is due the next business day regardless of schedule. A monthly depositor who crosses it becomes semiweekly the next day and stays semiweekly for the rest of the year and all of the following one.
How is this different from the close checklist?
The monthly close pack sequences the whole month and this does one task inside it. The liabilities it leaves behind get evidenced by the balance sheet substantiation pack, and net pay ties to the bank through the bank reconciliation pack.
What format are the downloaded files?
Four .docx documents covering the close procedure, the four wage bases, the accrual basis and the deposit rules, plus six .csv sheets, all zipped into one file. Everything opens natively in Word, Pages, Google Docs, Excel, Numbers and Sheets with no conversion step in between.
What does Edit with AI actually do?
It creates a free River account with this pack installed privately, ready to read your provider's registers, build the entry with the employer side on it, set the three accruals, and bridge your gross to every base. A normalized trial balance feeds it the ledger side.
Post the entry the register cannot give you
Download the blank pack as Word and CSV files, or open this exact pack in River and let the agent read your own registers.
Edit with AI