What is the difference between remove and redo, delete and reconcile or unreconcile in Xero accounts? It can be confusing when tidying up your bank account to know where you should look and which option you should use ...
If you just need some help getting your Xero all spick and span then you can book a handholding session with me!
You need to get your statement balance to match your Xero balance so you know the bank is correct in your accounts. So, it depends on where in Xero you choose these options and can be tied in with the statements page or the transactions page. It also depends if it is a payment or receipt on an invoice or a 'spend money or receive money' transaction.
"How to remove and redo from the bank statement page!"
Remove and redo on an invoice or bill payment deletes the receipt or bill payment, but then returns the bill or receipt to being unpaid. On a spend money or receive money transaction this will delete the transaction. The way you can identify which is which is that if the transaction is connected to an invoice or bill it will say 'payment' before the contact name on the transaction pages.
If the invoice or bill is not needed you need to go and void that too; often my clients put invoices in twice and pay both so you have to delete them in two stages. In both cases, the imported bank transaction it had been reconciled to is returned to the reconcile page where it can be reconciled again.
"How to unreconcile or remove and redo from the transaction page!"
Unreconcile just removes the link between the imported bank statement line and the entry in Xero, but doesn't delete anything. It is useful if a transaction has been allocated against a bank entry on the wrong date, but is still needed. I find that handy with clients who have a monthly bill going out for the same amount who then get out of sync with their allocations.
Remove and redo deletes the payment or receipt, but then if it is associated with an invoice the invoice will then be marked as outstanding again and the imported bank transaction it had been reconciled to is returned to the reconcile page where it can be reconciled again. This will then leave you in the invoice or bill so you can see if you need to void it or not.
"How to remove and redo from the account transactions page"
If you choose to remove and redo from the account transactions page, it just deletes the payment or receipt, and if it was associated with an invoice you would need to go and find it yourself to void if needed. That isn't a problem if it is a spend or receive money transaction.
"What about the bank statement page?"
The last thing you might want to delete in the bank is duplicate statement lines if you have accidentally imported the same transaction twice or the bank feed has had a funny turn which does happen from time to time.
If you delete a bank statement line which has already been reconciled then you would also then need to go to the account transactions page and delete it there too as the deletion only deletes the imported statement line, not the associated transactions.
This is only needed if imports or bank feeds have gone wrong. If you delete an unreconciled bank statement line then there is nothing else to remove. You can always see on the page if lines have been deleted from the bank statement and you can choose to restore them if they have been deleted incorrectly.
"What if there are missing imported bank statement lines?"
When an item is on the transaction page and is unreconciled and you know the payment should be there, but there was no bank feed or imported statement line to reconcile it to, then you can choose to reconcile manually. This is good if the bank had a blip and just missed one import or if you are just missing a few days of transactions.
When you manually mark an item as reconciled it will then appear on the bank statements page as a 'source' user and the account transactions page as reconciled.
You may need to 'enable mark as reconciled' if the option is not available to you. This can be found at the bottom of the menu when you click on the ? in the top menu bar in Xero when you are in a bank account. It switches it on for all bank accounts, but for your log in only.
As always, if all this information is a bit overwhelming and you just need some help getting your Xero all spick and span and correct then you can book a handholding session with me to go through it with you and show you how all the options work!
I do also undertake Xero tidying jobs as I find it very satisfying getting a messy Xero company all neat and tidy.
If anything I've written in this blog post resonates with you and you'd like to discover more about Xero or would like a handholding session or a Xero tidy-up, it may be a great idea to give me a call on 01604 217365 and let's see how I can help.
Alison loves bookkeeping and supporting bookkeepers. She has been helping clients to be better bookkeepers in Sage 50 for over 24 years and has been Xero Accredited in accounts and payroll for a number of years too.
She specialises in a very unique hand-holding method of training, helping bookkeepers and business owners to use their accounts software as and when they need support in setting up and producing their invoices, reports and financial information.
Alison combines her role at Silicon Bullet with her Forever Living network marketing businesses and is often to be seen at business networking meetings as she likes to keep busy.
You know what they say: if you want something done well ask a busy person!
No unauthorised use, duplication, distribution or modification to any original content contained within this blog is permitted without prior written permission of the author. All other trademarks and registered names are acknowledged.