How to use Bank Feeds in QBO - 2022
Вставка
- Опубліковано 9 бер 2022
- Need to get QBO set up for your business? Save money & grab a 12 month discount here: claracfo.com/QBO
"Bank Feeds, Banking Transactions, Classifying Transactions, or Banking section" - everyone calls this something different in QBO, but this video is all about HOW TO USE IT and how to make sure you don't mess up your QBO file in the process.
In this video, Hannah shows you how to use bank feeds in QBO by covering:
- How to match transactions
- Best practices for adding transactions
- How to add, match, transfer
- How to attach documents to a transaction
- How to avoid duplicate entries
Find more resources for your small business HERE: learn.claracfo.com/
--------------------------------------------------------------------------------------------------------------------------------------------
💲 Need an accounting system? We use Quickbooks Online with clients and recommend it as the best accounting system for small businesses. Sign up to get a discounted subscription for 12 months! claracfo.com/QBO
🙋♀Got Employees? Need a payroll company that knows what small businesses need? We recommend Gusto as the best small business payroll provider. Sign up for $100 gift card after you run your first payroll: claracfo.com/gusto
💸Pay vendors any way they want and get paid faster! Accept credit cards without paying merchant fees! Melio is a fantastic payments solution for every small business! claracfo.com/melio
(As an affiliate or referral partner for these companies, I may earn rewards from qualifying purchases)
Hannah Smolinski is a #CPA and the Founder of Clara CFO Group. Find out more about Clara CFO Group at claracfo.com/
Disclaimer: This video is intended for educational purposes and
should not be taken as legal or tax advice. You should consult with your financial professionals about your unique financial situation before acting on anything discussed in these videos. Clara CFO Group, LLC is providing educational content to help small business owners become more aware of certain issues and topics, but we cannot give blanket advice to a broad audience.
Just watched your video. Done subscribing thanks much.
Thank you!! New Bookkeeping student here. Don't stop making QBO videos! xooxx
Really loving your videos on QB, super helpful , you explain everything in simple , clear terms. QB is a bit overwhelming , so glad I found you
Glad you like them!
I am watching all videos. You have explained things amazingly Clara. Keep it up.
Thank you! I appreciate the encouraging words!
It all makes sense NOW. Before this video I was a little lost as new user. THANK YOU Clara!
Hey Clara....These videos are great. It has helped me so much, and I do feel empowered. I'm going to dig into all your QB videos to learn as much as I can. I am solo running a new business and I want to get a good foundation of booking keeping before I hand that off to someone else. I think this will probably be the first business system that I will let go of first and you're helping me get closer to that moment so thank you again.
Hi mike, I’m a bookkeeper working remotely and I’d be happy to help when you’re ready :)
Hi Sir, if you want to hire a bookkeeper in the coming days, let me know plz. Thanks.
Thanks Clara! I am new to QB and you are the only channel I like to watch! Your clear, concise, and calm way of explaining stuff is so helpful!
Thank you! I am glad it is helpful!
Very informative, loved it. Thank you so much
Thank you!
thanks for watching!
I am new to QB and my responsibilities to use it. I would appreciate you going just a bit slower. I have subscribed because I like your concise videos.
Thanks for being here, and I appreciate the feedback! It's a challenge to get things concise and slow enough at the same time, but I will try!
Go slower 😆 🤣 😂 it's called pause and rewind
You mentioned to be careful not to create duplicates, I am sure I have lots! Do you have a video on sorting duplicates out?
Enjoy and need your videos. Very helpful. Thank you
Yay🤗!!! Just what I needed😊
Thank you So Much🥰
Great! Glad I could help!
Thank you so much for these videos!
Thanks fun watching!!! 🙌
Thank you for your videos. So informative
Great video, Hannah! Keep up the great work =)
Thank you!! 😁
subscribed! thank you for the great video! Appreciate you.
Thanks for watching!! I appreciate you!
Thank you for this video Clara. I have a question. Once all the banking transactions have been “effectively categorized”…what can we, or what should we do next?
Thank you in advance.
Tony
Once you have categorized all your transactions, you can review your financial statements for the period!
@@ClaraCFOIndeed, Thank you Clara!
This was great
Love your videos! You make it more logical with what may happen and how things work in this system. Us newbies really appreciate that. Clara, when you are matching a payment received and are looking at the pop-up window of the invoice that is being applied, there is a 'clear payment' button under the dollar amounts. Do you use this to clear a payment? I am asking because the guy that I help with his books does not receive payments when he has checks to deposit and just writes up the deposit book and forgets this process. What will it do in the system and how can I change that after the fact?
can you do a video (or send me to the one you may have already done) about that 'clear payment' button? Please and thank you.
Thanks!
Hey Clara, do you have any videos that explain/teach how to do expenses between companies? For instance, someone has a company that owns other companies? It’s my understanding that each company has to have their own QBO subscription, which seems like it can make things more complex. Any help or advice is greatly appreciated. I love you content, keep up the good work!
Hi Tom, Quickbooks accountant can manage your companies in the best way. Yes, you have to buy separate subscriptions for both companies. I'm an accountant and QuickBooks Pro advisor. Let me know if you need any help. Regards
appreciate you for real thank you
Thank you for these videos ... Very helpful and great detail. Quick question(maybe it will be answered in another video) but I take cash out weekly to pay some of my staff - how do I add these?
Glad they are helpful! If you are paying people and not wanting them to get a 1099, then you need to take out money as an "owners draw". This would be if you are "paying under the table". However, if you want to pay them as a business expense, you need to set them up as 1099 contractors and there are a bunch of ways you can pay contractors. You can pay them in cash, but you would still be able to record it as an expense. The real question is....do you want it to be under the table cash to them or do you want to take it as a business expense. I'd recommend keeping everything "above the table", set everyone up as a contractor, and pay them accordingly.
Great video!
Thanks!
What version of quick book can someone who is not a business owner will use and practice with hypothetical figures data since i cannot create mine, currently i am not working with an accounting firm but i need to learn quick book to enable me apply for jobs.
Great video as usual Clara. Question. I use desktop and in desktop I like classic mode best. In classic mode when you download things that match are AUTOMATICALLY marked as matched. typically you don't gave to mess with those, only unmatched. Its possible to have almost all of the downloads automatically matched.
in online can it show items that automatically matched. I watched your whole video and maybe I missed it, but looks like you have to "go find a match" in QBO. yes/No? Thanks, david
If the system doesn't automatically recognize the match, then you need to go searching for it. MOST of the time QBO is good at recognizing things, but the demo account I am using is really lame and didn't have most of the items automatically matching for some reason. Hope that helps!
How do you determine if it is a match or an add when reviewing the bank feed?
What to do in reconciliation in QuickBooks Online if transactions are not in the bank statement but matched and shown in reconciliation, uncheck, or how to fix it?
Hi Clara! Thanks for the video. If a new client does not care much about previous year transactions, but want to start fresh from Jan 1, 2024. The first time bank feed pulls in data from 2023 and Jan 2024. I would assume to add all the 2024 transactions. How would you handle the previous December/November 2023 transactions? If the latest bank statement in January 2024 (to reconcile) also includes some Dec 2023 transactions? Thanks for your time!
Thanks Clare, great video. I'm new to QBO and having a problem setting up my bank feed, hoping you could help. My bank account has three sub-account which I need to track them separately, my problem is that when I connect to the bank it brings all the transactions into one sub-account, how can I move the transactions from one sub-account to another?
do you have a statement for each subaccount? Usually during the linkage, subaccounts are recognized and you can assign a different bank account to each one. Were you not given that option? I would consider disconnecting the linkage and trying again to see if you accidentally skipped that step. You will need to set up 3 different accounts in your chart of accounts so you can map each sub-account in your bank to a different account on your chart of accounts. I hope that help!
Here’s something I haven’t seen covered yet. I want to only use Quickbooks as an accounting software, how do I import transactions from customers that I bought products off of, keep track of, and mark the items out when they’re sold without using Quickbooks as a POS?
Hello! Could you please explain, how do you decide what category the transaction should be. On this video you were showing the example -Tim Philip Masonry, and you said - This looks like a Labor Cost. (minute 10.00). If it would be a real example. How do you decide, what the transaction is?? :) And you checked "Billable". Thank you!!!
Hey ...
After bank feed transaction
charges, Expenses are positive balance showing
&. Income was nagetive why ?
And how can setup problem
Hi Clara, just getting started with QBO and your channel. Thank you for making your courses easy to follow (even for non-accounting types :). Our previous accountant incorrectly categorized most of our transactions. Do you know of a way to move multiple transactions from an incorrect category to the correct one?
The only way to do this is to use QBOA, the accountant version of QuickBooks online. There is a reclass feature (that I think they should roll out to non-accountant versions…. But hey, no one is asking me!)
Hi Clara. Love your videos. I do have a question. I have credit card processing. So at end of day it closes out batch and sends it to checking. Every thing was going good until I started giving refunds. So lets say for example I had a sale for $2200.00 and I refunded $900.00 that day the Credit Card processing would show $1300.00 deposited in checking.$1300.00 doesn't match up to any transaction. I no what two do but don't no how to input it. Can you help. Thanks Robert
Please help me about quickbook
Hey, I can't find any videos on UA-cam on how to handle return/credits in bank feeds. I have a roofing company and we rarely return tools and materials to stores so I do not run across it enough to have a problem but we have recently.
For returns, I generally code the incoming money to the same account that it was outgoing. So if I purchased something from Home Depot and coded it to "Building supplies" then I returned that thing to Home Depot, I would code the incoming money as "Building supplies" so that the two amounts will net out over time. I'd do this even as a partial return.
I do!
You didn't fill in Payee when you were going through the bank feeds. Is there a reason for this?
Hello, I'm a new subscriber to your channel. First, thank you so much for these videos. They're absolutely great! Definitely the easiest to understand out here.
I'm a Finance Manager for a company. At month's end I make sure all posting is complete and I make sure to Match when available. Then our CPA does the reconciliation. I seem to keep running into the same issue month after month. I hope you can help.
When I receive a bill I enter it in under the vendor. Then when the bill is due I create the check for that bill. When I'm posting, I match the transaction QB pulls from the bank to that one that I entered. Up to this point I'm fine. The issue is when I run the P&L. I'm getting double transactions and it completely throws my numbers off. It's basically doubling my expenses.
What am I doing wrong? Am I missing a step? Is it possibly something our CPA is doing or not doing?
TIA for your help.
I think the problem is is happening when you create a check. You should "pay bill" and then "print checks" which will match the bill payment to the check record. This will make sure you don't have a duplicate!
thanks I have a question because I am from Pakistan how can I connect my bank with quickbooks Here is no options
Good videos. Still need some help. I am a long time desktop user running 3 small businesses. Never used bank feeds. I just reconciled from the bank and credit card statements and most transactions were already there. Now I work for an accountant as a bookkeeper. I am struggling with deposits coming in from the bank feed that are invoices paid through QB online payment system. It looks like the amounts are payments for multiple invoices for multiple customers with very little detail. Seems like no way to match those. Tried QB phone support and that was horrible. Any suggestions on how to match or what to do with these kinds of deposits? I just can't book them as revenue because that doubles up revenue and cash. Thanks.
Hello, can you do a video on how to link a BOA sub account ?? It so different from all of these videos. One account shows money that has been piad to the credit card, and other account shows the purchases that were made with the credit card. Its complicated to reconcile.
My son has several bank accts connected with QBO. He gets the updates but then they stop and he has to continually enter in a OTP for each acct to update them again. Anything in QBO to help with this? or is this a bank issue?
If you add something by mistake, is there a way to correct it? Thank you for these videos, they have been very informative. We are just getting started with QBO and have little accounting background.
Hi Erika, Yes! It's very easy to fix something you've done in the past. To find the transactions you have already added, you can go to the "bank register" and find the transaction to edit it. All the bank transactions need to be added to the books in order to reconcile, so you probably just need to recode the transaction or unmatch it and match it to something else (like an invoice or a bill). Want to tell me more about what happened? This is a great idea for a Short. I will link that here when I record it!
@@ClaraCFO thank you for the quick response. We haven't done it yet, as we are just getting started. I've been trying to learn as much as I can, so that we configure QBO right the first time. I'm sure we'll make some mistakes along the way, though. ;)
Thank you for creating this video, unfortunately it was not basic enough. I can't find where to view the receipts in order to match them. I am paying EVERYTHING with the same credit card, then only paying that credit through the bank account. is there a specific video you have recommend
Hi Kristine - deposits coming in would match to invoices if you are using the invoice function. Here's one of Hector's videos: ua-cam.com/video/mcbWGbAAg-g/v-deo.html
We transfer money (invoices customers have paid) from our QBO bank account to our other bank checking account. It is coming up as a match for an "expense" with these. Is this correct or do I record it as a transfer?
If the entry was made in QBO as an expense and you look at the original expense transaction and confirm that it was the correct transaction that's represented by the bank feed entry, then you can match them. I often enter transfers in an Expense "form" instead of the Transfer "form" because it gives you more fields and more flexibility should it need to be changed in the future.
If there are multiple deposits at one time adding up to example 35k and there are several. How do you separtae them?
You will need to make sure that you have a record (invoice or sales receipt) in the system for what each deposit should be matched to first. Then when you are in the bank feed, you can choose "find match" and select the transactions that the total $35k adds up to. So if it's 3 invoice from multiple customers, you should be able to select those. It will mark those invoices as paid.
I have run into an issue of deleting some transaction after reconciliation and don't know how to undelete them, also some of the transactions have c by them and some have the r by them...can you please tell me what this mean in the bank register?
R means that you've confirmed them through a formal Reconciliation. C means that the transaction has cleared the bank and the system knows this only because it was either matched to the bank feed or was entered from the bank feed.
You just saved my liiiifffeeee!
My only problem is that the bank won’t link - likely an issues with the bank - so I’m having to try to pull everything manually. Tried uploading the csv file but it’s adding everything as money in instead of money out.
If you edit the .csv file you can still do the upload! You just need to make sure that you tell the upload to read the information correctly - which might require editing the .csv to get it to work.
Hi, how do you handle an overpayment of an invoice please..? (Invoice value = £1,000 but say the payment in the bank feed + £1,200..?)
Hi there, hopefully this video can help answer your question: ua-cam.com/video/6tGb0-AzXEo/v-deo.html Tune in at 5:03
my QBO doesnt show the checking balance/ vs quickbooks balance box thats (blue/white) in this video, how do I turn these on?
Can you change it to a accountant mode? Go to the gear icon and I'm the bottom right, it should give you the option to switch to accountant mode.
@@ClaraCFO Thank you that was it!
just subscribed to your great videos. I am struggling with deleting bill payments waiting to 'send/receive' to the financial system. Without spending time on the fiasco that has led to this I just have one question. How do I delete those transactions from the send/receive. I am stuck in a 'loop'. Unable to pay any bill due to a message 'there are currently online tranactions to send for this account......unable to change or do anything until the transactions are sent or deleted'. Spent hours trying to delete those transaction and hours on the phone with QB. Anyone know what I am doing wrong. OR if Clara has a video about this. I am stuck.
Ann - thanks so much for joining us! I unfortunately haven't run into this problem before. Did you check to make sure that your banking information is correct? I'd look at Hector Garcia's videos and see if he has any answers for this. Maybe search in UA-cam "Hector Garcia bill pay" and see what you can find. I am so sorry!
We are a contracting service and our customers pay us a deposit before we start work. Now this money received comes in through my bank feed and I need to review it and add it so that it shows up on my bank account. When I open the transaction, the choices are only two: either deposit or sales receipt. Neither of these 2 give me a credit to the customer. Is there anyway that I can do this without first having to do a "receive payments" step beforehand so that QB can then match the two up when going back to bank feeds?
Elizna - do you invoice your customers for this money? How do they know how much to pay you? Ideally when the money comes into the bank account it's getting matched to an invoice. Maybe you are doing invoicing in a different system?
@@ClaraCFO We only invoice after the job is finished. They pay the deposit based on the quote we give where we specify the deposit amount. So when the client pay the deposit, there is no invoice in my books yet. I just want to record the payment so that it reflects as a credit to the customer. When I then make the invoice, I will then take the credit as part payment and show what the balance is due.
What if the deposit is matching with the wrong invoices, how can I fix this? The correct invoices won't pop up when I click on find match.
You are right to look for the right invoice in "find match" - you may have to change the date range of the invoices in order to find the right one to match it to. The system is half-smart. It will apply a match, but you always need to review it and make sure it's matching to the right thing!
How about e invoice for Saudi Arabia
Scroll to 2:30
I already have QBO simple start. Can I upgrade through your affiliate link?
unfortunately the discount code is only for new accounts.
Trying to match things is basically a time waster. I use bank feeds to enter missing transactions, usually debit card transactions or handwritten checks that you probably will have to look up online with your bank. And it's equally useless for customer payments and deposits and can create a real mess. After using it to enter missing transactions, reconcile the month, and then go back and remove all the garbage in bank feeds up to the closing date of the bank statement you just reconciled. If you have many payments from customers that are around the same amount, QBO has no idea who they are for or what invoice they are for. You should already have received these payments into the system and deposited the money. If they are Intuit Payments, they should already be automatically received and deposited, though sometimes Bank Feeds screws these up too.
Everybody has their own way of doing things! I use the bank feed as my "source of truth" because there is less room for human error. But I can see what you are saying too!
The matching process is basically reconciling the QB bank account with the bank statement. It speeds up reconciling the bank account so it is not a waste of time
Please go over not to have duplicates
Hi @catherine Gilles, we do have a video covering how to avoid duplicates in QBO! You can watch it here: ua-cam.com/video/6tGb0-AzXEo/v-deo.html
@@ClaraCFO Thank you.
Hi dear help me
Game
WARNING about syncing to a bank.... I'm a small business and synced quickbooks to my business account with Cambrian Credit Union. In the middle of Dec. 2022 Cambrian Credit Union STOPED 3rd Party Apps from syncing. Needless to say I'm in a huge mess, as EVERYTHING that was synced is just not in quickbooks. We are at the end of the year, and I have to manually input every single transactions manually... so be aware!
We don’t subribe cause you introduce the video 6 times in 3 min!
Hello these videos are so helpful. I am just starting in the bookkeeping business, and so much makes simple sense. I have a question what is the billable for? Also when your categorizing the bank feed and the drop down for vendor comes how do you know if it is a vendor or are all of them labled as vendors? I have signed up for your channel.
Tasha, you may have figured this out by now, but.... Typically a Vendor is someone that you give money TO and a Customer is someone that you get money FROM. The bank feed will default a new name to a Vendor Type is its for a money out transaction and default to a Customer type if it's for money in. Even the Post Office or a Gas Station would be considered a Vendor. Another way to think about it is - the only other options are Customer and Employee and the gas station is certainly neither of those. Hope this helps!
I tried to resync my bank feed w/ user name and pass word QBO says unable to connect try again later who should I contact or email???
Sometimes you just need to retry. You can try to contact support if it keeps persisting.
Please help me about quickbook canada
Your videos are helpful, I just started watching them yesterday. I am behind on taxes because I have not kept up with QuickBooks partly because I do not know how to use it properly; do you take on clients to individually help them? I'm trying to get it in order so that I can maintain it weekly.
Thanks for watching Fernanda! My company does not do bookkeeping, so we don't do catch-up engagements. You could try looking at the Quickbooks Pro-advisors to see if you can find someone who can help you with a cleanup/catchup project!