BANKING CREDIT CARDS ENTERING IN MASTERFILE

(Transcribe credit cards payment in an excel file)

Ø  Open Banking Master file at Google docs.

https://docs.google.com/spreadsheets/d/179gUEj0wUzflHUKJ99zhmp8v4LmFDxMw5SdMGcQxzRY/edit#gid=1861808175

Ø  Open pdf file for the credit cards located at JJAUTO-ACCOUNTS TEAM/AA NEW ACCOUNTS / BANKING

Ø  Type the date on the spreadsheet (yesterday’s date)

Ø  Record the card number (4 digits number) from the docket

Ø  Record Customer Name.

Ø  Record amounts. If there are 2 dockets in 1 page, insert another row for this. Be careful with the amounts, some amounts are with negative sign which are refund.

Ø  Get the Invoice numbers in Pinnacle using the work order# given:

-          Go to Pinnacle

-          Press F5 on the keyboard

-          Type the Work Order# to Order Number box

-          Get the invoice number

Ø  If invoice number is available, no need to get the work order number

Ø   If there is no invoice number available in Pinnacle, type UNCONFIRMED and date under invoice number column.

Ø  If there is no work order and invoice number given to the pdf file, type S11 Nil Balances under work order column.

Ø  Type Multiple if the invoice numbers are many

Ø  In Invoice number column put the multiple invoice numbers or the month account like July account

Ø If there is no work order and invoice number given to the pdf file and you have noticed that it is for Ebaysales, type S11 Nil Balances under work order column.

Ø Compare the total of the credit cards to the Banking list sent from car support. If the amount doesn’t match, double check the amounts of the dockets and and if still doesn't match send an email to shipping@jjautoparts.com.au asking why this amount doesn't match and ask them to recheck it before allocating the payments into pinnacle. 

Ø  Save file