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 the Additional Info tab in the left vertical pane of the New Customer window, then click on the Define Fields button in the lower right. It’s easy to create your custom field labels. Simply type a word or 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.
As always, you can consult with us if you want some suggestions.
Item Records
The custom fields we 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 Fields button over on the right and then Define Fields.
As you did with the earlier custom fields, enter a word or phrase under Label 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 our help in order to see true inventory levels in reports and add those custom fields to sales and purchase transaction forms. It may be that you need more inventory-tracking tools than are offered in your version of QuickBooks. If that’s the case, we can help you either add an application that will meet your needs or suggest an upgrade.
If you have questions or need assistance, contact the experts at Henssler Financial:
- Experts Request Form
- Email: experts@henssler.com
- Phone: 770-429-9166
Disclosures: This article is meant to provide valuable background information on particular investments, NOT a recommendation to buy. The investments referenced within this article may currently be traded by Henssler Financial. All material presented is compiled from sources believed to be reliable and current, but accuracy cannot be guaranteed. The contents are intended for general information purposes only. Information provided should not be the sole basis in making any decisions and is not intended to replace the advice of a qualified professional, such as a tax consultant, insurance adviser or attorney. Although this material is designed to provide accurate and authoritative information with respect to the subject matter, it may not apply in all situations. Readers are urged to consult with their adviser concerning specific situations and questions. This is not to be construed as an offer to buy or sell any financial instruments. It is not our intention to state, indicate or imply in any manner that current or past results are indicative of future profitability or expectations. As with all investments, there are associated inherent risks. Please obtain and review all financial material carefully before investing. Henssler is not licensed to offer or sell insurance products, and this overview is not to be construed as an offer to purchase any insurance products.
