• PAYROLL
  • BONUSES
  • REPORTS
  • HUMAN

How to calculate salary balances and bonuses with your AI

Connect your payroll data to your AI client to automate final payout math. It handles the heavy lifting for departing staff.

Ask AI about this page

Short answer

How can I use AI to calculate final employee payouts?

Your AI reads your payroll records to determine exactly how much salary is owed for the current period and calculates proportional 13th-month bonuses. You get a precise breakdown of the total severance amount owed per person.

The results you get.

Where the data lands.

Once the AI processes the payroll data, you get these specific results.

PAYROLL

Remaining salary totals

The AI identifies unpaid days worked in the current cycle. You receive the exact base salary balance for each departing employee.

BONUSES

Proportional 13th-month pay

The agent calculates the accrued portion of the annual bonus based on time served. This ensures the payout matches the specific tenure of the employee.

REPORTS

Final payout summaries

You get a consolidated view of all owed amounts. This makes it easy to verify the total liability for a specific termination date.

HUMAN

Final approval required

The AI provides the math, but you must review the figures. You remain responsible for authorizing the actual bank transfers or checks.

The workflow

What your AI does when the data arrives.

The AI moves through your payroll records to isolate the necessary figures for termination.

  1. Identify unpaid time

    The agent scans your employee records to find the last completed pay period and the current unpaid days.

    compute_salary_balance_and_bonuses

  2. Calculate bonus accrual

    It applies the proportional formula for the 13th-month bonus based on the employee's start date and termination date.

    compute_salary_balance_and_bonuses

  3. Aggregate totals

    The AI sums the base salary balance and the calculated bonus into a single final figure.

    compute_salary_balance_and_bonuses

  4. Format for review

    The agent organizes the raw numbers into a clear summary you can read in your chat interface.

    compute_salary_balance_and_bonuses

Try it

Copy these to start.

Use these prompts to trigger the calculation immediately.

Starting points

These are just ways to start the conversation. Swap the bracketed info for your actual data sources.

Severance Pay Calculator Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_tmwvTI9kN6uGqEI7qTAPQmfBZ2Oc6EA7lRhrbF1J/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Severance Pay Calculator capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "severance-pay-calculator-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_tmwvTI9kN6uGqEI7qTAPQmfBZ2Oc6EA7lRhrbF1J/mcp"
    }
  }
}
Copy into chat04

  • Calculate the final salary balance and 13th-month bonus for the employee in the 'Staff_List' sheet.

  • Based on the payroll data in the 'Q3_Payroll' folder, what is the total severance owed for John Doe?

  • Run a calculation for all employees marked 'Terminated' in the current HR spreadsheet.

  • Find the proportional 13th-month bonus for the employee listed in the 'Exit_Log' file.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Severance Pay Calculator once, then ask.

You only need to link your data source once. Your credentials stay encrypted and secure, and you can start asking questions in your preferred AI client right away.

Connect Severance Pay Calculator to your AI

FAQ

How the calculator behaves

  • 01

    Can the AI send the money to the employee?

    No. The AI only calculates the amounts. You must use your own banking or payroll software to actually issue the payment.

  • 02

    Does the AI change my original payroll files?

    No. The AI only reads your data to perform calculations. It does not write to or modify your source spreadsheets or databases.

  • 03

    What data does it need to work?

    It needs access to your payroll or employee records that contain salary rates, start dates, and termination dates.

  • 04

    Can it calculate taxes?

    No. This specific tool focuses on the gross salary balance and the proportional 13th-month bonus.

  • 05

    Does it handle different currencies?

    The calculation depends on the currency format used in your provided payroll data.

  • More questions about Severance Pay Calculator? The Connector page answers them. See everything the Severance Pay Calculator Connector can do

Connect Severance Pay Calculator to Claude, Cursor, ChatGPT & more