Offsetting Payments and Credit Invoices

Introduction: What Is Offsetting?

Offsetting means deducting payments that customers have made or credit invoices (refunds) they have received from their outstanding invoices. For example: a customer has a 100 euro credit and still owes 150 euro. After offsetting, the customer only needs to pay 50 euro.

Why Should You Offset?

You want to offset because:

• Customers won't overpay through direct debit (SEPA)
• You deduct credits and credit invoices before collecting payments
• You prevent customers from paying twice
• It's fair: if a customer has a credit, it should be used
• Your administration stays clean and correct

Important: Always do this before creating a SEPA payment run!

How Do You Offset Payments and Credit Invoices?

There are two methods: automatic (for many customers at once) or manual (per customer). Choose the method that best fits your situation.

Method 1: Automatic Offsetting (for Many Customers at Once)

Use this method when you want to offset for many customers at the same time. This is faster than doing everything manually.

Step 1: Go to the Offsetting Menu

1. Go to "Invoices"
2. Click on "(Payments) Per debtor"
3. Click on "Offset"

Step 2: Set Filters

Choose Administration:

1. Select at "Administration" which administration you want to offset
2. This is usually your company's main administration

Filter Customers (Optional): You can choose to offset only certain customers:

• Debtor category: For example, only "regular customers" or "wholesale customers"
• Specific debtors: Choose specific customers if you don't want to offset everyone
• Leave empty: If you want to offset all customers

Step 3: Set Credit Invoices to Offset

1. At "Credit invoices to offset," optionally select the types of payments you want to offset with
2. Examples:
   • Cash payments
   • Bank transfers
   • Credit invoices (refunds)
3. Leave empty if you want to offset with all types

Step 4: Select Invoices to Offset Against

1. At "Offset credit invoices / payments with," choose which invoices you want to offset
2. Examples:
   • Invoices with payment reference "SEPA B2B" (business direct debit)
   • Invoices with payment reference "SEPA Core" (consumer direct debit)
   • All outstanding invoices
3. These are the invoices from which the credits will be deducted

Step 5: Execute the Offsetting

1. Check that all settings are correct
2. Click "Apply"
3. The system now automatically offsets all payments and credit invoices
4. Wait until the process is complete (this may take a moment if you have many customers)

Done! All payments and credit invoices have now been offset against the outstanding invoices.

Method 2: Manual Offsetting (Per Customer)

Use this method if you only have a few customers or if you want to check exactly what is being offset.

Step 1: Go to Outstanding Payments

1. Go to "Invoices"
2. Click on "(Payments) Outstanding"
3. You now see a list of all payments that still need to be offset

What Do You See in This List?

• Payments that customers have made but haven't yet been assigned to invoices
• Credit invoices (refunds) that haven't been used yet
• The amount that still needs to be offset

Step 2: Offset a Payment

1. Click on a payment in the list
2. You now see the details of this payment
3. You also see a list of outstanding invoices for this customer

Step 3: Choose an Invoice

1. Click on the invoice you want to offset the payment against
2. The system now deducts the payment amount from the invoice
3. The payment has now been processed

Step 4: Repeat Repeat steps 2 and 3 for all payments you want to offset, until you're done.

Practical Examples

Example 1: Automatic Offsetting for SEPA

• Situation: You want to do a SEPA direct debit next week
• Action:
  1. Go to offsetting
  2. Choose "SEPA Core" for invoices to offset against
  3. Click Apply
• Result: All credits have been offset; customers now pay the correct amount

Example 2: Manual Offsetting for One Customer

• Situation: Customer Jansen has paid 50 euro and has an outstanding invoice of 150 euro
• Action:
  1. Go to Outstanding
  2. Click on Jansen's 50 euro payment
  3. Click on the 150 euro invoice
• Result: Jansen now has 100 euro outstanding instead of 150 euro

Example 3: Offsetting a Credit Invoice

• Situation: Customer Pietersen has a credit invoice of 30 euro (refund) and an outstanding invoice of 200 euro
• Action:
  1. Run automatic offsetting
  2. Or manually: link the credit invoice to the invoice
• Result: Pietersen only needs to pay 170 euro

Important Tips

Tip 1: Always Offset Before SEPA

• Do this at least one day before you create the SEPA run
• This prevents customers from overpaying
• Customers will be happy to see their credit has been applied

Tip 2: Check the Result

• After offsetting, verify that everything is correct
• Manually check a few customers
• Have the amounts been correctly reduced?

Tip 3: Use Automatic for Large Groups

• Have more than 10 customers? Use automatic offsetting
• This saves a lot of time
• It makes fewer mistakes than doing everything manually

Tip 4: Use Manual for Special Cases

• Unsure about a customer? Do it manually
• Want to see exactly what happens? Choose manual
• Special arrangements with a customer? Manual gives more control

Tip 5: Make It a Routine

• For example, offset every Friday
• Or always the day before your SEPA run
• That way you never forget and everything stays tidy

Frequently Asked Questions

Question: What if I forget to offset before a SEPA run?

• Customers will overpay
• You'll have to refund the money later
• This creates extra work and dissatisfied customers

Question: Can I undo an offsetting?

• Yes, but this must be done manually
• It's better to get it right the first time
• That's why you should always check before clicking Apply

Question: How long does automatic offsetting take?

• For 100 customers: about 1-2 minutes
• For 1000 customers: about 5-10 minutes
• Doing it manually would take hours!

Summary

Offsetting is done to deduct credits and payments from outstanding invoices:

• Automatic offsetting: For many customers at once, via Invoices → Per debtor → Offset, set filters and click Apply
• Manual offsetting: For individual customers, via Invoices → Outstanding, click on payment and link to invoice
• Why important: Prevents customers from overpaying with SEPA direct debit
• When to do it: Always before creating a SEPA payment run, for example every Friday or the day before