REQUIRES ACCESS TO: CYBERSOURCE WEBSITE , CAR SUPPORT BANKING FOLDER and XERO
DOWNLOAD REPORT - should be for yesterday's date
DELETE UNNECESSARY COLUMNS/ROWS - ROW 1, COLUMNS B-F THEN FREEZE ROW 1
DOUBLE CLICK ON BORDERS TO SHOW ROWS AND ALIGN ALL TO LEFT
FORMAT COLUMN C TO $ AND GET TOTALS, THEN HIGHLIGHT CELL GREEN AND SAVE - SHOULD LOOK LIKE THIS
MAKE SURE TOTAL MATCHES XERO EFTPOS AMOUNT
ADD IN BANKING FOLDER - RENAME TO FORMAT WEBPAYMENTS DD/MM/YR E.G 20/12/19
https://drive.google.com/drive/folders/0B5WqzeKqowzMWm5aZVg2UTBxWEU
Go to anz website and look at transactions list from sub folder