Help, need to reverse a transaction in QB online

JTF1 · ‎January 26, 2021

I paid an expense of £2,730 and then matched the transaction only to discover I had paid it already. The person paid the money back to my account, but then that has been recorded as income. It has resulted in there being £2,730 more in quickbooks in the bank and I don't know how to change it. If I delete the transaction coming in, it still shows the expense going out. How do I get them to match again?

GeorgiaC · ‎January 27, 2021

Hi JTF1

Thanks for getting back to us here, firstly, if you've already added the refund as income from the bank please undo this so that we can then match it once the refund is complete (to undo, go to Banking > Categorised and select 'Undo' against the transaction). After this:

1. Create a supplier credit (+ icon -> supplier credit)
2. Choose the correct date and supplier, put in the amount, choose VAT
3. Then click on the + icon again, and choose Bank Deposit, to show that the money went into your bank account
4. Choose the correct bank account on the top left corner, choose the date when the money actually hit your account
5. For Received from choose the correct supplier, for the account choose Creditors, put the amount in, choose no VAT
6. Go to the Supplier's page and create a cheque
7. Tick the deposit against the supplier credit and save and close
8. Match the deposit against the transaction on your banking screen

Please get back to us below if you have any further queries!

View solution in original post

EmmaM · ‎January 26, 2021

Hello JTF1, The amount you receive back that has been recorded as income was that a refund from the supplier can we confirm? If so it would be a case of recording the supplier credit and the separate transaction to record the money returned to the bank, but not as income as it is not really business income. Let us know and we can go through the steps here with you.:smiling_face_with_smiling_eyes:

JTF1 · ‎January 27, 2021

Thanks Emma, yes it was refunded as overpaid in error. I would very much appreciate you going through the steps, thank you!

GeorgiaC · ‎January 27, 2021

Hi JTF1

Thanks for getting back to us here, firstly, if you've already added the refund as income from the bank please undo this so that we can then match it once the refund is complete (to undo, go to Banking > Categorised and select 'Undo' against the transaction). After this:

1. Create a supplier credit (+ icon -> supplier credit)
2. Choose the correct date and supplier, put in the amount, choose VAT
3. Then click on the + icon again, and choose Bank Deposit, to show that the money went into your bank account
4. Choose the correct bank account on the top left corner, choose the date when the money actually hit your account
5. For Received from choose the correct supplier, for the account choose Creditors, put the amount in, choose no VAT
6. Go to the Supplier's page and create a cheque
7. Tick the deposit against the supplier credit and save and close
8. Match the deposit against the transaction on your banking screen

Please get back to us below if you have any further queries!

JTF1 · ‎January 27, 2021

Aw thank you this is really helpful - sadly it is asking me to upgrade in order to do this. Is there a way to do this on my existing subscription? I only have the Simple start subscription as am a sole trader. I would appreciate any support you can give with this.

emmam6 · ‎September 09, 2022

Hello Community Users, Just wanted to pop in and add some clarification to this thread. To confirm on a Simple Start package it is not possible to create supplier credits.

You can record the refund as follows>select bank deposit and in the account column of the 'add funds to this deposit' section select the same expense account that was originally used in the bill/expense. Any questions just reply to this thread.

Topics

Training

Community

Resources

Help, need to reverse a transaction in QB online