REQUIRES ACCESS TO 

CAR SUPPORT BANKING FOLDER and BANKING MASTERFILE - ask for log in credentials from your manager

SET UP - ONE SCREEN FOR SCANNED BANKING FOLDER and ONE SCREEN FOR BANKING MASTERFILE

This task is being done EOD once the scanned files are uploaded in the banking folder

USE F5 in PINNACLE to search for WO/INV number

1. Change the date of the tab to banking date - USE SCANNED BANKING DATE

2. Delete previous day’s entries from table

3. Copy details from scanned file to banking masterfile for each cheque / runsheet

GET:

1. Customer name / drawer

2. Bank 

3. Bank branch

4. Amount 

5. Cheque number

6. Invoice number

NOTES: 

• The amount in cheque should match the amount in runsheet - if not send an email to shipping@

• The name should also show name JJ AUTO PARTS because the cheque might bounce - if you see this happens, make a note in COMMENTS so we can easily go back to it when the cheque dishonours

• When there is no runsheet together with cheque - send an email to shipping and make a note in COMMENTS

BANK ABBREVIATIONS

NAB - National Australia Bank

CBA - Commonwealth Bank of Australia

WBC - Westpac Banking Corp

STGB - St George Bank

ANZ - Australia & New Zealand Bank

BENDIGO - Bendigo

BOQ - Bank of Queensland

CFCUL - Community First Credit Union

BOS - Bank of Sydney

DELPHI - Delphi Bank

BW - Bank West 

4. Once all cheque details are entered in the masterfile, we are going to make sure details are all correct so allocation would be easier

There are cases that the drawer does not match the customer name.  In cases like this, we are going to follow the customer name in Pinnacle so it is easier to search.  Use the invoice number to search in Pinnacle.

Name in ACCOUNT DETAILS is PINNACLE name

5.  Once all sorted, SORT RANGE in alphabetical order.  Click the red box to highlight sheet

Go to DATA - SORT RANGE

Tick DATA HAS HEADER ROW - SORT BY DRAWER - A-Z - SORT

6. Make sure totals are correct by checking the formula within range of entries

7. Check if the totals match the BANKING LIST totals

Banking lists are being sent daily and will be sent through as a ticket and assigned to the person doing this task

Download the attachment and compare totals

If totals are matching, proceed to next task