Admin · Setup

Import workbench

Paste JSON, see exactly what it will do, then apply through an audited database function. Applies run as you, so sign in first.

You are signed out

Previews still work, but every apply will be refused. Go to login.

EnvironmentReadyRoot env loaded

Remote writesTest windowGuarded CLIs

Bootstrap payloadValid1 company, 48 periods

Schema apply50 workbenchespnpm v2:migration-status

Payroll

Payroll setup

Back to the app

External AI briefing

Copy this prompt, paste it into ChatGPT/Claude with your Excel/CSV, then paste the returned JSON here.

Company

PAN: not set — add at /app/company

VAT: not set — add at /app/company

Fiscal yearSource dataNepal VAT/TDS conventionsAmounts in minor units (paisa)I will attach a spreadsheet

Your notes for the AI (column mapping, PAN, special cases)

Examples are templates, not gospel

Repo examples pass structural validation but use placeholder tax IDs and sample amounts. Your accountant should confirm statutory rules and opening balances before you apply in production.

Payroll Setup JSON

Valid

57 lines

{
  "companyCode": "SCC",
  "fiscalYearCode": "2083-84",
  "components": [
    {
      "code": "basic_salary",
      "name": "Basic Salary",
      "kind": "earning",
      "calculationBasis": "fixed",
      "taxable": true,
      "affectsNetPay": true,
      "expenseAccountCode": "5100"
    },
    {
      "code": "allowance",
      "name": "Allowance",
      "kind": "earning",
      "calculationBasis": "fixed",
      "taxable": true,
      "affectsNetPay": true,
      "expenseAccountCode": "5100"
    },
    {
      "code": "advance_recovery",
      "name": "Advance Recovery",
      "kind": "deduction",
      "calculationBasis": "manual",
      "taxable": false,
      "affectsNetPay": true,
      "liabilityAccountCode": "2500"
    },
    {
      "code": "employer_contribution",
      "name": "Employer Contribution",
      "kind": "employer_contribution",
      "calculationBasis": "manual",
      "taxable": false,
      "affectsNetPay": false,
      "expenseAccountCode": "5100",
      "liabilityAccountCode": "2500"
    }
  ],
  "ruleSets": [
    {
      "code": "np-fy-2083-84",
      "name": "Nepal Payroll Rules FY 2083-84",
      "effectiveFromAd": "2026-07-17",
      "effectiveFromBs": "2083-04-01",
      "status": "draft",
      "rules": {
        "country": "NP",
        "notes": "Draft placeholder until accountant-reviewed tax and contribution rules are entered."
      }
    }
  ]
}

Preview

Validation only

Company: SCC
Fiscal year: 2083-84
Components: 4
Earnings: 2
Deductions: 1
Rule sets: 1

Upserts pay components by code (re-activating archived ones) with optional expense/liability GL accounts used when pay runs post, and rule sets by code for the given fiscal year. Only one rule set can be active per fiscal year; activating a second is refused until the first is archived. Requires payroll.manage.

Runs app.apply_import('payroll_setup') as you; the database re-checks your permission and records an audit event.