Real Tips from Real Accountants: QuickBooks Tips

Our blog series that offers real tips from the accountants that make up the H&M team rolls on. In this installment, we focus on QuickBooks. This is an accounting software that is very popular among business owners. Many members of our team are highly proficient in the software and share some of their favorite features in the section below. So, get out a pen and prepare to take some note for things to try the next time you log on to QuickBooks!

QuickBooks is a tool that can make financial management for your business dramatically easier. Yet, learning all the ins and outs takes time. Hopefully, these quick tips can help you get started, advance your knowledge and save time on critical tasks. 

This tip is so important…secure your data by backing up your QuickBooks. Set up an automatic schedule. Backing up your QuickBooks is as integral as running your business. You can’t have your entire QuickBooks on one system without backing it up because if it crashes, your information is lost

Here’s the good thing about QuickBooks: You can customize what appears on your Icon Bar. This makes it easier to navigate since you only have the links you require most. Head to View>Customize Icon Bar and keep what you use most frequently.

Spellcheck can be a weird feature in QuickBooks, especially when you’re dealing with company names. If you’re getting irritated with Spellcheck, there’s a way to turn it off. All you must do is go to Edit>Preferences>Speller and uncheck the box for Always Check Spelling.

Carmen George, CPA- Director

This time of year – my favorite feature is the option to do what I call “Locking prior periods” – QuickBooks calls it a “Closing Date”.This feature allows a user to set a specific date to “close” books from posting any changes without first getting a warning to confirm the date is accurate.

The reason I find this to be useful in January is that I can set my LOCK or CLOSE date to 11/30 of the prior year and that way if I accidentally try to post a January transaction using the prior YEAR’s date out of habit  (ie: key in 2019 instead of 2020) ….. QB will pop up a warning that my date may be wrong.

By setting the date to 11/30/19 – I’m still able to easily post my year end December entries to 2019 – but will be warned if I try to post new entries to January 2019 instead of January 2020.  It takes time to retrain our fingers to type that new year number ?. This feature can be found at Edit / Preferences / Accounting / Company Preferences / Closing Date.

Tammy Westbrook- Staff Accountant

QuickBooks Online recently released the Business Performance Dashboard which is a great tool for any business owner! The Business Performance Dashboard, located within the Overview tab of QuickBooks Online, allows the business owner to quickly see business metrics for the current year compared to prior periods and helps to identify areas for growth. The key metrics and trend graphs can be customized to meet the business owner’s needs so they only see the data they are interested in. Each trend graph also includes a link to view the underlying calculations and support. The Business Performance Dashboard gives owners the insight and data to help them make real-time decisions and determine opportunities of growth for the future.

Danielle Cottle, CPA, CGMA- Director

Save time at year end 1099 season by attaching W-9’s to the Vendor’s detail page in Quickbooks online.  This will save you so much time at year end requesting and looking for this information to prepare 1099’s. I also recommend that you automate emails on invoices in QuickBooks online. Also, set up “Bank Rules” in the banking features there as well.

Joee Brandfass- Senior Assistant Accountant

My favorite feature in QBs is the Find feature.  In the Desktop Version, you will go to Edit at the top tool bar and select Find.  In the QB Online version, you simply click on the magnifying glass in the top righthand section.  In both versions you can filter many different ways.  There have been times I have input a transaction or journal entry and cannot find it.  I simply do a Find on one of the amounts that was a part of the transaction I’m looking for and the system filters through everything and finds every time that number was used. 

If you have more than one monitor and you use QB Online, you can display QB Online over multiple monitors.  When you are in your QB Online account, you right click on the internet tab that is displaying the QB Online and select Duplicate.  This will create another internet tab with QB Online and you just need to move that tab to another monitor.  You will then be able to move around in both tabs, looking at different things within your QB Online account.  I find this helpful if I want to review several reports at once.    

Julie Roe- Staff Accountant

After you close the books for the month and/or year, set the closing date and password.  Bookkeepers often get in the habit of typing a certain month or year when entering transactions.  By setting a closing date and password, if the user tries to post a transaction to a prior period, it will ask for a password.  This can prevent users from posting transactions to a closed or incorrect period.

Another quick tip…if you are looking for a specific transaction, and know the dollar amount or reference number, use “Ctrl + F”.  This allows users to search the entire QuickBooks file for specific transactions

Natalie Bruns, CPA, MBA- Senior Accountant

Third party apps are a great way to enhance the capabilities of QuickBooks & make it work for your business.

Use these apps to track time & expenses, manage customers, and help with human resources tasks. 

You may find these tools will replace the manual records you may be keeping outside of QuickBooks.

Linda Lehman- Senior Assistant Accountant