Islamia School and Mosque Association Daily Cashflow
Tracking Bank 102 and Bank 107 across the 2026/27 fiscal year.
Today
When cheques hit the bank
Where the money is going
After next week
Outstanding liabilities
Liabilities are entered by the secretary in the dedicated Google Sheet tab.
Every cheque, one clear record.
Search, filter and review both bank accounts.
| Date | Cheque | Payee & narration | Category | Account | Status | Amount |
|---|
Spend patterns, without the spreadsheet work.
Fiscal year runs 01 April to 31 March.
Cheque value trend
Spend by purpose
Largest recipients
102 vs 107
Connect the secretary's source sheet.
No change to the current data-entry routine is required.
Google Sheets Private API
The cheque workbook remains private. This dashboard connects through a token-protected Apps Script API and a secured cPanel PHP proxy. No published CSV links are used.
Private connection status
The Apps Script URL and API token are stored outside the public website directory. Browser users never receive either credential.
Connected columns
The private API reads MAIN 102 and QAB 107 directly and can update the status and cleared date without publishing the workbook.
Reporting setup
Import or reset
CSV import remains available only as an emergency offline backup. Live data comes from the private API.
Local edits are saved in this browser.