Skip to content

How do I record an advance payment from a customer?

An advance payment is money the customer hands over on account before the invoice exists, or on account of an order. It goes into the cash or the bank at that moment and stays as a balance in their favour until it is applied to an instalment.

What do I need before I start?

The customer who hands over the money and an active treasury account to pay it into.

You don’t need an invoice or an instalment: that is why the advance payment is used to collect in advance. What you do need is to know who the money belongs to.

Is the customer required?

Yes. An advance payment is always a payment on account by someone: its balance can only be spent on its owner’s debt. The dialog’s Customer field lights up in red if you try to save without filling it in.

There are two ways for it to come already set:

From /cobros, where there is no customer in context, the field opens empty and you have to choose one.

To change it, clear the field with its cross and choose another. While it is empty the form is incomplete: saving will point this out instead of recording a payment with no owner.

How do I do it?

  1. Go to Receipts and banks and click Receipts.
  2. Click Advance payment.
  3. Choose the Customer the payment belongs to. It is required. If you opened the dialog from a customer’s record, it is already set.
  4. Choose the Document the payment is associated with, if there is one: when you choose it, the customer is filled in.
  5. Type the Amount. It must be greater than zero.
  6. If there are any, type the Expenses of the payment and its expected Due date.
  7. Choose the Bank where the money goes in and the Date.
  8. Click the save button.

The advance payment appears in the table with a teal background and the Advance payment label, so it isn’t mistaken for a bill.

How do I know how much of an advance payment has been used?

The Status column of its row says it, below the Advance payment label:

An advance payment that has paid invoices does not disappear from the list, not even on the customer’s or supplier’s record: neither if it was only partly used and its expected date has passed, nor if the rest was given back, nor if it was handed over more than a year ago and applied later. In the Document column it says, in grey, which invoices it was applied to (‘Applied to …’); if there are many, hover over it to see them all.

In an advance payment row, Paid is what was handed over when it was recorded, and it doesn’t change; Advance payment is what is left to apply. In a bill row, Advance payment is the part of that bill paid with an advance payment. So, when an advance payment is applied, that amount moves from the Advance payment column of the advance payment to the one of the bill.

The Paid total at the bottom counts each euro once: from an advance payment it only adds what no bill has paid yet, because what has been applied is also in the bill’s Paid.

For an advance payment to a supplier the route is the same, from Payments.

The expenses don’t change the balance of the advance payment or the money that goes into the cash.

The due date is the date by which you expect to apply it, and it decides until when it is shown in the Receipts table: once that date has passed, if it hasn’t been fully spent, its row no longer appears, because that table shows today’s situation. The advance payment isn’t lost: it keeps its balance, still counts in Advance payments on account on the customer’s record and is still applied when collecting. To see it in the table again, change the date filter to All dates. If you don’t want it to disappear, leave the due date empty.

What happens when I record an advance payment?

An advance payment batch is created with its number and the money goes into the treasury account. The advance payment is also left with its available balance, in the customer’s name.

In the Receipts table, the Document column of that row shows the document you associated the payment with. If you didn’t associate any, it is empty: the operation number isn’t a document.

That balance doesn’t touch the customer’s debt yet: it is money received on account. The debt is cancelled when you apply the advance payment to an instalment.

Which accounting account does the advance payment go to?

It depends on how your company has the Advance payments and vouchers in the customer’s or supplier’s account checkbox (Settings → Transfer):

Changing the checkbox only affects the advance payments you record afterwards: each advance payment stays in the account it came in through until it is applied or returned.

What is the ‘Issue advance payment invoice’ checkbox?

It appears when adding a customer advance payment (not supplier ones) and starts unticked.

The law requires the VAT on an advance receipt to be declared at the moment of the receipt when that money is on account of a specific operation: it is known what is going to be sold and at what VAT rate. In that case an advance payment invoice has to be issued. If the payment is general —the customer leaves money on account and it isn’t yet known what they will buy or at what rate—, there is nothing to declare yet.

That is why the checkbox doesn’t ask whether you want to declare VAT, but whether that operation already exists:

If the VAT rate is missing when you click save, the field lights up in red and nothing is recorded.

What happens when I issue an advance payment invoice?

When you later apply the advance payment to the final invoice, the VAT isn’t counted twice: the part of the tax amount already declared with the advance payment invoice is deducted automatically when applying, both in the journal entry and in the VAT register. If you apply the advance payment in several goes, the tax amount is shared among them and matches to the cent when the advance payment runs out.

What it doesn’t do yet: the final invoice is issued for its full amount and doesn’t print the deduction of the advance payment invoice or mention it. The VAT is declared correctly (the application offsets it), but the paper of the final invoice doesn’t show the advance payment. And a refund of money from an invoiced advance payment doesn’t correct its invoice: you have to issue the credit note by hand.

Voiding the advance payment (while it hasn’t been applied yet) also voids its advance payment invoice.

How do I give back or cancel an advance payment?

In the Receipts (or Payments) table, select only the row of the advance payment (teal):

Each button’s tooltip says what it will do before you click it.

Where do I see a customer’s advance payments while collecting?

In the Receipts table itself: the teal rows are their advance payments. The Advance payment column says what it has left available and the Paid column, what was handed over at the time.

And when collecting, the dialog suggests them on its own: see Collect an instalment.

Where do I see the advance payments and the balance left?

In the Receipts and Payments table itself: customer ones in Receipts, supplier ones in Payments. Advance payments live with the rest of the open items, not in a separate list.

To see them all, mark Advance payment in the status filter and set the dates one to All dates. Each advance payment row says what was handed over (Paid column) and what it has left available (Advance payment column).

On the customer record and on the supplier record, the Financial tab shows the total balance in Advance payments on account; it is a read-only figure, calculated from the advance payments that still have an amount available. And their Receipts (or Payments) tab is that same table limited to them.

How do I apply the advance payment to an invoice?

From the receipt, which is how it is done:

  1. Go to Receipts and mark the bills to settle.
  2. Click Collect. The Advance payment field comes filled in with what the customer’s balance covers.
  3. Lower that amount if you only want to spend part of it, or leave it at zero not to use the balance.
  4. Confirm.

If the advance payment covers the total, no money goes into or out of the cash: the instalment is collected with the balance alone. If it covers part, the difference comes in as cash.

An advance payment is never overdrawn. If you apply more than it has, the whole receipt is rejected.

If the advance payment was collected on account of an order (which is what the ERP does with orders paid in the online store), its invoice deducts it automatically when it is issued, provided the invoice’s payment method is immediate: immediate payment first uses what was collected on account of the order and only new money comes in for the difference. With a deferred payment method it is applied from the receipt, like any other.

Can I choose which advance payment the money comes from?

Not from the screen. The Advance payment field in the receipt dialog says how much of the balance is spent, not from which one: they are used up from the oldest to the most recent until that amount is reached. The one that runs out stops being offered; the one that is half used keeps the rest.

To spend a particular one, ask the assistant: ‘apply advance payment 12 to instalment 340’. It is the same operation —an application batch, with no cash movement— and it leaves you a confirmation card before doing anything.

How do I give back the money of an advance payment?

Refunding the balance isn’t done from the screen. The balance of an advance payment is spent by applying it to any outstanding instalment of that customer, or it stays in their favour until there is one.

An advance payment recorded by mistake can’t be voided from the screen either: the money really did go into the treasury account, and undoing it means giving it back to the customer. Ask support if you need to take that amount out of the cash.

If something goes wrong

What you seeWhat has happenedWhat to do
‘Fill in the required fields’, with Customer in redYou haven’t said who the payment belongs toChoose the Customer: an advance payment always belongs to someone
‘The advance payment customer or supplier is missing’The command arrived without a business partnerChoose the Customer and save again
‘The advance payment amount is missing’You haven’t typed how much is handed overType the Amount
‘The batch’s treasury account is missing’You haven’t chosen where the money goes inChoose the Bank
‘The advance payment does not have enough balance’You are applying more than what is leftLower the Advance payment amount in the receipt dialog
‘The advance payment N does not belong to the batch’s business partner’That advance payment belongs to another customerRemove it from the selection: its balance is only valid for its owner
‘The available balance does not cover all the specified instalments’You asked the assistant to apply an advance payment to more instalments than its balance coversAsk it for fewer instalments, or tell it what amount to apply
‘Choose the VAT rate for the advance payment invoice’, with VAT rate in redYou ticked Issue advance payment invoice without saying the rateChoose the VAT rate of the operation, or untick the checkbox
‘An advance payment invoice is only issued for a customer advance payment’The checkbox was ticked on an advance payment to a supplierUntick it: the invoice for that advance payment is issued by the supplier
‘Issuing advance payment invoices is not available in this installation’The invoicing module is missing in this installationLeave the checkbox unticked and ask support

See also: Collect an instalment · Use a voucher · Return a receipt

More about Payments