You explained the problem, but did not even touch on the solution. I can find lots of videos on telling me how to find out I have the problem. Yes when I pull the discrepancy report I can see the change, and YES I want it that way, so NOW what?
That’s because there could be 100 different reasons for the discrepancy with 100 different ways to fix it. Once you see what the discrepancy is, then you need to troubleshoot what needs to be done to fix it
Hi I have a business since 2018. I never did reconcile. What is the easy and best why to start doing reconcile for the checking account? The problem is how can I put the Beginning balance with out going back to the previous years?
To get it to balance you’ll have to enter something for previous years. You can do the recon now for the latest month, check off everything from the past and let QuickBooks enter an adjustment for how far it’s off. This is a quick and easy fix. Depending on the size of the adjustment
@@QbuniversityOrg May I ask a question about adding new item using item number in item list? Our company buys meats and we input meat inventory without using account number (item number) but I like to use for easy memory. Do u think is it a good idea to use a same item number Vendor uses for our item inventory? I think personally it’s good because I can place an order with their item number easily.
uick question: when reconciling my business checking account, QB tells me that one tansaction ws deleted, which is a credit card payment from the checking account. But that transaction is there and reconciled in the checking and credit card ledger! Any explanation?
Thank you for the video, but the begining balance in my QB is zero however there is no previous reconciliation, plz guide me to how to figure this problem out? thanks
@@QbuniversityOrg Thank you, I use QB pro 2019 and this account that I want to do reconcilation comes from 2018 and the data is restored to QB pro 2019 after backup from QB, so you mean that previous reconciliation from 2018 is wrong?
Hamid Durani no I was asking if it had been an existing account. It sounds like it is so I would look at the Previous Reconciliation report to see if it’s in there. I would also troubleshoot by entering the ending balance and starting the reconciliation to see what’s going on
The Quickbooks University Yes it is an existing account and the reconstruction is done till Oct-2018 after that the prior accounting who was in charge shifted the QB data to QB pro 2019 and now in the new QB it doesn’t show opening balance
I transitioned from QBO to QB Desktop. 9 years of bookkeeping was reconciled through the end of 2023. I've imported the banking for Jan of 2024 and QB desktop is acting like I've never reconciled this account and is insisting that we call the starting balance 0. I have no idea how to fix this.
Reconcile like normal and when the transactions come up on the screen see if one of the deposits is the opening balance. If so, check this off as part of the recon
My report won't let me double-click on the transactions I need to fix. Apparently I deleted them. They were bill payment checks that I thought were duplicates. Is there a way to correct that?
If they are deleted then unfortunately they are gone unless you have a recent backup you can restore from before you deleted them. Sounds like you’ll have to re-record them
so the company i just started with has never reconciled their QB in 10 years as they invoice manually and its recorded into QB as second copy. Year ending is July and I want to reconcile the 2018-2019 year for the accountant and start doing things properly. right now when I try reconciling it has a starting balance of $0 and a ending balance of $65,000. both which are wrong. how can i do this
Honestly I would do one big reconciliation as of 7/31, start with the $0 beginning balance, and enter the ending checking account balance. Then clear everything in the recon screen other than the recent items in the current year that did not clear by 7/31. After this I would see how big the adjustment is (how far the recon is off) and just enter an adjustment to get it correct going forward.
i would start reconciling as of august 2018-july 2019. however the difference will be in the millions. There is 9 previous years that havent been touched. Is this possible. I dont want my accountant to think I'm stupid but I'm new to this
@@abcd-xg5qo well, let's think this through. If the difference is in the millions, this essentially means that millions of either expenses or income were not recorded somehow in the bank account over those years (that's huge!). So, this means, depending on if it's a negative or positive adjustment) that millions in expenses or revenue were never reported in the past so you are essentially catching up. Personally I would discuss this with your CPA (and I wouldn't worry about them thinking you are stupid - I've met so many stupid CPA's it's not even funny) - if they are not willing to sit down and help you through it, then quite honestly you should find another CPA. Anyway, I digress. One option, and not to get all "accountant" on you, is to do the recon, and put the adjustment to retained earnings - this will essentially do what is called a "prior period adjustment" to the books to catch them up. It's not the most kosher approach and I would discuss this with the CPA to see if they are OK handling it this way, but it works to clean up and move forward.
Unfortunately you are going to need to go back and search and find where the issue is. You may have to unreconcile some previous months and then rereconcile to find it unfortunately
@@QbuniversityOrg ok thank you so much for that information. Yes I did went back amount ago and it’s was matching but it’s seems like there were some deleted transactions and everytime re-enter them it doesn’t reflect on my reconciliation still? Is there any other way to do this maybe manually?
@@tee1ibrahim112 if you are re entering the transactions they should show up on the recon. Is the date correct for that particular month on the transactions you re entered?
@@QbuniversityOrg yes I believe so the date on the deleted transaction is 12/31/19 for deposit .so i made a new entry for CK deposit for 12/31/19 then save and close, but when I went back to my rec. is still not correcting my beginning balance . I’m so sorry for the inconvenience.
@@tee1ibrahim112 oh I see. When you enter it, it will not correct the beginning balance. You will have to reconcile and check off that new deposit you entered to clear it
Mat, I hired Bookkeeper to reconcile our accounts. We will receive a bulk check of say 28,950 representing 12 customers and 19 invoices. My question somehow she reconciled to zero without including one payment from this check. The only way to fix is to unreconcile that month, Am I correct
I have one credit card transaction that was deleted after the checking account was reconciled for several months. I have now entered the payment for the credit card and marked it cleared in the checking account but my beginning balance is still wrong in quickbooks desktop. I have tried to go back to the 4th month of 2022 and just reconcile that month so my beginning balance would be correct going forward but it doesn't fix it. The only way I can see to fix it is to unreconcile all these months so that I can get my beginning balance correct starting from the 4th month of 2022. Some things in Quickbooks are stupid! It should be easy to fix this problem but it is not.
is it possible, when setting up your bank info on a fresh version of quickbooks, to put in the beginning balance as one from 2019, and still input transactions from years past? Sort of an interesting situation Im in lol
Just recently upgraded to quickbooks 2019 pro from quickbooks 2005 and I want to put in all my transactions from those years, however, the computer I used QB 2005 on is extremely out dated and is not connected to the internet. Im connecting my bank for accepting credit card payments but do not want my beginning balance to mess with any information I input that is from the past
Squad Down yeah definitely you can do that. It can get a bit tricky making sure everything matches up but it’s doable. What I mean is if, in 2019 you enter a check that cleared, then in 2018 enter that same check as written but uncleared it will double the expense. You just have to be careful of entering uncleared transactions as of 12/31/18 if you entered them in January 2019
Squad Down so make a backup of the 2005 QB to a thumb drive and restore it in QB 2019 on the new computer. It’ll bring into 2019 all your backed up data
My client has not reconciled her checking account since 2012. I’m doing the books for 2018 and I want to reconcile starting in 2018. The beginning balance isn’t correct because it is from 2012. Can this be overhauled so I can change the beginning balance to 1-31-18 and start fresh?
Instead of entering my start date of 01/01/2019 (yes, I'm behind!), I entered 01/01/2020. I have reconciled and about to start 02/01/2019 when I noticed the date issue. How do I keep the numbers - since I have reconciled - but change the date to reflect 2019? Or do I simply undo last reconciliation? I've only entered one month.
You may be able to pull up the reconciliation screen and adjust the date, but if it will not let you, you would have to undo the reconciliation unfortunately
You explained the problem, but did not even touch on the solution. I can find lots of videos on telling me how to find out I have the problem. Yes when I pull the discrepancy report I can see the change, and YES I want it that way, so NOW what?
That’s because there could be 100 different reasons for the discrepancy with 100 different ways to fix it. Once you see what the discrepancy is, then you need to troubleshoot what needs to be done to fix it
Hi
I have a business since 2018. I never did reconcile. What is the easy and best why to start doing reconcile for the checking account? The problem is how can I put the Beginning balance with out going back to the previous years?
To get it to balance you’ll have to enter something for previous years. You can do the recon now for the latest month, check off everything from the past and let QuickBooks enter an adjustment for how far it’s off. This is a quick and easy fix. Depending on the size of the adjustment
@@QbuniversityOrg
Thank you for quick reply. I will check and let you know if this work. Thank you 🙏🏻
@@ameralgram11 you’re welcome!
@@QbuniversityOrg May I ask a question about adding new item using item number in item list?
Our company buys meats and we input meat inventory without using account number (item number) but I like to use for easy memory.
Do u think is it a good idea to use a same item number Vendor uses for our item inventory? I think personally it’s good because I can place an order with their item number easily.
uick question: when reconciling my business checking account, QB tells me that one tansaction ws deleted, which is a credit card payment from the checking account. But that transaction is there and reconciled in the checking and credit card ledger! Any explanation?
Weird. No idea. Does it still allow you to reconcile?
@@QbuniversityOrg No, I agree, it's really weird.
Thank you for the video, but the begining balance in my QB is zero however there is no previous reconciliation, plz guide me to how to figure this problem out?
thanks
Hamid Durani is it a new account so the beginning balance would be zero? If not it sounds like previous transactions may not be in there.
@@QbuniversityOrg
Thank you, I use QB pro 2019 and this account that I want to do reconcilation comes from 2018 and the data is restored to QB pro 2019 after backup from QB, so you mean that previous reconciliation from 2018 is wrong?
Hamid Durani no I was asking if it had been an existing account. It sounds like it is so I would look at the Previous Reconciliation report to see if it’s in there. I would also troubleshoot by entering the ending balance and starting the reconciliation to see what’s going on
The Quickbooks University
Yes it is an existing account and the reconstruction is done till Oct-2018 after that the prior accounting who was in charge shifted the QB data to QB pro 2019 and now in the new QB it doesn’t show opening balance
Hamid Durani yeah it sounds like you’re going to have to troubleshoot and see what’s going on
the yellow circle around the cursor makes the screen fuzzy to read and follow along
Sorry. Try changing the resolution of the video in the bottom right hand corner
I transitioned from QBO to QB Desktop. 9 years of bookkeeping was reconciled through the end of 2023. I've imported the banking for Jan of 2024 and QB desktop is acting like I've never reconciled this account and is insisting that we call the starting balance 0. I have no idea how to fix this.
Reconcile like normal and when the transactions come up on the screen see if one of the deposits is the opening balance. If so, check this off as part of the recon
My report won't let me double-click on the transactions I need to fix. Apparently I deleted them. They were bill payment checks that I thought were duplicates. Is there a way to correct that?
If they are deleted then unfortunately they are gone unless you have a recent backup you can restore from before you deleted them. Sounds like you’ll have to re-record them
so the company i just started with has never reconciled their QB in 10 years as they invoice manually and its recorded into QB as second copy. Year ending is July and I want to reconcile the 2018-2019 year for the accountant and start doing things properly. right now when I try reconciling it has a starting balance of $0 and a ending balance of $65,000. both which are wrong. how can i do this
Honestly I would do one big reconciliation as of 7/31, start with the $0 beginning balance, and enter the ending checking account balance. Then clear everything in the recon screen other than the recent items in the current year that did not clear by 7/31. After this I would see how big the adjustment is (how far the recon is off) and just enter an adjustment to get it correct going forward.
i would start reconciling as of august 2018-july 2019. however the difference will be in the millions. There is 9 previous years that havent been touched. Is this possible. I dont want my accountant to think I'm stupid but I'm new to this
@@abcd-xg5qo well, let's think this through. If the difference is in the millions, this essentially means that millions of either expenses or income were not recorded somehow in the bank account over those years (that's huge!). So, this means, depending on if it's a negative or positive adjustment) that millions in expenses or revenue were never reported in the past so you are essentially catching up. Personally I would discuss this with your CPA (and I wouldn't worry about them thinking you are stupid - I've met so many stupid CPA's it's not even funny) - if they are not willing to sit down and help you through it, then quite honestly you should find another CPA. Anyway, I digress. One option, and not to get all "accountant" on you, is to do the recon, and put the adjustment to retained earnings - this will essentially do what is called a "prior period adjustment" to the books to catch them up. It's not the most kosher approach and I would discuss this with the CPA to see if they are OK handling it this way, but it works to clean up and move forward.
Hello, in reference to beginning balance not matching, I followed the video but still couldn’t locate the discrepancy. Please advise.
Unfortunately you are going to need to go back and search and find where the issue is. You may have to unreconcile some previous months and then rereconcile to find it unfortunately
@@QbuniversityOrg ok thank you so much for that information. Yes I did went back amount ago and it’s was matching but it’s seems like there were some deleted transactions and everytime re-enter them it doesn’t reflect on my reconciliation still? Is there any other way to do this maybe manually?
@@tee1ibrahim112 if you are re entering the transactions they should show up on the recon. Is the date correct for that particular month on the transactions you re entered?
@@QbuniversityOrg yes I believe so the date on the deleted transaction is 12/31/19 for deposit .so i made a new entry for CK deposit for 12/31/19 then save and close, but when I went back to my rec. is still not correcting my beginning balance . I’m so sorry for the inconvenience.
@@tee1ibrahim112 oh I see. When you enter it, it will not correct the beginning balance. You will have to reconcile and check off that new deposit you entered to clear it
Mat, I hired Bookkeeper to reconcile our accounts. We will receive a bulk check of say 28,950 representing 12 customers and 19 invoices. My question somehow she reconciled to zero without including one payment from this check. The only way to fix is to unreconcile that month, Am I correct
Yep that’s right!
I have one credit card transaction that was deleted after the checking account was reconciled for several months. I have now entered the payment for the credit card and marked it cleared in the checking account but my beginning balance is still wrong in quickbooks desktop. I have tried to go back to the 4th month of 2022 and just reconcile that month so my beginning balance would be correct going forward but it doesn't fix it. The only way I can see to fix it is to unreconcile all these months so that I can get my beginning balance correct starting from the 4th month of 2022. Some things in Quickbooks are stupid! It should be easy to fix this problem but it is not.
is it possible, when setting up your bank info on a fresh version of quickbooks, to put in the beginning balance as one from 2019, and still input transactions from years past? Sort of an interesting situation Im in lol
Just recently upgraded to quickbooks 2019 pro from quickbooks 2005 and I want to put in all my transactions from those years, however, the computer I used QB 2005 on is extremely out dated and is not connected to the internet. Im connecting my bank for accepting credit card payments but do not want my beginning balance to mess with any information I input that is from the past
Squad Down yeah definitely you can do that. It can get a bit tricky making sure everything matches up but it’s doable. What I mean is if, in 2019 you enter a check that cleared, then in 2018 enter that same check as written but uncleared it will double the expense. You just have to be careful of entering uncleared transactions as of 12/31/18 if you entered them in January 2019
Squad Down so make a backup of the 2005 QB to a thumb drive and restore it in QB 2019 on the new computer. It’ll bring into 2019 all your backed up data
The Quickbooks University okay good deal! Thanks again!
Squad Down welcome!
My client has not reconciled her checking account since 2012. I’m doing the books for 2018 and I want to reconcile starting in 2018. The beginning balance isn’t correct because it is from 2012. Can this be overhauled so I can change the beginning balance to 1-31-18 and start fresh?
Absolutely. What I would do is do one big recon as of 12/31/17 and enter an adjustment as of then. Then start fresh as of 1/1/18
Instead of entering my start date of 01/01/2019 (yes, I'm behind!), I entered 01/01/2020. I have reconciled and about to start 02/01/2019 when I noticed the date issue. How do I keep the numbers - since I have reconciled - but change the date to reflect 2019? Or do I simply undo last reconciliation? I've only entered one month.
You may be able to pull up the reconciliation screen and adjust the date, but if it will not let you, you would have to undo the reconciliation unfortunately
Former employee messed up with qb. Bank balance shows -$9999000
Can I just clean up all and try as new start $0?
3:10
my quickbooks looks nothing like this
Are you using QuickBooks online or maybe QuickBooks simple start?