August Accounting Back-To-School Education Series: QuickBooks Tips

The beginning of August is always bittersweet. As we head into the final month of summer, we feel the urge to relish every last moment that waning summer days have to offer—while keeping one eye on the “back to school” vibe permeating the air around us. Even if you’ve been out of school for a while, the lure of clean notebooks and sharpened pencils (or, ahem, shiny iPads and wearable gadgets) is enough to bring you back to the moments in early September when all is fresh, new and inviting for education.

Perhaps it’s just us—or our back-to-school nostalgia—but beginning today and for the entire month of August, we will be committing ourselves to improving accounting and bookkeeping education. From QuickBooks tips and tricks to how-tos for the latest software integrations, we will be bringing you everything you ever wanted to learn about accounting and bookkeeping! (We know, we know—we can hear your applause from here).

To get started, we’re contributing a few of our go-to favorites to a Webucator Tips series, where students can for QuickBooks training. So without further ado, let’s get Back To School!

AccountingDepartment.com Back To School Series Day 1: Making QuickBooks Work With You

Beginner Level: QuickBooks Keyboard Short Cuts

  • Control + A = brings up the Chart of Accounts
  • Space Bar = marks or un-marks items or boxes with check marks
  • Control + F = opens Find Transactions window
  • Control + Q = brings you a quick report of transactions for each item in a list you have highlighted (sale item, customer, vendor, etc.)
  • Alt + F4 = exits the QuickBooks software
  • Control + M = brings up the Memorize Transaction option
  • Control + Delete Key = deletes a line
  • Control + Insert Key = inserts a line
  • Alt + Down Arrow Key = displays list for a field
  • Control + E = lets you edit a transaction
  • Control + I = creates a customer invoice
  • Control + W = opens up Write Checks window

Intermediate Level: Customizing the QuickBooks Icon Bar

The QuickBooks Icon Bar can be customized for convenient access to your most frequently used QuickBooks windows. Shortcuts appearing on the Icon Bar by default can be removed, and shortcuts for any window in QuickBooks can be added.

Customize the Icon Bar by selecting View > Customize Icon Bar to open the “Customize Icon Bar” window. A list of shortcuts currently appearing on the Icon Bar appears under “Icon Bar Content”.

To remove a shortcut that is not needed, simply highlight the name of the shortcut in the list and click Delete. To add shortcuts from the pre-defined shortcut list to the Icon Bar, click the Add… button to open the “Add Icon Bar Item” window. Highlight the shortcut you wish to add and click OK to return to the “Customize Icon Bar” window.

To reorder the icons within the Icon Bar, click the diamond next to the item you wish to reposition and drag it up or down to the desired location.

Shortcuts for similar tasks can be grouped together on the Icon Bar using Separators, which appear as (space) in the “Icon Bar Content” list. Separators can be added, deleted, and reordered in the same way as shortcuts.

Display Options for the Icon Bar are set by default to “Show icons and text.” If desired, the Display Options can be changed to “Show icons only” to remove the text description from the shortcuts on the Icon Bar.

Shortcuts can be added to the Icon Bar for any window in QuickBooks, even if the shortcut does not appear in the pre-defined list. Begin by opening the window for the shortcut you wish to add. This can be a transaction (Make Journal Entry), a list (Memorized Report List), a register, or a specific report. With the window displayed on the screen, select View > Add “” to Icon Bar… to open the “Add Window to Icon Bar” window. Select an icon for your new shortcut from the list on the left. QuickBooks suggests a label for the shortcut in the Label field. You can either accept the suggested label or modify it as preferred. Click OK to add the new shortcut to your Icon Bar. Once added, the new shortcut can be reordered in the “Customize Icon Bar” window.

The QuickBooks Icon Bar is user-specific, so each user can customize the Icon Bar to suit his or her preferences.

Advanced Level: Customized Columns for Lists and Account Centers

The columns for Item Lists, Fixed Asset Item Lists, etc. can be customized to remove data fields that are not applicable or to add data fields that you frequently use, including custom data fields. This way you can view it at a glance, instead of having to open/edit the item to view data fields.

Open the Item List (Lists > Item List). Right click and select Customize Columns in the pop-up window. The Customize Columns box pops up (shown below).

You can add or remove data fields and move them up or down so that they appear in the desired order.

The columns in the Vendor and Customer Centers can also be customized to add or remove data fields. For example, you can add the Due Date or Open Balance columns. If you have a client that frequently pays partial amounts, the Open Balance column allows you to quickly see the unpaid amount of each bill, without having to run an Open Balance Report. Same for A/R customer partial payments of invoices.

When in the Vendor or Customer Center, right click (in the lower right section of the Vendor Information or Customer Information window, where the transactions are listed) and select Customize Columns in the pop-up window. The Customize Columns box pops up (shown below).

You can add or remove data fields and move them up or down so that they appear in the desired order when you look at vendor/customer records in the Vendor/Customer Center.

Looking for a professional outsourced bookkeeping or accounting service to take care of QuickBooks for you? Our full time, expert accounting professionals can help!

#100HappyDays Update!

Saturday, May 3, #Day39: AccountingDepartment.com Co-Founder Dennis Najjar has thrown down a challenge to ADC employees—can you walk 150 miles between 5/1/14 and 8/31/14? To break it down, we’re saying pick 100 of the 133 days and walk just 1.5 miles each day… and you’ll have walked 150 miles this summer! Many ADC employees said “CHALLENGE ACCEPTED” and away we go! We’ll keep you posted on our progress with hashtag #150ADCMiles

Sunday, May 4, #Day40: Happy Birthday Jodi G.! May the Fourth be with you… and have an amazing day!

Monday, May 5, #Day41: AccountingDepartment.com Co-Founder Bill Gerber meets Women Presidents’ Organization Founder Marsha Firestone… Who is AWESOME and leads an amazing organization, whose annual conference we were lucky to be a part!

Tuesday, May 6: #Day42: AccountingDepartment.com Marketing Manager Andrea Boccard passed her Hubspot Certification test—furthering ADC goals of becoming #Inbound Marketing experts!

Once again catching up on #100HappyDays - here goes #Day30 - #Day34

Thursday April 24th, #Day30 - We’re happy to have Intuit / QuickBooks Online supporting us as we bring virtual accounting to small businesses across the nation!

Friday April 25th, #Day31 - We’re happy to have awesome new photos of our Directors, shot by Michael Palumbo (http://www.mpphotography.com/) in New Orleans.

Saturdsay April 26th, #Day32 - We’re happy to have each other as more than just colleagues—we’re friends! We share in each other’s lives, cheer accomplishments, support personal needs and have developed strong bonds. Just this weekend we shared baby photos, kids’ prom photos and a host of love and support for those in the tornado areas. We <3 our co-workers!

Sunday April 27th, #Day33 - We’re happy to have expense report technology provider Tallie (https://usetallie.com/) to help us bring the best accounting technology solutions to our friends and clients… they developed some awesome new creative materials and we’re pumped to have some to share with our clients!

Monday April 28th, #Day34 - We’re happy to celebrate the 6 year work anniversary of ADC Bookkeepers Carla S. and Deb M. - they both help make our company AccountingDepartment.com awesome!