In this video, we’ll show you how to reconcile your bank statement in QuickBooks.
This is an important step to make sure all of your transactions are accounted for and to catch any discrepancies. 🤓
Do you have a bank account that’s never been reconciled and you’re not sure of the proper process?
Then you are in the right place I created this QuickBooks Desktop tutorial for reconciling your bank account just for you.
Whether you’re using bank feeds or manually entering your transaction, taking the time to reconcile and make sure you don’t have errors in QuickBooks will make your next tax appointment so much easier.
You’ll need to grab your bank statement and hit play 😊
Looking for how to reconcile QuickBooks as an Online user ➡️ Click Here
What is Reconciliation?
- To know if you entered everything correctly.
- It’s the number one way to show up on your next tax appointment with Confidence.
- Grab your Bank Statement and get into your QuickBooks Desktop
- Go up to “Banking”
- The “Reconcile”
Or
- From Homescreen, Choose “Reconcile”
- Choose “Account”
- “Statement date” (Base on your Statement)
- Check “Beginning Balance”
- “Ending Balance”
- Enter Other details
- Service Charge & Date
- Account
- Classes – If you’re you’re using it
- Interest Earned & Date
- Account
- Classes – If you’re you’re using it
- Click “Continue”
- Read the pop up notification first if it’s accurate – Click ‘Yes”
Inside Reconciliation Screen
- For Period Date (Statement Ending Date)
- Find the transactions in the Statement (Checkmark the ones that is only cleared)
Hide Transactions after the Statement End date
- To prevent using transactions outside the current statement date.
Other Reconciliation Feature
- Highlight Marked
- mark All – Not Recommended’
- Unmark All
- Go To
- Matched
- Columns to Display…
- Modify – If you need to make some changes
- Click “Reconcile” when you’re reconciliation amounts are balanced
**Remember: Make sure the Difference is always Zero, if not Zero go back to the details and figure out why it’s not balanced.
If you need to do or enter something to balance your Reconciliation, you can choose “Leave”
- To go back, Choose “Reconcile” in the Homescreen
- Confirm Details
- Click “Continue”
- Check Details in the Reconciliation Screen again
- Click “Reconcile”
- “Select Reconciliation Report” screen will pop up
- Choose (Summary, detail, both)
- Then Choose if you want to (Display or Print) the Report
Going back to print any reconciliation that you’ve missed
- Go up to “Reports”
- “Banking”
- “Previous Reconciliation”
- “Types of Report” (Summary, Detail, Both)
- In this report, include (Additional Options)
- Click “Display”
______________________
Have you been using QuickBooks for a while, but when you pull a report you just don’t understand what it’s saying?
Does the idea of going to see your tax professional sound a little stressful and maybe cause you to feel like you want to pull your hair out?
I would love for you to join me on my customizing QuickBooks workshop.
I’ll be sharing:
- The most efficient way to track your Income and Expenses.
- How to create accurate reports in order to view how your business is actually doing and stop second-guessing yourself.
- Where to get the data you need to make the best decisions to grow your business.
And the #1 SECRET to feeling confident at your next tax appointment.
I’m excited to see you on the workshop!
Click here to save your seat → Join My Free Workshop!
🙋🏻♀️ I’d love to connect with you on Instagram or Facebook
Subscribe for more QuickBooks tips on YouTube
#CandusKampfer
I know how to reconcile but all the extra little tips and buttons I’ve never used was so helpful. Thank you!
You’re welcome Danni! 🤩 ~Kindra/Team Candus
I never had formal training on Quickbooks so these videos and tips are very helpful. I am looking forward to attending the course Tuesday on customizing QB.
Yay Janet! We are excited to have you join us. 😊 ~Kindra/Team Candus
I have been using QB desktop for 4 years but never had any real training on it. This video was very informative on things I did not know you could do in the program. This was my first video but I plan on looking at all of them that you have done.
Thank you.
Hi Mary,
I’m so glad this training was helpful for you. Thank you for watching our videos. ~Kindra/Team Candus
Sometimes I just like knowing I am doing something right.
Always enjoy your videos and tips
Yay! I’m so glad you’re on the right track and you enjoyed the tip this week. ~Kindra/Team Candus
Thank you. I love these refreshers! I always learn something!!
You’re welcome Jan! I’m so glad you enjoyed it. 🙂 ~Kindra/Team Candus
Candus and Team,
Thank you for what you and your team are doing.
We manufacture and distribute fishing tackle since 1985.
I’m using QB 2002 desktop for manufacturing.
My question is when I’m creating a new product in my inventory. I generate a new UPC code in the:
Item Tab
Type – Inventory part
Item Number
Purchase information
description of product
cost of what we paid for item
COGS tab
purchases spring or winter
Preferred Vendor
Name of company we buy from
Inventory information
Asset Account (Other current asset)
Inventory Asset/finished
I don’t enter reorder point, but it shows a negative
My question is
Why do all my sales to customers show up in Purchases (Spring or Winter) some have a 0 and some numbers show item with $ amount?
What am I doing wrong?
Hi Cheryl! Since you are a QBS member, the best place to ask this question is on our QBS FB page. That way others can help you and we can direct you from there. 🙂 ~Kindra/Team Candus