BANKING - BANK TRANSFER ENTERING IN MASTERFILE 01/21
Open Xero (ask for access from your manager if you don't have one)
Go to Dashboard page at the top
See Bank Accounts listed in Cheque Account
Click blue box where it says Reconcile 10 items
This will open the Cheque Account automatically
The left column shows bank transactions
The right column is for reconciliation (different task)
Type the date on the Master file or spreadsheet the transaction date (previous working day date)
Type B/T on the c/card# column
Record Customer Name - it must be complete details of what have in the screen in Xero
When the customer name in XERO is not in PINNACLE it is necessary to attach UNKNOWN BANK TRANSFER right after the details from XERO.
*If there is a word Credit located at the top left side of the costumer name it should be included to the Bank Deposit - that is credit to our account which they are all and that is a Bank term.
If the costumer name was Unknown Bank Transfer in Master file it must have details from the screen in Xero
Enter the amount
Usually it doesn’t have any Invoice # and Work order # given to the bank statements. Check Zendesk for remittance tickets
Assigned to whoever is doing banking.
If there is no work order and invoice number given to the file and you will notice that it is for EBAYSALES, type S11 Nil Balances under work order column.
If there are unsure deposits or don’t know the specific costumer name, PLEASE FOLLOW THIS PROCESS
IF YOU DIDN'T GET RESULTS, send email to sales guys.
If no reply - check with Glenn also and the EBay team if this is an EBay sale
After 2 hours resend email to all again. If still no reply, receive under UNKNOWN BANK DEPOSITS in Pinnacle
And note under UNALLOCATED PAYMENTS tab in BANKING MASTERFILE
Once a reply is received from a particular sales person, delete all the other email address then continue on with the conversation with 1 person only. This minimises noise in inboxes of sales guys.
FOR PAYMENTS FROM MULTISITE CUSTOMERS (ACM, NRMA, GEMINI)
We must action and resolve unallocated amounts immediately – keep ticket open until sorted
In a scenario that there’s more owing than unallocated or vice versa ,
we still action immediately the sooner its “ sorted “ while all staff remember the situation the better
Remembering we wont do any refunds/adjustments until the deal is completed i.e items returned ,RMA closed
FOR UNCONFIRMED WORKORDERS
If the payment is for a workorder that hasnt been converted into an invoice, add a note in the WO
And send an email to the sales person who owns the WO
Related Articles
BANKING BANK TRANSFER PAYMENTS ALLOCATIONS
BANKING MASTERFILE BANK TRANSFER-PAYMENTS ALLOCATIONS Ø Open Bank Transfers Master file Ø Go to Pinnacle / Accounting / Payments Ø Type the Customer Name in customer name box then press enter Ø The Payment and the Credit of Customer will ...BANKING CASH ENTERING IN MASTERFILE AND PAYMENTS ALLOCATIONS
CLICK HERE FOR MASTERFILE ENTERING IN MASTERFILE (Transcribe cash in an excel file) Ø Open Banking Master file at Google docs Ø Open pdf file for the Cash located at JJAUTO-ACCOUNTS TEAM/AA NEW ACCOUNTS / BANKING Ø Type the date on the ...BANKING CHEQUES ENTERING IN MASTERFILE AND PAYMENTS ALLOCATION
ENTERING IN MASTERFILE (Transcribe cheques in an excel file) Ø Open Banking Master file at Google docs. Ø Open pdf file for the cheques located at ACCOUNTS/ AA NEW ACCOUNTS / BANKING TO DO Ø Replace the date from yesterday’s date Ø Remove ...BANK TRANSFERS - ENTERING IN MASTERFILE 2021
REQUIRES ACCESS TO XERO and BANKING MASTERFILE - ask for log in credentials from your manager SET UP - ONE SCREEN FOR XERO and ONE SCREEN FOR BANKING MASTERFILE This task is being done in the morning once data is available in the Xereo dashboard USE ...BANKING CREDIT CARDS ENTERING IN MASTERFILE
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 Ø ...