How to Add Custom Fields in QuickBooks
In accounting and business management, flexibility is key. Every company has unique processes and information they need to track. Whether you’re managing client projects, tracking internal department codes, or recording PO (Purchase Order) numbers, adding custom fields to your QuickBooks setup can significantly improve accuracy and efficiency.
Fortunately, both QuickBooks Online (QBO) and QuickBooks Desktop support custom fields, allowing you to tailor invoices, sales forms, and reports to meet your specific needs. In this article, we’ll explore how to add custom fields, like PO Numbers or Project Codes, in both versions of QuickBooks, including:
- How to create and use custom fields
- Use case examples
- Limitations and tips
- Troubleshooting and best practices
What Are Custom Fields in QuickBooks?
Custom fields in QuickBooks are additional data fields you can add to transactions (like invoices, estimates, or purchase orders), customer profiles, or items. These fields allow you to track information that isn’t captured by the default form layout.
For example, you might want to track:
- Purchase Order (PO) Numbers
- Project or Job Codes
- Customer Reference Numbers
- Department Names
- Internal Approval IDs
- Contract or Agreement Numbers
By using custom fields, you can:
- Improve reporting and filtering
- Ensure consistency across documents
- Align QuickBooks with your internal processes or client requirements
How to Add Custom Fields in QuickBooks Online
Custom fields are available in QuickBooks Online Essentials, Plus, and Advanced versions. The Advanced version provides the most flexibility, including support for multiple custom fields with conditional logic and reporting.
Step 1: Access Custom Fields Settings
- Log in to QuickBooks Online.
- Click the Gear icon (⚙️) in the top right corner.
- Under Lists, click Custom Fields.
Step 2: Create a New Custom Field
- Click the Add field button.
- Enter a Name for the field (e.g., “PO Number” or “Project Code”).
- Choose the forms where you want this field to appear:
- Invoices
- Sales Receipts
- Estimates
- Purchase Orders
- Select the field type:
- Text (free text input)
- Number
- Dropdown menu
- Date
- Checkbox
- If you’re using QuickBooks Online Advanced, you can set additional rules like:
- Making the field required
- Adding it to specific customer types
- Adding the field to reports
- Click Save.
Step 3: Add Data to Custom Fields
Now, when creating a new invoice or other form:
- Go to + New > Invoice (or other transaction).
- You’ll see your custom field (e.g., “PO Number”) on the form.
- Enter the appropriate value when creating or editing a transaction.
Step 4: Run Reports with Custom Fields (Advanced Users Only)
If you’re using QuickBooks Online Advanced:
- Go to Reports.
- Create a custom report.
- Choose to include your custom field as a filter or column.
How to Add Custom Fields in QuickBooks Desktop
QuickBooks Desktop (Pro, Premier, and Enterprise editions) has long supported robust custom fields for customers, vendors, items, and transactions. You can add custom fields to sales forms and then include them in templates and reports.
Step 1: Enable Custom Fields for Customers or Items
- Open QuickBooks Desktop.
- Go to Customers > Customer Center.
- Double-click a customer name.
- Click the Additional Info tab.
- Click Define Fields.
- Enter a Label Name for each custom field.
- Tick the boxes for where it should be used (Customer, Vendor, Item, etc.).
- Click OK to save.
These fields now become available in forms like invoices and sales orders.
Step 2: Add Custom Fields to Transaction Forms
- Open a form such as an Invoice.
- Click Customize Data Layout.
- Switch to the Columns, Header, or Footer tab, depending on where you want the field.
- Check the box next to your custom field (e.g., “PO Number”).
- Use the Screen and Print columns to control visibility.
- Click OK.
Step 3: Use the Field When Creating Transactions
Now when you create an invoice or estimate:
- Your custom field appears on the form.
- You can enter a PO number or Project Code directly on the invoice.
Step 4: Report on Custom Fields
- Go to Reports > Custom Reports > Transaction Detail.
- Modify the report.
- In the Columns section, select your custom fields.
- Apply filters if needed and run the report.
Not all QuickBooks Desktop reports support custom fields. You may need to use custom transaction detail reports or export data to Excel for deeper analysis.
Custom fields are a powerful tool in QuickBooks that can help you tailor the software to match your business needs. Whether you’re tracking Purchase Order Numbers, Project Codes, or other custom data, using this feature correctly can streamline operations, enhance reporting, and support better decision-making. By thoughtfully implementing custom fields, you can turn QuickBooks into a more dynamic and tailored financial tool for your organization.