Report: Cash Summary

Related Pages

Client Payment Deposit Training 6: Accounting Training 7: Management

Related Categories

Agency Bill Cash Direct Bill Receivables Reports

The Cash Summary Report is a list of all distributions for Cash Transactions within the date range specified. The report is grouped by GL account with sub-totals for each account.

Any incoming money to the agency is referred to as Cash; physical checks, wire transfers (EFT), money orders, or physical cash.

Types Of Cash Receipts:

• Regular Cash: Agency Bill client and company payments, or money from any other general ledger account.
• Transmittal Cash: Direct Bill client payments which are forwarded in full to an insurance company.

Frequently Asked Questions (FAQ)

• How do I run a report for total commission received by company?

Access and Window Options

The Cash Summary Report can be opened by selecting Reports -> Cash Reports -> Cash Summary.

Access to the Cash Summary Report is controlled through the security system A/R -> Cash Deposit Report -> View setting.

• Start Date and End Date: All items with a general ledger date within the selected range are included.
• Run by...: Changes the report to run by either Entry dates or Effective dates. Both dates are included on the report.
• Bank: Enter a Bank Code to limit the report to a single bank. By default, cash transactions entered to all banks are included.
• Operator: Enter an Operator Code to limit the report to one entry operator. By default, cash transactions entered by all operators are included.
• Department: See the Department section below.
• GL and Sub GL: Limit the report to a specific General Ledger account. By default, all GLs are included.
• Reconcile Status: Limit the report to only reconciled or unreconciled cash. See Bank Reconcile and Bank Deposit for additional information.
• Applied Status: See the Applied Status section below.
• Detail Level: See the Report Examples section below.

Department

Enter a Department Code to limit the report to only items with distributions to a single code. By default, cash transactions entered with all departments are included.

Cash transactions to invoice GLs have a primary Department record entered when the receipt is made, and distribution department records based on the invoices paid.

The Cash Summary Report finds items based on the distribution department, not the primary department for invoice GLs.

If a department filter is set, only the distributions to invoices with that department are included for invoice GLs. When that occurs, the total for the cash transaction is not displayed, since distributions to other departments are not included. This feature allows a single payment to pay both commercial lines and personal invoices, without losing the ability to produce a report for only a single department code.

The department filter works for both the summary and detailed reports.

Applied Status

Optionally limit the report to only distributions which are applied to an invoice, or unapplied (on account). Only items to invoice GLs can be applied.

In the event a cash transaction is partially applied to an invoice, only the distribution applied or unapplied will be included based on the selected filter.

The applied status works for both the summary and detailed reports.

Report Examples

The primary difference between reports is determined by the Detail Level. A summary will produce a short report, with only totals for each matching item. A detailed report will list invoice details applied to each cash receipt.

For additional reporting options, see Report: Cash Deposit Report.

Detail Level -> Summary

Example: Cash Summary - Summary - All Items.pdf

Detail Level -> Detail

Example: Cash Summary - Detail - All Items.pdf