Forum Discussion

debbie123456's avatar
7 months ago

customer statement and customer transaction report shows no transaction for selected customer

A customer has paid us twice and asked us to hold the funds for next year.

They have an invoice, an invoice payment and now a cash received item against their account.

 

None of these show in the customer transactions report and only the invoice and associated payment show in the customer statement.

 

What am I doing wrong? 

Thanks

4 Replies

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator
    7 months ago

    Hi debbie123456,

     

    If your customer has paid too much, record the entire payment and a customer return (credit) will be created for the overpaid amount. This credit can be held for future use or refunded, depending on the customer's preference.

     

    You can leave the extra payment as a credit on the customer's account. When the next year's invoices are created, you can apply this credit toward those invoices. Here's a link that has information to guide you: Customer overpayments.

     

    Regards,

    Sai

  • Thanks for the quick reply Sai.

    I'm not sure that will work in this case, as they have paid us twice in two separate transactions in two different months.

    Regards,
    Debbie

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    7 months ago

    Hi debbie123456,

    Please check the invoice in the Banking > Find Transactions tab and the General Ledger (GL) report. If the invoice is not there, it might have been deleted. Additionally, please check the Journal Security Audit report to see if the invoice was deleted or edited.

    Regards,
    Earl

  • Sorry, I still don't think I have explained the issue correctly.

    The invoice is there. They paid it in one month. This has all been closed off and balanced.

    The next month, they paid the same amount again. I do not have an invoice for this, as they are wanting to keep this as a credit against their account.

    I created a cash receipt against their account, but that cash receipt is not showing correctly.

     

    But as I have not been able to sort this, we have told them we can't keep the funds and have refunded it to them. I now need to go and delete the cash receipt I created, and hopefully everything will reconcile.