Accounting Summaries

This article was developed to describe the Accounting Summaries page, found via the Accounting module/tab. The article is broken down into the following sections:

• Overview
• Using the Summaries Report
• Configuring Filters
• Report Columns
• Transaction Types to Show On Summary

Overview

The Summaries page is used when looking for a quick one-time report of numbers and metrics for your company and also to keep better track of transactions over time. If you plan on using this report regularly, we suggest creating such a report via the Accounting tab.

Begin by logging in to the CRM, click on the Accounting tab, and then "Summaries" in the Navigation Bar (see the image above).

The following page will then appear.

You can export the table in its current view by clicking "Export to CSV". The CSV formatted table will then be available in your "Downloads" folder.

Using the Summaries Report

1. INCLUDE TRANS TYPES: Un-checking any of these payment type checkboxes will exclude that transaction type from displaying on this report.
2. If one of the checked transaction types has payments that have been processed using that transaction type, then each individual transaction type will display its totals separately per day on this report.

Configuring Filters

Filters (displayed on the top of the edit page) set conditions for a transaction to appear on the summary page you are building. It is best practice to start with as few filters as possible and then add more as needed. This will prevent you from adding too many filters and causing the report to display a blank table. See the summary of the filters shown just below the image:

1. File Type: You can filter by different file types that contacts are assigned to. Using this is not necessary if you operate using a single file type.
2. Date Field: This will filter out transaction information based on specific payment processing dates.
   • Process Date will filter out transactions based on the transaction process dates that you have specified in the start date and end date filter boxes. Cleared Date will filter out transactions based on the transactions cleared date that you have specified in the start date and end date filter boxes. Enrolled Date will filter out transactions based on the contact's enrolled date that is set in the start date and end date filter boxes. Submitted Date will filter out transactions based on the contact's submitted date which is specified in the start date and end date filter boxes.
3. Report Type: Selecting a Report Type will configure how the report displays its transaction information per report type. This information will be displayed in the second column of each report. These include Transaction Type, Company, Assigned To, Data Source, Subtype, Paid To State, or Client Status.
4. First Group: Designates the field by which the system will be grouping the data. Accounting Summaries can only be grouped by Timeframe or by Report Type.
5. Time Period: This will determine how this report breaks up the payment information per day, week, month, or quarter.
6. Range Selector: This will allow you to pick preset date configurations, including: "Today", "Yesterday", "Week to Date", "Last Week,", "Month to Date", "Last Month", "Year to Date", or "Last Year". If you require a specific date range, use the "Start Date" and "End Date" filters listed below.
7. Start / End Dates: Leaving the Range Selector dropdown option as "select" and clicking on the Start Date and End Date filter boxes will allow you to input custom date ranges of your choosing.

Click the Filter button to the right of the "End Date" field once you have made your selections.

Report Columns

• Column 1: This will display the information that is specified in the Date Field drop-down filter box.
• Column 2: This will display the information that is specified in the Report Type drop-down.
• All: This will display ALL transactions scheduled for the specified date range.
• Open: This will display any transaction currently in the open status.
• Error Processing: This will display ALL transactions related to Error Processing for the specified date range.
• Cancel: This will display ALL transactions that have been canceled.
• Pending: This will display ALL transactions that are pending.
• Cleared: This will display ALL transactions that have been cleared.
• On Hold: This will display ALL transactions that are on hold. 
• Total: The total amounts for each column will be displayed at the bottom of each day, week, month or quarter.
  
  

Transaction Types to Show On Summary

Located on the left side of the summary edit screen you will find the "Include Trans Types" options.

These are the transaction types that will appear within each date range selected when viewing the Accounting Summary.

To add a field, check the box designating the field. In the example pictured to the left, we are displaying the Balance Transfer, Client Check Payment, Client Refunds, Credit Card Payments, Debit Card Payments, and Settlement Payments. 

Article Version History: