removing pending payment in General Ledger that doesn't exist

SUGGESTED

I'm new to Sage and bookkeeping. I was posting a deposit in a sale invoice. I used pay later and cheque. I then discovered that a previous transaction for the deposit had already occurred.  in the confusion, both payments got reversed with credit memos. Now the client has a credit balance for the 2 deposits and the GL is waiting for payment from the one that i did. I need to reverse it so that the client doesn't show a credit balance and also how do i take it out of pending payment  in the GL . it's showing a variance when i try to reconcile because of the deposit i did as "pay later" ? can anyone help? 

  • 0
    SUGGESTED

    Hi Angelika:

    The best way to handle this is to go backwards from what you last entered. Reverse or void both credit notes then reverse or void the last payment by cheque that you entered which made a duplicate payment. What you should have now is a sales invoice that is outstanding and a prepayment towards the previous sales invoice. Next in the Receipts screen pay the invoice and apply the prepayment so the net receipt is zero. Date the transaction with the date of the sales invoice and record as a cash transaction (it will not affect the bank because there is no money involved). This should alleviate your issues.

    Hope this helps!

  • 0 in reply to Agate

    thank you so much, i'll give that a try tomorrow. Another question: someone on our sales floor took a $5 debit payment from a customer in order to give them back $5 cash  for parking. Now i have a $5 debit and i'm out $5 cash. Do you know how to fix that so i balance? Thank you for your patience as i'm new to all of this!

  • 0
    SUGGESTED

    Hi Angelika:

    There are several ways to do this. You can record the debit as a miscellaneous sale and then record a cash payout though purchase invoices to the same miscellaneous sales account. You may also create a journal entry recording the debit and the withdrawal of cash. In all cases the only difference is your cash drawer is going to be out by $5.00 and your bank account is going to increase by $5.00. It almost sounds as if you are using two separate accounts one for the cash drawer and one for the actual bank account. If this is the case just journalize a transfer from one account to the other if I understand your situation.

    Hope this helps!

  • 0 in reply to Agate

    Hi There,

    is there any way to remove the "false credits from the client account? There aren't any sales invoices anymore  as we deleted them in error when what i should have done was delete the payment so when i go to reverse the credits in the payment screen  , there aren't any sales invoices to refer too. Any suggestions? Thank you !

  • 0

    Angelika:

    If you deleted them in error then you must enter them back in. Once they have been entered go to the receipts screen and apply the newly created invoices against the credits so your receipt comes to a zero balance.

    Hope this helps!