Report Details

Below is a brief overview of each of the reports available to you on Halo. To access reports, review this article for assistance.

Aged Analysis Report

What it shows:

• A summary of all outstanding customer invoices.
• Grouped by how long they’ve been unpaid (e.g., 0–30 days, 31–60 days, etc.).
• Highlights any unmatched payments or credits.

Why it matters:

Gives you a quick view of overdue invoices and potential cash-flow points to follow up with your customers.

Aged Analysis – Item Detail

What it shows:

• A detailed list of each open invoice and any adjustments.
• Includes invoice dates, age, and outstanding balances.
• Identifies unallocated cash or credits.

Why it matters:

Useful for in-depth reconciliation or when you need the full invoice breakdown per customer.

Client Summary Report

What it shows:

• Sales Ledger: Opening balance, transactions for the day (new invoices, payments), and your total outstanding invoices.
• Funds in Use: How much you’ve borrowed (increases with funded invoices, decreases as customers pay).
• Key details on available funds, approved funding, accrued fees, and your facility limit.

Why it matters:

Provides a real-time view of your funding position and available borrowing capacity.

Client Statement (Sales Ledger & Funds in Use)

What it shows:

• Same as the Client Summary Report, but designed for monthly reconciliation.
• Adds a Client Balance Summary, showing retention balances owed to you once all invoices are settled.

Why it matters:

Ideal for end-of-month checks and ensuring everything aligns correctly.

Credit Item Reconciliation Report

What it shows:

• How customer payments or credits were allocated to invoices.
• Reflects short payments, credit offsets, or split allocations.

Why it matters:

Helps you track how each customer payment was applied and confirms accurate allocation.

Movement Report

What it shows:

• Every transaction on your debtor accounts (e.g., new invoices, settlements, adjustments, reassignments).
• Full audit trail per customer.

Why it matters:

Gives you a complete picture of all movements for transparency and compliance.

Video Overview