Report: Cash Summary

From Agency Systems Wiki
Revision as of 14:01, 15 September 2016 by Mlively (Talk | contribs) (added applied and department sections)
Jump to navigation Jump to search
Related Pages
Related Categories

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:


Access and Window Options

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

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

Menu-ar-cashreports-cashsummary.PNG

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.

Report-cashsummary-cashdpt-main.png

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

Report-cashsummary-cashdpt-alldpts.png

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.

Report-cashsummary-cashdpt-plonly.png

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.

Report-cashsummary-cashtrans-applied-and-unapplied.png

Report-cashsummary-unappliedonly.png

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

Report-cashsummary-summary-all.PNG

Detail Level -> Detail

Example: Cash Summary - Detail - All Items.pdf

Report-cashsummary-detail-all.PNG