Skip to content

How do I view and prepare my online store’s receipts?

Each order paid in the store brings its receipt: what it was paid with, when, how much and the gateway’s transaction number. The ERP saves them on its own when it brings in the orders. In the Receipts tab of Online store you see them and tell the ERP how to handle each of the store’s payment methods.

What is it for?

The bank doesn’t pay out each store sale separately: the virtual POS pays in the day’s total as a single bank entry, the remittance. To know which orders are inside that entry, the ERP needs the receipts of each order and to know which POS merchant each one belongs to.

What if I already invoice those orders in this program?

Connect the store with Reconciliation only, in What it is connected for, when you add it in the Configuration tab. If the company already has invoices, the program makes you choose before saving.

With Reconciliation only, the program creates no order, invoice, receipt or advance and publishes nothing to the store. This tab neither captures nor records receipts: they are brought in from Reconciliation hints.

To start selling with that store, change What it is connected for to Sell and switch on Active store.

How are the payment methods set up?

  1. Go to Online store and open the Receipts tab.
  2. Choose the store at the top.
  3. Payment methods lists the payment methods that have already come in on some order, named as the store names them (‘redsys’, ‘bizum’, ‘Card payment’…). The ones that don’t have an ERP payment method yet are flagged.
  4. For each method choose:
    • Gateway: who moves the money. The ERP works it out from the name; correct it if it gets it wrong.
    • Payment method: the ERP one the order will be collected with. Its card or bank account is where the money will sit until the bank pays it out.
    • For Redsys and Bizum, the virtual POS Merchant no., its Terminal as it appears in the POS contract, the Session cut-off time (usually 00:00) and the Days until settlement (usually 1). For the other methods these boxes are greyed out.

The last column, Receipts, says how many receipts have already arrived with that method.

  1. Click Save payment methods.

If your Redsys plugin stores the transaction number under an unusual name, type it in Transaction no. key and click Re-read payments.

What does the ERP do with each receipt?

When the paid order is already in the ERP as a sales order, its receipt is recorded on its own in the account of its method’s payment method (the card or bank account). How is decided by the company in Recording of payments, at the top of the tab:

If you untick Record payments automatically, the receipts are still saved and shown here, but the ERP doesn’t enter them in treasury. Record now does straight away what the next store sync would otherwise do.

A receipt that can’t be recorded stays Captured and the list shows why: the method has no payment method, an invoice couldn’t be issued, what was collected doesn’t match the order… Correct it and click Record now.

A return is recorded with the order’s corrective invoice. The ERP doesn’t make it by itself, because it is an invoice and a partial refund has to be decided; you make it, with the button on the cancelled order or from the invoice. The corrective invoice takes the invoice’s payment method, so issuing it gives the money back through the same card account, and the store’s return changes to Collected. Until then it stays Captured, with the reason: the corrective invoice is missing, it is a draft or it doesn’t match what was refunded.

What invoice does a buyer without a Tax ID get?

In an online store almost nobody gives their Tax ID, and a full invoice can’t be made without it. That is why, with On payment, the ERP looks at who has bought:

The store’s simplified invoices go in their own series, so they don’t get mixed up with the POS receipts or with full invoices. Type it in Simplified invoice series, next to When the invoice is created, and click Save settings. It has to be different from the sales invoice series and from the POS one, and if the company doesn’t create series on the fly, it has to be created first in Settings → Document series. If you leave it empty, simplified invoices go to the sales invoice series.

A simplified invoice is only valid up to an amount, and that limit is the one your company has in the POS settings (tax section). If an order goes over it, it isn’t invoiced automatically and the receipt stays pending with the reason. Ask the customer for their Tax ID (for example, by email), enter it on their record and click Record now: the full invoice will be issued.

How is each day’s remittance prepared?

With the receipts of the POS methods (Redsys and Bizum) already recorded, the ERP builds on its own the remittance it expects to receive from the bank: one per merchant number and per sales day, with all its orders inside and the date the payout should arrive. The receipt changes to In remittance. When the bank pays out, that remittance is the one reconciled with the bank entry: it shows in the bank reconciliation as a Redsys settlement. If the payout matches the remittance, after deducting the POS fee, it is confirmed on its own and its receipts change to Reconciled; if not, it is left for you to review (Balance a POS or payment gateway settlement).

What about returns, orders that arrive late and unusual cases?

What is ‘Re-read payments’?

It reads again the receipts of all the orders that are already in the ERP. Use it the first time, so that the receipts of orders that arrived before you had this tab come in, and when you change the transaction number key. It doesn’t duplicate anything.

What do I see in ‘Payments received’?

Each receipt and each return from the orders, with its Payment date, the Order, the Method, the Gateway, the Type (receipt or return), the Transaction no., the Amount and its Status. A return is shown with a negative amount. The header says how many have been read in total.

Above the list there is a Status filter: leave All statuses or choose one to see only, for example, the ones left Captured. If there are many, they are split into pages: move between them with Previous and Next.

Where do I see what was paid for an order that isn’t invoiced yet?

On the sales order itself. With receipts with the order, the order has no receipts yet, so Collected and Outstanding show zero; next to them is Advance payment, with what the buyer has already paid. If you hover over it, it says how much is still to be deducted from the invoice. What was refunded doesn’t count.

What do I do if the store refunds only part of an order that isn’t invoiced?

It happens with receipts with the order: what was paid is an advance on the sales order and there is no invoice to correct yet. For example, the customer paid 60 € and you refund 20 € because you don’t have one item.

  1. In Digital channels → Online store, Orders tab, select the order. The panel warns about what the store refunded.
  2. Press Refund … from the advance. The amount is what the store refunded.

The ERP refunds that amount from the advance, through the same account it was collected in, and the store’s refund is recorded. What is left of the advance is deducted by the invoice when you make it.

The sales order does not change: if you are not going to ship the item, remove it from the order before shipping. If the store cancels the whole order, use the cancelled order’s button, and if the order already has an invoice, the refund is recorded with its corrective invoice.

How do I know the receipts are set up correctly?

Above the Payment methods table there is a summary. If something would stop the receipts being recorded, it says so there, with the method it affects: a method without a payment method, a payment method without a card or bank account, a POS method without a merchant number, or Record payments automatically turned off. With the invoice On payment, it also warns if the payment method isn’t cash, because then the invoice is issued but the receipt isn’t recorded.

If everything is fine, the summary says All set in green. That way you don’t have to wait for a receipt to fail to find out what was missing.

If something goes wrong

What you seeWhat has happenedWhat to do
‘Payments arrive with this method and it has no payment method assigned…’The method isn’t assignedChoose its payment method and save
‘The merchant number is missing…’It is a POS method without a merchantType the merchant number the bank gave you
‘the merchant number must be digits only (6 to 12).’You have typed letters or an incomplete numberCopy the merchant number exactly as it appears in the POS contract
A receipt is shown without a Transaction no.The store plugin saves it under another nameType its key in Transaction no. key and click Re-read payments
No receipts are shownNo paid order has come in yet, or the orders arrived earlierClick Re-read payments
‘The method … has no payment method assigned…’ on a receiptThe receipt arrived before the method was assignedAssign its payment method in Payment methods and click Record now
‘The amount paid (…) does not match the order total…’With On payment, the order was paid in part or with a different amountInvoice the order by hand and apply the receipt from Receipts
‘Paid in … : the POS pays out in euros…’The receipt isn’t in eurosReconcile it by hand with its bank line
‘It arrived after remittance … was confirmed’The bank didn’t include that receipt in its day’s payoutFind which payout it arrived in and reconcile it by hand
‘The order invoice could not be issued: …’With On payment, the invoice failed a check (for example, the customer’s Tax ID)Correct what the reason says on the customer record and click Record now
‘…exceeds the simplified invoice limit (…). Contact the customer…’The buyer has no Tax ID and the order goes over your company’s limitWrite to the customer at the email shown in the message (the one they gave in the store) and ask for their Tax ID. Enter it on their record and click Record now: the full invoice will be issued
‘Series … is the sales invoice series’ or ‘…the POS receipt series’ when savingThe simplified invoice series has to be its ownEnter another one (for example “W”) or leave it empty
‘Make the order’s corrective invoice to record the refund.’The store refunded the money and the order has no corrective invoice yetMake it from the cancelled order or from the invoice, and issue it
‘The order’s corrective invoice is a draft…’The corrective invoice is made but not issuedOpen it, review it and issue it
‘The amount refunded by the store (…) doesn’t match the corrective invoice (…)…’The store refunded part and the corrective invoice is for another amountCorrect the corrective invoice so it credits the same as was refunded
‘The corrective invoice was issued without a cash payment…’Its payment method isn’t cash and the refund stayed in the customer’s receivablesPay that due item from Receipts with the card account
‘The order has no invoice: the refund is recorded with its corrective invoice or by refunding its advance…’The order isn’t invoiced and the payment was kept as an advanceIf the store cancelled it, use the order’s buttons: Cancel the sales order and then Refund the advance
‘The amount refunded by the store (…) doesn’t match the refunded advance (…)…’A different amount was refunded from the advanceCheck the advance refund in Receipts
‘Series … does not exist’ when savingThe company doesn’t create series on the flyCreate it for sales invoices in Settings → Sales and documents → Document series

See also: Receive the store orders

More about Online shop