different time

Modifying Reports: Better Insight Into Past, Future

If you make one resolution about improving your accounting procedures in 2012, it should be this: Make extensive use of the tools that QuickBooks offers for report modification. Comprehensive, meticulously-shaped reports that flow out of your carefully-constructed records and transactions are your reward for pounding on the keys every day, conscientiously recording income and expenses.

QuickBooks supplies you with a wide variety of pre-formatted reports whose modification options can help you do focused, critical analysis of your financial data. The right set of numbers will help you understand your history and plan for the future more effectively.

Note: The reports discussed and pictured here shows only one possible set of customization options. There are many variations. We can answer your questions.

Check your preferences

When you created your company file in QuickBooks, you chose between reporting on a cash (income and expenses are recorded when money changes hands) or accrual (recorded when you invoice or receive a bill) basis. This affects summary reports, but not those that break out individual transactions or are simply lists.

If you want to change this, click Edit | Preferences | Reports & Graphs | Company Preferences and click the desired button:

Figure 1: You can establish a preference for your summary reports’ basis here.

You can set other preferences in this window that will affect your report output here, too, as you can see.

Altering the display

Open the Income by Customer Summary report (Reports | Company & Financial). Change the dates to reflect a range you’d like to see. Want the data displayed by different time increments — like week or quarter — instead of just the total? Click the arrow next to Columns and select Four week.

Figure 2: You can do some report display alterations from this toolbar; the options it offers vary by report.

By default, your report rows display alphabetically. If you want to view a column by total in ascending or descending order, select the column by hovering over the top number until the magnifying glass appears, and click on it. Click the arrow next to Sort by and choose Total, then click the AZ [down arrow] icon (in some reports, there will be other options here).

Additional options in this toolbar let you:

Memorize the report
Print, email or export it to Excel
Hide or Show the Header
Collapse or Expand the columns
Refresh the report if you’ve made changes that will alter data

More display options

Click Customize Report to open this window:

Figure 3: This window outlines your report’s content options.

Some of the options here duplicate what you saw in the toolbar. In addition, you can switch between Accrual and Cash for just this report, and add subcolumns in some. The latter is a complicated operation, one that you must understand well in order to glean any insight from it. We can help you with this.

Sometimes the subcolumns are generic, as shown in the screen above. In other reports, they’re very specific to that group of data.

Clicking on Revert takes you back to the default format, and Advancedopens additional options specific to the current report.

More customization = more insightful results = more informed financial choices

Transaction reports have many similarities and two major differences: You can change the column order by hovering your cursor over the column label until a hand appears. Click, hold and drag the column to the desired spot and let go. You can also add or delete columns by clicking Customize Report and checking or unchecking labels.

Figure 4: In transaction — or detail — reports, you can alter the column structure.

Learn the mechanics of report display modification well, and your company’s finances will come into much sharper focus, improving the wisdom of future choices. Up next month: filtering your reports for additional clarity.

If you have questions on this or any other QuickBooks feature, call or email us. We’re your partner and we’re here to make your business better.

QuickBooks 2012: Better Financial Management

As it usually does this time of year, Intuit has introduced new versions of its Pro and Premier products. QuickBooks 2012 promises to help you get better organized, save steps, and acquire more in-depth financial insights.

The new Express Start is designed for businesses that want to blast through setup and start entering customers and invoices. You have two other options though.

Advanced Setup is the old EasyStep interview that solicits more details. You can also open an existing file or convert data from Quicken or other accounting software.

Express Start requires minimal input. Company name, industry, company type, tax ID, and contact information is all that’s required. After you save your company file, it lets you start adding or importing customers/vendors/employees, products/services, and bank accounts.

Figure 1: Express Start simplifies company setup

An Activity-Driven Calendar

QuickBooks’ Reminders keep you apprised of each day’s tasks, but they don’t provide any information about the past or future. QuickBooks 2012 solves this problem with its new Calendar. When you enter an appointment, to-do, or key business task (invoices, bills, purchase orders, etc.), it appears in the calendar. You can display a graphical view of the month that tallies activities for each day and lists them below. Daily and weekly views are in list form and links open the original documents.

Figure 2: The new Calendar displays daily, weekly, and monthly views of your financial transactions

Save Excel Formatting

Once you’ve formatted a QuickBooks report in Excel, it’s frustrating to have to reformat it each time you run it for different time periods and/or with your ever-changing content. Excel Integration Refresh simplifies this process. You can now export a report to Excel, make formatting changes and save them, and then reapply them later to the same type of report using different date ranges and your updated QuickBooks data. Acceptable alterations include:

Row and column header font formatting
New formulas
Renamed column and row headers, and report titles
Resized columns
Inserted columns and rows
Inserted formula text

You can do this by opening your report in QuickBooks and clicking Update an existing worksheet, or by launching your report in Excel and clicking the QuickBooks tab on the toolbar, then the Update Report button.

Figure 3: This window opens when you click Update Report in Excel

A New Report Community

There’s always room for more report formats. QuickBooks 2012 offers a library of Contributed Reports, variations created either by Intuit or your fellow users. You can select one of these, like Customer Sales By Quantity By Item Detail and instantly populate it with your own data.

You can sort these templates by industry and rating, and view them as a list, in a grid, or in the Report Center’s Carousel view.

Centralized Operations

QuickBooks 2012 also saves you time with its new Centers. The Inventory Center works similarly to those available for customers, vendors, and employees. It’s a clearinghouse of item records and transactions that can be viewed and sorted. You can also do inventory housekeeping tasks here, like adding items and launching transactions.

The Lead Center helps you carefully track new leads that you either paste in from Excel or enter manually. You can add to-dos and notes to contact records, and convert them into customers.

Upgrading Can Be Tricky

Intuit has included other, smaller time-saving organizational and reporting tools in QuickBooks 2012, like One-Click Transactions, which lets you create related transactions from existing ones (i.e., invoice to credit memo) with one click.

There’s nothing especially difficult about using most of QuickBooks 2012’s new features. But upgrading and setup are sometimes quirky, and the Excel Integration Refresh tool has a learning curve. We’re happy to help you start your company file on the right foot or get acclimated to this latest version.

Figure 4: Track your leads and convert them into customers in the new Lead Center