Odoo SO Deposits and Down Payments Applying to Multiple Invoices

By default in Odoo if you collect a $100 deposit for two widgets (sold at $50 each), and then deliver and invoice just one widget - Odoo will create a credit memo for $50 instead of an invoice, with one widget at $50 and the reversal of the $100 deposit. This way, you no longer have a down payment applicable to just the specific order, but a general credit memo. And the balance is credited to your “receivables” instead of a specific account designated for down payments.

Steersman created a deposit enhancement module for Odoo to allow allocating down payments partially to multiple invoices and automatically monitoring such allocations. Here are the things it does:

1. Disperse the deposit across multiple invoices, without creating unnecessary records that complicate reconciliation.
2. Apply deposits against specific delivered sale order lines on an invoice, including lines to be drop-shipped.
3. Deposits will automatically reconcile with invoices, providing a manageable and easy reconciliation process.
4. Users are unable to take a down payment that exceeds the sale order amount.
5. Quick visibility as to how much of the deposit is remaining or what invoices it is associated with.
6. Filter sales order by sales deposit balance

Advanced Sale Order Down Payments for Odoo

This new feature is part of our Sales Order Deposits Module and will require that you first set up a Down Payment in your Sales Settings before you install the module.

With the Sale Order Deposits feature enabled, you will be able to place a main deposit that will later be applied against the sale order lines as they are delivered.

In this example order, there are two sales order items, each of which will be delivered using a separate shipping method. Let’s go ahead and click CONFIRM.

The Register Payment pop-up will display the currently selected invoices and allow me to choose whether to charge the saved payment token for this contact or transfer the transaction directly to the terminal so that the customer can swipe their card. Click PROCESS PAYMENT after making your selection.

After this, the Sales Order will refresh and now show a new tab called Deposits. This will list the deposit invoice and any subsequent invoices created, as well as display the remaining deposit amount. To see the deposit invoice, click on the Invoices smart button or click the invoice line under the Deposits tab.

This invoice is specifically designed to show you the deposit paid by the customer, as well as the linked payment transaction that resulted from the credit card charge.

Deposit Applied Against an Invoice for a Delivered Product

After processing the delivery order, this updated the sale order line card for the product. So, now that the delivered quantity is greater than the invoiced quantity for the item, Odoo will allow you to click CREATE INVOICE, which will generate an invoice for just the items that have been delivered so far.

The invoice will be created and added to the list of invoices in the Invoices smart button, which can be accessed on the sale order. By default, this newly generated invoice will be in a draft state and will display the item that was delivered, as well as the sale order deposit applied against this specific sale order line, resulting in a $0.00 invoice. Which, by default in Odoo, will be marked as paid.

If we go to the Sales Order’s tab called Deposits, we will see that the invoice has not only been added to the list but also has decremented its invoice amount from the deposit total. The remaining amount on the deposit is shown below.

Deposit Applied Against an Invoice for a Drop-Shipped Product

After processing the Dropship transfer, Odoo updates the delivered quantity to reflect the amount sent from the vendor to the customer. Since the delivery quantity is now greater than the invoiced quantity, Odoo will allow you to click CREATE INVOICE, which will generate an invoice for the delivered product.

On the invoice, the deposit line will be applied to the dropship product sale order line. This will result in a $0.00 invoice, and by default, Odoo will mark it as paid.

On the sale order under the Deposits tab, we will see the latest invoice amount being deducted from the deposit total. The remaining amount left on the deposit will also be zeroed out altogether.

Filter Sales Orders by Deposit Balance

From the sales orders list, enable the ‘Deposit Balance’ column to show the current deposit balance for each order.

Use custom filters to sort orders with deposit balances above $0.00 or sort orders in a specific deposit balance range that would likely be an unintentional mismatch balance (i.e., balances between $0.00 and $30.00).

Click Filters > Add Custom Filter, then select ‘Deposit Balance’ from the dropdown.

Check out our other Steersman Odoo Features

• Unrouted Emails Dashboard
• POS Style Sale Order Management: A Powerful Combination
• Steersman’s Odoo TaxJar integration for sales tax look up and filing automation