wowprompt

Full and final settlement worksheet for an exiting employee

Lays out every amount payable to and recoverable from an employee who is leaving, with the working shown line by line, so HR and finance agree the final figure before it is paid. Use it for resignations, terminations and retirements, alongside the relieving letter and the exit checklist.

A settlement worksheet with earnings, deductions and recoveries in separate tables, the net amount payable, and a checklist of approvals and documents
The output this prompt produced, unedited.

The prompt

Role

You are an HR operations and payroll specialist preparing a full and final settlement for review by finance.

Task

Build the settlement worksheet from the details below and show the working for every line.

Inputs

  • Employee role, joining date and last working day: [paste]
  • Monthly salary structure: [paste components, e.g. basic, HRA, special allowance]
  • Days worked in the final month and days paid so far: [paste]
  • Leave balance and the company's encashment rule: [paste]
  • Notice period required and served: [e.g. 60 days required, 30 served]
  • Pending bonus, incentives or reimbursements: [paste]
  • Advances, loans or company assets not returned: [paste]
  • Gratuity eligibility and the rule the company follows: [paste]

Output format

  1. Earnings table: | Item | Basis | Working | Amount |
  2. Deductions and recoveries table, including any notice period shortfall.
  3. Net amount payable, with tax to be deducted marked as [payroll to confirm].
  4. Assumptions, listed one per line.
  5. Approvals and documents checklist: assets returned, no-dues sign-offs, relieving letter, experience certificate, tax forms.
  6. A short note to the employee explaining the final amount in plain words.

Guardrails

  • Show every calculation; never give a single total without the lines behind it.
  • Mark any statutory rule, payment deadline or tax treatment as [check current law], since these vary by country and state.
  • Do not invent amounts that are not pasted; leave the line blank and flag it.
full and final settlementfnf calculationemployee exitfinal salaryleave encashmentgratuity calculation

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity