Tool Panel

Reports - Analyzing Sales, Aging, and Account Activity

Reports - Analyzing Sales, Aging, and Account Activity

The Ecommerce portal includes a set of built-in reports for analyzing sales performance, tracking outstanding invoices, identifying top customers, and monitoring other aspects of account activity. Reports are accessed from the Reports section of the portal navigation.

Available Reports

Daily Activity

Provides a summary of daily transaction activity. Use this report to review the volume and value of charges, payments, and other transactions for a specific day or date range. Helpful for daily reconciliation and monitoring overall activity trends.

Daily Sales Detail

Provides a detailed breakdown of individual sales transactions for each day. Unlike the Daily Activity summary, this report shows each transaction with its details, making it useful for auditing specific charges or tracing individual orders.

Purchase History

A filterable list of orders across all accounts. Use this report to search for orders by date range, payment status, account, or description. Each order row includes:

  • Selection checkbox for bulk actions
  • Invoice number (clickable to preview)
  • Due date
  • Payment status
  • Description
  • Amount

Bulk actions available on this report include sending invoices and canceling orders.

Invoice Aging

Shows outstanding (unpaid) invoices organized by age. Invoices are grouped into aging buckets:

  • Current (not yet due)
  • 30 days past due
  • 60 days past due
  • 90+ days past due

Use this report to identify overdue accounts, prioritize collection efforts, and monitor accounts receivable health. The total outstanding amount and distribution across aging buckets provides a snapshot of your receivables position.

Item Purchase Report

Shows purchase volume for individual products/items. Use this report to identify best-selling items, track item performance over time, and make inventory or catalog decisions.

Item Category Purchase Report

Aggregates purchase data by item category. Use this report to compare performance across product categories and identify trends in category-level purchasing behavior.

Top Buyers

Ranks accounts by total purchase volume. Use this report to identify your highest-value customers, monitor key account activity, and support customer relationship management.

Top Category Buyers

Ranks accounts by purchase volume within specific categories. Use this report to understand which customers are most active in each product category.

Tips Report

Shows tip amounts collected, organized by staff member and time period. Use this report for staff compensation, tracking tip trends, and managing tipped services.

Dues Deferral Report

Tracks deferred dues and their status. Use this report to monitor deferred revenue, verify deferral accounting entries, and manage accounts with deferred payment arrangements.

General Ledger Account Summary

Summarizes transaction activity by GL account. Use this report to verify that charges, payments, and other transactions are categorized correctly across your chart of accounts. Helpful for reconciling ecommerce activity with your external accounting system.

Suspended Certifications Report

Lists accounts with suspended or pending certifications. Use this report to identify accounts that may need follow-up regarding their certification status.

Manages the queue of invoices, receipts, and other documents waiting to be printed. Use this to process print jobs for accounts that receive paper communications.

Common Report Features

Most reports share these standard features:

  • Date Range Filters — specify a start and end date to narrow results to a specific period
  • Account Filter — limit results to a specific account
  • Status Filter — filter by payment or order status
  • Pagination — navigate through large result sets (typically 50 records per page)
  • Download — export the report data as a CSV file for offline analysis
  • Search — text search within the report results

Using Reports for Common Tasks

Daily Reconciliation

Run the Daily Activity report to see a summary of the day's transactions, then drill into the Daily Sales Detail for individual transaction details. Compare totals against your payment processor records.

Collections Follow-Up

Run the Invoice Aging report to identify overdue accounts. Sort by the oldest aging bucket to prioritize outreach. Click account names to navigate to account details where you can review the account's full history and contact information.

Sales Analysis

Use the Item Purchase and Item Category Purchase reports to analyze product performance. Compare with Top Buyers to understand which customers drive the most revenue.

Financial Review

Use the General Ledger Account Summary to verify that transactions are categorized correctly before running a GL export. Cross-reference with the Dues Deferral report for deferred revenue tracking.

Tips

  • Export reports to CSV for further analysis in spreadsheet software
  • Run the Invoice Aging report regularly to catch overdue accounts before they become collection issues
  • Use the Purchase History report's filters to quickly find specific orders when responding to customer inquiries
  • The Top Buyers report is valuable for identifying customers who may benefit from credit terms or volume pricing