Project Cost Dashboard

Monthly cash outflow

Accrual vs cash

Monthly accrual vs cash

How these figures are built

Source. Every figure on this dashboard comes from the Transactions table of the Jaber Dev workbook, joined to the chart of accounts. Nothing is estimated or entered by hand. Totals have been reconciled line-for-line against the Jaber Devtest Power BI model measures.

Reporting period. The report only covers complete calendar months. The current period runs to 31 August 2026; the part-month after that date is excluded and joins the report once the month closes. Use the Reported through control to re-cut the whole dashboard at any earlier month-end.

Cash basis. Sum of Debit on accounts whose type is Current Liabilities, excluding rows flagged Exp = X. The liability control account is debited when cash leaves the bank, so this is money actually paid out. The Exp = X flag marks adjustments, credit notes and transfers between accounts — movements that change a vendor's balance but never touch cash, so they are kept out of the cash report while remaining on the vendor statement.

Accrual basis. Debit less Credit on accounts whose type is Project Cost. These are debited as cost is invoiced or certified, regardless of payment.

Accrual vs cash. Cash above accrual means the position is prepaid — down payments, reservations and advances issued ahead of invoices. Accrual above cash means cost has been recognised but not yet settled.

Vendor balances. Balance is cumulative Credit less Debit, matching the workbook's netflow convention. A credit balance is payable to the vendor. A debit balance — shown in brackets — means the vendor has been paid ahead of what they have invoiced, and sits as an advance. Statements list every movement including Exp = X rows.

Combining names. A vendor often carries more than one account, because the same firm is booked under several cost categories. Select as many names as needed and the statement combines them into one continuous running balance, with the account shown on each line.

Per type. On the cash basis an account is the vendor or liability control account that was paid. On the accrual basis it is the project cost account the expense was booked to, so the same work can appear under a different account name on each basis while sharing one cost category.

Weekly page. The current month is split into week bands by day of month — 1–7, 8–14, 15–21, 22–28, and 29 to month end where the month is long enough. Bands never cross a month boundary, so every month has four or five of them and the weeks always add back to the month. Figures are cash basis, on the same definition as the cash pages.