Forum Discussion

TonyLaser3D's avatar
TonyLaser3D
Contributing Cover User
2 days ago

Customer Deposit

We raise customer sales orders and receive payments against the orders raised. When the sales orders are converted to an invoice, the deposit is transferred from the liability account to the debtors account. However, my question is, which report can I run to see a summary of the list of all the customer sales orders raised with their payments made against it? Basically, there's a running balance in this customer deposit a/c in MYOB but from this balance, how do I know which customers have paid us a deposit.

Thanks.

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator

    Hi TonyLaser3D,

    You can use the Sales [Customer Detail] Report in AccountRight. This report includes detailed information about each sales order and the payments made against them. Please see this help page Sales reports then scroll down to Sales [Customer Detail] report for more information.

     

    Regards,
    Earl

    • TonyLaser3D's avatar
      TonyLaser3D
      Contributing Cover User

      Hi Earl_HD,

      Thanks for sharing.

      I tried running that report and filter the Sales Status to "Orders" only.

      There is a list of the customers with outstanding orders showing a total of $30,063.30 of customer deposits received.

      However, in the ledger account 2-1600 "Customer Deposits" it shows a different balance for the same period (ie at end of Feb 2025 the a/c balance is $63,233.43 which is different to the total showing on this Sales report.

      I am expecting the 2 balances to agree, have I missed anything? 

      Thanks & Regards,
      Tony

       

      • Earl_HD's avatar
        Earl_HD
        MYOB Moderator

        Hi TonyLaser3D,

        The only reason that I can think of is there may have been manual adjustments made to either the Sales Status report or the ledger accounts that have not yet been synced. It's better to consult with your accountant for an accurate answer.

        Regards,
        Earl