how to handle overpayments
  • marcnycmarcnyc January 2010

    Hello, I was wondering what the best way is to handle overpayments.
    If I client owns $100 and pays you $200, is it best to just enter the amount of the overpayment ($200) in the $100 invoice? or is it best to enter $100 as payment for that invoice so that that invoice looks paid and then create another payment of $100 and assign it to another open invoice of the same client?
    I noticed that if you enter an overpayment you can see the credit and I suppose it is applied to the balance of the client, but if I do this, how can I show that all invoices are paid? In other words, if I do this I will see the balance of the client go down but I will not see the open due invoices amounts go down and it will seem that there are still unpaid invoices even though the client has paid everything...
    What's the best way?

  • bmcgonagbmcgonag February 2010

    This is something I hadn't really thought of.

    I suppose you could go in and add a new payment to the overpaid invoice at the same time as clearing a new invoice. Basically they are credited $100.00.

    You Sell them $100.00 worth of more doodlywhatzits...so instead of making them pay...

    Go into the original invoice where the overpayment was made, do 'Process a Payment' and enter $ -100.00.

    Now go into the invoice for the current purchase and enter your payment of $100.0. Everything should balance for you and the client.

  • marcnycmarcnyc February 2010

    I'm not sure I understand what you mean... could you elaborate?

  • bmcgonagbmcgonag February 2010

    I'll try.

    Okay, you bill customer Joe Blow for $100.00 on Invoice #562. Joe Blow mistakenly pays you $200, and you catch the mistake.

    In a situation where returning the extra money is not an option, or where the customer has a busy account with constant activity, you enter $200.00 for Invoice #562, thus setting the Owing total to $ -100.00.

    Now, you have Joe Blow come in and purchase another $100.00 worth of items on Invoice #589. You would do the following.

    Enter a Payment on Invoice #589 of $100.00, thus setting that invoice total Owing to $0.00.

    Enter a Payment on Invoice #562 of $-100.00, thus setting that Invoice total Owing to $0.00. This will also set the total owed by the client to $0.00 for your overall tracking of invoices and payments.

    I think it's best to enter the total payment and go negative as it accounts for the money at all times should the client ever raise a question about it.

    Hope that helps,

    Brian

  • marcnycmarcnyc February 2010

    I understand what you mean.
    My question/situation is slightly different.
    I have a client for whom I do a lot of business... Let's say he has invoices for $100, $200 and $300. He owes $600 total and he pays me in installments. So one day he'll give me a check for $350. Should I go and create a payment for the first invoice of $100 in the amount of $100 and then a payment for $200 on the second invoice and a payment of $50 on the third? Or should I add a payment of $350 to the first invoice because that's what I got and that way I have a record of the actual payment that was made with the date on it (I also write the check number in my payment notes). And yet if I do that the other invoices will look unpaid even though the client paid for the first and the second and part of the third.

  • bmcgonagbmcgonag February 2010

    Just split it into the payment for each invoice. Just $100.00 for the first, $200 for the second, and $50.00 for the 3rd. That will still show the Third with an outstanding balance, which you can now send to your client as an updated amount owed, thus verifying your receipt and acceptance of the first payment installation.

    Also, you can send "Paid in Full" receipts to the client for the 1st two invoices for their records.

    As for the Check number in the notes, that's a great idea, and you can do that on each...just put.

    Check #XXXXX - 1
    Check #XXXXX - 2
    Check #XXXXX - 3

    Then you know that it's a part of several invoices paid on one check. If you have a situation where the negative amount owed is necessary due to complete overpayment, then use that method, but otherwise try to keep the books as neat as possible.

    Whatever works best for you and your accountant if that's someone other than you.

  • marcnycmarcnyc February 2010

    That's what I've been doing... I guess I was just wishfully thinking that I could enter every payment as one payment (and not multiple ones) and then click to assign which invoices it goes toward... it'd be nice if instead of having to type the invoice number when one enters a payment, one could click on checkboxes next to the list of invoices, you know?

  • owenhowenh August 2010

    This is a feature I have wanted for some time. If a client is behind on payments, then pays for several invoices at once, I would prefer to be able to just enter one payment and have it be automatically distributed amongst the invoices that are owed.

    I am currently working on a small mod that will allow you to automatically distribute a lump sum payment amongst multiple invoices. It will basically split overpayments amongst any unpaid invoices that the customer has.

    I will post again once I have some kind of working implementation.

  • justinjustin August 2010

    thanks owenh

    sounds like a great feature - let us know when its available

    i'll review and might add into Simple Invoices

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • owenhowenh September 2010
  • justinjustin September 2010

    thanks owenh!

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories