Month: May 2015

How Custom Fields Provide Better Business Insight

QuickBooks makes it possible for your business to create very detailed records for customers, vendors, employees, and items. In fact, you may find that you rarely make use of every field each contains.

But you may also find that there are additional fields that you’d like to see in your predefined record formats. That’s where custom fields come in. QuickBooks lets you add extra fields and specify what their labels should be.

You can define up to 12 total fields for use in customer, vendor, and/or employee records. QuickBooks treats these just as it treats your built-in fields. They appear in the records themselves, of course, and are included when you export a file containing them. You can also search for them in reports.

People Records

There are separate processes for defining fields for your individual and company contacts and your items. Let’s look at how you can set up custom fields for customers, vendors, and employees first.

Go to your Customer Center and open a blank Customer record (in newer versions of QuickBooks, you’ll click on New Customer & Job in the upper left corner, and then click New Customer). Then click theAdditional Info tab in the left vertical pane of the New Customerwindow, then click on the Define Fields button in the lower right. This window will open (with blank fields):


Figure 1: You can create up to 12 total custom fields that will be shared by customers, vendors, and employees.

It’s easy to create your custom field labels. Simply type a word or a short phrase on a line under Label, and then click in the box(es) on the same line in the appropriate column(s). While it’s possible that you would want to include the same field in multiple record types, you’ll most likely have separate labels for each.

Consider carefully before creating custom field labels. Ask yourself questions like:

  • What do I want to know about customers/vendors/employees that isn’t already covered in the pre-built record formats?
  • What kinds of information will I want to make available in report filters?
  • How will I want to separate out individuals for communications like emails, memos, special sale invitations, etc.

Remember that you’ll have to go back into existing records and fill in these blanks in order to be consistent. You’re not required to complete them, but your searches, reports, etc. will not be comprehensive if you don’t.

Item Records

The custom fields just created are generally only used internally. That is, they won’t automatically appear on sales forms, purchase orders, etc.

You may decide that some custom fields in item records, on the other hand, do need to be available on some forms. For example, you might sell shirts in multiple sizes, colors, and styles.

To start creating them, open the Lists menu and select Item List. Click the down arrow on the Item menu in the lower left, then click New. Since you will be selling similar items that you’ll be keeping in stock, select Inventory Part under TYPE. Then click on the Custom Fieldsbutton over on the right and then Define Fields.


Figure 2: If you sell similar items that are available with different characteristics, you’ll want to create custom fields.

As you did with the earlier custom fields, enter a word or phrase underLabel and then click in the Use column. After you’ve entered up to five fields, click OK.

A Complicated Process

This is where the simplicity of creating and using custom fields for items in reports and transaction forms ends. If you sell t-shirts in various sizes and colors, you’re going to need help in order to see true inventory levels in reports and add those custom fields to sales and purchase transaction forms.


Figure 3: Adding custom fields to QuickBooks’ standard transaction forms is possible, but you’ll need our assistance to make sure inventory tracking is set up right.

It may be that you need more inventory-tracking tools than are offered in your version of QuickBooks. If that’s the case, you can either add an application that will meet your needs or suggest an upgrade. Don’t hesitate to call the office if you have any questions.

Relief for Certain Small Business Retirement Plans

Small businesses that have failed to timely file certain required retirement plan returns have until Tuesday, June 2 to take advantage of a special IRS penalty relief program.

Launched June 2, 2014, the one-year temporary pilot program is designed to help small businesses with retirement plans that may have been unaware of the reporting requirements that apply to these plans. Normally, plan administrators and sponsors of these plans who fail to file required annual returns, usually Form 5500-EZ, can face stiff penalties–up to $15,000 per return.

By filing late returns by June 2, eligible filers can avoid these penalties. So far, about 6,000 delinquent returns have been filed under this program.

This program is generally open to certain small business (owner-spouse) plans and plans of business partnerships (together, “one-participant plans”) and certain foreign plans. Those who have already been assessed a penalty for late filings are not eligible for this program.

Applicants under the program may include multiple late returns in a single submission. There is no filing fee or other payment required.

For more information or details on how to participate in this pilot program, please call the office.

Seven Tips to Determine if Your Gift is Taxable

If you gave money or property to someone as a gift, you may wonder about the federal gift tax. Many gifts are not subject to the gift tax. Here are seven tax tips about gifts and the gift tax.

1. Nontaxable Gifts. The general rule is that any gift is a taxable gift. However, there are exceptions to this rule. The following are not taxable gifts:

  • Gifts that do not exceed the annual exclusion for the calendar year,
  • Tuition or medical expenses you paid directly to a medical or educational institution for someone,
  • Gifts to your spouse (for federal tax purposes, the term “spouse” includes individuals of the same sex who are lawfully married),
  • Gifts to a political organization for its use, and
  • Gifts to charities.

2. Annual Exclusion. Most gifts are not subject to the gift tax. For example, there is usually no tax if you make a gift to your spouse or to a charity. If you give a gift to someone else, the gift tax usually does not apply until the value of the gift exceeds the annual exclusion for the year. For 2015, the annual exclusion is $14,000 (same as 2014).

3. No Tax on Recipient. Generally, the person who receives your gift will not have to pay a federal gift tax. That person also does not pay income tax on the value of the gift received.

4. Gifts Not Deductible. Making a gift does not ordinarily affect your federal income tax. You cannot deduct the value of gifts you make (other than deductible charitable contributions).

5. Forgiven and Certain Loans. The gift tax may also apply when you forgive a debt or make a loan that is interest-free or below the market interest rate.

6. Gift-Splitting. You and your spouse can give a gift up to $28,000 to a third party without making it a taxable gift. You can consider that one-half of the gift be given by you and one-half by your spouse.

7. Filing Requirement. You must file Form 709, United States Gift (and Generation-Skipping Transfer) Tax Return, if any of the following apply:

  • You gave gifts to at least one person (other than your spouse) that amount to more than the annual exclusion for the year.
  • You and your spouse are splitting a gift. This is true even if half of the split gift is less than the annual exclusion.
  • You gave someone (other than your spouse) a gift of a future interest that they can’t actually possess, enjoy, or from which they’ll receive income later.
  • You gave your spouse an interest in property that will terminate due to a future event.

Questions about the gift tax? Don’t hesitate to call.

Scroll to top