BLACK CREDIT CARDS VISA / AMEX RECONCILIATION-UPDATED SEPTEMBER 2015 TO UPDATE MATT NOV 2015

BLACK CREDIT CARDS VISA / AMEX RECONCILIATION-UPDATED SEPTEMBER 2015 TO UPDATE MATT NOV 2015

WEEKLY RECONCILING BLACK CARD AND AMEX


Reconcile for previous week MONDAY TO SUNDAY inclusive 
Reconcile to bank statement not just XERO feed 


VIDEO INSTRUCTION FOR VISA RECONCILIATION


Login to Xero (JJ Auto Parts file) --> Dashboard --> BLACK ACC VISA - AUTO DEBIT or AMEX 61008 - AUTO DEBIT --> click Reconcile XX items




COMPARE BALANCES BETWEEN BANK STATEMENT AND XERO
  • Open up the statement from the bank and compare the balances with Xero

  • Statement balance in Xero must be the equal to the closing balance on the statement for the same period

  • To further check that everything is correct, click on Reconciliation Report and pull out Bank Statement report, date range should be same with the statement from the bank

  • Opening and closing balances in Xero and the statement from the bank for the same period MUST BE EQUAL

  • If balances are equal, proceed to the reconciliation process
      Note: If the balances are not equal, go back to previous periods and compare the opening and closing amounts, and find your way to any missing or duplicated transaction/s



RECONCILIATION PROCESS




  • Go back to Reconcile tab in Xero and go through the transactions

  • If there are matching transactions (colored green), make sure that the match is 100% correct before hitting OK

  • For transactions without any suggested match, click Find & Match and search for a possible match for the entry

  • If there are no matching transactions at all, go to Card Verification table and find the client's or customer's name in the spreadsheet and create a new invoice entry for it.
    Follow the spreadsheet - if it says the transaction needs invoice or approval, request for it before creating an entry

  • For entries that you are not sure of, list them down with proper notes in the Black Card Queries or AMEX Queries 1009 tab in the spreadsheet and send to matthew@jjautoparts.com.au by creating a Zendesk ticket
       

   TIP -SET DATE RANGE IN XERO TO BE SAME AS BANK STATEMENT RANGE 






TO CREATE A BILL 



MATCH TO SUPPLIER NAME FROM CARDS SUPPLIERS 


    • Related Articles

    • JJ ACCOUNTS APPLICATION FOR CREDIT ACCOUNT - UPDATED MAY 2023

      this guide to be updated matt 090523 Occasionally new customers will request an account application we need to balance between offering this service and extending our credit and cash flow Ideally we would not offer any accounts as is takes time to ...

    • AMEX 61008 RECONCILIATION

      VIDEO INSTRUCTION FOR AMEX RECONCILIATION AMEX Reconciliation schedule: THURSDAYS EVERY WEEK Matthew will be sending the latest AMEX statement with the closing balance to Zendesk on Wednesdays. If in case he missed to send it, send him an email and ...

    • ACCOUNTS COLLECTION - COD ACCOUNTS -Guide Updated FEBRUARY 2022 -DRAFT

      LINK TO GUIDE DOC

    • BUSINESS VISA CARD .. 5480 RECONCILIATION

      Business Visa Reconciliation. The first import step is to make sure and confirm the bank feeds are going through correctly - -------------------------------------------------------------------------------------------------------------------- NOTES * ...

    • ACCOUNTS COLLECTION - ACC JUNE 2021 XXXXXXXXXX

      https://docs.google.com/document/d/17xGk7dFsI3HDTIkMufOTRD-EOILBCcZnYBsQpEeoqoc/edit?tab=t.0#heading=h.ge2kcnmnovt8 To do Tuesdays and Thursdays ONLY After sending the email, schedule the ticket for the next day so calls can be made. ...