📊

Cashflow Workbench

JPS Financial Planning & Analysis

Sign in with your JPS account. Contact your administrator to request access.

JPS FP&A
Cashflow WB
— select month —
🔍
Workbench
📤Outflow Validation
🔍Map Exceptions
📋Base Case
⚙Rules
📊Multi-Month Report
Admin
📁Data Manager
📜Audit Log
❓Instructions
?
—
FP&A Team
📊

Cashflow Workbench

JPS Financial Planning & Analysis

Theme
?
—
Connecting…
⚠️ Add a config.js with your Supabase URL and anon key, then run supabase/schema.sql.
|

Data Manager

Source files are stored in Supabase so the month can be reprocessed at any time. Reset wipes all records and uploads for the selected month.

AP Outflows — By Base Case Row
AP Outflows — By Category
Cashbook Summary
Exceptions / Unmapped Lines
Add / Edit Rule Changes are not saved until you click Save Rule
Rule saved — rebuild this month with the updated rules?
Base Case Summary
Saved Mapping Rules
Audit Log
Select Months to Include

No saved months — process a month first.

Base Case — Multi-Month Comparison
⚙ Settings
Setup checklist
1. Enter the approver and from email above and click Save Settings.
2. Set RESEND_API_KEY as a Supabase secret:
  Supabase Dashboard → Edge Functions → cashflow-approval → Secrets.
3. The from email must be a verified sender in your Resend account.
4. Click Submit for Approval on any open month to trigger the OTP email.
Month Approval Status

Recommended Workflow

  1. Enter your name on the welcome screen — it is recorded on every action in the audit log. Click your name badge in the header to change it.
  2. Select a month in the Month field, or pick a saved month from the dropdown and click ↩ Load Month.
  3. Upload the AP invoice/payment report and the two cashbook text exports (180 and 132 formats). The optional Rules Import CSV lets you bulk-load rules from a spreadsheet.
  4. Click ▶ Process & Save Month. The status bar shows each stage: parsing → rule application → record count → save progress (e.g. "Saving records… 500 / 13,208"). Raw source text and processed records are stored in Supabase.
  5. The Outflow Validation tab opens first. Review AP outflows by base case row and by category, and the cashbook summary side-by-side.
  6. Switch to Map Exceptions to see unmapped lines or lines with no base case row. Click Map on any row to pre-fill the rule form. Save the rule, then click Reapply Now to rebuild immediately.
  7. Use ↻ Reapply Rules from the month panel at any time to re-run all rules against the saved source files without re-uploading.
  8. Use 📊 Multi-Month Report to compare any combination of saved months side-by-side as a base case matrix, then download as Excel.
  9. Export the single-month Base Case via ⬇ Excel Report when the month is finalised.

Procedure Logic — AP Rules (47 rules total)

The following rules are pre-loaded and reflect the JPS FP&A cashflow procedures (updated 27 Apr 2026):

  • IPP: Pay group contains "PURCHASE POWER"
  • Capital: FPC 18601 or 30000–39999, Supplier pay group
  • Inventory: FPC 15401–15499, Supplier pay group
  • Insurance: FPC 16501
  • Jameco (Motor Vehicle Transport): Vendor contains "JAMECO"
  • Regulatory Fees: Vendor "OFFICE OF UTILITIES" or pay group "REGULATORY FEES"
  • Loan Principal: FPC prefix 22xxx, Loan pay group
  • Loan Interest: FPC prefix 23xxx, Loan pay group
  • Loan Fees: FPC prefix 42xxx, Loan pay group
  • JPS Fuel: FPC 143xx, 23237, 23258, 23272, Fuel pay group
  • Lease/Rental: Description contains "PROPERTY RENTAL" or "HEAD OFFICE"
  • Other: Description contains "DONATION", "SPONSORSHIP", or "FOUNDATION"
  • Payroll: Pay group contains "EMPLOYEE"
  • Taxes: Pay group contains "TAX"
  • Supplier (default): Pay group contains "SUPPLIER"

Procedure Logic — Cashbook Rules (updated 27 Apr 2026)

  • CI 1–99: Payroll → Collections
  • CI 321–322: F/X Gain/(Loss) → Collections
  • CI 352: Interest Income → Collections
  • CI 380, 395: Bank Charge (credit side, excluded from Base Case)
  • CI 912: Interest Income → Collections
  • JE27: Cash Book → Collections
  • JE 09MA, JE 09TA: Transfer (excluded from Base Case) ★ new
  • JE 26B: Transfer (excluded from Base Case) ★ new
  • FERC 12806, 42101: Dividend Received ★ new
  • CI 13101: Sinking Fund → Long-term Debt Financing ★ new
  • CI 13102: Payroll → Collections ★ new
  • CI 13104, 13111, 13129, 13149: Transfer (excluded) ★ new
  • CI 13118: Supplier → Collections ★ new
  • CI 13119: RBTT Cheques → Collections ★ new
  • CI 13123: Citibank Cheques → Collections ★ new
  • CI 13126: BNS F/X Cheques → Collections ★ new
  • CI 13175: Expense Cheques → Collections ★ new
  • F/X Purchase: F/X Purchase → Collections ★ new

★ Rules added from procedures update dated 27 Apr 2026. Run ↻ Reapply Rules on each saved month to apply the new rules to historical data.

Notes

  • Cashbook debits are the receipt side (Collections row). Cashbook credits are the bank control side only and are excluded from the Base Case.
  • AP invoice/payment report is the primary source for categorising outflows.
  • Transfers (JE09MA, JE09TA, JE26B, CI 13104/13111/13129/13149) have no base case row and are excluded from all summaries.
  • Reset / Wipe removes all records and uploads for the month and logs the action. You will need to re-upload files to reprocess after a reset.
  • No login password is required. Your name is captured from the welcome screen and stamped on every save, rule change, and audit log entry.
  • The Multi-Month Report queries the database directly for each selected month — no need to have a month loaded first.