customer center

Quickbooks

QuickBooks’ Custom Fields: An Overview

The beauty of QuickBooks is that it can be used for so many different kinds of businesses. Its smart design lets realtors and retail shops, plumbers and plastic surgeons use it to track income and expenses, pay bills and invoice customers, and to run those all-important reports.

But Intuit knows that QuickBooks can’t–and shouldn’t–tailor itself to individual business types (except in the industry-specific versions). So its structure and tools are somewhat generic and as universal as possible.

That’s where custom fields come in. You can simply use them for your own informational purposes, but QuickBooks also lets you create and add fields to your existing customer, vendor, employee and item records and forms, and use them as filters in reports.

A Common Application

Let’s say you want to search for your best customers to create a targeted marketing mailing.

Start by opening the Customer Center and opening any customer’s record there. Click on the Additional Info tab. In the lower right corner of this dialog box, click on Define Fields. This box (with some fields already defined in this example) opens:


Figure 1: You can create custom fields for your lists of names in this dialog box. 

You want to send mailings to customers who order frequently, or who regularly purchase big-ticket items. You can call them your “High-Value Customers.” Click in the first field that’s available in the Label column and type that phrase, then tab over to the Custcolumn and click in it to enter a checkmark. Click OK. The Edit Customer dialog box opens with the new custom field included.

This field will now appear in all of your existing customer records as well as any new ones you create. You’ll need to open the record for each High-Value Customer, click on theAdditional Info tab and enter “Yes” on the corresponding line.


Figure 2: Custom fields appear in this box in your customer records. 

Using Custom Fields in Items

If you sell physical inventory, custom fields will probably be needed in your item records. You might want to use them for t-shirt colors or sizes, for example, or to store serial or model numbers. They can be employed for all items types except subtotals, sales tax items and sales tax group items.

The process is similar to the one you used to define custom fields in your contact records. Open the Lists menu and select Item List (or Fixed Asset Item List where appropriate). Click Custom Fields in the dialog box that opens.

Tip: The Custom Fields tool is also available in the New Item dialog box. So you can move directly to that step as you create an item record if you’d like.

Click Define Fields and add your field(s). Be sure to put a checkmark in the Use column, and click OK.


Figure 3: QuickBooks also lets you define and use custom fields in your item records. 

Reports and Forms

Custom fields can be invaluable when it comes to using them in forms and reports. Your fields will automatically appear at the bottom of the Filter list within your reports’ customization tools, but you’ll have to add them manually to any forms where they should appear.

Warning: You should probably enlist our help before you customize forms. QuickBooks provides tools to help you through this process, but you will encounter some potentially confusing messages as you add fields to forms, and you may have to use the Layout Designer, which can present quite a challenge.

Let’s say you wanted to find out how many blue coffee mugs Suzanne Jenkins sold in November. You’d proceed like you normally do when you’re customizing a report, but you’d have to scroll down to the end of the Filter list to find the Color custom field that you created. You’d enter the word “Blue” in the field supplied. Your Sales by Item Summaryreport setup would look something like this:


Figure 4: Filtering a report using a custom field. 

This report will only run properly if you’ve added your Color field to your sales forms. Again, we’d be happy to help you with this, and to explore other uses for QuickBooks custom fields.

Accounting Business Quickbooks

QuickBooks Helps You Make a Statement

How do you let customers know they owe you money? Probably by sending invoices. And how’s that working for you? If your customers are all conscientious and pay on time, maybe that’s all you need to do.

But perhaps you need to consider doing at least part of your billing by dispatching statements. These forms have their drawbacks. For example, you can’t include sales tax or discounts on them. You can’t group related charges and subtotal them. And your customization options are weaker than in invoices.

Statements lay out the customer’s current financial obligation to you, including any statement charges, invoices, payments, unpaid bills and finance charges that have accrued during a specified period. Unlike invoices, they do not create new charges; they simply report on what’s already been entered. Billing statements that outline historical transactions can be sent as reminders of past due accounts, or you can use them for customers who order frequently, to keep track of items until you’re ready to bill and ship. They’re also useful when you request payment in advance.

You should not invoice for any products or services that have already been entered as statement charges or the customer will be double-billed. Statement charges show up under Recent Transactions in the window adjacent to invoice forms; they also appear in the Customer Center and your Accounts Receivable account in the Chart of Accounts. And you can find them in the Customer Register (Customers | Enter Statement Charges).

Outlining the charges

If you want to enter new statement charges instead of an invoice for, say, a monthly billing or a customer who is ordering frequently but is not ready to be billed, click on the Statement Charges icon on the desktop. (If there’s no icon and you want one, click Edit | Preferences, then Desktop View | Company Preferences, then click in the box next to Statements and Statement Charges.) Or you can just click Customers | Enter Statement Charges.

Click on Edit | Preferences to add Statement Charges and Statements icons to your desktop.

The customer register opens. Select the customer you want to create a charge for by clicking the down arrow next to Customer:Job. If you are in the middle of more than one job for the customer, make sure you make the correct one active.

Go down to the first blank line and change the date if necessary. Tab to the Item field, and drop the list to select the relevant product or service. Tab and enter the Quantity. The Rate and Amt Chrg should be filled in (if not, go back to Lists | Item List and edit the record). QuickBooks will have entered STMTCHG in the Type field. Tab to the Description field and complete it if it’s blank, and select a Class if you’d like. Your window will look something like this:

It’s very easy to enter statement charges in QuickBooks.

If you have another charge for that job or customer, go ahead and enter it. When you’re done with charges for that job/customer, click Record.

Build a statement

You can create statements at any time from data already entered in QuickBooks. The process is the same whether you’ve just entered a series of charges, as outlined above, or you want to remind a customer of outstanding invoices. You’re simply capturing all activity within a given time period. To do so, click the Statements icon on the home page. This window opens:

You’ll select options from this window when you’re building a statement run.

If the window contains an A/R field, that means that you have more than one receivables account. Be sure to select the appropriate one. Verify, too, that the date is correct. This will appear in the customer’s register as the Billed Date.

Here, too, you can choose a range of transaction dates for your statement(s), or simply opt to create forms for all customers with open transactions (in the latter case, you can limit it to transactions that are more than 30 days past due). You must also indicate whether you want statements sent to all customers or a subset. You can manually choose one or many customers, or select by Type (commercial, residential) or Preferred Send Method (E-mail or Mail).

QuickBooks gives you some control over your statements’ layout; click Customize if you want to explore this. Next, you can indicate whether you want to create one statement per customer or per job. The other options here are self-explanatory, but be sure to go through them every time you create statements.

Another decision

Will you be wanting to assess finance charges on the past due charges? This is a decision you should talk over with your ProAdvisor. It’s a complex issue. Should you want to do so, though, clicking on Assess Finance Charges will open the Assess Finance Charges window.

When you’re satisfied with all of your statement choices, you can Preview them. Here’s an example:

Statements lay out all transaction activity within a given period. Statement charges appear as “Due.” In this case, you’re reminding the customer that there’s a large past due balance as well as additional new charges.

Statements can be an effective way to let your customers—and you—get a comprehensive view of their financial interaction with you. They can be used instead of invoices, but there are limitations. If you’re still unclear on how these forms can fit into your accounting workflow, your ProAdvisor can help.

Scroll to top