The Banking Deposit report produces bank deposit and reconciliation lists for cash, check (cheque), credit card, debit card (EFTPOS), direct debits, cash drawer (till) listings, or a list of all of these.
Accessing The Banking Deposit Report
Types of Banking Deposits
There are several choices for the Banking Deposit report, by payment type:
This provides a listing of all cash transactions.
Check (Cheque) Listing
This provides a listing of all check (cheque) transactions, including bank and branch information, as well as the check number.
Credit Card Listing
This provides a listing of all credit card transactions, including the credit card company name, credit card number, and authorization number.
Debit Card (Eftpos) Listing
This provides a listing of all debit card (EFTPOS) transactions.
Direct Debit Listing
This provides a listing of all direct debit transactions.
Cash Drawer (Till) Listing
This provides a cash reconciliation, like the Balance the Till report.
All Of The Above
This provides a listing for all payment types by running each one sequentially. Using this option may help prevent missing one or more payment options when running Banking Deposit reports as well as reduce the time needed to set up the same reconciliation dates multiple times.
About the Banking Deposit Report
Banking Deposit reports are essential for accurate bookkeeping. The reports keep track of every payment made for a given payment method and for a given time period.
Notice the report period shows:
By default, this report runs from the time the previous report ended to the current time. This means you can usually run the report at the end of the day or at the end of a shift without changing the default settings.
What The Report Does
This report produces bank deposit and reconciliation lists for cash, check (cheque), credit card, debit card (EFTPOS), direct debits, cash drawer (till) listings, or a list of all of these.
When To Run The Report
This report should be run daily, on completion of invoicing and receipting for the day, or at the end of a shift. The “Balance the Till” report should be run first.
Things To Watch For
The report searches records based on the system date and time staff entered the transaction onto the computer. In many cases, this will not be the actual date and time of the transaction. This is to make sure the report includes backdated transactions as a daily movement on the cash listing. The report details everything added on to the computer between the two system times entered. See >a href=”/index.php/onlinemanual/om-reports-section/186-a1-reconciliation-a-banking-audit.html?start=3″ title=””>How Transactions are Selected>/a> for more details.
The Report Window
Last Time Till Was Balanced Dates
This is the date and time the ‘balance the Till’ report was run. Do not change this date or time.
Dates To Reconcile The Till Balance To
The date and time you wish to reconcile the till balance to. Date and time cannot be earlier than the ‘last time till was balanced’ dates. The current date and time will display by default.
I Want To Reconcile To (All Of The Above Payment Type Only)
Click one of the two radio buttons. The ‘Last Till Balance’ option will automatically set the reconcile date to the last date the cash drawer (till) was balanced; the ‘Specified Date and Time’ option will allow you to set dates as usual.
Only Show Transactions Dated
If you want to restrict the report to transactions within a date range check the ‘Only show transactions dated’ checkbox and enter in the date range you want.
What you are then asking for is to report all transactions entered on to the system between the first set of dates, but only if the transaction date falls within the second set of dates.
Restrict To Clinic
This will restrict your till balance to the selected clinic. (Branch clinics only).
This opens the report in a preview window, from which you can review it, then save and/or print it.
This prints the report on the Crystal Reports default Page Style unless otherwise specified.
This opens the report in Microsoft Excel as a spreadsheet.
This allows you to export to the following file types (some of the file types are available via the other viewing options):
This opens the report in a PDF viewing software like Adobe Acrobat or Foxit Reader.
This opens a dialog in which you can change the page style of the report.
This returns you to the Reports page without creating a report.
How RxWorks Selects Transactions for the ‘Banking Deposit’ Report
Because you want to investigate the money going into an out of the till on a certain day, the program selects transactions for the report by the CREATED date, not the TRANSACTION date. It is important to understand the difference.
The Creation And Transaction Dates
- The date on a clients payment receipt is the TRANSACTION date.
- The date and time when the receipt is processed (by clicking OK when taking a payment) is recorded as the CREATED date.
Finding The Created Date
To find out the created date of a transaction:
- Right click on the transaction in the Client’s financial record and choose Last Modified.
- View the date listed next to the CREATED ON field in the popup window that appears.
Unless the transaction was altered, the ‘Created On’ and ‘Last Modified On’ will always display the same date.
How to Run a Banking Deposit Report.
Update Till Start Date
When you run the ‘Balance the Till’ report, a new window will appear asking if you would like to update the start date for next time you run the report.
Click OK for RxWorks to keep the ‘Actual’ amounts entered for the report and set the next start date.
Click CANCEL to exit from the report and run again.