Hi,
I have posted sales on account in the month of June, now need to correct it but as we have perfomed month end I can't simply delete it.
I can't jopurnal it out of the bank as rec's have also been completed. So it's sits as an overpayment on customer record and due the currency exchange (EUR) my bank balances each month are out by this ammount.
Any advice how i can reverse it?
Thanks
Replies (12)
Please login or register to join the discussion.
What exactly do you mean here?
Have you posted a cash receipt to a sales ledger account.
Deleting a transaction is almost never the way to go.
How can bank balances be 'out' - what are you comparing to what?
If you cannot re-open the period and reverse the transaction, you need to reverse it in the first open period.
You have not said what software you are using, but a customer refund would probably do the trick.
Let me get this straight. As far as Sage is concerned, your customer has overpaid. Processing a customer refund doubles up the error?
This does not make sense.
What is the error that is being doubled up?
I assume that the customer balance is changing, and something else.
Is this the bank balance or sales?
What version of Sage Line 50 do you have?
- The latest is SL50 2016 / version 22
I only ask because Sage keep changing the UI, and knowing what screen you are looking at will make instructions easier.
Are you saying that in addition to the overpayment, the customer has also been invoiced too much?
In that case you need to raise a sales credit (SC) for the difference.
In summary,
A customer refund to get the bank balance right and
an SC to correct the invoice.
What is the transaction that actually occurred?
A receipt of cash from a customer?
In what currency?
How much?
If not in GBP was it immediately converted into GBP and paid into a GBP bank account, or was it paid into a bank account in another currency?
Note I am not asking about the accounting entries that have been made to record the transaction, but about the events themselves.
What is the transaction that actually occurred?
A receipt of cash from a customer?
In what currency?
How much?
If not in GBP was it immediately converted into GBP and paid into a GBP bank account, or was it paid into a bank account in another currency?
Note I am not asking about the accounting entries that have been made to record the transaction, but about the events themselves.
I was struggling to ascertain that one too,
At the moment you have to many customer receipts.
(assuming your original transaction was misposted)
You thus need a customer payment to correct it, as jndavs correctly identified.
If you are 'doubling up' I suggest you are confusing a refund to a customer with a credit note.
It has been many years since I used S50, so if it doesn't have the customer payment option you may need to post an invoice instead.
Code it to nominal 9999, using VAT code T9.
Then match the transactions against each other, which should clear your FX issue.
Then, to correct the bank, post a bank payment to the suspense account.
then reconcile your bank