DEMO · Synthetic figures onlyNo live QuickBooks, bank or customer data connected.
Monthly financial reporting
Cash flow & debt
January 2027 · Accrual basis · SGD, exclusive of GST
Draft pack · v1
Company cash, debt and equity are not allocated to programme or centre.
Company cash flow
| Accounting line | Current month | Prior month | Budget | Variance | Variance % | Notes |
|---|---|---|---|---|---|---|
| Opening cash | $180,000.00 | $169,200.00 | $187,200.00 | -$7,200.00 U | -3.8% | — |
| Cash collected from customers | $157,000.00 | $147,580.00 | $163,280.00 | -$6,280.00 U | -3.8% | — |
| Other operating receipts | $1,000.00 | $940.00 | $1,040.00 | -$40.00 U | -3.8% | — |
| Payroll and CPF paid | -$48,000.00 | -$45,120.00 | -$49,920.00 | $1,920.00 F | 3.8% | — |
| Suppliers and operating costs paid | -$75,000.00 | -$70,500.00 | -$78,000.00 | $3,000.00 F | 3.8% | — |
| GST and tax paid | -$7,000.00 | -$6,580.00 | -$7,280.00 | $280.00 F | 3.8% | — |
| Interest paid | -$1,800.00 | -$1,692.00 | -$1,872.00 | $72.00 F | 3.8% | — |
| Asset purchases | -$3,200.00 | -$3,008.00 | -$3,328.00 | $128.00 F | 3.8% | — |
| Loan proceeds | $0.00 | $0.00 | $0.00 | $0.00 | — | — |
| Loan principal repaid | -$5,000.00 | -$4,700.00 | -$5,200.00 | $200.00 F | 3.8% | — |
| Other financing cash flow | $0.00 | $0.00 | $0.00 | $0.00 | — | — |
| Net operating cash flow | $26,200.00 | Input required | Input required | Input required | — | — |
| Net investing and financing cash flow | -$8,200.00 | Input required | Input required | Input required | — | — |
| Closing cash | $198,000.00 | $180,000.00 | Input required | Input required | — | — |
Cash outflows are negative. Debt principal repayments are positive in the loan roll-forward.
Debt roll-forward
| Accounting line | Current month | Prior month | Variance | Notes |
|---|---|---|---|---|
| Loan principal: opening | $105,000.00 | Input required | Input required | — |
| New borrowing | $0.00 | Input required | Input required | — |
| Principal repayment | $5,000.00 | Input required | Input required | — |
| Closing principal | $100,000.00 | $105,000.00 | -$5,000.00 | — |
| Interest (separate expense) | $1,800.00 | Input required | Input required | — |
| Fees | Input required | Input required | Input required | — |
Three-year repayment is a conditional planning target. Lender terms, break costs, covenants and liquidity must be assessed. It is not an approved commitment.