Forum Discussion

JenCas's avatar
JenCas
Contributing Cover User
1 year ago

any work around for adding a deposit to an order?

Hoping someone has worked out a way to apply a deposit to an order ? A deposit is often paid a month before the invoice is raised - with MYOB Business i can no longer place a payment against an order - don't want to invoice as the client that early as it leads to them receiving  overdue notices.  Not being able to apply deposit is making reconciling bank so time consuming - have made it a suggestion to MYOB but not having the ability to apply a deposit is adding hours of work

Grateful for any suggestions / help 

14 Replies

  • colleenWatson's avatar
    colleenWatson
    Experienced Cover User

    https://community.myob.com/discussions/bus-sales/any-work-around-for-adding-a-deposit-to-an-order/868790/replies/876393

     

  • colleenWatson's avatar
    colleenWatson
    Experienced Cover User

    Hi Mike

    That is ok if your order becomes a sale in a short time.

    My S/O can be up to 12 months before they become a sale. Reconciling my deposit-held account can sometimes be frustrating, but that is what it is.

    What I have come up with is:

    1. Create your sales order as usual.

    2. Create a customer service invoice with tax as (NT)

     (I use the s/o no. with a C, e.g. 123C, to keep track if needed)

    with the deposit amount to the liability account for customer deposits.

    In the following line, do a (-)credit for the same amount to the bank account where the money was deposited.

    This will be a nil invoice. It puts the deposit into the deposits held and the banking account to be reconciled.

    3. When the S/O becomes a sale.

    a. I use the S/O no. as the invoice no.

    b. Create a credit invoice for the deposit amount to Customer deposits held. Tax (NT)

    c. Allocate credit to the customer's invoice.

     

    The Customer Held account has two entries, DR and CR.

    The invoice has the correct balance after the deposit has been allocated.

     

    I hope this helps

     

     

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User

    Until a proper solution is provided, here's a workaround (untested) that I have seen posted elsewhere:

    • create a "Deposits held" liability account, type Credit card
    • Use Receive Money to record the deposit to that account. Put the customer name and order number in the reference.
    • On the invoice, add a negative line, no GST, for the deposit, allocated to that account.

     

  • colleenWatson's avatar
    colleenWatson
    Experienced Cover User

    I am working on it, but it is a three/four-step solution. I am just checking to see how it affects reporting and GST.

  • JenCas's avatar
    JenCas
    Contributing Cover User

    Hi Earl - thanks for the links but no what i am after - i wish do be ale to put a deposit towards an order - which would become an invoice once goods are ready 

    • Mike_O's avatar
      Mike_O
      Member

      Earl I have the same issue that Jen has, I swapped over from Account Right to Business Lite recently to save money. But like Jen the work arounds suggested in this post are way to complex when it should be simple task like it is in Account Right. We receive payment before delivery on all orders for items in our on line store. Often we don't have items in stock and we have to order in from suppliers. When I raised the purchase order in Account Right I simply allocated the pre-payment to the sales order. When the stock arrives I convert the order to an invoice and transfer the payment from deposits across to the invoice. Simple. In Account Lite you can't do this. Very frustrating. In desperation I have made up dummy invoices for items I do have in stock which I convert to the same value as the order. But this is time consuming and not a viable solution. Are MYOB looking seriously at rectifying this ? Should be a straightforward simple exercise. If not will have to revert back to Account Right.

      • Doreen_P's avatar
        Doreen_P
        MYOB Moderator

        Hi Mike_O,

         

        Apologies for any inconvenience this may have caused you. To help you add a deposit to an order, please refer to this helpful community forum post: Adding a Deposit to an Order. This guide should provide you with the steps you need.

         

        Best regards,

        Doreen

    • colleenWatson's avatar
      colleenWatson
      Experienced Cover User

      https://community.myob.com/discussions/bus-sales/any-work-around-for-adding-a-deposit-to-an-order/868790/replies/876393

       

      my solution

    • JenCas's avatar
      JenCas
      Contributing Cover User

      Still having the issue