Count out the float
Count out the float of $200. Put this back in the till and set the remaining money aside.
The ONLY money to go back into the till is the float.
Here is a suggestion of the float that you should hold:
10c - $0.50
20c - $1.00
50c - $3.50
$1 - $5.00
$2 - $10.00
$5 - $30.00
$10 - $50.00
$20 - $100.00
Having some of each coin is essential.
Unleashed & Banking Template
Open Unleashed and the banking template.
The banking template is located in the G&T folder and then Admin folder.
Open Invoice Enquiry
In Unleashed, go to the shortcut grid, located in the middle of the red banner at the top of the page, and click on Invoice Enquiry.
Select Date
Select the date, from the day before, till today
Select Your Warehouse
Select the warehouse that you are doing the banking for.
Select Status
Change the status of invoices to completed.
Sales Order Group - Cash
Select sales order group Cash
Click the green Run button in the top right.
Then click the dropdown arrow next to export and then click Export to CSV
Sales Order Group - Eftpos
Select the sales order group EFT - Eftpos
Next, click the green Run button in the top right corner to run the program.
Then click the drop-down arrow next to export and select Export to CSV.
Open Invoice Enquiry List
Open the two Invoice Enquiry Lists. These should open in an excel spreadsheet.
They may open on another screen if you are using dual screens.
Delete and Resize Columns
Delete the sales invoice column
Delete Invoice date and status columns
Delete comment and warehouse columns
This should leave you with the columns:
Sales Order Number
Customer Name
Total
Resize the remaining columns so that you are able to comfortably see the information
Check Eftpos Printout
Check the Eftpos job cards against the excel list and add any that might be missing e.g. account payments.
Add Account Payments
Add in any account payments
Then, auto-sum all the amounts from both the Eftpos payments and Account payments.
Add Cash Payments
Open the Cash Invoice Enquiry List and delete
The sales invoice column
Invoice date and status columns
Comment and warehouse columns
Copy in the cash payments from the cash invoice Enquiry List.
Resize the columns so that you are able to see the information comfortably
Add and label any of the split payments.
Copying Eftpos Payments
Copy the cash customers from the invoice enquiry list into the banking template.
Then, write split payment in the notes column for any split payments, and color the row.
Copying Account Payments
Insert enough rows so that when you copy over the account payments it doesn't copy onto any other cells.
Then, copy over the account payments and highlight the total of Eftpos and Account payments.
Copying Cash Payments
Copy the cash payments over from the Invoice Enquiry List and paste them in to the cell below Deposit Bag #
Settlement Enquiry Summary
Clear any numbers that might have been already entered.
Input the debit summary amount into the debit slot.
Do the same for Mastercard, Visa, Union pay, CRM Prepaid, Farmers, and Q Card.
Entering the Deposit Bag Number
Enter the deposit bag number into excel.
Enter the Date
At the top of the template, make sure the date is correct. If not, enter the day's date.
Email Tracey
Copy the banking and paste it into a new email to Tracey.
The subject of the email should be Banking followed by the days date.
CC in your branch manager .
Double check that it all copied over correctly.
Send!
Deposit the Cash
Take the cash down to the bank and deposit the cash.
The banking needs to be taken to the bank daily, especially on the last day of the month.
Thank you for viewing these instructions on how to complete the daily banking. You should now have a greater understanding on this topic.