This article explains how to reconcile the bank accounts against the Lightspeed Invoices brought into Xero:
All accounts should be reconciled each week so we are only ever one week behind.
What you will need access to:
- Log into Xero first
- Any cash/tyro/amex credits that have shown up green in the bank accounts you can click ok on and auto reconcile
- Choose which type of payment you are going to reconcile next – it doesn’t really matter the order, but it is easier to do all the same type of payments together.
Before starting reconciliation, login to the following:
- Login to Xero
- Click on the bank feed you which to reconcile – Tyro and Bank Accounts
- Open a second screen, Click on Business Tab – Invoices – Paid
- Click Search and select your same week in the start and end dates and click search
- Right click on the word BUNDABERG/MARYBOROUGH and open the first invoice you wish to reconcile
- Login to Lightspeed
- Click reports
- Click reconciliation
- Click ‘Past 7 Days’ on right of screen
- Choose the following:
- The Site you are working on and the day you want
- Then click Payment Breakdown to see where the payments have come from eg Tyro/Cash/App
- Login to TYRO Portal
- Choose the merchant (store) you are working on
- Click on Location report (to the right on the screen)
- NB: As Maryborough & Hospital only have one EFTPOS Machine, choose Daily EFTPOS Machine Report
- Choose your date
- Click Generate Report
- You’ll see a NET TOTAL (at the end) and AMERICAN EXPRESS TOTAL (7th column) If there is an AMEX amount deduct this from the NET TOTAL and cross check that this matches the TYRO credit to the Bank Account.
Video: What to do when Tyro is up to what Lightspeed says (loom.com)
Gift Card Top Up – Tyro settlement and Lightspeed out (loom.com)
$60.14 amex payment in Maryborough (loom.com)
As at December 2023, AMEX are now included in the Tyro amounts and will not need to be separated/ remove & redo.
Changes to Tyro/Amex Payments for Berts (loom.com)
Reconciling LOKE Payments – Click Here
Reconciling Stripe Paymnts – Click Here
FatZebra – Intrepid Pipeline Reconciliation – click here
Reconciling Payments “ALOWISHUS DE MERCHANT SETTLEMENT” (FAT ZEBRA GATEWAY)
- Pay It Forward (from Alowishus website) and Kounta/Lightspeed Account Payments
- Log into https://loke.pmnts.io/
- Download detailed Transaction Report for required dates
- Reports – Transaction – Choose dates – Download detailed report
- On the report the references for each payment are as follows:
- Pay it Forward: eg 19918
- Kounta/Lightspeed Account being paid: eg 10271971