Generating Professional Reports with QuickBooks

You probably already run reports in QuickBooks – but are you making full use of the program’s reporting tools?

Let’s take a look. Reporting changed a lot between QuickBooks 2009 and 2010 in terms of interface, navigation, and access to reports. We’ll look at version 2010 since the core reporting mechanisms are similar, and wrap up with a brief summary of the new features in 2010.

Extensive Customization

Open the Reports menu. You can go directly to the Report Center, but since the interfaces are different (and very self-explanatory), we’ll work from the menu.

Drop down to Sales, and in the pop-out menu, click Sales by Customer Detail. You’ll see a window similar to Figure 1.

Figure 1: You may just be changing the date range when you run reports in QuickBooks. If so, you’re missing out on a lot of customization and other features.

 

Don’t like displaying the date/time/basis for each report? Click Hide Header and then Show Header if you want to bring it back.

Is the text in some of your columns – usually Name, Item, and Memo – being truncated (such as “Gutter clean…” in the example above)? Grab the diamond to the right of the column name and drag it to the right with your mouse. It may take some adjusting to make every column header display properly.

Are you exporting a lot of reports to Excel workbooks but never clicking on the Advanced tab in the dialog box? If your reports always look different in Excel and you don’t like them, it may be because you’re skipping this step. Click the Export button, and the dialog box shown in Figure 2 appears. Click Advanced to see this view.

Figure 2: Before you export a report to an Excel worksheet, click the Advanced tab in the Export Report dialog box. You’ll be able to select options that will preserve or ignore the original QuickBooks formatting.

 

Sophisticated Modifications

To get to the real meat of your modifications, click the Modify Report button. You’ll be able to tinker with a number of report elements here, including (and shown in Figure 3):

  • Display. What dates should the report cover? Which columns should display? (You’ll have plenty to choose from.) Cash or accrual? How do you want to total and sort data? Click Advanced to show all accounts or those in use during the report period, and to display a customer’s current balance or the balance as of the report’s ending date.
  • Filters. QuickBooks builds in powerful filtering capabilities, allowing you to corral a subset of data that contains exactly what you want, down to the words included in the Memo field. Take some time here and read the accompanying help files. A box on the right displays the current filters; you can easily remove any of them or revert to the original configuration.
  • Header/footer. Easy stuff. How should the report look? QuickBooks gives you a lot of control over that. You’ll simply check or uncheck boxes, and enter information.
  • Fonts & Numbers. Easy there, too. You can make choices about the fonts and colors you want your report to contain, and how you want numbers to be displayed.

Figure 3: QuickBooks gives you an enormous amount of control over the format and content of your reports.

 

Memorization and More

Once you’ve gone through all the trouble of formatting a report, you’ll probably want to save it so you can use it again (the settings are memorized, not the data). QuickBooks makes this easy. With the report open, click Memorize. In the window that opens, type a name for your report (if you want to specify a new one), and check the box next to Save in Memorized Report Group if you want it categorized. To access a memorized report, open the Reports menu and put your mouse on Memorized Reports. From the pop-out menu, select the report you want. You’ll still be able to modify it.

The new Report Center in QuickBooks 2010, shown in Figure 4, makes it easier to locate the desired reports quickly. It features a scrolling 3D representation of sample reports in each financial category (list and grid views are also available); you can click on icons in a toolbar to see your own version of the report, change the dates, learn more about it, and tag it as a favorite. Other links let you toggle the view among standard, memorized, favorite, and recently accessed reports.

Figure 4: This “carousel” view of sample reports in QuickBooks 2010 especially helps beginners find the correct report. Grid and list views are also available, as are other tools for locating the right screen.

 

When you’re just running reports for your own edification, you may not do more than select a report and change the date range. But there will likely be many occasions when you’re presenting reports to an audience, like bankers or potential customers. QuickBooks’s report tools can help you slice and dice your data in myriad ways and make your financials look polished and professional. The ability to export to Excel opens up even more possibilities.

If you need help with this feature, or you have any questions about QuickBooks, don’t hesitate to give us a call.



kim

Kimberly Mitchell
Partner Development Manager

 

Kim is a Partner Development Manager with 10 years of experience working with Strategic Partners. As a 19-year veteran with Intuit and a history of driving growth and sales results within the QuickBooks echo system Kim, brings a wealth of knowledge to our team by assisting us with sales and marketing initiatives while helping us strive for the highest net promoter (clients satisfaction) scores. Kim is passionate about creating and nurturing new partnership opportunities through the relationships she has built over the past 25 years of sales experience.

This will close in 0 seconds

Noah

Noah Raney
Senior Account Payroll Manager

 

Noah is our dedicated Intuit Senior Account Payroll Manager who can help you find the right payroll solution for you and your business. He is well versed in all of the QuickBooks platforms being desktop/online/standalone and payroll has been his world since joining Intuit 13 years ago. Whether you are looking for ways to save on time, reduce inflated payroll costs or just get set up with the best discounts, he is here to help. Your success and satisfaction are of utmost importance!

This will close in 0 seconds

Sean

Sean McCaffery
Global Channel Sales Partnerships and Alliances Leader

 

Sean McCaffery has more than 15 years of experience leading channel sales and cloud solutions in the US and Internationally. Sean has held leadership positions with Avaya in Europe growing the channel business with resellers and distributors in key countries driving double-digit growth. He then joined Rackspace Technology and was instrumental in developing sales growth strategies in cloud adoption for customers and partners. Most recently, he ran channels at Dizzion responsible for dynamically growing and expanding the partner ecosystem through SaaS-based VDI solutions before joining Intuit. Currently, he runs the QuickBooks Solution Provider Program supporting the strong business that solution providers and ISV partners have established as well as finding new opportunities to drive emerging mid-market growth together!

This will close in 0 seconds

Gabor

Gabor Terebesi
Account Manager

 

Gabor Terebesi is an Account Manager with the Payments Team of Intuit for over 15 years. He works in the partner division for Intuit payments to ensure Intuit partners along with any clients of theirs are in the most suitable and financially cost-effective solution accepting payments through eCommerce, QuickBooks, mobile payments, or any other options necessary for their business.

This will close in 0 seconds

Aimee

Aimee Garneau
Accounting Manager

 

Aimee joined Siegel in 2022 as the Accounting Manager overseeing the accounting and bookkeeping team. Aimee brings 18 years of experience with increased responsibility with privately and publicly held companies. Her experience lies with SaaS-based companies as well as in healthcare, consulting, education and nonprofits. Prior to joining Siegel, she held accounting leadership positions with Waban Projects, Elastic Path, Moltin, and Ned Davis Research. Aimee loves partnering with business owners to establish financial reporting and results that promote growth and expansion. When Aimee is not working, she loves spending time with her family and friends and exploring all New England has to offer. She is also an avid Red Sox fan and enjoys going to Fenway Park when she can.

This will close in 0 seconds

Jeffrey Siegel
CPA, CEO

Jeff has spent the last twenty years working providing solutions to emerging growth businesses. After graduating from Northeastern University, he spent five years working with two multinational CPA firms in an auditor capacity building a foundation for understanding how business work. He later went on to work in various controller and CFO roles before starting Siegel & Associates (previously Siegel Financial Group) in 2000. In those roles, he sold a company to ADP, raised funds for a major expansion of a large regional IVF clinic, and helped set up accounting and financial structures for dozens of companies. Since starting Siegel & Associates, Jeff has worked with hundreds of clients providing accounting system solutions. Those solutions include setting up QuickBooks in a single-user environment putting in QuickBooks Enterprise in a 30-user environment and integrating various add-ons including inventory, CRM, and e-commerce. He is a Certified Public Accountant, a QuickBooks Pro Advisor, a QuickBooks Advanced Pro Advisor, and an Intuit Solution Provider certified in Enterprise Solutions, Point of Sale & QuickBase. Jeff is also a Microsoft Certified Systems Engineer

This will close in 0 seconds

Lori Swartz
Client Support Manager

After graduating from Boston University, Lori spent eight years working in various managerial positions for two national companies. In those positions, Lori developed the skills necessary to manage multiple projects, clients, and resources. She later went on to work for a management company that handled over 25 real estate properties with multiple tenants. Lori joined Siegel Solutions in 2003 as a client services manager where she utilized her skills developed to manage multiple clients and multiple staff. She recently moved into the client support manager role where she is responsible for meeting with and onboarding new clients, managing and maintaining our technology stack along with QuickBooks setups, conversions, training, and consulting.

In her free time, Lori enjoys spending time with her family. She loves to travel, music, and theater.

This will close in 0 seconds

Kristin Hogan
Office Administrator

Kristin has been with Siegel Solutions since 2008 when she started as a part-time Office Administrator. In addition to the administrative work for Siegel Solutions, Kristin also assists with bookkeeping for a handful of clients, and manages and processes payroll for about 25 clients. Kristin has been working in administrative roles for many years in various fields, including from an academic department in a local university, a start-up biomedical company, to recording and pricing inventory for a small gift shop. Kristin has also held customer service positions in food service, department stores, a local Boys & Girls Club, and a nursing home.

Outside of work, Kristin enjoys hanging out with family, friends, and the family’s black lab named Clyde. Kristin is a New England Revolution fan and goes to as many games as possible each season.

This will close in 0 seconds

Kathy Crouse
Senior Bookkeeping Associate

Kathy graduated from Framingham State College. She then attended Bently College in their Accounting Certificate program, while also working as an Assistant Payroll Supervisor and Compensation Specialist in the corporate offices of a large contract employer. After many years of experience as a Full Charge Bookkeeper for a private investment firm, and various small CPA firms, Kathy joined Siegel Solutions in 2001. She enjoys learning about different types of businesses working for Siegel and the satisfaction of tailoring our role to best serve each client's needs.

During her free time, Kathy loves spending time with her family and her dog. She also enjoys DIY projects and exploring the beautiful New England coast.

This will close in 0 seconds

Janet

Janet Jodoin
Bookkeeping Associate

Janet joined Siegel Solutions in May of 2022 as an Associate Bookkeeper. In her younger years, while raising her family, she completed her degree in Business and she spent 20 years in the trades as a custom designer. Janet also has 16 years in corporate management. Her strong team support, training, and development led her to support and manage Human Resources. Janet's desire to change careers has led her to return back to bookkeeping at Siegel Solutions. In Janet's free time she enjoys spending time with her growing family. Her personal favorite is creative landscaping in her yard. She also enjoys working alongside her partner in construction and remodeling.

This will close in 0 seconds

Tricia

Tricia Gullage
Associate

Tricia Joined Siegel Solutions in 2022 as a bookkeeper and works with our clients to keep their day-to-day bookkeeping in order. Tricia has 12 years of bookkeeping experience working for a large construction company for 10 of those years handling all their accounting and Payroll. She met Jeff our CEO while working there and decided she wanted to join our team.

When not working Tricia enjoys spending time with her family and friends. She recently moved up to the lakes region in NH and loves going to concerts, enjoying her time boating and snowmobiling.

This will close in 0 seconds