POS Reconciliation Report

POS Reconciliation Report

Access: Payables Administrator

Notes
The POS Reconciliation report has been updated and is now available in new reporting, under POS Reports. It's still available in classic reporting for now — skip to Classic reporting steps.

Use the POS Reconciliation report to see a breakdown of point of sale payments grouped by payment type — for example, all bank transfers, then all EFTPOS, then all cash — for daily banking and settlement tracking. It's useful for reconciling your EFTPOS receipts and cash deposits against what's come through Kindo.

Running the POS Reconciliation report

  1. Select Reporting from the admin home page on the shop site.
  2. Select View new reports.
  3. In the left-hand menu, under POS Reports, select POS Reconciliation.
  4. Set your filters as needed:

  5. Processed date range — when the transaction was processed in Kindo
  6. Received date range — when the funds were received
  7. Payment type — e.g. bank transfer, EFTPOS, cash
  8. Processed by — filter by staff member
     5. Click Search.



The results show a Totals row, followed by a group for each payment type with its receipt count and total amount.
Click a payment type to expand it and see each receipt's:
  1. Processed date and received date
  2. Amount
  3. Caregiver, with their email shown underneath
  4. Student, with their student ID shown underneath
  5. Transaction type
  6. Notes
  7. Who processed it
  8. POS ID
Click Export to download the report.

Idea
Export splits the caregiver's email, student's ID, and processed date/time into their own columns — useful if you want to sort or filter by any of these in Excel.

Classic reporting steps

There are two different POS reports available.    
  • POS Reconciliation - which shows you a breakdown of payments by payment type.  

            E.g. all eftpos transactions, then cash transactions etc. 

  • POS History  - will show you all transactions and top-ups and also shows you the Kindo account information, the student name and room number.

POS RECONCILIATION REPORT

1.    Login to the shop site and select the Admin option from the main Kindo Payables menu.

2.    Click on the Reporting button.

3.    Select POS from the first drop-down box, and POS Reconciliation from the second drop down box.

 

4.    Select the date from the Starting drop-down box - you can choose Today, Yesterday, or Type in which allows you to         type in the date you would like to search for.

5.    Click OK.  A list of transactions will appear on the screen.

In this example there was a bank transfer of $16, cash sales of $25.00 and eftpos sales of $45.50.

You can also see which Kindo account it was applied to, any remarks and the dollar value of each individual transaction.

You can then reconcile your eftpos receipts and cash deposits etc.