DOCUMENTS / LOCAL / FREE

Salary slip with arrears format

A salary slip with arrears lists the employer, the employee, the pay period, current earnings, the arrears line and the period it covers, deductions, and net pay. Download the PDF, Word, or Excel file and edit the figures. In Excel, gross pay, total deductions, and net pay calculate automatically.

Published · Updated

A salary slip with arrears lists the employer, the employee, the pay period, current earnings, the arrears line and the period it covers, deductions, and net pay. Download and edit the PDF, Word, or Excel sample.

Salary slip with arrears format sample in Word and Excel

Download or edit this sample

Edit document details
MAKE IT YOURS

Choose your style

Excel gross pay, total deductions, and net pay calculate from the amount cells. PF, ESI, and tax rates are not looked up.
Live document previewA4 · 1 page
YOUR COMPANYSAMPLESalary statementSalary slip with arrears formatEMPLOYEE DETAILSEmployer[Company]Employee[Employee Name]Employee ID[Employee ID]Pay periodSeptember 2026Current basicINR 30,000Current HRAINR 12,000Current allowanceINR 3,000Current month earningsINR 45,000Arrears periodJuly and August 2026Approved difference per previous monthINR 2,000Number of prior months in this adjustment2Salary arrears paidINR 4,000Total gross earningsINR 49,000Revision approval referenceREF/2026/___Previously paid arrears against this referenceINR 0Payment reference[actual bank reference]Approved by[authorised payroll officer]DEDUCTIONSTotal deductions entered by payrollINR 4,200NET PAYINR 44,800Made with OpenToolSuite.com01

What each part means

Effective date

Use the approved revision’s effective date and identify every earlier period affected. If the revision begins mid-month, record the employer-approved partial-month treatment rather than assuming a complete monthly difference.

Earlier paid amounts

Compare prior slips with the revised structure and check previous adjustment payments. A revision reference should link the catch-up amount to a unique record, making duplicate arrears easier to detect.

Current and arrears totals

Keep the INR 45,000 current salary subtotal separate from the INR 4,000 arrears subtotal. Their combined gross figure is INR 49,000; the net calculation must use the deductions approved for the combined payroll.

What this arrears salary slip must contain

A salary slip with arrears is the current pay period plus a catch-up amount payroll has already approved. It must name the employer and the employee, the pay period, current earnings, the arrears line and the earlier period it covers, deductions, and net pay. Download the PDF, Word, or Excel file and edit those figures. Keep the arrears off basic pay so it is not read as a new recurring allowance.

How the filled example works

Sana’s current earnings total INR 45,000. The approved revision also creates a difference of INR 2,000 for each of July and August, so the arrears paid in September total INR 4,000. Combined gross earnings are INR 49,000. Payroll has entered total deductions of INR 4,200, leaving INR 44,800. The example records zero arrears previously paid against the revision to explain why the entire approved difference is included.

Prepare the supporting record

Keep the revision letter, effective date and earlier payslips beside the adjustment worksheet. Compare the old and revised amounts for each affected month, using the employee’s actual payable days where relevant. Check that a previous partial adjustment has not already settled one month. A two-month label alone is not enough evidence that two identical full-month differences are payable.

Resolve this scenario before issuing

Separate a salary revision from a payroll correction or unpaid transfer. If an earlier payslip already recorded earnings that the bank did not pay, issuing the same earnings again can duplicate the record. If the old salary was genuinely lower before a retrospective approval, the difference belongs in the arrears explanation. Have payroll confirm how the adjustment affects deductions rather than applying the current month’s deduction amount a second time.

How to edit and share the document

Download Word to add a short month-by-month arrears schedule if the actual differences vary. Excel multiplies the approved monthly difference by the number of prior months, then sums current earnings and arrears into gross pay. Net pay subtracts the deductions you type. The sheet does not recompute past statutory deductions. Preserve the revision reference so a later payroll can identify this catch-up payment as already settled.

Payroll record boundaries

Treat each salary period as a separate payroll record. Start with approved attendance and the salary structure, record earnings that belong to the period, and subtract the actual deductions confirmed by payroll. Employer contributions and annual CTC do not automatically belong in cash earnings. Keep reimbursements separately identifiable when they are included in the same bank transfer. The completed slip should explain the transfer amount without suggesting that a sample confirms employment.

Review this scenario

  • Read the salary revision approval and effective date.
  • Check the affected earlier months individually.
  • Subtract any arrears already paid.
  • Keep current salary and arrears separately labelled.
  • Ask payroll to approve deductions on the adjusted payment.
  • Mark the approved revision as settled in the payment record.

Questions

Can this be used for a correction rather than a pay rise?

Yes, if the record describes the correction accurately. Replace the revision wording with the actual correction reference and identify the affected periods. Check the original payslips so the updated document does not record earnings or deductions twice.

Are arrears always the same amount every month?

No. Attendance, a mid-month effective date or earlier partial payments can make monthly differences unequal. Add a dated schedule for the actual amounts, then enter their confirmed total. The two equal INR 2,000 differences are only the example.

What does Salary slip with arrears format include?

The employer, the employee, the pay period, earnings, deductions, and the net pay that results from those figures.

Does it calculate PF, ESI, or income tax?

No. Type those amounts. The Excel salary slip does not look up statutory rates.

Are the sample names real people?

No. Replace the name, the identifiers, and the amounts with the payroll record.

Can I edit it in Word?

Yes. DOCX contains editable text. Customized PDF exports preserve the layout as page images; direct English sample PDFs contain searchable text. Neither is a digitally signed document.

Is my entered information uploaded?

Document generation happens in this browser. Optional consented analytics measures actions, never document contents.

Check before you use it

Only an approved arrears amount from payroll should appear, on its own line, with the period it covers. In Excel, arrears are the approved monthly difference times the number of prior months. The sheet does not reconstruct past statutory deductions.

  1. Replace every sample or bracketed field with accurate information.
  2. Check dates, amounts, identifiers and the intended recipient’s requirements.
  3. Open the exported file and obtain any required employer, landlord or legal approval.

Prepared by Feroz Sheikh ·