Love it! I just spent 4 hours searching through videos and saw a bunch of them trying to explain the reconciliation steps but they all kept skipping. If we were accountants or bookkeepers, we wouldn't be looking for videos that explain basic steps. I need a video just like yours to EXPLAIN things. Thank you so much!!
Thank you for this tutorial,now I want to ask you what can correct my bank in Balance sheet where it shows negative while I have reconciled everything??? Kindly advise me
Hi I have Question, 1. In impoting the bank feed, is there a possibility to import wrong or incorrect transaction in bank statement? how to resolved it?
i guess Im asking randomly but does any of you know of a way to log back into an instagram account..? I was stupid forgot the login password. I would appreciate any help you can give me!
@Jaxson Alberto thanks so much for your reply. I found the site on google and im in the hacking process now. I see it takes a while so I will get back to you later when my account password hopefully is recovered.
Hi, thanks a lot for the easier bank reconciliation tutorial. Could you please to tell me how to remove the bank transaction after uploading into Xero? waiting for your reply
Thanks for the tutorial. This may not happen often but, how do you handle a transaction that is correct in Xero but incorrect on the Bank Statement? Thank you
@@NutsAccounting Hi Sharon. No I have not but, I just needed to know in the event that this may happen. I've encountered this before at another company with a different bank. Thanks
But Ms. Sharon, may I ask, I'm a bit confused with regards reconciling the Business Savings Acct in Xero Demo Company. There are prior period reconciling items which I can't find a match in the Account transactions. Why I don't see an OK button, and tabs for Match, Create, Transfer, Discuss, Find & Match. I imported the csv file of the bank statement and there are reconciling items that popped out but I don't know how to proceed because the tabs are missing. I don't know if there was a locked period on it. The video tutorials I watched focused only on Business Bank Acct which reconciling items arise in current year. How do I go about prior period reconciling items?
Hi Sharon, what if i get my software change from MYOB to Xero, how can i get my unpresented chq of my bank from last year carried forward to the opening bal in xero system? Your help is highly appreciated. Thank you.
I't seems bank recon in Xero interface is easier than in QB becoz side by side you can see the bank statement data vs the Xero data and it's not that complicated , am I right Mam?
If your bank statement is in Xero while your account transactions are not created yet, its even easier to create your account transactions based on your bank statement.
I get confused with the sales tax and how it’s getting entered. If I add the “tax rate” when I create a reference is it being entered as a portion of the “spent/received” amount. And is the “tax rate” then used to crest the Sales tax summary?
Hi! Do I need to update the opening balance if I do the reconciliation everyday ? For example I have done my reconciliation for 17th July and if I have to do the reconciliation from 18th of July. Do I need to update the opening balance for 18th July that I got as a closing balance from 17th July ?? Thank you.
Hi Sanjay! You don't need to update the opening balances everytime. In your example, your closing balance of 17th July will be your opening balance for 18th July. =)
Hi! Is the Bank Balance and xero balanced needed to be equal? What if i deleted line items, will they still be equal? Thank you Also, i experience that there are invoices with payment already so they don't appear when I find and match. What can I do to make them appear in Find and Match? Thank you so much!
Hi Jessica Avila! The purpose of bank reconciliation exercise is to ensure that your transactions in Xero accounting matches the transactions in your bank statement. Hence, bank statement balance and balance in Xero must be equal to achieve bank reconciliation. If your bank reconciliation is done and your balances matched, do not delete, add new or edit any of the transactions to the reconciled period. It should be closed and not be touched anymore. Any changes to the reconciled period will alter the balances and it will not be reconciled. If you have clicked "OK" on the transaction in the reconciliation page, it will disappear from your reconciliation page. If you have not clicked "OK" and it still doesn't appear in your reconciliation page, check your payment transaction if the bank account is correct. Try out the above and let me know how it goes! =)
Hi your video very helpful I a small business owner trying to do my own accounts my questions 1. The balance from bank account =. Xero account? IF not match how to fix it 2. Creditnote from suppliers I have a problem about this could you show how to reconcile please Thank you
Hi ma'am, I'm from Philippines. I'm finding a part time job where I can use my knowledge in xero acctg, I have earn my xero advisor certification last June 2020. I do practices and watched different tutorials in youtube including yours. I'm asking for your help if you could hire me as your bookkeeper, only part time because I'm currently working full time monday to friday 7am-5:30pm as bookkeeper.
Hi Tshepzinto! If you have followed through all the steps in the tutorial and the balance still doesn't match, it'll difficult for me to say exactly what's the problem and how to fix it without looking at your Xero accounts. Here are some questions to help you to troubleshoot your problem. 1) Is your previous month's bank reconciliation completed and balances matched? 2) Is your Statement Balance (as shown in Xero) same as the balance shown in your bank statement after you have imported your bank statement (CSV file) or bank feed? (The balances as at the date that you want to reconcile) 3) Are all the transactions in your Bank Reconciliation page matched and cleared? Try to check if these are done. Let me know how is your bank reconciliation after you have troubleshoot these! Waiting to hear from you! 😀
@@NutsAccounting my actual bank account and xero balance not balancing all reconciliation done, I will just escalate the issue to Xero. Thank you for your reply.
Thank youvey much ,but i never get or not consum any money because y banks has freeze my acounts is very suspct for me who get my money inmy name i not know about never thank you GR
Love it! I just spent 4 hours searching through videos and saw a bunch of them trying to explain the reconciliation steps but they all kept skipping. If we were accountants or bookkeepers, we wouldn't be looking for videos that explain basic steps. I need a video just like yours to EXPLAIN things. Thank you so much!!
I had so many doubts, but now you have just made it crystal clear. Thank you Sharon! :)
Which method do you use: bank feed or CSV import? What other Xero tutorial you would like to learn? Let me know in the comments below!
2
A great video: very clear, helpful and well organised. Thank you!
So nice your explanation
Thank you for this tutorial,now I want to ask you what can correct my bank in Balance sheet where it shows negative while I have reconciled everything???
Kindly advise me
Hi; do you offer one to one tutoring, if yes please let me know, I need help with xero.
Hi,how to do bank reconcile for salary without using payroll?
Amazing Video. Crystal Clearly Explained. Very Knowledgeable
Hi, may I know you capture the reconciling items such as unpresented cheques in Xero? Thanks
Hi I have Question,
1. In impoting the bank feed, is there a possibility to import wrong or incorrect transaction in bank statement? how to resolved it?
Today I found your tutorials ,very helpfull . Thanx for sharing this vedio
How can I access the Xero Site, so that I can practice an explore more inside. Thankyou
csv import method. Tutorial is good to learn for me. thanks
I really love you as an accounting teacher! Huhu thank you for sharing your knowledge and for your energy! ....and you sound so humble
Thank you for your compliments, Daryll! It's my pleasure to be your guide in your bookkeeping learning journey! :)
i guess Im asking randomly but does any of you know of a way to log back into an instagram account..?
I was stupid forgot the login password. I would appreciate any help you can give me!
@Clark Nikolai Instablaster ;)
@Jaxson Alberto thanks so much for your reply. I found the site on google and im in the hacking process now.
I see it takes a while so I will get back to you later when my account password hopefully is recovered.
@Jaxson Alberto It did the trick and I finally got access to my account again. Im so happy:D
Thanks so much, you saved my account !
Great explaination!!!
Great 😃👍
Hi, thanks a lot for the easier bank reconciliation tutorial. Could you please to tell me how to remove the bank transaction after uploading into Xero? waiting for your reply
Hi Rabd! Your question will be answered in tomorrow's live Q&A session: ua-cam.com/video/aFeMSEL4mLE/v-deo.html
Thanks for the tutorial. This may not happen often but, how do you handle a transaction that is correct in Xero but incorrect on the Bank Statement? Thank you
Hi Nathalie! Have you checked with your bank if the transaction is confirmed to be incorrect?
@@NutsAccounting Hi Sharon. No I have not but, I just needed to know in the event that this may happen. I've encountered this before at another company with a different bank. Thanks
But Ms. Sharon, may I ask, I'm a bit confused with regards reconciling the Business Savings Acct in Xero Demo Company. There are prior period reconciling items which I can't find a match in the Account transactions. Why I don't see an OK button, and tabs for Match, Create, Transfer, Discuss, Find & Match. I imported the csv file of the bank statement and there are reconciling items that popped out but I don't know how to proceed because the tabs are missing. I don't know if there was a locked period on it. The video tutorials I watched focused only on Business Bank Acct which reconciling items arise in current year. How do I go about prior period reconciling items?
Hi Sharon, what if i get my software change from MYOB to Xero, how can i get my unpresented chq of my bank from last year carried forward to the opening bal in xero system? Your help is highly appreciated. Thank you.
You are very nice person thank you for great explication the at s why i love to work with peoples like you GR
Thank you Global RodicaGazii for your support! We'll do our best to produce more videos for you! :)
Thanks
I't seems bank recon in Xero interface is easier than in QB becoz side by side you can see the bank statement data vs the Xero data and it's not that complicated , am I right Mam?
Hi Marivel, yes, having the bank statement and account transactions side by side is easy for bank reconciliation.
If your bank statement is in Xero while your account transactions are not created yet, its even easier to create your account transactions based on your bank statement.
I get confused with the sales tax and how it’s getting entered. If I add the “tax rate” when I create a reference is it being entered as a portion of the “spent/received” amount. And is the “tax rate” then used to crest the Sales tax summary?
very good
hi how about if I just use xero accounting just this time but my business run year ago, what will i do?
Dear mam
How get to xerox account software tell me same tally software
Hi! Do I need to update the opening balance if I do the reconciliation everyday ? For example I have done my reconciliation for 17th July and if I have to do the reconciliation from 18th of July. Do I need to update the opening balance for 18th July that I got as a closing balance from 17th July ?? Thank you.
Hi Sanjay! You don't need to update the opening balances everytime. In your example, your closing balance of 17th July will be your opening balance for 18th July. =)
Hi! Is the Bank Balance and xero balanced needed to be equal? What if i deleted line items, will they still be equal? Thank you
Also, i experience that there are invoices with payment already so they don't appear when I find and match. What can I do to make them appear in Find and Match?
Thank you so much!
Hi Jessica Avila! The purpose of bank reconciliation exercise is to ensure that your transactions in Xero accounting matches the transactions in your bank statement. Hence, bank statement balance and balance in Xero must be equal to achieve bank reconciliation.
If your bank reconciliation is done and your balances matched, do not delete, add new or edit any of the transactions to the reconciled period. It should be closed and not be touched anymore. Any changes to the reconciled period will alter the balances and it will not be reconciled.
If you have clicked "OK" on the transaction in the reconciliation page, it will disappear from your reconciliation page. If you have not clicked "OK" and it still doesn't appear in your reconciliation page, check your payment transaction if the bank account is correct.
Try out the above and let me know how it goes! =)
Hi your video very helpful I a small business owner trying to do my own accounts my questions
1. The balance from bank account =. Xero account? IF not match how to fix it
2. Creditnote from suppliers I have a problem about this could you show how to reconcile please
Thank you
Hi there! Your question will be answered in tomorrow's live Q&A session: ua-cam.com/video/aFeMSEL4mLE/v-deo.html
Thank you so much xx
there is no caption in this video
Hi Angus! Thanks for highlighting! We'll work on it to add in subtitles soon!
Plz tell about Hindi Indian language
Hi ma'am, I'm from Philippines. I'm finding a part time job where I can use my knowledge in xero acctg, I have earn my xero advisor certification last June 2020. I do practices and watched different tutorials in youtube including yours. I'm asking for your help if you could hire me as your bookkeeper, only part time because I'm currently working full time monday to friday 7am-5:30pm as bookkeeper.
could u please tell me how to get xero advisor certification?
Dear mam
You are explain very well i have small douit accounting voucher, petty cash, cash book and Pass Book
pls can you help me that xero o
pls
My reconciliation is done, but does not match by bank statement on actual account. How can I fix this?
Hi Tshepzinto! If you have followed through all the steps in the tutorial and the balance still doesn't match, it'll difficult for me to say exactly what's the problem and how to fix it without looking at your Xero accounts. Here are some questions to help you to troubleshoot your problem.
1) Is your previous month's bank reconciliation completed and balances matched?
2) Is your Statement Balance (as shown in Xero) same as the balance shown in your bank statement after you have imported your bank statement (CSV file) or bank feed? (The balances as at the date that you want to reconcile)
3) Are all the transactions in your Bank Reconciliation page matched and cleared?
Try to check if these are done. Let me know how is your bank reconciliation after you have troubleshoot these! Waiting to hear from you! 😀
@@NutsAccounting my actual bank account and xero balance not balancing all reconciliation done, I will just escalate the issue to Xero. Thank you for your reply.
You're welcome. Hope your issue resolved soon!
Thank youvey much ,but i never get or not consum any money because y banks has freeze my acounts is very suspct for me who get my money inmy name i not know about never thank you GR
1
thank you so much this really helpful and informative.
2
Thanks
1
Thank you