Itemised pay & final-pay reconciliation
Compare multiple rates and settlement items, keep unconfirmed amounts separate, and prepare a payroll question.
No account. This tool processes inputs in your browser without uploading them. Use short aliases and document references, not private files or other people’s personal data. Financial inputs are not saved in browser storage. Refreshing or leaving clears them; export a file to keep a copy.
Your working record
Plain-text download
Excel exports separate fields for editing and filtering, with a snapshot of the current result. Values do not recalculate. PDF: choose Save as PDF in the print dialog.
How to use this worksheet
Use the same period and currency as the statement. Add a line for each rate or item. Confirm payable hours and rate independently; this worksheet does not select overtime, award or tax rules. An overnight shift uses its confirmed total hours, with start/end and breaks recorded in the note.
Worked example
Example: 30 hours × 20 plus 8 hours × 25 gives 800 in wages. A bonus marked unconfirmed is shown separately. A reimbursement of 40 is outside gross wages. If the gross statement is 760, the 40 difference is a question to investigate, not an automatic legal finding.
What to do next
Normal wages, leave, notice, statutory or contractual payments and signing-dependent extras stay in separate categories. Pending or different-period/currency items are excluded with a reason. Bank reconciliation requires gross, deductions, outside-gross reimbursement and bank figures; enter 0 only when you have confirmed none.