Introduction
This report shows a breakdown of all payments (not just cash) within a specified date range.
Each section shows a payment type and profiles that paid an invoice with that payment type.
Each profile's record includes the profile name. main contact name, invoice number, invoice date, payment date, payment amount, and resulting balance.
Running the Report
- Click on the Reports menu and Run a Report.
- Click to expand the Revenue Reports and Payment Reports.
- Click on Cash Receipts.
This will open a window where you define parameters for the report.
After you click OK to run the report, you can refresh the report page at any time to go back to the parameters window, and make changes.
At the top of the report, be sure to look at the paging controls (see screenshot below). If the button on the right (next page) is available then there is more data.
Parameters
After you define these parameters, scroll to the bottom, and click OK to go into the report.
Select Beginning Date and Select Ending Date: This is required and determines what period of time should be reflected in the report. Payments will appear if the payment date falls within this date range.
Accounting Package Name Contains: This allows you to include data for a specific accounting package based on the Revenue Item(s) used. In your Global Settings (Admin menu), under the Accounting Packages tab, you will see the Accounting Package Name. If you want to focus on data for that package, enter that name in the parameters window.
Otherwise leave this as All to show all data.
Enter ShowChart: If this is set to Yes then a pie chart will appear at the top of the report, showing a percentage of payment types in the specified period. If this is set to No then the pie chart will be hidden.
Breakdown of Report
The report is broken up into sections.
Each section of the report represents a different payment type.
Within a section, the data is sorted by profile name, and includes the:
- Profile name (Report Name)
- Main Contact name
- Invoice Number
- Invoice Date
- Payment Date
- Payment Amount
- Balance
At the bottom, you will find a:
- Subtotal of all payment amounts
- Subtotal of all balances
Exporting
In the top left corner is a button to print which allows you to export this report to PDF.
Once exported to PDF, you can view and print the PDF.
Also in the top left corner is a button to export to other formats.
The other available formats include:
- Crystal Reports (RPT)
- Microsoft Excel
- Microsoft Word
- Rich Text Format
- Character Separated Values (CSV)
- XML
PDF and Microsoft Excel (97-2003) are common formats.