How do I review my store’s POS remittances?
The POS doesn’t credit each store sale separately: it credits the day’s total in a single entry, the remittance. In POS remittances you see each remittance with the orders it contains, what was expected, what the bank credited and the difference.
What do I need before I start?
The online store has to record its receipts and its POS payment methods have to have a merchant number: see Store receipts. To see what has been credited, your bank also has to be connected: see Connect my bank.
What if those orders are already invoiced here?
When you connect the store, choose Reconciliation only in What it is connected for. The program only reads the store’s receipts: it creates no order, invoice, receipt or advance and publishes nothing, so no receipt is repeated.
With that store, the screen shows two steps: connect it and bring in its receipts, in Reconciliation hints. No remittances appear: what you see are the bank’s credits.
Where is it?
In Treasury → POS remittances.
What does each credit contain, if the store is for reconciliation only?
The Unreconciled POS credits list has one row per bank credit. Click one to see each order with its customer, its transaction number and what the program says about it:
| Status | What it means |
|---|---|
| Already collected | The customer’s receipt is paid in a batch of that bank. It must not be collected again |
| Collection missing | The invoice exists and its receipt is still outstanding |
| No invoice | The customer has no receipt for that amount close to the sale |
| No customer | The order could not be linked to any record. The reason is shown underneath |
| Several possible receipts | There is more than one receipt equally close to the sale. It has to be checked by hand |
The program looks for a receipt from the same customer for the same amount, 15 days from the sale at most. If there is only one further away, or collected through another bank, it does not accept it, but it tells you it exists.
The same appears in reconciliation, on the credit’s line, in Orders in this credit. Looking at it changes nothing.
How do I reconcile the credit?
Click Reconcile the remittance. Next to the button it says what it is going to do:
- What is already collected is linked to its batch. Nothing is created and no receipt is repeated.
- What is missing is collected: a single collection, with the date and bank of the credit, even if it covers several customers. Their invoices end up paid.
Everything is saved together or nothing is saved.
The button does not appear, and the reason is given, in these cases:
- An order shows No invoice, No customer or Several possible receipts. Resolve it by hand and come back.
- The orders do not add up to the credit.
- The credit has the POS fee deducted.
- The collected batch contains more than the orders of this credit.
If the month is closed, the collection is not created: it says so when you click.
Can I undo it?
Yes. In reconciliation, open the line and click Undo (back to pending). The collection created is cancelled and its invoices are outstanding again. The batches that already existed stay as they were: they are only released from the credit.
What do I see in the list?
One row per merchant number and day of sales:
- Credit date: the day the bank should credit it.
- Merchant and Sales on: which POS and which day the sales are from.
- Orders, Gross and Commission: how many operations it contains, what was sold and the POS fee.
- Credited and Difference: what came into the bank and what is missing or left over. They are empty until the credit arrives.
- Status: Awaiting credit, Unbalanced, Balanced, not confirmed or Reconciled.
With the status filter you see only the ones you are interested in, for example the unbalanced ones.
What do I see when I click a remittance?
Each operation with its operation number, its order, its invoice (if it has already been made), the amount, the share of the fee that falls to it and whether its receipt is matched in the bridging account. A return shows in red and as a deduction.
What can I do with a remittance?
- Confirm: when it is balanced and wasn’t confirmed on its own. If it is unbalanced, the button says Confirm with the difference and asks for the Reason; the reason is saved with the remittance.
- Balance again: repeats the balancing with the bank credit, for example after correcting an order.
- Reopen: undoes the confirmation (fees journal entry and moving the money to the bank) so you can work on it again.
- Exclude an order: takes it out of an unconfirmed remittance, with the Reason written at the top. The receipt is set aside and doesn’t go into any remittance again; if the remittance already has its credit, it is balanced again on its own.
If the bank gives you the Redsys settlement file, you can also import it from bank reconciliation: see Balance a POS settlement.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| No remittance appears | The store doesn’t record receipts from a method with a merchant number | Check the payment methods in Digital channels → Online store → Receipts |
| A credit says Store payments missing | The orders of those days have not been brought in | Bring them in from Reconciliation hints, with the period of those days |
| An order shows No invoice although the invoice exists | The invoice belongs to another customer or another amount, or was made more than 15 days after the sale | Read the order’s warning and check it on the invoice |
| A remittance is still Awaiting credit after its day | The bank hasn’t credited it yet, or the credit hasn’t been recognised | Synchronise the bank and analyse the pending lines in the reconciliation |
| ‘Confirming an unbalanced remittance requires a reason.’ | You clicked confirm without typing the reason | Type the reason and click again |
| ‘Excluding an operation from the remittance requires a reason.’ | The reason is missing | Type it at the top and click Exclude again |
| ‘That operation cannot be excluded: the remittance is already reconciled.’ | The remittance is confirmed | Click Reopen first |
See also: Store receipts · Reconcile the bank transactions
More about Banks
- How do I use my spreadsheets to reconcile the bank?
- How do I load the bank statement from a file?
- How do I reconcile the bank transactions?
- How do I connect my bank to the ERP?
- How do I balance a POS or payment gateway settlement?
- How do I set up my company’s access to Enable Banking?
- Connecting the bank and reconciling the statement
- How do I reconcile the bank month by month?
- How do I review the transactions that come in from the bank?