Genie has made your daily banking tasks easier by providing an automated daily banking report. This area will allow you to view transactions by bank account, view past batches, and seal banking, among other functions.
In Genie v9.3.7 and above, the Cheque No column in the Daily Banking Report is now called Payment Ref to align with our new Advanced Extras product - Patient Payments, powered by Ezidebit. Please see our updating article to have access this new feature.
Before you begin
To open the Banking Report go to File > Maintenance and Reports > Daily. Select the Daily Banking Report option and this will open to the current batch. By default, all unsealed banking transactions for all providers will be displayed. To view the banking for a particular account, use the bank code drop down menu.
It is important to note that Genie only retains 260 banking batches (this equates to creating one batch every weekday for one year). If you require banking totals outside that time period, please consult the Banking Summary in the Practice Analysis tab of the Maintenance and Reports window instead.
Why you should seal the banking daily
- Your banking batches will be smaller and with fewer transactions in them. This will make them easier to deal with during your regular banking tasks.
- Once a banking batch is sealed it cannot be edited. This will mean that transactions cannot be adjusted, minimising discrepancies between your Genie banking records, and statements from your bank.
- If you accept deposits from your patients, these must be sealed into a banking batch before they can be applied to an invoice. Making a habit of sealing your banking everyday means you won’t have to worry about whether the payment needs to be sealed first before you can apply deposits.
Buttons and menus in the Daily Banking Report
Used to restrict transactions displayed so that only one bank account’s transactions will show. This would commonly be used in a multi-doctor practice where different doctors have different bank codes.
The default date displayed will be the date of the earliest receipted transaction for the current banking batch. Only used when you need to see transactions starting at a specific date. Selecting a date in the calendar window will take you to the earliest batch with a transaction with your selected start date in it.
Gives the total of each payment type in a pop up window.
If you bill GST, this shows the breakdown of GST in the batch. This is only used if you bank GST separately.
If you have sealed a banking batch and then deleted payments that were included in this batch, they will not print on the Payment and GST Report. This is because the Payment and GST Report is built from payments that actually exist in Genie, not from the sealed batch records.
Note: This GST report is NOT used for taxation purposes. Instead use the ‘GST Report’ located in File > Maintenance and Reports > Practice Analysis
For more on charging GST, please refer to the Charging GST article.
Used to mark the displayed transactions as reconciled. This allows you to separate reconciled and unreconciled transactions using the radio button.
Used to seal the current batch without printing the banking report. This process is irreversible.
Used to display only transactions prior to the specified date. This would commonly be used when you come in on a Monday and find that the batch was not sealed on Friday. Entering Friday's date in the Show Until Date field will allow you to seal Friday's transactions without sealing Monday's transactions.
Once you have reconciled and you are ready to go to the bank, you can press the printer icon to print the Banking Report. The window below will appear:
This window will allow you to specify how many copies of this report you would like to print, and whether you would like to print EFTPOS separately. Once you have printed this, Genie will remind you to seal your banking, if it hasn't already been sealed:
To move forward and backward through your batches, click on the forward and backward arrows at the top of the Banking Report window.
Using the Daily Banking Report when sealing every day
- Print a report to reconcile against the till by clicking the print
icon. When prompted, select the number of required deposit slips. If preferred, tick the EFTPOS and Direct Deposits separately checkbox to print these on a separate page. A separate report is generated for each bank account.
- Using this report, reconcile Genie’s records against the till. The easiest way to do this is to use the
button as this displays the total of each payment type (Cash, Cheque, EFT)
Note: If the wrong payment type has been allocated (e.g. EFTPOS instead of cash) double-click on the relevant bank record and select the correct type from the Payment Type menu.
- When reconciliation is complete (i.e. Genie’s banking matches with your till/EFTPOS terminals) click on the
button. This seals off the current batch so that any further receipts will go into the next batch. Sealing a batch is irreversible. Once sealed, payments cannot be removed from that batch.
Using the Daily Banking Report when not sealing daily
If you don’t bank every day but still want to reconcile the till, follow the procedure detailed below.
On day one:
- Print the report and reconcile it with the till.
- Click the
button to mark the displayed records as having been reconciled.
- Bundle the monies with the bank deposit slip.
On subsequent days:
- Click the
radio button to display all payments that haven’t been reconciled.
- Print the report and reconcile with the till.
- Click the
button to mark the displayed records as having been reconciled.
- Bundle the monies with the bank deposit slip
On banking day:
- Click the
radio button to display all payments that haven’t been reconciled.
- Print the report and reconcile with the till.
- Click the
radio button to display all payments for day one, two, and three onwards.
- Click the
button.
- Take all bundles of deposits to the bank.
Note: If you forget to seal the batch, click on the button, enter the date the banking was meant to be sealed, and click
.