GET:

1. Card number - last 4 digits in docket below card type
   

2. Customer name - use data from ACCOUNT DETAILS box
   

3. AMOUNT IN DOCKET
   

4. Invoice number or workorder number 
   

vvv

4. Once all details are entered in the masterfile, SORT RANGE in alphabetical order.  Click the red box to highlight sheet

Go to DATA - SORT RANGE

Tick DATA HAS HEADER ROW - SORT BY CUSTOMER NAME - A-Z - SORT

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

6. 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