| Report Name |
Summary |
Aged Trial Balance |
- Shows customer account balances aged into current and overdue periods as at a selected date.
- Filter by customer type, group, region, sales rep, and account range; group results; optionally include outstanding transactions.
- Use to review who owes money and how overdue balances are.
|
Transactions |
- Lists customer financial transactions (invoices, payments, credit notes, adjustments, and related activity) for a date range.
- Filter by transaction type, customer attributes, manager, sales rep, and location; group by account or transaction type.
- Use for a detailed audit trail of customer account activity.
|
Unallocated Payments |
- Lists customer payments not fully allocated to invoices.
- Filter by customer type, group, and account range; sort by account, name, payment date, or amount.
- Use to find payments that still need to be applied.
|
Customer Quotes |
- Summarises or details customer quotes for a date range (by quote date or expiry date).
- Report types include summary by status, detailed by customer, and detailed by product.
- Use to review open, accepted, or expired quotes.
|
Customer Pending Invoices |
- Lists invoices that are pending (not yet fully processed/posted) for a selected invoice date range.
- Report types include summary by customer, sales rep, status, or reference, and detailed by customer or product.
- Use to monitor work-in-progress invoicing.
|
Customer Outstanding Credits |
- Shows customers with outstanding credit balances (unapplied credits) as at a selected date.
- Filter by customer type, group, region, sales rep, and account; optionally limit to negative unpaid transactions or zero-balance customers.
- Use to identify credits that may need refunding or allocating.
|
Sales Analysis |
- Analyses sales over an invoice date range with flexible grouping (up to three levels, e.g. customer, product, sales rep).
- Filter by customer, product, location, sales rep, manager, and more; optionally show costs.
- Use for general sales performance analysis.
|
Sales Analysis MTD/YTD |
- Shows month-to-date and year-to-date sales as at a selected date.
- Group results (e.g. by customer group or sales rep) and sort by customer name, MTD sales, or YTD sales.
- Use for a quick view of current-month and year-to-date performance.
|
Sales Analysis Top Sales |
- Ranks top-performing customers (or other groupings) by MTD or YTD sales as at a selected date.
- Optionally limit the number of records returned.
- Use to identify highest-value customers or segments.
|
Sales Analysis 13 Month |
- Shows sales broken down across 13 months ending at a selected month-end.
- Use for trend analysis and month-over-month comparison across a rolling year.
|
Sales Analysis Dual Date Range |
- Compares sales across two separate invoice date ranges side by side.
- Use to compare performance between two periods (e.g. this quarter vs last quarter).
|
Sales Analysis – YTD With Previous Year |
- Compares year-to-date sales with the same period in the previous financial year.
- Use for year-on-year performance tracking.
|
Statements – All Customers |
- Generates customer statements of account for all customers (or a filtered subset) as at a selected date.
- Choose whether to include zero-balance and credit-balance accounts.
- Use for bulk statement runs (e.g. month-end debtor statements).
|
Customer List (detailed) |
- Detailed listing of customers including contact information.
- Filter by type, group, region, sales rep, marketing type, location, and delivery method; include active and/or inactive customers.
- Use when you need full customer and contact details.
|
Customer List |
- Simpler customer listing with postal or delivery addresses.
- Same filtering as the detailed list, focused on address information.
- Use for mail-outs, deliveries, or address verification.
|
Customer Contract Rates |
- Lists contract rates set up for customers, showing agreed pricing by product.
- Filter by customer type, group, account range, and sales rep; include active or inactive customers.
- Use to review or audit customer-specific pricing agreements.
|
Discount Matrix |
- Lists discount matrix entries that define customer/product group discount rules.
- Filter by customer group and product group; optionally include individual customers, products, and future/expired entries.
- Use to review your discount structure.
|
Dispatch Sheets |
- Lists customer invoices due for dispatch for a date range.
- Filter by invoice status (posted/unposted), location, customer attributes, and sales rep; optionally include line details.
- Defaults to unposted invoices.
- Use to prepare and manage outbound deliveries.
|
Invoice Margin Exception |
- Identifies invoice lines where margin falls below a threshold you set (by percentage or dollar amount).
- Filter by date, customer, product, sales rep, and invoice status.
- Use to find under-margin invoicing that may need review.
|
Quote Margin Exception |
- Identifies quote lines where margin falls below a threshold you set (by percentage or dollar amount).
- Filter by date, customer, product, and sales rep.
- Use to catch low-margin quotes before they are accepted or converted to invoices.
|
