IN THIS ARTICLE:
Learn about the Bank Deposit Report (FIN-2), its filter options, and how to generate it.
What is the Bank Deposit Report?
The Bank Deposit Report is used to track the state of income coming into and exiting the business in the form of new payments, credits, refunds and deleted transactions. The report includes details about all payments recorded within the specified date range, including the Payment “Active Date”, payment method used, credit card type (with last four digits of the card), transaction/check number data (if manually recorded in that field), amount, and family name (as the primary guardian). The payment status will also be noted in this section.
Approved payments will only show only once with the original created date. If the payment was requested and approved on different days, the approval date will be noted along with the status.
Failed, Voided, Refunded or Deleted Payments
If the payment is both taken and voided/refunded on the same date or within the date range of the report, there will be an entry for each in the payments section -- a positive entry for the payment itself and a negative entry for the void/refund. These payments will balance each other out so they do not affect the report total.
If the payment is voided/refunded on a different date than when it was originally taken or the date range of the report does not encompass both dates, there will be a positive payment entry on the date it was taken and a negative payment entry on the date it was voided/refunded.
While deleted and failed payments are included on the report, they are listed at the bottom of the report in their own "Deleted/Failed Payments" section with appropriate notes/status. This ensures that you have an accurate total for operational bank deposits. The bottom of the report allows you to account for deleted/failed payments and to see how those may affect program and charge category totals.
NOTE: Chosen filters that relate to enrollments will produce results that are true based on the “As of Date” you select when generating the report.
If you commonly use the same filters when running this report, you can now save them as Presets! Simply load a Preset Filter whenever you open the report page, set your date range and click to generate the report in your preferred format. See our "Preset Filters for Reports" document for more information.
Available Formats
The Bank Deposit Report is available in either HTML, PDF, XLS or CSV format.
General Filters
-
USE CREATED DATE INSTEAD OF DEFAULT ACTIVE DATE: if enabled, the system will look at the date/time the payment was actually created, rather than the “Active Date” assigned to the payment.
- If this option is enabled, the system will display separate CREATED START DATE & TIME/CREATED END DATE & TIME fields.
- LOCATIONS: the system will only include charges/payments associated with the selected Location(s) in the results.
Ledger Filters
- CHOOSE PROGRAM: selecting one or more specific programs will limit the results only to payments applied to charges assigned to the selected program(s) within the specified date range of the report. (Leaving this filter blank will include all programs.)
- CHOOSE STAFF: selecting one or more staff members will limit the results only to payments created by the selected staff member(s) within the specified date range of the report. (Leaving this filter blank will include all staff members.)
-
NOTE: Entries will not be included on the final report for any selected staff member who was not associated with payments/credits created during the designated date/date range.
- If a staff member was deleted AFTER the start date of the report, the results will include relevant entries for the staff member on the date(s) before they were deleted.
- If a selected staff member was created AFTER the end date of the report, that staff member will not be included in the results.
-
NOTE: Entries will not be included on the final report for any selected staff member who was not associated with payments/credits created during the designated date/date range.
- PAYMENT METHOD: selecting one or more payment methods will limit results only to payments created assigned to that payment method within the specified date range of the report.
See our “What are Payment Types and Credit Types" document for more information about these payment methods.- Cash
- Check
- E-Check
- Credit Card
- Credit Card Present
- Credit Card - Swipe/Insert/Tap
- External Credit Card
- Custom Payment Type (if defined)
- CREDIT METHOD: selecting one or more credit methods will limit results only to payments created assigned to that credit method within the specified date range of the report.
See our “What are Payment Types and Credit Types document for more information about these credit methods.- Coupon
- House
- Other
- Gift Card
Display Options
- SORT: defines how the results will be sorted. The “Sort by Transaction Method” is selected by default to group entries of the same transaction method separately. Deselecting this option will sort all entries by “Active Date” regardless of the transaction method.
- SHOW: selecting one or more options will display additional columns on the report with the chosen information.
- Programs and Charge Categories - displays the Program and Charge Category to which a payment/credit was applied at the time it was recorded. (NOTE: if a payment was applied to multiple charges, there will be an entry for each charge with the appropriate amount applied. When totaled, these should match the full payment amount.)
- Locations - displays the Location at which the payment/credit was recorded.
- E-Mail - displays the primary email address of the family associated with the payment/credit.
- Created By - displays the name of the staff member that created the payment/credit.
- Payment Guardian - displays the name of the guardian associated with the payment.
- PRINT LAYOUT
- Landscape - will generate the report in Landscape mode (rather than Portrait).