LUTZ BUSINESS INSIGHTS

 

Confused by quickbooks’ report customization?

amanda harpster, client accounting services manager

 

If you’re still doing your accounting on paper, you know how challenging it is to create reports. You might be able to cobble together a simple report using Excel, but even that takes time and skill.

QuickBooks makes that critical process easier. It comes with dozens of pre-formatted report templates. You simply choose one, and the software fills it with your company’s own data. You can even modify it to target the exact slice of data you need.

Here’s a simple example. Let’s say you want a list of residential customers who are 60 days or more in arrears. You would open the Reports menu and select Customers & Receivables, then A/R Aging Detail. The report will open; by default, it lists all transactions. Click Customize Report in the upper left corner, and the Modify Report: A/R Aging Detail window opens.

 

 Modify Report: A/R Aging Detail

 

Click the Filters tab. The list that displays under CHOOSE FILTER contains all of the data types you can choose for your customization. Click Account. The middle column will provide your options here. Open the drop-down list in the middle column and select All accounts receivable. That filter will appear in the third column.

Go back to the first column and select the second filter listed there, Aging. The middle column actually gives you four options. Choosing Any wouldn’t pare down the list. The next line lets you enter a number that is equal to, greater than, or less than a specific number. You want to see the customers who are 60 days or more past due, so you would click in the radial to the left of >=  and enter 60 in the box.

You are limiting your search to residential customers, so you would go back to the first column and scroll down to Customer Type. Open the drop-down list in the second column and select Residential. The next filter in the first column is Date. Click on that to highlight it, then select Today in the second column. And there’s one more: Select the Paid Status filter and select Open.

As you continue to select filters, you’ll notice that they appear in the third column. At this point, you’ve selected five, and you could choose more if you wanted to, but that’s not necessary for this customization. If you’ve made a mistake, simply highlight the incorrect filter in the third column and click on Remove Selected Filter. When you’re done, click OK. Your modified report will appear.

You can see from scanning the list of available filters that you could set up very complex searches. You could also modify the report’s column structure, its header and footer, and the way fonts and numbers appear. We are happy to help you customize your reports and explore any other QuickBooks features that can help you make better business decisions. Contact us anytime to schedule a consultation.

ABOUT THE AUTHOR

402.827.2307

aharpster@lutz.us

AMANDA HARPSTER + CLIENT ACCOUNTING SERVICES MANAGER

Amanda Harpster is a Client Accounting Services Manager at Lutz with over 14 years of relevant experience. She focuses on QuickBooks support, tax and payroll compliance, and small business consulting.

AFFILIATIONS AND CREDENTIALS
  • Intuit Certified ProAdvisor, QuickBooks
EDUCATIONAL BACKGROUND
  • BSBA in Accounting, University of Nebraska, Omaha, NE
COMMUNITY SERVICE
  • St. Patrick’s Parish, Volunteer
  • Cub Scout Pack #409, Treasurer
  • Ponca Hills Fire Department Women’s Auxiliary, Member
QUICKBOOKS PROADVISOR CERTIFICATIONS

Certified ProAdvisor - Online  

SIGN UP FOR OUR NEWSLETTERS!

We tap into the vast knowledge and experience within our organization to provide you with monthly content on topics and ideas that drive and challenge your company every day.

Toll-Free: 866.577.0780  |  Privacy Policy

All content © Lutz & Company, PC

VIEW MODIFIED SUMMER HOURS HERE

OMAHA

13616 California Street, Suite 300

Omaha, NE 68154

P: 402.496.8800

HASTINGS

747 N Burlington Avenue, Suite 401

Hastings, NE 68901

P: 402.462.4154

LINCOLN 

601 P Street, Suite 103

Lincoln, NE 68508

P: 531.500.2000

GRAND ISLAND

3320 James Road, Suite 100

Grand Island, NE 68803

P: 308.382.7850