What is accrual and prepaid reconciliation?

Accrual and prepaid reconciliation proves that the balance in each accrued liability or prepaid asset account on the GL equals the sum of its supporting schedule lines, and that every schedule line traces to a source document: a bonus model, vendor invoice, insurance policy, or contract clause. Unlike bank or AP reconciliation, there is no subledger; the schedule itself is the source of truth.

Why are accruals and prepaids harder to reconcile than other GL accounts?

Every other major reconciliation has a system on one side: bank statement, AP subledger, AR module, payroll register. Accruals and prepaids don't. The Excel schedule a senior accountant maintains is the only support. When that schedule drifts from operational reality (stale lines, lost reversal flags, miscellaneous catch-alls), the GL drifts with it, and there is no second source to catch the error.

How often should the accrual schedule be regenerated from source?

Every close. A schedule that rebuilds from source documents each period, pulling the bonus model fresh, querying the HR roster, re-reading insurance policy effective dates, produces a confirmation. A schedule that carries forward the prior month's balance and only books deltas accumulates errors quarter over quarter until material at year-end.

What causes the 'miscellaneous accrual' line to grow unchecked?

Every senior accountant adds a small accrual for something that doesn't fit a named category and intends to document it later. Documentation slips. Three years later the line has compounded from $40K to $300K+ with no traceable composition. At audit it becomes a finding because there is no support for any individual component.

How should prepaid amortization schedules be set up?

Each prepaid line should tie to the originating contract: insurance policy effective dates, software subscription terms, prepaid rent agreements. Amortization period should match the contract term exactly, not a template that worked once. The most common error is a JE template configured for 13 periods instead of 12, which produces a one-month understatement of the prepaid balance by year-end.

Accruals & Prepaid Reconciliation: Source vs Schedule

Every other reconciliation in the close cycle has a system on one side. Bank statement. AR module. AP ledger. Payroll register. Accruals and prepaids don't. The schedule a senior accountant maintains in Excel is the entire source of truth. The GL is supposed to match the schedule. The schedule is supposed to match operational reality. At month-end someone proves both, usually by opening three versions of the same file.

The rollforward that should regenerate from source

For any accrual line (accrued bonus, accrued utilities, accrued audit fees) the math is trivial:

Accrued bonus rollforward (illustrative, $K)

Opening

Prior balance

$840K, carried from prior period close

→

+ New

Accrual

$210K, ratable accrual for current period

→

− Reversal

Paid out

$180K, disbursement against prior accrual

→

= Closing

New balance

$915K, should tie to GL balance

The math is trivial. The control is in whether every cell traces to source: a bonus model, a vendor invoice queue, an HR roster, a contract clause. When the schedule rebuilds from source each month, the rec is a confirmation. When it carries forward the prior month's balance and adjusts at the margin, errors compound across quarters.

Schedule regenerated vs schedule carried forward

Regenerated each close

Schedule rebuilds from source

Bonus accrual queries the HR roster and bonus model. Prepaid insurance ties to the policy effective date. Utility accrual rolls from the latest vendor invoice cycle. Every line traceable, every reversal triggered automatically.

Carried from prior month

Schedule adjusts at the margin

Opening balance copied, only changes booked. Stale lines never reviewed against source. Reversal flags lost across template versions. The 'miscellaneous accrual' line grows quarter over quarter until material.

Both patterns produce a clean balance on the trial balance at month-end. Only one survives a substantive audit walk-through where the auditor traces a sample of schedule lines back to source.

Where accrual and prepaid reconciliation breaks

Four predictable failure modes

Recurring accruals don't auto-reverse

The auto-reverse flag on a recurring JE template gets unchecked during a system update. The accrual sits on the books a second month while the actual invoice posts on top. Expense doubles up in the period of payment.

Fix:

Prepaids amortize on the wrong cadence

Annual insurance, software, prepaid rent. The JE template was set up for 13 periods instead of 12. By year-end the prepaid balance is short by one month and expense overstates by the same amount.

Fix:

Accrued bonus doesn't reverse on payout

Bonus accrued ratably sits on the balance sheet. When bonuses pay, the disbursement hits expense by default instead of the accrual. Bonus expense doubles up in the year of payment.

Fix:

The 'miscellaneous accrual' line

Started at $40K three years ago, now sits at $310K. Every senior accountant adds something and forgets to write what. At audit it becomes a finding because no individual component can be supported.

Fix:

What good looks like

A clean accrual and prepaid reconciliation has every schedule line tied to a source document with an owner and a reversal trigger. New accruals get added at the JE level, not retrofitted at close. Auto-reversal flags are monitored, so a recurring template that loses its reverse flag surfaces immediately. Prepaid amortization periods tie to contract dates, not to a template that worked once in 2021. And no line on the schedule is labeled "miscellaneous" without a documented investigation.

The same control gap appears one layer up at the subledger-to-GL reconciliation: manual JEs that bypass the subledger grow until material. The structural fix is identical: tie every entry to a source document at the point of posting, not at close.

See how Cadel handles continuous reconciliation across the close stack, or get in touch to walk through your current accrual schedule workflow.

#reconciliation#accruals#prepaids#close-cycle#general-ledger

Accruals & Prepaid Reconciliation: Source vs Schedule

The rollforward that should regenerate from source

Schedule regenerated vs schedule carried forward

Where accrual and prepaid reconciliation breaks

What good looks like

More from the blog

Stock-Based Comp Recon: Cap Table to GL Tie-out

Fixed Asset Reconciliation: NBV Rollforward Gap

Cash Reconciliation: Beyond the Bank Statement

See Cadel reconcile your books