Month: October 2014

Customize Reports, Make Better Business Decisions

Do you remember why you started using QuickBooks?

You may have simply wanted to produce sales forms and record payments electronically, over time expanded your use of the software–perhaps paying and tracking bills through it and keeping an eagle eye on your inventory levels.

And, it’s likely that you’ve also run at least some of the pre-built report templates offered by all versions of QuickBooks since their inception.

QuickBooks’ automation of your daily bookkeeping tasks has undoubtedly served you well. But that’s merely limited use; now it’s time to take advantage of QuickBooks’ greatest strength: customizable reports.

One of the rewards for diligently entering all of your accounting information is a better grasp of your company’s financial performance to date. That insight ultimately leads to better business decisions that can contribute to your future growth and success.


Figure 1: QuickBooks’ Report Center can help you learn about what each report is designed to tell you. But smart customization requires deeper insight. 

Making Reports Meaningful

Like many other tasks in QuickBooks, report customization tools aren’t that difficult to master. What’s challenging is:

  • Understanding what each report is designed to tell you
  • Determining which reports are most relevant to your business information needs, and
  • Designing each to produce the critical insight you need in order to move forward.

The first of these is fairly clear. You can understand what many reports do by their titles, their content, and the descriptions QuickBooks offers. We recommend that you spend some time looking at the Report Center in QuickBooks to familiarize yourself with your options.

The second two challenges are a bit more formidable. It’s our job to assist you in establishing a workflow in QuickBooks to keep accurate records and produce necessary transactions. But we want you to do more than just maintain the status quo. When you analyze and interpret what your reports are telling you, you can make smart business decisions.

So if we haven’t gone over this with you already, we encourage you to schedule some time with us so you can get the maximum benefit from your QuickBooks reports.


Figure 2: You can’t miss QuickBooks’ customization link when you open a report. But the trick is knowing how to best use its options for your business. 

A Simple Set of Steps

Let’s take a look at a report you may already be generate: Sales by Customer Detail (Reports | Sales | Sales by Customer Detail). QuickBooks comes with a commonly-used set of default columns in its reports. This particular report contains column labels like Type (invoice, sales receipt, etc.), Item and Quantity, and Sales Price.

You can easily change the date range that’s offered as a default up below the toolbar. But to get to QuickBooks’ powerful customization tools, click Customize Report. A window with four tabs opens. They are:

Display. Options in this window help you specify the columns you want to appear in your report. In the lower left corner, there’s a list titled Columns that contains every possible column label for that report. If you scroll down, you’ll see a check mark in front of the default columns. Click on any of those to uncheck them, and click in front of any that you’d like to add. Other options here include how your data should be totaled and sorted. Some reports let you choose between cash and accrual basis.

Filters. This is the difficult one–and the tool that will provide the most insight. Filters determine which subsets of related data you’ll see (accounts, items, customer types, zip codes, etc.) by including only those that meet certain conditions. Here’s where we can really help you answer critical business questions that will lead you to smart decisions.


Figure 3: In this example, you’ve created a filter that will find all commercial drywall jobs that have been invoiced in the current fiscal quarter. You could narrow this report further by, for example, class, state, and paid status. 

Header/Footer and Fonts & Numbers. You can tailor the design and layout of your reports here.

Well-formulated reports can help you spot cash flow problems, maintain the right inventory levels, see which jobs are the most profitable, and compare your estimates to actual costs. You’ll also be able to identify your best customers, your most sought-after items, and your most successful sales reps. Careful customization of your reports–and thorough analysis of their data–will make the answers to your constant questions about your company’s future direction much clearer. We can help you take full advantage of these powerful tools.

Tips for Self-Employed Taxpayers

If you are an independent contractor or run your own business, there are a few basic things to know when it comes to your federal tax return. Here are six tips you should know about income from self-employment:

  • Self-employment income can include income you received for part-time work. This is in addition to income from your regular job.
  • You must file a Schedule C, Profit or Loss from Business, or Schedule C-EZ, Net Profit from Business, with your Form 1040.
  • You may have to pay self-employment tax as well as income tax if you made a profit. Self-employment tax includes Social Security and Medicare taxes. Use Schedule SE, Self-Employment Tax, to figure the tax. Make sure to file the schedule with your tax return.
  • You may need to make estimated tax payments. People typically make these payments on income that is not subject to withholding. You may be charged a penalty if you do not pay enough taxes throughout the year.
  • You can deduct some expenses you paid to run your trade or business. You can deduct most business expenses in full, but some must be ‘capitalized.’ This means you can deduct a portion of the expense each year over a period of years.
  • You can deduct business costs only if they are both ordinary and necessary. An ordinary expense is one that is common and accepted in your industry. A necessary expense is one that is helpful and proper for your trade or business.

Questions? We have answers. Give us a call!

Hobby or Business? Why It Matters

Millions of Americans have hobbies such as sewing, woodworking, fishing, gardening, stamp and coin collecting, but when that hobby starts to turn a profit, it might just be considered a business by the IRS.

Definition of a Hobby vs. a Business

The IRS defines a hobby as an activity that is not pursued for profit. A business, on the other hand, is an activity that is carried out with the reasonable expectation of earning a profit.

The tax considerations are different for each activity so it’s important for taxpayers to determine whether an activity is engaged in for profit as a business or is just a hobby for personal enjoyment.

Of course, you must report and pay tax on income from almost all sources, including hobbies. But when it comes to deductions such as expenses and losses, the two activities differ in their tax implications.

Is Your Hobby Actually a Business?

If you’re not sure whether you’re running a business or simply enjoying a hobby, here are nine factors you should consider:

  • Whether you carry on the activity in a businesslike manner.
  • Whether the time and effort you put into the activity indicate you intend to make it profitable.
  • Whether you depend on income from the activity for your livelihood.
  • Whether your losses are due to circumstances beyond your control (or are normal in the startup phase of your type of business).
  • Whether you change your methods of operation in an attempt to improve profitability.
  • Whether you, or your advisors, have the knowledge needed to carry on the activity as a successful business.
  • Whether you were successful in making a profit in similar activities in the past.
  • Whether the activity makes a profit in some years, and how much profit it makes.
  • Whether you can expect to make a future profit from the appreciation of the assets used in the activity.

An activity is presumed to be for profit if it makes a profit in at least three of the last five tax years, including the current year (or at least two of the last seven years for activities that consist primarily of breeding, showing, training, or racing horses).

The IRS says that it looks at all facts when determining whether a hobby is for pleasure or business, but the profit test is the primary one. If the activity earned income in three out of the last five years, it is for profit. If the activity does not meet the profit test, the IRS will take an individualized look at the facts of your activity using the list of questions above to determine whether it’s a business or a hobby. (It should be noted that this list is not all-inclusive.)

Business Activity: If the activity is determined to be a business, you can deduct ordinary and necessary expenses for the operation of the business on a Schedule C or C-EZ on your Form 1040 without considerations for percentage limitations. An ordinary expense is one that is common and accepted in your trade or business. A necessary expense is one that is appropriate for your business.

Hobby: If an activity is a hobby, not for profit, losses from that activity may not be used to offset other income. You can only deduct expenses up to the amount of income earned from the hobby. These expenses, with other miscellaneous expenses, are itemized on Schedule A and must also meet the 2 percent limitation of your adjusted gross income in order to be deducted.

What Are Allowable Hobby Deductions?

If your activity is not carried on for profit, allowable deductions cannot exceed the gross receipts for the activity.

Note: Internal Revenue Code Section 183 (Activities Not Engaged in for Profit) limits deductions that can be claimed when an activity is not engaged in for profit. IRC 183 is sometimes referred to as the “hobby loss rule.”

Deductions for hobby activities are claimed as itemized deductions on Schedule A, Form 1040. These deductions must be taken in the following order and only to the extent stated in each of three categories:

  • Deductions that a taxpayer may claim for certain personal expenses, such as home mortgage interest and taxes, may be taken in full.
  • Deductions that don’t result in an adjustment to the basis of property, such as advertising, insurance premiums, and wages, may be taken next, to the extent gross income for the activity is more than the deductions from the first category.
  • Deductions that reduce the basis of property, such as depreciation and amortization, are taken last, but only to the extent gross income for the activity is more than the deductions taken in the first two categories.

If your hobby is regularly generating income, it could make tax sense for you to consider it a business because you might be able to lower your taxes and take certain deductions.

Still wondering whether your hobby is actually a business? Give us a call and we’ll help you figure it out.

Scroll to top