614.494.5300

QuickBooks tips and tricks to cut your bookkeeping time in half

By: Natalie Bruns, CPA- Senior Accountant

As a member of the BSST team, I sometimes see clients spending hours and hours catching up their books.  At times I see them spending more time than is required because they are not aware of some very handy features of the accounting software.  There are several tips and functions within QuickBooks that can save hours when preparing financials and performing bookkeeping functions.  Some of the most common and most time saving functions are listed below.

Memorized Transactions

For transactions that occur every month and are the same amount, QuickBooks can memorize these transactions and book them automatically on a certain day of the week, month, or year, saving a significant amount of time entering the same information over and over.  For transactions that vary in amount every month, there is an option to memorize the transaction for when you want to use it.  Even though it’s not automatically created, it saves time required in selecting the vendor, customer, or accounts in a journal entry.  The entry and all of its information is saved in the memorized transaction list.  When selected, amounts can be changed before booking.

Bank Feeds

Setting up your bank account to feed any activity into QuickBooks is a huge time saver.  When set up correctly, QuickBooks pulls activity from your bank account into the file, where you then review it.  When reviewing, a vendor or customer is selected along with the correlating account to which it is coded.  By using bank feeds, the time spent manually entering each individual transaction is eliminated.  It also ensures that all activity from the bank statement is imported, making the bank reconciliation process less time consuming.

Keyboard Shortcuts

Even though keyboard shortcuts may only save a couple of seconds when they are used, those couple of seconds can add up to minutes, saving valuable time in doing the bookkeeping.  Some of the most common keyboard shortcuts are listed below.

 

  1. Pull up Chart of Accounts – Ctrl + A
  2. Create an Invoice – Ctrl + I
  3. Pull up Customer List – Ctrl + J
  4. Create Journal Entry – Ctrl + Y
  5. Write a Check – Ctrl + W
  6. Delete the selected line in a transaction – Ctrl + Del
  7. Insert a Blank Line – Ctrl + Ins
  8. Save Transaction – Alt + S
  9. Print – Ctrl + P

Search Feature

Using the search feature of QuickBooks can save hours and hours of time looking for a transaction that may have occurred several months or years ago.  If you know some of the information about a transaction you are looking for, then the search feature is the way to go.  After pressing Ctrl + F a box will appear that allows you to search in various different ways.  Whether searching for a bill, check, invoice, payment, vendor, customer, or journal entry, this feature can find it all, no matter when the transaction occurred.  There is also the option to search by the dollar amount of the transaction.  This feature has saved not only my client’s time, but I also find it very useful and a huge time saver myself.

For those small business owners who want to minimize the amount of time needed to keep up their books, these tips and tricks can make the process a lot less tedious.  For more information on QuickBooks or QuickBooks training, contact a member of the Holbrook and Manter BSST team.

Columbus Office

Holbrook & Manter
775 Yard Street, Suite 160
Columbus, OH 43212
Phone: 614.494.5300

Worthington/Lewis Center Office

100 East Campus View Blvd. Suite 250
Columbus, Ohio 43235
Phone: 614.885.8521

Dublin Office

Holbrook & Manter
545 Metro Place S, Suite 100
Dublin, OH 43017
Phone: 614.766.3696

Marion Office

Holbrook & Manter
181 East Center Street
Marion, OH 43302
Phone: 740.387.8620

Marysville Office

Holbrook & Manter
103 Professional Parkway
Marysville, OH 43040
Phone: 937.644.8175