Monthly Closing Statements

module: monthly-closing-statements
intent: null            # setup | advice | review | fix | build | convert | export
scale: null             # Starter | Growth | Scale, only if the answer changes it
areas:
  "Close": null
  "Reconciliations": null
  "Adjustments": null
  "Output": 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

Closing Number,Period Start,Period End,Entries Completed,Cash Reconciled,Bank Reconciled,Party Ledgers Reconciled,Inventory Reconciled,TDS Reconciled,Other Statutory Liabilities Reconciled,Receivables Reviewed,Payables Reviewed,Depreciation Recorded,Accruals & Prepayments Reviewed,VAT/Tax Account Reviewed,Trial Balance Prepared,Financial Statements Prepared,Revenue,Gross Profit,Net Profit/Loss,Receivables Outstanding,Payables Outstanding,Working Capital,Cash Flow Position,Financial Position,Open Adjustments,Closing Date,Prepared By,Reviewed By,Status,Notes,Closing ID
CL-2026-08,2026-08-01,2026-08-31,Complete,Yes,Yes,Yes,Yes,Yes,Yes,Yes,Yes,48200.00,Yes,Yes,Yes,Yes,4820000.00,1542400.00,612000.00,486200.00,394800.00,91400.00,1284500.00,"Solvent, working capital thin against a 42 day collection cycle.",3,2026-09-05,Ananya Rao,Vikram Singh,Done,Three accruals still open; statements marked draft until cleared.,

CREATE TABLE monthly_closing_statements (
  closing_number VARCHAR(255),
  period_start DATE NOT NULL,
  period_end DATE NOT NULL,
  entries_completed VARCHAR(100) NOT NULL,
  cash_reconciled VARCHAR(100) NOT NULL,
  bank_reconciled VARCHAR(100) NOT NULL,
  party_ledgers_reconciled VARCHAR(100) NOT NULL,
  inventory_reconciled VARCHAR(100) NOT NULL,
  tds_reconciled VARCHAR(100) NOT NULL,
  other_statutory_liabilities_reconciled VARCHAR(100) NOT NULL,
  receivables_reviewed VARCHAR(100) NOT NULL,
  payables_reviewed VARCHAR(100) NOT NULL,
  depreciation_recorded NUMERIC(14,2),
  accruals_prepayments_reviewed VARCHAR(100) NOT NULL,
  vat_tax_account_reviewed VARCHAR(100) NOT NULL,
  trial_balance_prepared VARCHAR(100) NOT NULL,
  financial_statements_prepared VARCHAR(100) NOT NULL,
  revenue NUMERIC(14,2) NOT NULL,
  gross_profit NUMERIC(14,2) NOT NULL,
  net_profit_loss NUMERIC(14,2) NOT NULL,
  receivables_outstanding NUMERIC(14,2),
  payables_outstanding NUMERIC(14,2),
  working_capital NUMERIC(14,2),
  cash_flow_position NUMERIC(14,2),
  financial_position TEXT,
  open_adjustments NUMERIC,
  closing_date DATE,
  prepared_by VARCHAR(255),
  reviewed_by VARCHAR(255),
  status VARCHAR(100) NOT NULL,
  notes TEXT,
  closing_id SERIAL PRIMARY KEY,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_monthly_closing_statements_status ON monthly_closing_statements (status);

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Monthly Closing & Statements",
  "type": "object",
  "additionalProperties": false,
  "properties": {
      "Closing Number": { "type": "string" },
      "Period Start": { "type": "string", "format": "date" },
      "Period End": { "type": "string", "format": "date" },
      "Entries Completed": { "type": "string" },
      "Cash Reconciled": { "type": "string" },
      "Bank Reconciled": { "type": "string" },
      "Party Ledgers Reconciled": { "type": "string" },
      "Inventory Reconciled": { "type": "string" },
      "TDS Reconciled": { "type": "string" },
      "Other Statutory Liabilities Reconciled": { "type": "string" },
      "Receivables Reviewed": { "type": "string" },
      "Payables Reviewed": { "type": "string" },
      "Depreciation Recorded": { "type": "number" },
      "Accruals & Prepayments Reviewed": { "type": "string" },
      "VAT/Tax Account Reviewed": { "type": "string" },
      "Trial Balance Prepared": { "type": "string" },
      "Financial Statements Prepared": { "type": "string" },
      "Revenue": { "type": "number" },
      "Gross Profit": { "type": "number" },
      "Net Profit/Loss": { "type": "number" },
      "Receivables Outstanding": { "type": "number" },
      "Payables Outstanding": { "type": "number" },
      "Working Capital": { "type": "number" },
      "Cash Flow Position": { "type": "number" },
      "Financial Position": { "type": "string" },
      "Open Adjustments": { "type": "number" },
      "Closing Date": { "type": "string", "format": "date" },
      "Prepared By": { "type": "string" },
      "Reviewed By": { "type": "string" },
      "Status": { "type": "string" },
      "Notes": { "type": "string" },
      "Closing ID": { "type": "integer" }
  },
  "required": [
      "Period Start",
      "Period End",
      "Entries Completed",
      "Cash Reconciled",
      "Bank Reconciled",
      "Party Ledgers Reconciled",
      "Inventory Reconciled",
      "TDS Reconciled",
      "Other Statutory Liabilities Reconciled",
      "Receivables Reviewed",
      "Payables Reviewed",
      "Accruals & Prepayments Reviewed",
      "VAT/Tax Account Reviewed",
      "Trial Balance Prepared",
      "Financial Statements Prepared",
      "Revenue",
      "Gross Profit",
      "Net Profit/Loss",
      "Status"
  ]
}

| CSV column | Notion property | Set after import |
|---|---|---|
| Closing Number | Title | Use as the database title |
| Period Start | Date | Convert to Date |
| Period End | Date | Convert to Date |
| Entries Completed | Select (add options after import) | Convert to Select, add options: "Complete", "Incomplete", "Blocked" |
| Cash Reconciled | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Bank Reconciled | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Party Ledgers Reconciled | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Inventory Reconciled | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| TDS Reconciled | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Other Statutory Liabilities Reconciled | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Receivables Reviewed | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Payables Reviewed | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Depreciation Recorded | Number (format: currency) | Convert to Number, set format to Currency |
| Accruals & Prepayments Reviewed | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| VAT/Tax Account Reviewed | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Trial Balance Prepared | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Financial Statements Prepared | Select (add options after import) | Convert to Select, add options: "Yes", "No", "Pending" |
| Revenue | Number (format: currency) | Convert to Number, set format to Currency |
| Gross Profit | Number (format: currency) | Convert to Number, set format to Currency |
| Net Profit/Loss | Number (format: currency) | Convert to Number, set format to Currency |
| Receivables Outstanding | Number (format: currency) | Convert to Number, set format to Currency |
| Payables Outstanding | Number (format: currency) | Convert to Number, set format to Currency |
| Working Capital | Number (format: currency) | Convert to Number, set format to Currency |
| Cash Flow Position | Number (format: currency) | Convert to Number, set format to Currency |
| Financial Position | Text | Leave as Text |
| Open Adjustments | Number | Convert to Number |
| Closing Date | Date | Convert to Date |
| 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 |
| Closing ID | Text (preserve source ID) | Keep imported IDs as Text; optionally add a separate Unique ID property |