Reconciling the payroll journal entry
A short note on where things go wrong when the payroll journal entry and the ledger drift apart. This is placeholder content.
This article is placeholder content. It exists to prove that the Markdown conversion works and will be replaced. The formatting below deliberately uses everything the build script supports.
Why the reconciliation drifts
The payroll journal entry posts the cost of a payroll run to the general ledger. If payroll runs a month ahead of or behind the financial records, the balance on the suspense account no longer adds up. That is almost always a timing difference rather than a posting error, but you can only say so after you have split it out.
The three places the difference hides
- The net wages suspense account, when payment falls in another period.
- The wage tax payable account, when the return has been filed but not yet paid.
- The holiday allowance accrual, which builds up monthly and pays out yearly.
A difference you cannot explain is not a difference you are allowed to write off.
What we check every month
| Account | Expected balance | Signal |
|---|---|---|
| Net wages | nil after payment | anything left means a payment is stuck |
| Wage tax | the current month's return | a doubled amount points to an unprocessed payment |
| Holiday allowance | accrual less payout | a negative balance means too much was paid out |
The check itself is a per-account listing with the movements of the month next to it. We pull
that with a small script; the columns that matter are datum, omschrijving and bedrag.
$mutaties = Import-Csv .\grootboek.csv -Delimiter ';'
$mutaties | Where-Object { $_.rekening -eq '2200' } |
Measure-Object -Property bedrag -SumFurther reading
See the note on the VAT return timeline and the page on payroll.
Disclaimer
Placeholder. No rights can be derived from this text and it deliberately contains no advice.
Updated on .