Applying overpayment to invoice without journal entry

Is there any other way the system can allow the overpayment on a customer’s invoice to automatically be applied to the next invoice created instead of having to create a journal entry?

For example, if I pull up the list of customers, it shows each one’s balance … can I not apply a payment to the balance and it will be taken off of the oldest invoice?

To be honest, I don’t like applying overpayments to invoices through journal entries as well.

Here is what I propose. If you are viewing unpaid invoice of a customer who has credit (result of overpayment or prepayment), Manager will show some notice box saying there is available credit that can be applied to this invoice. By clicking on button, Manager will transfer this credit (or portion) to pay off (or offset) invoice balance.

Would that work for you?

3 Likes

Certainly would make my life a lot easier. Please let me know if you implement it.

1 Like

This would be a great help.
I journal entry when you pick an invoice the the o/s amount does not appear, which means before setting off entries in this option you need to write down the amount of each invoice. If this amount is added to appear automatically it will be a great help.

This would be a great addition to your application!!

Yes that would be great feature. Had to allocate 15 invoice this week where the customer just pays random amount during the month. Now you allocate then until you check over paid on the invoice then go edit that to add a line for the next invoice and so on.

I have been using the new Allocation button in applying advance payments to invoices. Thank you for implementing this!! In the Customer Transaction Report those allocations are using two lines as a debit and a credit. Is it possible to leave those out of the report, making for a cleaner look? We have older members in our association and I think those internal entries will be very confusing.

Actually, this feature is not yet complete and still work in progress.

There will be new version (hopefully tomorrow) which will make these credit allocations even easier.

When you say Customer Transaction Report, what exactly do you mean? Where do you click to see this?

Sorry, I worded that incorrectly. It’s the Customer Statement by Transaction.
Two screenshots:

Yeah, I agree this looks ugly but upcoming new implementation is fixing this. Plus it will show proper descriptions on statements.

Abundant thanks!!!

The implementation should be complete in the latest version (14.11.33).

If you issue new invoice and there is a credit, Manager will now automatically allocate the credit to the invoice.

Also, it is no longer required to specify invoice when receiving money from customer or paying supplier… simply allocate the payment to Customer credits or Supplier credits account and Manager will automatically do the matching for you. Of course, you can still directly allocate to invoice just like before if that’s what you prefer.

I recommend to scan through relevant guides on A/R and A/P again just to update yourself on this simplified workflow.

I’ve been watching for this feature. Huge inprovement!

Are you still working to achieve this change in reports?

@tmtreasurer, it’s fixed in the latest version (14.12.31)

Thank you!! That cleaned it up very nicely.

Hello, I have a customer who made an over payment. Manager acknowledged the excess amount, The customer has a new invoice but that invoice does not have the credit amount subtracted. Nevertheless, in the Customer’s statement it is applied. It would be best if the new Invoice shows the real due balance to avoid another overpayment. Is this possible?

this is a five year old topic and most discussions are outdated.

do not select any invoice on the line item when entering the excess payment. this will automatically adjust on the next invoice to the customer. please read the guides section where these have been explained clearly.

Read this Guide, @martagisela: Resolve overpaid status on sales invoices | Manager. There are some examples that should make things clear.

The point is that, if you force Manager to apply a receipt to a specific invoice, it will do just that, causing it to be overpaid but leaving others unpaid. If you do not designate an invoice, the program will methodically apply the receipt to unpaid invoices, oldest due dates first. When a sales invoice is partially paid, the mini-statement at the bottom will provide details and display the reduced balance due.

I followed the guidelines and saw How the transaction was to be entered. Thank you!