Refunding part of Pre-paid deposit

Hi I'm using Sage 50 Premium - I received a deposit from a customer for goods yet to be delivered. However, the deposit was overpaid by about $20,000.00 which I have refunded to the customer by hand-written cheque. This still leaves a large deposit from the customer. How do I reduce the original deposit and make payment to the customer for the $20,000.00 whilst still retaining the balance of the deposit in the Prepaid Sales/Deposit account?

I have followed one suggestion here which was to create a fake invoice to a holding account, apply deposit to this invoice and post then make payment to customer. However, this removes the total deposit from the Prepaid Sales/Deposit account as well as reducing the bank account by the full amount.

  • 0
    if you don't have one, create a 'clearing bank' account
    create an AR invoice for 20K with account = clearing bank
    make a payment, pay the 20K invoice with 20K of the deposit, leaving the remainder of the deposit in prepaid sales
    this will fix the AR with the correct deposit, leaving the clearing bank with a credit

    set up the customer as vendor (add a '-' to the name to make it unique)
    make an AP payment (pay expenses) by cheque for 20K with account = clearing bank
    leaving the clearing bank with a zero-balance
  • 0 in reply to Roger L
    Hi Roger L

    Thank you for your help - it worked and now got it all done. Much appreciated :)