Accounting

Financial Tips for February 2012

Review Your Savings Plan

Establish or review your savings plan to begin accumulating assets for your life goals. Professional guidance will be helpful in reviewing investment alternatives.

Review Your Retirement Plan

Establish or review your retirement plan. Explore the availability of deferred compensation programs through your employer, such as 401(k) and 403(b) plans. Begin contributing as soon as you are eligible.

Review January’s Budget vs. Actuals

Compare January income and expenditures with your budget. Make adjustments as appropriate to your February expenditures. Make sure you have invested your planned savings amount for January.

Collect Your Tax Information

Verify that you have received all necessary Forms W-2 and 1099 and a statement showing the year-end balance of IRA and Keogh plans. Contact the appropriate company for any that have not been received. For those that have been received, make certain that the amounts agree with your records.

Although taxes for personal returns are not due until April 17, it is best to get an early start since additional follow-up may be necessary.

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.

7 Tips for Preparing Your Taxes Without the Stress

Many people find preparing their tax return to be stressful and frustrating. But it doesn’t have to be! Here are 7 tips for how to do your taxes without pulling out your hair:

  1. Gather your records in advance. Make sure you have all the records you need, including W-2s and 1099s. Don’t forget to save a copy for your files.
  2. Get the right forms. They’re available around the clock on the IRS Web site, www.IRS.gov.
  3. Take your time. Don’t forget to leave room for a coffee break when filling out your tax return as rushing can mean making a mistake.
  4. Double-check your math and verify all Social Security numbers. These are among the most common errors found on tax returns. Taking care will reduce your chance of hearing from the IRS. Submitting an error-free return will also speed up your refund.
  5. E-filing is easy. E-filing catches math errors and provides confirmation your return has been received. It also gives you a faster refund.
  6. Get the fastest refund. When you e-file early, you receive your refund faster. When you choose direct deposit, you receive your refund even sooner because you don’t need to wait for a check. This year, electronic filing options will speed the payment of refunds to millions of taxpayers. Taxpayers who e-file and choose direct deposit for their refunds, for example, will get their refunds in as few as 10 days. That compares to approximately six weeks for people who file a paper return and get a traditional paper check.
  7. Get started early. Don’t wait to the last minute to work on your taxes. Getting a head start will not only keep the process calm, but also mean you get your return faster.

And remember, if you run into any problems or you have any questions, call us. We are more than happy to help.

Scroll to top