How to Add Missing Expense (& Deposit) Transactions to QuickBooks Online
Вставка
- Опубліковано 12 вер 2024
- I recommend QuickBooks Online for your small business bookkeeping. Get the current QuickBooks Online deal through my referral link: www.SmallBusin...
Most of the time, every transaction from your bank account or credit card will be automatically brought into QuickBooks Online. However, every once in a while, for many different reasons, an expense or a deposit will be missing from your QuickBooks Online bank feed. You'll often catch this issue when you go to perform your account reconciliation at the end of the month.
This is the scenario we have here. The electronic connection between the credit card account and QuickBooks was temporarily lost for a few days in the month. Now, we need to add in the missed transactions manually. We'll do this through the Plus button - Expense. It's easy!
The same process also works for deposits!
For more small business bookkeeping help, check out my other videos and my website, www.SmallBusin...
This video is for informational purposes only and does not constitute accounting or tax advice.
This is exactly what I needed. You're fantastic! Simple, short and to the point. Thank you for making this video!
The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.
I was pulling my hair out until I saw this video. I linked my bank accounts and then realized quickbooks never uploaded my expense from the entire month of January, it all only recorded my January sales, thanks again!!!
Glad it was helpful! If you have a huge chunk of missing transactions, you can also upload a CSV file. From the Banking page, go to the carrot dropdown next to Link Account, and you can upload a CSV file that way. I recommend using two columns for your CSV file. One for money coming in, the other for money going out, that just makes it easier to get the upload correct. Good luck!
Sarah Korhnak saving my life one video at a time. Bless you, and ROCK ON!!
Thanks for watching and commenting!
Perfect! I am going to come directly to your page next time I have questions. Thank you!
I'm so glad!
Great explanation. Simple and short. Thank you.
Great video. It was just what I needed. Thank you so much.
MANY THANK YOUs Sarah. A simple thing but when you experience it as a newbie, you really appreciate it.
Glad it was helpful!
Life saver thanks! Saving your page, straight to the point.
Nice video, clearly understood
Great video Sarah! It's just want I needed today. Thank you.
So glad!
It was just what I needed. Thank you so much.
You're welcome!
Thank you so much!! Easy to follow and understand
Super helpful, thanks Sarah!
THANK YOU! Just what I needed to know.
This is a fairly common problem I see. Thanks for the vid. I keep having them dropping random transactions. Got to keep a tight eye on it. I've let it get out of control. Now have to add in a few hundred transactions. Again. Thanks for the vid.
If it's easier you could compile your missing transactions on a CSV file and then do a big file upload of the transactions. Might be faster. The method discussed in the video works well for one off transactions. Good luck!
@SmallBusinessSarah ty Sarah! Unfortunately I have hundreds and hundreds of transactions missing from about 3.5 months. It just boggles my mind that QB would not have an option in which you can "ask it" to relink to an account (my business bank account for ex.) during a specified time period?? Why isn't this a feature offered through QB. As you replied to the lady above would you recommend I do the same, compile all missing transactions on a CSV file and then do that file upload of the transactions? I sure appreciate you sharing that advice...but of course, I still don't know how to do that. Do you happen to have a video on that? Ugh....it sure is frustrating. Thank you for your wonderful information instruction.
😊 I think I found a video on how to do it...hoping it works....tnx again, you set me on the right path to find the information.
Thanks dude it worked 🎉
Thank you so much for this!
You're so welcome!
Very helpful! (Especially right before Tax Season!)
Excellent! I am extremely pleased with your tutorial. Thank you
Glad it was helpful!
Thank you, such clear instruction. Really enjoy your videos.
Thanks for watching!
Great!! Helped me out massively, thank you 😊
You saved my day!!! Thank you!!!
I'm so glad!
Thank you Sarah !! 😊
THANK YOU!!!
Great Video! I think we can also upload the missing transactions from banking tools to bank feeds.
Yes! If there were a lot of transactions, that would be a great option!
short n sweet thanks
So helpful!! Thank you!!
Glad it was helpful!
Thank you!
Great Job! . Very clear.
thank you very helpful
Glad it helped
Thank you for your assistance!
Happy to help!
Thank you! Do you click Reconcile at the end?
Yes, I do reconcile these accounts once I have added the missing information. When you go to reconcile, the items you added won't initially be checked off. So scroll down, find the transactions you added, and then check the box so that everything does reconcile correctly.
Love the channel.
Hi Sarah, great and helpful video. One question: there’s a discrepancy of $388+ for December 2023, I triple checked my bank statement made sure all transactions were accounted for, the date, beginning and ending balance is correct….so now what? Should I just click ‘Finish Now’ anyway? Thanks.
Hmm. That's unusual if you have checked everything. Sometimes it helps to use the info at the top of the reconciliation where it shows the deposit total figure then the expense total figure, so you can isolate where the mistake is. Or it can help to review the register for any transactions without a green box. Or it can be helpful to do the reconciliation for a smaller chunk of time if possible, like a week at a time. Just some ideas if you want to keep looking! But if you don't want to keep looking, which is perfectly fine, then yes, just Finish the reconciliation anyway and let QB put in an AJE to get you back on track.
Hi there, thanks for this. great tutor! qu... what if im manually adding multiple transactions from the same customer, is the a quicker way?
You can also upload CSV files if you have a large group of missing transactions. You can find that option on the Banking Tab.
@@SmallBusinessSarah do you have a tutorial for uploading these CSV files?
How do I go back and add last year’s transactions. I click only this year but would like to also add last years. Thank you😊
If you have a whole year of transactions I would upload a CSV file.
Hi Sarh, Thank you for the video. Your videos help me to understand a lot about online bookkeeping. I am going to buy quickbooks online soon. Which version is best for Canadian etsy seller with two etsy shops? Do i need to buy twice for two shops? Thank you.
In Canada it's called QuickBooks Online Easy Start. You only need one QuickBooks account. Both Etsy shops can be accounted for in the same program.
@@SmallBusinessSarah Thank you for the reply Sarah.
Hello Sarah, thank you for this content this is what im looking for... Follow up questions please if you have a owner personal expenses.( I accidentally used my business card) do i have to reconcile this so my difference would be zero? I created expense, category is --owners draw right? also do i have to exclude the one that showed up to my bank feeds?
This video will walk you through what to do: ua-cam.com/video/ljEzCwvQc2w/v-deo.html But the Owner's Draw should be an Equity account type, not an Expense account type.
Thank you Sarah, it is helpful. But after i added all the expense in the bank register, i can see all the transactions in the register but they don't show up under the banking account. Do you know why?
That's because you have already assigned a category to them. So they don't need to be in the tab of items to be categorized. You have done that step, so they go directly to the register, and that is fine!
No.. what if they simple say .. deposit .. and they are on bank statement and not in QBO
Hopefully you know what the deposit is, but then you can just go to +New to add the missing deposit to QB.
Thank you very much Sarah for this information. Is it possible for me to reconcile a month without a bank statement? My bank merged and they were re-duing things for a while. However there is no transactions for the month of August. And I have no bank to pull a statement from. Any advice?
If QB hasn't pulled in some transactions, the only way to find the missing transactions is from the bank or a bank statement. Sorry!
Hey Sarah, thank you SO much for these videos. They are extremely helpful! I have a question for you.. Should my PayPal withdrawals be going to my checking account? Right now my PayPal transactions (item - fee) is showing in my PayPal bank, but so are some of my PayPal transfers. Sorry if this is a silly question
I think maybe this video will help: ua-cam.com/video/V6cqFZuWhuQ/v-deo.html
How about "credits" that serve as part of the payment of the total amount due? How to add it manually to QBO?
For those I would probably just split the transaction. You can split either expenses or deposits in the bank feed into multiple categories.
I'm really stuck on my actual balance bring correct ajd my quick book balance being wrong. Called quick books but they couldn't help. I've gone through all bank statements and all ending balances and dates match. So stuck 😞
Sorry to hear that Jade. Reconciling can be tricky depending on the account. I would just pull up your bank statement and pull up your QB register for that account and literally go line by line until you find the problem.
what if I've already started reconciling will this still work???
Yes, you can leave your reconciliation, just hit Save for Later. Then add what you need to, and go back and finish reconciling.
Hi Sarah, I have 4 months of missing bank transactions right in the middle of the year (connection glitch?), too many to enter manually. Anyway to import those 4 months missing transactions in to QB online?
Hi Sandy, yes you can import transactions. This video is geared towards people who need data earlier than 90 days when they are first starting up QB, but the principle of uploading transactions still applies.
And here's the link! ua-cam.com/video/gU5JqtppGzk/v-deo.html
I'm trying to figure out why my expenses are not showing in my profit and loss report. Like it shows that my total expenses for Q1 are $84,000 in the balance sheet, but only showing about $23,000 in profit and loss report. Please help!
I'm not sure what's happening with your bookkeeping, because expenses can't appear on the Balance Sheet. Sorry!
7 months missing quick books not good
You can also do bulk uploads! ua-cam.com/video/gU5JqtppGzk/v-deo.html
thank you. much appreciated. The official quick books videos aren't helpful at all.
The dude is just not fakeing . The finishes of the goals. Beautiful. Magisterial. Love you *leapnotch!.* .🙏🏼.
Thanks!