10 Mar 10 Balancing (Payment) of a Pending Invoice/Debit Note explained in Detail

In this answer we have tackled a detailed indepth explanation of how the system works internally when an Invoice or Debit note is settled against a Receipt/Credit Note. Lets first understand the functionality provided by the Control Panel.

There are many places where you can choose to settle the Invoices/Debit notes of your Customers/Sub-Resellers -

• From the List View or Detailed View of an Invoice or Debit Note

• From the Detailed View of an Order for all Invoices associated with that Order

• After performing an Add Funds transaction, the system gives you a list of Pending Invoices and Debit Notes

An Invoice and Debit note are quite different transactions. An Invoice is always related to an underlying Order, and may actually have some action of the Order dependant on the Invoice. For instance an Invoice for Renewal of an Order, has the action of renewal dependant on the Invoice. A Debit Note on the other hand is not related directly to any Order. The system itself does not recognise any link between a Debit Note and a specific Order. However with respect to accounting effect, both of them reduce the balance of your Customer/Sub-Reseller when they are paid for. With respect to the process of settling them, they function exactly the same way. Let us examine this process of balancing of an Invoice or Debit Note

It is important to understand that by simply having an Invoice or Debit Note, it does not reduce the balance or available funds of your Sub-Resellers or Customers. You or they have to actually balance that Invoice or Debit Note (settle it) against some Receipt(s)/Credit Note(s) in order for it to reduce the available balance of your Customers/Sub-Resellers

Balancing of an Invoice/Debit Note

When you or your Customer/Sub-Reseller chooses to pay for an Invoice or Debit Note, you/he/she are given the option use the existing Debit Account balance of the Customer or Sub/Reseller to pay for the Transaction. There is also an option to Add Funds to the Debit Account, or pay online depending on what options you have enabled for your Customers/Sub-Resellers. In effect however an Invoice or Debit note gets paid through some Receipt or Credit Note. The Receipt/Credit Note could have already been added from before, or added during the Invoice/Debit Note Payment process.

Both an Invoice and a Debit Note consist of the following fields

Invoice/Debit Note Amount: This is the amount of the Invoice or Debit Note
Pending Amount: This is the amount of payment pending on this Invoice or Debit Note

The above amounts will be stored in dual currency, incase your Selling Currency is different from your Accounting Currency.

Lets journey through the payment process of an Invoice to understand what actually goes on during the Payment process. Upon confirming the balancing process, the System will attempt to balance this Invoice against existing Receipt(s)/Credit Note(s) or a New Receipt, depending on where the payment is attempted from.

Lets take a dummy Invoice for a Customer A with the following figures

Invoice ID: 1
Invoice Amount: USD 100 (INR 5000)
Pending Amount: USD 100 (INR 5000)
Conversion Rate: 50

Note the following points about the above Invoice

• As you can see the above Invoice is fully unpaid (since the Pending Amount is equal to the Invoice Amount).

• Additionally the Selling Currency in this example is USD and the Accounting Currency is INR.

• The conversion rate between both is taken as 50. This conversion rate is the conversion rate at which the Invoice was entered or created manually or by the System.

Lets now Assume that the Customer A has the following Receipts in his account

Receipt ID: 1
Receipt Amount: USD 50 (INR 2450)
Pending Amount: USD 0 (INR 0)
Conversion Rate: 49

Receipt ID: 2
Receipt Amount: USD 75 (INR 3675)
Pending Amount: USD 50 (INR 2450)
Conversion Rate: 49

Receipt ID: 3
Receipt Amount: USD 75 (INR 3600)
Pending Amount: USD 75 (INR 3600)
Conversion Rate: 48

As we can see above, there are 3 Receipts, each with a different pending amount. The important aspects to note are as follows

• Receipt ID 1 has no pending amount remaining. This means that this Receipt of USD 50 has been fully utilised against other previous transactions. Receipt ID 2 and 3 have some pending amount which can be utilised to balance this Invoice

• The conversion rate of the Receipts is different from the conversion Rate of the Invoice. This is obvious considering that the Receipts would have been fed in on a different day from the Invoice.

Now this is what the system will do. It will gather all Receipts which have some pending amount left in them. The system will then use these Receipts one after another to balance the Invoice until either the Invoice or the Receipts are completely balanced. The important aspect in this payment process is the forex difference calculation. Since the Invoice and Receipt are both fed in at different Conversion rates, it is obvious that there will be a Forex gain or loss with respect to this payment. The system automatically calculates this Forex Gain/Loss and stores it against the Invoice for you to account it appropriately. Here is how this works -

In the above case the system would first inspect Receipt ID 2. This Receipt has a pending amount of USD 50. Here we bring up an important point. When the system is balancing Invoices or Debit notes, it is actually balancing the Selling Currency Amount. What this basically means is if your Invoice is for USD 100, the system will attempt to balance Receipts worth USD 100 against this Invoice. By now you would have got a clue as to how the Forex diff would come into picture. In the process of balancing USD 100 from receipts, the INR amount used up from the Receipts would not be the same as the INR amount of the Invoice, since they are both fed in at different conversion rates. This leads to the Forex Diff. Lets see how this calculation works.

In the case above the System will use USD 50 from Receipt ID 2 and USD 50 from Receipt ID 3 in order to balance the USD 100 Invoice. In this process let us compute the INR amount of each Receipt that is used up

Receipt ID: 2
USD Amount utilised: USD 50
INR Amount utilised: USD 50 x 49 (Conversion rate) => INR 2450

Receipt ID: 3
USD Amount utilised: USD 50
INR Amount utilised: USD 50 x 48 (Conversion rate) => INR 2400

Total USD Amount Utilised: USD 100
Total INR Amount Utilised: INR 4850

The above calculation shows the amounts utilised in both currencies to fulfill an Invoice of USD 100. The Invoice amount in INR as we know was INR 5000. Against that we have Receipts of INR 4850. The difference between these is the Forex Loss of (INR 150). Below we have the final status after the payment is completed

Invoice ID: 1
Invoice Amount: USD 100 (INR 5000)
Pending Amout: USD 0 (INR 0)
Forex Loss: INR 150

Receipt ID: 2
Receipt Amount: USD 75 (INR 3675)
Pending Amount: USD 0 (INR 0)
Conversion Rate: 49

Receipt ID: 3
Receipt Amount: USD 75 (INR 3600)
Pending Amount: USD 25 (INR 1200)
Conversion Rate: 48

At the end of the transaction the Invoice is fully balanced, Receipt ID 2 is fully utilised, Receipt ID 3 is partly utilised and there is a Forex Loss of INR 150.

There are a few important points to note in the above transaction

• The transaction would work in exactly the same fashion if you had a Debit Note instead of an Invoice, or a Credit note instead of the Receipt

• The Invoice in this case was fully balanced, while the last Receipt (Receipt ID 3) was partly utilised. The reverse condition could also take place, wherein the Receipts were not sufficient to cover the Invoice Pending Amount, and therefore the Invoice would remain partly paid, and the Receipts would be fully utilised

Tags: Inr, Invoice, online depending, Receipt, USD