Reading and interpreting the Cash Breakdown report

Reading and interpreting the Cash Breakdown report

The Cash Breakdown report is a statement of all cash account activity over a selected period. Unlike a simple list of transactions, it groups movements by account and transaction type, making it easy to see where cash came from and where it went.

What the report shows

The Cash Breakdown report organizes cash data in three layers:

1. Cash Account (e.g., "Main Cash," "Bank Account – XYZ Bank"): The top level groups all activity for one account.
2. Transaction Type (e.g., "Customer Receipts," "Vendor Payments," "Internal Transfers"): Each account is broken down by the kind of transaction.
3. Opening and Closing Balances: The report shows the account balance at the start of the period, plus all adds and subtracts, ending with the balance at the report date.

Key columns

• Account Name: The name of the cash account being reported on.
• Opening Balance: The account balance on the start date.
• Transaction Type: The category of cash movement (receipt from customer, payment to vendor, transfer, etc.).
• Debit / Credit: The amount added (debit) or removed (credit) in that category.
• Closing Balance: The account balance at the end date.

The opening balance plus all debits minus all credits equals the closing balance. If this balances, your account is accurate.

How to interpret it

Verify cash movements: For each transaction type, the amounts should match your underlying documents (invoices paid, bills settled, salaries distributed, etc.). If you see a large payment to vendors but no corresponding bills, investigate whether a transaction was misclassified or posted to the wrong account.

Spot trends: Compare the opening and closing balances. A large decline suggests cash is leaving the business; a big increase suggests cash is coming in. Look at which transaction types are driving the change. Is it customer receipts (good) or vendor payments (normal operations)?

Reconcile with your bank: If you have a "Bank Account" cash account, compare the closing balance with your actual bank statement. They should match (or be close, allowing for uncleared checks). If there is a gap, check for outstanding deposits or checks.

Audit cash handling: If you use multiple cash accounts (till, safe, petty cash, etc.), run the report for each one. All opening balances plus all inter-account transfers should explain the closing balances.

Why it matters

Cash is the most liquid and trackable asset. A detailed breakdown tells you whether your cash records match reality, and it flags unusual or suspicious flows—such as unexplained outflows, misrouted transactions, or imbalances that could signal fraud or error.