intuit

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 Quickbooks

Spring Cleaning: Streamlining QuickBooks 2013

Although Intuit did a great job of giving QuickBooks’ home page a fresher, more “open” look in its 2013 versions, maybe some of your screens have become unnecessarily cluttered. Perhaps your QuickBooks company file needs some attention as well. By taking a few minutes to do some “spring cleaning” you’ll have a tidier workspace, and you’ll save time and frustration. The following suggestions will help you to do just that.

Make a Clean Start

One simple way to take care of cluttered screens is to do the following:

  • Minimize icons. That pretty graphical process map on the home page is great for quick access to frequently-used actions. Some of them must remain there if they’re related to activities you do (i.e., Invoices has to stay if you use Estimates), but you can remove some of the ones you don’t use. Go to Preferences | Desktop View | Company Preferences. You’ll see this:


Figure 1: You can turn off some of the feature icons on your home page.

Some of the options have been grayed out because they support other processes. To remove an active feature icon like Inventory, click on it. In the window that opens, uncheck the box next to Inventory and purchase orders are active (you can also modify options here).


Figure 2: Clicking the checkbox next to Inventory and purchase orders are activegrays out the other options and removed related feature icons from the home page.

To reduce the number of feature icons even more, go to the Finance Charge, Jobs & Estimates, Payroll & Employees, Sales & Customers, Sales Tax and Time & Expenses. QuickBooks removes the related icons and reroutes the process map on the home page.

More Time-Saving Tweaks

  • Don’t allow multiple windows to open in your work area. Tired of seeing all of those overlapping open windows on your desktop? Open the View menu and select One Window. All of your open windows remain active in the background. To return to one of them, open the Window menu and select the one you want to move to the front (Window | Close All returns you to a blank work area).


Figure 3: Your Icon bar can be your fastest route to often needed screens–if you modify it to only contain the functions you use, in order of importance. You can also change the labels to make them more meaningful to you.

    • Trim down your icon bar. Seems like a minimal change, but it’s one of those things that can add unnecessary moments of frustration throughout the day (“Where’s the Calendar!”). Click View | Customize Icon Bar.

 

  • Customize columns in Lists. You probably work in QuickBooks’ Lists often, but are you spending too much time tracking down the right information? Customize their columns so your registers contain only what you usually need (and add additional ones if it’s helpful). Open a list, right-click anywhere within it and select Customize Columns to modify the display (re-size column widths by placing your cursor on the vertical set of dots between labels and dragging).


Figure 4: When you customize your columns in Lists, you’ll find what you’re looking for faster. 

  • Hide inactive items. Highlight an item, right-click and select Make Item Inactive. Open the Item menu in the lower left and click Hide Inactive Items (this action won’t delete them).

Internal Cleaning

These may all seem like cosmetic changes, but you will save time and frustration over the long run.

The most critical spring cleaning task is company file analysis and maintenance. We can handle this for you. QuickBooks can slow down and start generating error messages when the data file becomes unwieldy and sloppy. Preventing file corruption before it crashes your system is a lot faster and less expensive than a reconstruction project.

Quickbooks

Backup or Portable Company File? How to Decide

When you think about it, it’s pretty amazing that Intuit is able to pack the lion’s share of your financial data into one giant company file. It certainly makes it easier to separate from QuickBooks and move when necessary.

There are actually three options for saving and relocating that file. You know about backups, since you should be producing them religiously. You generate them so that if QuickBooks — or your computer itself — stops working or your file becomes corrupt, you can re-create the entire environment. Portable company files are more limited, and are best used when you want to save your file to a temporary location and/or email it to someone else.

You would only use an Accountant’s Copy, of course, when you want us to check your progress. We’ll work with you on setting this up.


Figure 1: Once you save and send off an Accountant’s Copy, you can’t work on transactions created before the dividing date. 

The Critical Backup

We can’t emphasize this enough: Losing your financial data can be the beginning of the end of your company. You won’t know what you’re owed, so you’ll be unable to collect. You’ll miss vendor payments. Payroll will be impossible to reconstruct, and you won’t be able to submit payroll taxes. And how will you know what your income tax obligation is?

It can happen to you.

QuickBooks simplifies this process. Click File | Create Backup… You’ll be asked whether you want to back up locally — to a network folder or thumb drive, for example – or to the cloud, using Intuit Data Protect (fees apply). If you select the local preference, click onOptions to designate a location in this window:


Figure 2: Choose from options in this window to create a backup profile. 

Click OK, then Next. QuickBooks will ask when you want to save your backup copy and offer scheduling options. When you’re done, click Finish.

Warning: If you’re using Intuit Sync Manager, there are special rules about copying the company file. Let us help you handle this safely.

Just the Facts

Portable company files are more compact than backup files, so they can be easily e-mailed as attachments or copied onto another computer. But they don’t contain everything that backups do. They lack, for example, letters, logos, attachments, images and templates. Don’t use this option if changes will be made, since they can’t be merged back into the file.

Be sure to create a current backup before you begin to move your file.

To save a portable company file, click on File | Create Copy (you can do this to copy any kind of file, actually). This window opens:


Figure 3: Click File | Create Copy… to access any of QuickBooks’ three options. 

Select Portable company file and click the Next button. In the following window, you’ll browse to a location for your file. QuickBooks will already have entered the name and will save your data in .qbm format. Click Save, then OK when QuickBooks tells you it must close and reopen your file first. Click OK again when you’re told that the file has been created.

Opening the File Elsewhere

When you’re ready to open the file at another location, click File | Open or Restore Company… In the window that opens, select Restore a portable file. The Open Portable Company File window opens; make sure that the file’s location is displayed in the Look in: field. Click Open. QuickBooks then asks where you want to restore the file.

The following step is critical. Rename your file unless you want to overwrite your current company file. You can add a date or some other identifying information like a version number.

Click Save. QuickBooks will convert your portable file to a standard company file with a.qbw extension.

QuickBooks makes it easy to create copies of your data, but an error here can threaten your company’s future. We can help ensure that that doesn’t happen.

Scroll to top