Resolve issues with automatic credit allocations

When you enter a new sales or purchase invoice, you might find that Manager automatically credits the invoice with some amount, making the Balance due less than the invoice Total:


This automatic credit allocation happens when the customer or supplier has a pre-existing credit balance. In other words, you owe a customer money or a supplier owes you money. Normally this is the desired outcome. You want any credits to be automatically applied to invoices, so you are not trying to collect from a customer more than is really owed to you and you don’t pay suppliers more than you really owe them. For example, if a customer has a credit balance of $100 due to a credit note, Manager will remember this until the next invoice is issued to that customer and will automatically apply the $100 credit to it without your having to keep track of it.

But if you are certain the customer or supplier didn’t have a credit balance, such an automatic credit allocation indicates something has been recorded incorrectly. The example below illustrates how to resolve the issue.

You have issued a sales invoice to Antonio Moreno Taquería for $3,370.00 and Manager has automatically applied credit of $2,345.30, leaving a balance due of $1,024.70:

Suppose you know this customer didn’t have any credit with your company, so you want to discover the origin of this credit. The best way is to view the customer ledger by going to Customers tab:


Locate the customer and click the balance in the Accounts Receivable column:

This will reveal the customer’s ledger:

There, you see invoice 2650 for $1,284.60 and a receipt for the same amount on 08/05/2017, which was payment for that invoice. However, you also see another receipt for $2,345.30 on 26/04/2017, which you suspect was not paid by this customer. After looking at your bank statement, you discover this amount was actually paid by different customer and attributed to Antonio Moreno Taquería in error. You can Edit the receipt to fix the error and attribute the receipt to correct customer.

You take one final look at customer ledger to verify all transactions belong to this customer:

Now, when you view the invoice, no amount is automatically credited:

Some bookkeeping errors can be discovered immediately, some can take weeks or even months to discover. Used properly, Manager’s double-entry accounting system ensures all errors will be eventually discovered.

In the example above, even if you didn’t notice the bookkeeping error, eventually the customer who actually paid $2,345.30 on 26/04/2017 would complain that its customer statements did not reflect the payment. Or your Aged Receivables report would show that customer’s account becoming more and more overdue. Sooner or later, you would discover the payment having been attributed to the wrong customer.

While the example illustrates an erroneous credit being automatically applied to a sales invoice because of incorrect attribution of a receipt from a customer, similar mistakes can happen with purchase invoices and payments to suppliers. Detection and correction procedures are the same.



Subscribe to Updates

Subscribe to our newsletter and get exclusive product updates you won't find anywhere else straight to your inbox.

© 2017 - Based in Sydney, Australia but providing goodness globally