Ledger Report
How the ledger report shows finance movement, review signals, transaction type breakdowns, recent rows, and exports.
The ledger report is the best reporting screen to use when the question is about movement rather than balances. It shows what has happened across finance rows in the selected date range, which transaction types are doing the work, and where the messy edges are before you export or reconcile anything.
Filters at the Top
- Date range: This decides which ledger rows are pulled into the report. The same dates drive the summary cards, review signals, type breakdown, monthly activity, recent rows, and export.
- Business: Use this to switch the report to a different business if your login can access more than one.
- Clear filters: Returns the report to its default date range and removes the business override.
Details Tab
- Completed rows: A count of completed ledger items in the selected date range.
- Gross movement: Total gross amount across completed rows.
- Net movement: Total net amount across completed rows.
- VAT movement: Total VAT across completed rows.
- Failed rows: A quick warning that some finance rows in the selected period are in a failed state and may need attention outside the report.
Those headline cards are followed by the review signals. This is where the ledger report becomes especially useful for cleanup work.
- Uninvoiced charges: Completed charge rows that are not linked to an invoice yet. If this number is high, the report is telling you that income has been recorded operationally but not packaged into invoice records.
- Unallocated payments: Completed payment rows with no linked invoice. This usually means money has been received but not attached properly to the debt it was meant to reduce.
- Uncategorised expenses: Completed expense rows with no expense category. This makes downstream reporting harder, so it is a useful prompt to tidy up expense coding.
- Cancelled rows and Pending count: This helps you see how much finance activity is still unresolved or has been stopped before completion.
Transaction Type Breakdown
The transaction type breakdown groups completed rows by ledger type and shows a count, gross amount, and VAT amount for each one. It is the easiest way to see whether the selected period is being driven by charges, payments, expenses, refunds, write-offs, or other row types.
Monthly Activity Tab
The Monthly Activity tab turns the selected date range into one row per month. Each row shows completed row count plus the gross values for charges, payments, expenses, refunds, and VAT. This is the view to use when you want to spot finance patterns over time rather than inspect individual rows.
Recent Rows Tab
The Recent Rows tab shows the latest finance rows in the current filter window. It includes the date, type, status, description, customer, and gross amount, with net and VAT tucked into the description cell. Work Planner only shows a short recent slice here, so think of it as a quick inspection panel rather than a full transaction browser.
Report Notes
The notes on this screen matter. Monthly totals use entry date, monetary summaries are based on completed rows only, and the review signals are there to help you spot workflow gaps before you export or hand figures over elsewhere.
Export Tab
The Export tab downloads the ledger report as CSV using the date range and business filter currently on screen.
Related articles
- Reporting Overview: Start there when you need the big picture before moving into ledger movement.
- Transactions List: Use this when you need to work with finance rows directly rather than review them in report form.
- VAT Report: Useful when the ledger movement needs to be checked specifically from a VAT angle.
- Statements Report: Move there when you want a more management-focused performance view of the same period.