Free tool

Crew Pay Record Organiser

Record what you expected to be paid for one period, the deductions you expected and the payments you actually received. The tool does the arithmetic from your entries so you can ask a clear question.

Use one record for each pay period. All figures are your own assumptions, not verified entitlements. Nothing is uploaded, saved or shared, and closing or reloading the page clears your entries. Export a CSV if you want to keep a copy on your device.

This tool needs JavaScript for the calculations. You can use the printable pay reconciliation idea instead: list expected earnings, deductions and payments received for one period on paper.

1. The period

Period start

Period end

Currency (one currency per record)

Adjustment mode: allow negative expected payment lines

Use adjustment mode only for a line that corrects an earlier period, such as a reversal shown on a payslip. Label it clearly.

2. Expected payment lines

For example: basic wage, guaranteed overtime, allowance, commission. Use the amounts you believe apply for this period.

3. Expected deduction lines

For example: tax, social security, allotment, uniform. Enter deductions as positive amounts.

4. Payments received

Each payment you actually received for this period, for example a bank transfer or cash payment.

Summary based on your entries

Expected payments
Expected deductions
Expected net
Payments received
Difference based on your entries

This is arithmetic from the figures you entered: expected net (expected payments minus expected deductions) minus payments received. It is not what your employer legally owes. Pay-period timing, payments that cover more than one period and how payments are allocated can all affect the comparison. Use the result to ask for a written explanation; see records to keep about missing pay and where to get help.