177: Automating QuickBooks To Save Time Whether You Are Starting A Business Or Side Hustle, A Solopreneur, Entrepreneur, Mompreneur, Freelancer, Bookkeeper, Virtual Assistant, Business Owner
177: Automating QuickBooks To Save Time Whether You Are Starting A Business Or Side Hustle, A Solopreneur, Entrepreneur, Mompreneur, Freelancer, Bookkeeper, Virtual Assistant, Business Owner, Or Self-Employed
As a business owner, you are always looking for ways to save time in your business, but you want to make sure you are not cutting corners in one place and causing additional problems down the road. This holds true when you are doing your bookkeeping as well. I always tell my clients when they are setting up their bookkeeping systems to make sure that they are capturing information that will be helpful for them when it comes time to prepare their tax returns. But tax compliance shouldn’t be your only concern when you are doing your bookkeeping. If there are certain items you want to track in your bookkeeping, you need to set those processes up in the beginning so that you can see the results at the end of the month, quarter, or year. Remember the saying garbage in is garbage out? This is true in your bookkeeping as well. When you are utilizing a computerized software system to track your bookkeeping, I’m sure you’ve noticed how easy it is to have your banking transactions automatically feed into your bookkeeping system. There are also ways that you can have them automatically categorized for you by using bank rules. In theory, this is a great system, but it can cause problems in your bookkeeping if you are not careful about how everything is set up from the beginning. In today’s podcast episode, I am going over what bank feeds and bank rules are and how to ensure you have everything set up appropriately so that you can have accurate financial statements that allow you to make sound business decisions. It doesn’t matter if you are just getting started with your business, you are a self-employed individual, a solopreneur, entrepreneur, small business owner, a remote, virtual, online, or in-house bookkeeper, or a virtual assistant or VA, you want to make sure you are utilizing the processes available to you in a way that you are truly saving time and not creating another task that will take even more time to straighten out in the end. I’ve seen how easily this can happen to business owners when they think they have everything recorded correctly only to find that their financial statements are a mess, and their tax preparer won’t prepare their return. I’ve had lots of projects like this come through my business just in the last month, so I want to help you avoid this costly mistake. Listen in, as I walk you through steps you can take today to ensure your bookkeeping is on the right track. It doesn’t matter if you are using a computerized software system like QuickBooks, Xero, Wave, or FreshBooks for your business finances, or if you are doing your bookkeeping manually with an Excel spreadsheet or even a Google Document, this episode will be helpful for you…
Find out how you can work with me by either scheduling a free consultation or signing up for the BALANCE Life Coaching program, where you can get private one-on-one coaching every week. Find out where you’d like to see yourself and your business in the future. We’ll create a laser-focused plan, including which action steps you need to take to get started on the path to success:
Accountants, CPAs, Bookkeepers, Tax Preparers & Financial Professionals, sign up here to get updates on upcoming opportunities & grab the Audit Of Your Well-Being & Balance Guide here:
Ready to set up your business? I have a program I’m creating to help you get your business set up so that you can start making money. Sign up for this program here:
Are you ready to try coaching? Schedule an Introductory Coaching Session today. You’ll have the opportunity to dip your toes in and see how you like coaching with an Introductory Coaching Session. I’ll spend the whole time coaching you on anything you’d like coaching on in your business or your personal life:
Join us in the Mastering Your Small Business Finances PROFIT LAB if you are ready to take control of your business finances and create the profitable business you are striving for. Are you ready to generate revenues and increase the profit in your business:
If You Are Ready To Choose, Start Or Grow Your Side Hustle, Get Your Free Checklist And Assessment Here:
Grab Your FREE guide: 5 Essential Strategies For Stress-Free Bookkeeping:
Your FREE Online Virtual Bookkeeping Business Starter Guide & Success Path Is Waiting For You:
Join Our Facebook Community: https://www.facebook.com/groups/womenbusinessownersultimatediybookkeepingboutique
The Strategic Bookkeeping Academy, including Bookkeeping Basics, is open for registration! You can learn more and sign up here:
Looking for a payroll solution for your business? You can get an exclusive 15% discount on your payroll services when you sign up here:
QuickBooks Online - Save 30% Your First 6 Months:
Sign up for a virtual coffee chat to see if starting a Bookkeeping Business is right for you:
Show Notes:
As a business owner, you are always looking for ways to save time in your business, but you want to make sure you are not cutting corners in one place and causing additional problems down the road. This holds true when you are doing your bookkeeping as well. I always tell my clients when they are setting up their bookkeeping systems to make sure that they are capturing information that will be helpful for them when it comes time to prepare their tax returns. But tax compliance shouldn’t be your only concern when you are doing your bookkeeping. If there are certain items you want to track in your bookkeeping, you need to set those processes up in the beginning so that you can see the results at the end of the month, quarter, or year. Remember the saying garbage in is garbage out? This is true in your bookkeeping as well. When you are utilizing a computerized software system to track your bookkeeping, I’m sure you’ve noticed how easy it is to have your banking transactions automatically feed into your bookkeeping system. There are also ways that you can have them automatically categorized for you by using bank rules. In theory, this is a great system, but it can cause problems in your bookkeeping if you are not careful about how everything is set up from the beginning. In today’s podcast episode, I am going over what bank feeds and bank rules are and how to ensure you have everything set up appropriately so that you can have accurate financial statements that allow you to make sound business decisions. It doesn’t matter if you are just getting started with your business, you are a self-employed individual, a solopreneur, entrepreneur, small business owner, a remote, virtual, online, or in-house bookkeeper, or a virtual assistant or VA, you want to make sure you are utilizing the processes available to you in a way that you are truly saving time and not creating another task that will take even more time to straighten out in the end. I’ve seen how easily this can happen to business owners when they think they have everything recorded correctly only to find that their financial statements are a mess, and their tax preparer won’t prepare their return. I’ve had lots of projects like this come through my business just in the last month, so I want to help you avoid this costly mistake. Listen in, as I walk you through steps you can take today to ensure your bookkeeping is on the right track. It doesn’t matter if you are using a computerized software system like QuickBooks, Xero, Wave, or FreshBooks for your business finances, or if you are doing your bookkeeping manually with an Excel spreadsheet or even a Google Document, this episode will be helpful for you…
Welcome Back…I wanted to take some time today to talk to you about how to manage your bank feeds as well as your bank rules. These options are normally available to you if you are using a computerized software system for your bookkeeping, but in today’s episode, I will be referring to QuickBooks and QuickBooks Online specifically. Much of what I say will also relate to other computerized software systems, so make sure you follow the tips to manage your bookkeeping system whether you are using QuickBooks or another computerized software system.
For a quick introduction, when you use a computerized software system for your bookkeeping, you normally have the option to link your bank account to your bookkeeping software system so that you don’t need to manually enter each transaction. This is indeed a time saver, but you need to know that even though these transactions don’t need to be manually entered, you still need to take the time to record them properly. In a typical situation, your bank will bring in your transactions and you will see them in a download area for your review. In QuickBooks, you can look in your banking tab to see your bank accounts. You can then select which bank account you want to view, and you will see all the transactions that have been downloaded and are ready for review. You can also view the transactions that have been downloaded and have been categorized or excluded in this area by selecting the appropriate tab in the banking area.
Each transaction that has been downloaded and is in your for review area will need to be reviewed and added to your books. If you have already recorded the transaction, you will have the option to match the downloaded transaction to your original entry. For example, you may have already entered a check for your utilities for the month. When this check clears the bank, it will be included in your for review area and you can then match this transaction to the check that you already entered in your books. This is the first area that I want to stress the importance of today. When the transactions are downloaded, there is normally a category that is suggested for you to use when you need to add the transaction to your books. Don’t just assume that this category is correct. Make sure you actually take time to review the transaction and if the category that is suggested for you is incorrect, you have the option to change it to the correct account or category. All you need to do is click on the transaction and you will have the option to categorize it to the correct category or account. You also have the option to split the transaction into multiple categories or accounts as well. This is helpful whenever you have a transaction that involves multiple items. Let’s say, for example, you made a purchase at an office supply store where you bought office supplies as well as a new telephone. You can easily categorize the total for your office supplies as office expense and your new phone could be categorized as telephone expense. The total of both split categories will equal the total of the transaction. This is also where you would split the principal and interest portions of a loan payment that you pay so that your loan balance and interest expense would always reflect the correct amounts.
Once you see how the bank feeds are coming into your bookkeeping software, you can take being efficient with your bookkeeping a step further. You can set up bank rules so that you can have QuickBooks automatically pre-fill information for you in the transactions that have been downloaded into your bookkeeping software. When you set up bank rules, you have the option to set up the rule so that QuickBooks will suggest the information you set up in the rule, or you can also have the bank rule automatically record the transaction into your books. To set up a rule, you would click on the downloaded transaction just like I mentioned previously when you want to change the category or account and then you will see the option to create a rule. When you click on create a rule, you are able to name the rule as well as create the rule around that specific transaction. You can specify the transaction type, category, payee and select if you’d like this rule to automatically confirm the transaction. Make sure that the information you provide in this area is accurate. If you like the thought of having QuickBooks automatically know which category and vendor you want this transaction to go into, but don’t quite feel comfortable with having the transaction automatically confirmed, you don’t need to select the Auto-Add option. It will still save you time by having recurring transactions automatically populated with the correct information.
When you follow these steps, you will save time and be efficient with recording your transactions into your bookkeeping software, but if not done correctly, you may find a bigger task that you need to work on in the future. I mentioned earlier in the podcast that I have seen quite a few projects come into my office that had issues with this process, which is why I thought this episode was so important to talk about today. Regardless of whether you are utilizing the bank feeds and bank rules, you still need to reconcile your bank accounts. When you do this, you will find out if all the transactions that have gone in and out of your bank account have been recorded. It is also a time when you will find out if there are any duplicate transactions that have been entered. Make sure you are doing a reconciliation for all of your accounts to ensure you have accurate information.
Once your bank reconciliations have been done, you should be reviewing your balance sheet and your income statement or profit and loss report. Here is where you can see if you have any issues from the transactions that have been reviewed or automatically recorded from your bank feeds and bank rules. I’ve worked with clients who thought everything was being recorded correctly until they started looking at their financial statements and nothing was making sense. There were transactions that should have been recorded as insurance but were recorded as office expense, transactions that should have been recorded as a telephone expense that have been recorded as interest, and so many other transactions that were categorized incorrectly. All of these errors are fixable, but they take time. This is where I want you to be proactive and take the initiative to spend a small amount of time, in the beginning, to save a large amount of time down the road.
I want you to make sure that when you are categorizing your transactions for review in the bank feeds area that you are taking your time and categorizing them correctly from the start. If you are unsure of the category, make sure you reach out to your accountant or tax preparer for help. If you are using bank rules, I want you to periodically review your bank rules to ensure you have them set up appropriately – especially if you are utilizing the auto-add function and you don’t have to review the transaction before it gets automatically added to your books. To review your bank rules, you simply can go to your banking tab and select rules from the top list of menu items. When you do this, you will see all of the bank rules you have already set up. You may find some rules in here that are not set up correctly and need to be edited so that future transactions will be recorded accurately. You can click on each rule to view the information and you can edit them if needed. If you have rules that are set up as an auto-add and you no longer want these automatically added, you can change this option in the rules section as well.
By making sure you are proactive in recording transactions correctly from the start, you will be able to rely on the information in your financial statements. Remember the garbage in, garbage out saying. Don’t just review a transaction and enter anything in for a category or account. If you are unsure and you want to keep moving forward with reviewing your transactions, you can always use the “Ask My Accountant” category. This account works well for you to put all your questionable transactions into one place so that you can ask questions about them in the future. If you don’t already have this account, you can go to your chart of accounts to add it as an expense so that you can start using it in the future.
Imagine having a system in place where you spend less time buried in paperwork and more time doing what you love. That’s where I help my clients. They are able to have proper processes in place, understand why they are following through with these processes, and they have more peace of mind when it comes to their business. Striking a balance between the demands of running a business and maintaining a fulfilling personal life is an art; it’s about creating an environment where you can thrive and support your lifestyle. By being proactive and setting up efficient processes, you can ensure a smoother, more enjoyable year-end, and you’ll be prepared to file any necessary filings with the IRS. By working with me, you’ll change more than just your bookkeeping processes. Like many of the clients I’ve worked with, you’ll go from not knowing how to get through all the stressful situations or being unprepared to being totally in control of exactly what you are choosing to get done at the time you want to have it accomplished by, all while knowing you are doing enough and you’re able to enjoy your business and your personal life. I help clients just like you with strategy, mentorship, and coaching. When you work with me, you’ll show up much more differently than you do today, and, after all, this is what you ultimately want in your life, right? You can be stress-free in both your professional and personal life. Come join me. When I work with clients throughout the year, they are able to reduce their stress and overwhelm, understand how to master their small business finances, develop solutions to grow their bottom line, and create a work-life balance they truly enjoy. I encourage you to take the next step by signing up for a free consultation where I’m going to teach you the first step in my process so that you can eliminate stress, overwhelm, or overworking in your professional or personal life while you continue to get done what matters so that you can live your life with joy, purpose and a more fulfilled life. Feel free to reach out to me with any questions you have; I’d love to help you on this journey. You can schedule your free consultation or sign up for a coaching session today at www.FinancialAdventure.com. As a Certified Public Accountant and Certified Life Coach, I can help you set goals and develop a plan that will allow you to lead a happier and more sustainable life in your business, career, or your personal life. I’m here to guide you through the financial aspects of your business as well as help you focus on the strategies you need to follow to reach the success you want to achieve in your professional or personal life and stay committed so that you can continue to keep pushing forward and relieve the stress, anxiety, or overwhelm you are currently feeling. Having an accountant and certified life coach like me can provide you with valuable insights and ideas to help you simplify your life, which enables you to go back to enjoying your professional and personal life. I work with business owners, accountants, and other financial professionals to create the actionable steps they need to take to ultimately achieve their goals while getting relief from the stress and overwhelm they feel from the pressure of owning a business, deadlines, and the workload they face every day. If you are struggling with this as well and would like some help developing a solution, help strengthen and maintain your emotional health, increase your well-being, create a more positive, happy, and joyful life, set and achieve your goals, and manage your relationships, I’d love for you to join me in my Balance Life Coaching program so that you can live a more purposeful life. Each week, we meet privately one-on-one, and you get to bring whatever is on your mind on any given week. I also have a daily coaching program where you can talk to me whenever it works best for you, 24/7, any day of the week. In either program, you get to work on your highest priority, whatever you want more of in your life, or if there is something that is weighing on you heavily that you need coaching on, and we’ll work through it together. Having a certified life coach like me helping you through all of this allows you to feel so seen and cared for, and the results are amazing. Everyone benefits when they work with a certified life coach. After every session, you feel energized, and you know exactly what to do for the day or week to come, and relief knowing we will meet again to go over anything that comes up after your session. You’ll gain self-awareness while you take each step toward your goals. The investment in either of these programs is an easy yes for you. I’ve set these programs up in the most supportive way. If you are ready to join the Balance Life Coaching program, you can go to www.FinancialAdventure.com and click on the work with me button. You’ll see the link to join as well as additional information about the programs. Sign up now. There are limited spots available for these programs due to the one-on-one aspect, and they do sell out. If the payment link is gone, you can get on my waitlist to join the programs when additional spots are available. I help people get results and live a more joyful life. I coach everybody on everything. I know there is something you want in your life, and I can help you get it. I know this is something you’ve been waiting for. I’ve been asked by many of my listeners to create these exact programs. The faster you get access to the program, the quicker you’ll see the possibilities available to you. I also have a risk-free guarantee. I believe so strongly that everyone benefits from coaching that when you sign up for the Balance Life Coaching program today, if for any reason you are not satisfied with your first session, you can send us an email, and we’ll refund you immediately. Are you ready to enjoy your life now? Why would you want to wait? Make this investment for yourself. Take the journey with me…make it happen for yourself. Ask yourself why you need this program in your life right now. Are you ready to make bigger, bolder, stronger life goals? I’m looking forward to meeting with you soon and digging deeper to see where you currently are in your business or career and start creating actionable steps so that you can reach your vision and goals for the future, not only in your business or career but also in your personal life. I’m ready to work with you, see all of your successes, and watch you thrive in your business or career while creating your best work-life balance. I’ll post links to this and other valuable resources for business owners and accountants where you are listening to this podcast.
And, you know I’m going to ask…what’s at least one thing you will take away from this episode that will help your business succeed and grow your bottom line? If you need some accountability, join our PRIVATE Facebook community and post your action item, we’d love to support you.
