⚡ Automated • Accurate • Official

Calculate Government Salary & Pension Arrears Instantly

Built for Central Government officers. Automate the calculation of arrears owed under 5th and 6th Pay Commission revisions — with verified DA/HRA rates from 2004 to 2026.

Arrears Statement

📅 Since 2004

22+ Years

of arrears automated

₹ Crores

Actual Govt Dues

recovered for officers

✓ 100% Accurate

Verified Formula

against official government records

Years of Unpaid Dues. Calculated in Minutes.

The old way was slow and error-prone:

  • Manual Excel sheets — prone to formula errors
  • DA/HRA rates looked up one by one
  • Promotion splits calculated by hand
  • Separate calculations for salary vs pension arrears
  • No audit trail for PAO verification

😖 The “before” — arrears.xlsx

Apr-2004 8100 #REF! ❌
May-2004 8100 =B2*1. ❌
Jun-2004 ???? manual ❌
Jul-2006 GP? by hand ❌

How It Works

1

Upload

Upload the officer's pay-fixation Excel (8 columns, validated before import).

2

Calculate

System explodes periods into monthly rows, applies DA/HRA rates, computes entitled vs drawn difference.

3

Report

Download the official arrears statement — ready for PAO verification and government filing.

⏱ Average time: under 30 seconds per officer — vs. 4–6 hours manually in Excel.

Everything You Need. Nothing You Don’t.

Salary Arrears Engine

Explodes pay-fixation periods into month-by-month rows. Handles 5th CPC (Dearness Pay) and 6th CPC (Grade Pay) automatically.

Pension Arrears Module

Government pension rules applied automatically from the officer's final revised pay, reconciled month by month with the allowance of the day.

DA / HRA Rate Master

Official rates from April 2004 to June 2026 built in. 5th → 6th → 7th CPC transitions handled. Editable by admin.

PAO Verification Screen

Dedicated Pay & Accounts Office view. Search by Emp No, select bill type, export to Excel for audit trail.

Excel Upload & Validation

3-check validation gate: Emp No match, 12-month period cap, date continuity. Rejects partial imports, flags missing rates.

Official Report Format

Output matches the official government report layout exactly. Banner headers, TOTAL row, right-aligned numbers. PDF + Excel.

22 Years of Pay Commissions — Covered

Apr 2004

5th CPC

Pay revision effective. DA 11% → 21%.

Jan 2006

6th CPC

Grade Pay introduced. DA 0% → 35%.

Jul 2016

7th CPC

DA reset to 0%, rising to 50%+.

Today

Bakaya

Covers it all — 2004 to 2026.

Accurate, Rule-Based & Verified

Every figure follows official Government of India pay-fixation rules — applied consistently, month by month, and reconciled against official government records.

For every month an officer served, the system works out the entitlement under the revised pay scale and compares it with what was actually drawn — accounting for the applicable Dearness and House Rent Allowances and prorating partial months. The shortfalls are added up to give the total arrears due. The exact methodology mirrors the sanctioned government pay-fixation procedure.

Pension arrears follow the standard government pension rules applied to the officer's final revised pay, compared month by month against what was actually drawn, with the applicable allowance added each month. As with salary, the result is the verified shortfall owed.

The rates and rules are sourced from official Government of India Office Memoranda and reconciled against official government records. Every calculation is reproducible, auditable, and can be re-verified through the PAO Check & Verification screen before any bill is passed.

Frequently Asked Questions

5th CPC (pre-2006, with Dearness Pay), 6th CPC (2006–2015, Grade Pay), and 7th CPC (from Jan 2016). DA/HRA rates are built in for all three periods from April 2004 to June 2026.
Yes. Pension arrears are derived from the officer's final revised salary figures, so salary arrears must be generated first. The system enforces this and prompts you if pension is requested without prior salary calculation.
Yes. Each officer gets their own record. Upload the Excel template separately for each officer. All officers are listed in the Officer Details screen.
The existing periods and arrears lines are fully replaced — no duplicates. A confirmation is shown before replacement.
The rates are sourced from official government OMs and verified against official records. Admins can also update rates directly through the DA/HRA Rates screen.
Salary and pension arrears reports export as PDF (for official filing). The PAO Check & Verification screen exports to Excel for audit purposes.