IN THIS ARTICLE:
Learn about the Bank Deposit Report (REPORTS>FINANCIAL>FIN-2) and how collected payments are reflected based on the specified date(s) and filter options.
You can view more information about the Bank Deposit Report below:
- What is the Bank Deposit Report?
- Showing How Payments are Applied
- Deleted Payments
- Accounting for Deleted Payments
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 date recorded, 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 primary guardian name.
While deleted payments are included, they are separated out at the bottom of the report to give you an accurate total for operational bank deposits. The bottom of the report allows you to account for deleted payments and to see how those deletions may effect program and charge category totals. More about accounting for deleted payments.
Showing How Payments are Applied
To easily reference how/where a payment from a family has been applied, you would use the filter "Show Programs" when running the Bank Deposit report. This provides you not only with the payment details, but a list of Programs and Charge Categories it has been applied to.
Take into consideration the following entries, recorded for each of the families in the following reports, to help you understand how these payments are being tracked on the Bank Deposit report over time.
DESCRIPTION OF EVENTS
|Scenario 1:||On 04/16/2019, a payment is recorded and applied to a charge immediately from the New Payment window.|
|Scenario 2:||On 04/16/2019, a payment is recorded and left un-applied, then applied to a charge later in the same day.|
On 04/16/2019, payment is recorded and accidentally applied to the wrong charge.
Then it is immediately un-applied and re-applied it to the correct charge on the family ledger.
|Scenario 4:||A payment is recorded on 04/16/2019, then not applied to a charge until one week later (04/23/2019).|
A payment is recorded and applied on 04/16/2019 to an incorrect charge.
Then it is un-applied and re-applied to a new charge one week later (04/23/2019).
Bank Deposit - End of day 04/16/2019
One payment has been received by each of the families in this report. $1 from the Scenario 1 family, $2 from the Scenario 2 family, etc.
Note: When "Show Programs" is selected, in the event that a payment has only been partially applied, it will be reported twice- once for the applied amount and once for the un-applied amount. The same type of entry system occurs if the payment is applied to multiple charges, each with its own Program and Charge Category.
Bank Deposit - End of day 04/23/2019
Because no new payments were recorded on 04/23/2019 in this example, the Bank Deposit report for just that date would be blank. The changes described in Scenario 4 and Scenario 5 would be reflected in the Program Deposit Split report for the 23rd under the Adjustments Made to Payments Received Prior to 04/23/2019 section.
Bank Deposit – Date range of 04/16/2019 through 04/23/2019
When run for the date range, the Bank Deposit report with the "Show Programs" filter ran from the time the payment was taken to the 23rd when the final adjustments were made will match the information found for the same date range on the Program Deposit Split report. If an amount is applied, then un-applied within the same date range, the report will only show the program/charge category the payment was applied to as of the end date of the report.
If you were to run this report without the "Show Programs" filter, it would give you a strict count of transactions that took place, wherein the $5 payment received from the family in Scenario 5 and the $3 payment received from the family in Scenario 3 would each only be recorded once upon receipt.
It is important for accountants or book keepers to be notified of deleted payments in iClassPro in the case that they have already entered the payment as income in a separate accounting software.
Because different businesses reconcile at different frequencies with their accounting software, iClassPro's day by day approach of showing payment activity must extend to deleted payments in real time. In other words, a payment recorded on Monday and deleted on Wednesday must show up as 1) a positive entry, or income, on Monday's reports and 2) a negative entry on Wednesday's reports.
Note: To make reconciling these events easier, we have added information about the original date of the entered payment on the date the amount is deleted. We have also enabled a similar note in the system to be added to the payment on the payment date, referring back to the date of the deletion.
Bank Deposit April 24, 2019 (Before Deletion)
On the original Bank Deposit report, the $39.99 cash payment is simply recorded as income on 04/24/2019.
Bank Deposit – April 24, 2019 (After Deletion)
The next day (04/25/2019), a staff member realizes that this payment was entered incorrectly and he/she deletes it. When run again, the report for the day before will move the payment to the deleted section to indicate that the payment is deleted in the future (the date of the deletion is marked as a note in the Transaction/Check# field for quick reference). However, it will remain a positive balance on the report because the deletion of the income did not occur until the following day.
Bank Deposit – April 25, 2019 (After Deletion)
If you run a Bank Deposit report for 04/25/2019, a negative entry for the same amount is included in the deleted payments section, as seen below. That is because the income was not deleted until 04/25/2019 and it is possible that the accountant/bookkeeper has already recorded it as income from the previous day. This negative entry would allow the accountant/bookkeeper to make the necessary adjustment if that had occurred.
Note: The negative deleted entry also includes a note in the Transaction/Check # field which references the original payment date.
Bank Deposit - Date range of 04/24/2019 to 04/25/2019 (After Deletion)
This Bank Deposit report, run over the full date range of the payment entry and the date of the deletion, demonstrates how the positive and negative entries for the deleted payment even out over time, reporting the correct income totals for the date range.
Accounting for Deleted Payments
Comparing Deleted Bank Deposit Totals to the Program Deposit Split Report
Under normal circumstances where no payments are deleted or payment entry mistakes are made and deleted on the same date, the Bank Deposit report's "Payments" totals will match the Program Deposit Split report's "Payments Recieved on" totals perfectly. That is because the Bank Deposit report is showing a list of transactions that took place on a specific date(s) and the Program Deposit Split report is simply displaying where the money was applied within your company's financial structure at that time.
However, when a payment is deleted one or more days after it has been reported as income, it can cause totals in the Bank Deposit report's "Payments" section to be different from the Program Deposit Split report's totals.
Below are the three possible outcomes a deleted payment can have on the totals in the Bank Deposit and Program Deposit Split reports.
- If the payment and deletion happen on the same date or within the date range of the report, they will balance each other out in the deleted payment totals. This will result in a zero dollar balance that will not effect the totals in the Program Deposit Split report for the matching date range. (This is the case in the last example shown above.)
- If there is a positive deleted payment amount in the deleted payments portion of the Bank Deposit report without a matching negative transaction, that means that the payment was not deleted until a date after the date range of the report. This payment will be included as a positive amount in the Bank Deposit's deleted payment totals and in the "Payments Received" table on the Program Deposit Split report.
- If there is a negative deleted payment amount in the deleted payments portion of the Bank Deposit report without a matching positive transaction, that means a payment was deleted over this date range which was reported as income before the date range of the report. This results in a negative amount in the deleted payment totals on the Bank Deposit report and will be displayed in the "Adjustments" table on the Program Deposit Split report.