CD - Bank Deposit Report
Bank Deposit Report Overview
This program collates all unbanked money transactions from receipts entered through program Finance > Commercial Debtors > Customer Transactions > Receipts.
It provides the ability to:
Print a 'Trial' bank deposit report without updating the cash book for checks against physical banking. It also can be used for checking totals and other details prior to closing off the banking.
Generate a final deposit report suitable for taking to the bank. Running the 'Bank Deposit Report' in 'Final' mode closes off the banking and updates the General Ledger 'Cash Book' with the total of the banking.
Reprint a previously generated 'Final' bank deposit report.
To process a banking choose 'Trial Report' or 'Final Report' from the 'Action' column.
Important!
Receipts cannot be edited after the 'Final' Bank Deposit Report has been run. Therefore, it is important to run the bank deposit first in 'Trial Mode' and do all of your checks before running it again in 'Final Mode'.
The following screen will be displayed 'TRIAL or FINAL Bank Deposit Report' (based on the mode you selected).
| Fields that require further explanation | |
|---|---|
Print Plastic Cards Separately | When this box is checked the Plastic Cards list will start on a new page. |
Include EFTPOS Receipts (on separate page) | When this box is checked the EFTPOS list will be printed on a separate page. When this box is unchecked the EFTPOS list will not be printed at all. |
Report Title | This defaults to 'Bank Deposit Report – TRIAL or FINAL and can be overridden with a different title. |
Click 'GO' to generate the report.
Payment Type
Here is a summary of the different payment types and how they are handled in relation to Cash Book and General Ledger posting:
CASH (Type C): This payment type will be included in the Bank Deposit Report Total. They will be combined with Cheque and Plastic payment types and posted to the Cashbook as one amount. The date that gets posted to the cashbook is the latest date for this set of Cash, Cheque and Plastic payments.
CHEQUE (Type Q): Cheques will be listed separately on the Bank Deposit Report. They will be included in the Deposit Total on the Bank Deposit Report. They will be combined with Cash and Plastic payment types and posted to the Cashbook as one amount. The date that gets posted to the cashbook is the latest date for this set of Cash, Cheque and Plastic payments.
PLASTIC (Type P): This payment type will be included in the Bank Deposit Report Total. They will be combined with Cheque and Cash payment types and posted to the Cashbook as one amount. The date that gets posted to the cashbook is the latest date for this set of Cash, Cheque and Plastic payments.
EFTPOS (Type E): EFTPOS payments will be printed on a separate page of the Bank Deposit Report. They will not be included in the Deposit Total on the Bank Deposit Report. They will be totalled for each date and posted to the Cashbook as one amount for each date.
DIRECT DEPOSIT (Type D): This payment type will not be printed on the Bank Deposit Report and not included in the Bank Deposit Report total. Each Direct Deposit receipt will be individually posted to the Cashbook.
WEB (Type W): This payment type will not be printed on the Bank Deposit Report and not included in the Bank Deposit Report total. They will be totalled for each Settlement Batch ID and posted to the Cashbook as one amount for each batch.
Important!
It is a good idea to print out a separate listing and check Direct Deposit receipts before running the Bank Deposit Report in 'Final' mode. Running the Bank Deposit Report in 'Final' mode posts the Direct Deposit receipts to the Cashbook, after which they cannot be edited.
Use program Finance > Commercial Debtors > Customer Transactions > Receipts to produce a list of all receipts with 'Banked Status' = 'Unbanked Only' and 'Payment Type' = 'Direct Deposit'.