Tds Booking Payment

module: tds-booking-payment
intent: null            # setup | advice | review | fix | build | convert | export
scale: null             # Starter | Growth | Scale, only if the answer changes it
areas:
  "Nature of payment": null
  "Rates": null
  "Deposits": null
  "Returns": null
  "Outcome": null
requested_outputs: []   # csv | sql | json | notion | xlsx - requested formats only
confirmed_facts: []     # only what the user actually said
open_questions: []      # the unanswered ones, in the order worth asking

TDS Record Number,Tax Period,Nature of Payment,Payee Name,Payee PAN,Transaction Reference,Payment Date,Gross Payment/Base,TDS Rate %,TDS Deducted,Deducted On,TDS Payable Ledger,Deposit Date,Challan/Bank Reference,Amount Deposited,Return Filed Date,Return Reference,Ledger Reconciliation,Variance Amount,Reconciliation Frequency,Prepared By,Reviewed By,Status,Notes,TDS ID
TDS-2026-0194,2026-08,Professional Fees,Pixelworks Studio,29ABCDE1234F1Z5,EXP-2026-0338,2026-08-18,32500.00,10,3250.00,2026-08-18,TDS Payable - Professional Fees,2026-09-15,CHL-2026-0912,48200.00,2026-10-15,TDS-Q2-2026-PF,Variance,325.00,Monthly,Sneha Iyer,Vikram Singh,In progress,Deposit and return agree to the challan; ledger short by 325.00 and under investigation.,

CREATE TABLE tds_booking_payment (
  tds_record_number VARCHAR(255),
  tax_period VARCHAR(255),
  nature_of_payment VARCHAR(100) NOT NULL,
  payee_name VARCHAR(255),
  payee_pan VARCHAR(255),
  transaction_reference VARCHAR(255),  -- relation -> target record
  payment_date DATE NOT NULL,
  gross_payment_base NUMERIC(14,2) NOT NULL,
  tds_rate_pct NUMERIC NOT NULL,
  tds_deducted NUMERIC(14,2) NOT NULL,
  deducted_on DATE,
  tds_payable_ledger VARCHAR(255),
  deposit_date DATE,
  challan_bank_reference VARCHAR(255),
  amount_deposited NUMERIC(14,2) NOT NULL,
  return_filed_date DATE,
  return_reference VARCHAR(255),
  ledger_reconciliation VARCHAR(100) NOT NULL,
  variance_amount NUMERIC(14,2) NOT NULL,
  reconciliation_frequency VARCHAR(100) NOT NULL,
  prepared_by VARCHAR(255),
  reviewed_by VARCHAR(255),
  status VARCHAR(100) NOT NULL,
  notes TEXT,
  tds_id SERIAL PRIMARY KEY,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_tds_booking_payment_status ON tds_booking_payment (status);

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "TDS Booking & Payment",
  "type": "object",
  "additionalProperties": false,
  "properties": {
      "TDS Record Number": { "type": "string" },
      "Tax Period": { "type": "string" },
      "Nature of Payment": { "type": "string" },
      "Payee Name": { "type": "string" },
      "Payee PAN": { "type": "string" },
      "Transaction Reference": { "type": "string" },
      "Payment Date": { "type": "string", "format": "date" },
      "Gross Payment/Base": { "type": "number" },
      "TDS Rate %": { "type": "number" },
      "TDS Deducted": { "type": "number" },
      "Deducted On": { "type": "string", "format": "date" },
      "TDS Payable Ledger": { "type": "string" },
      "Deposit Date": { "type": "string", "format": "date" },
      "Challan/Bank Reference": { "type": "string" },
      "Amount Deposited": { "type": "number" },
      "Return Filed Date": { "type": "string", "format": "date" },
      "Return Reference": { "type": "string" },
      "Ledger Reconciliation": { "type": "string" },
      "Variance Amount": { "type": "number" },
      "Reconciliation Frequency": { "type": "string" },
      "Prepared By": { "type": "string" },
      "Reviewed By": { "type": "string" },
      "Status": { "type": "string" },
      "Notes": { "type": "string" },
      "TDS ID": { "type": "integer" }
  },
  "required": [
      "Nature of Payment",
      "Payment Date",
      "Gross Payment/Base",
      "TDS Rate %",
      "TDS Deducted",
      "Amount Deposited",
      "Ledger Reconciliation",
      "Variance Amount",
      "Reconciliation Frequency",
      "Status"
  ]
}

| CSV column | Notion property | Set after import |
|---|---|---|
| TDS Record Number | Title | Use as the database title |
| Tax Period | Text | Leave as Text |
| Nature of Payment | Select (add options after import) | Convert to Select, add options: "Professional Fees", "Contractor Payment", "Rent", "Salary", "Commission", "Interest", "Contract Payment", "Other" |
| Payee Name | Text | Leave as Text |
| Payee PAN | Text | Leave as Text |
| Transaction Reference | Relation (link to the target database) | Convert to Relation, link to the target database |
| Payment Date | Date | Convert to Date |
| Gross Payment/Base | Number (format: currency) | Convert to Number, set format to Currency |
| TDS Rate % | Number | Convert to Number |
| TDS Deducted | Number (format: currency) | Convert to Number, set format to Currency |
| Deducted On | Date | Convert to Date |
| TDS Payable Ledger | Text | Leave as Text |
| Deposit Date | Date | Convert to Date |
| Challan/Bank Reference | Text | Leave as Text |
| Amount Deposited | Number (format: currency) | Convert to Number, set format to Currency |
| Return Filed Date | Date | Convert to Date |
| Return Reference | Text | Leave as Text |
| Ledger Reconciliation | Select (add options after import) | Convert to Select, add options: "Reconciled", "Variance", "Pending" |
| Variance Amount | Number (format: currency) | Convert to Number, set format to Currency |
| Reconciliation Frequency | Select (add options after import) | Convert to Select, add options: "Monthly", "Quarterly" |
| Prepared By | Text | Leave as Text |
| Reviewed By | Text | Leave as Text |
| Status | Select (add options after import) | Convert to Select, add options: "Not started", "In progress", "Blocked", "Done", "Cancelled" |
| Notes | Text | Leave as Text |
| TDS ID | Text (preserve source ID) | Keep imported IDs as Text; optionally add a separate Unique ID property |