Guide to Custom Fields in QuickBooks Online

 Custom fields in QuickBooks Online (QBO) are a tool you can use to track information and tailor your accounting processes to meet your unique business needs.

From adding specific information to invoices to creating detailed reports, custom fields give you enhanced organization and reporting capabilities.

This guide will cover everything you need to know about custom fields in QuickBooks Online, including:

  1. How to create and manage custom fields.
  2. Using custom fields on various forms.
  3. Searching for data using custom fields.
  4. Leveraging custom fields in reports.

Let’s dive in!


What Are Custom Fields?

Custom fields allow you to add personalized information to your transactions. Use cases include purchase order numbers, sales rep names, or project identifiers.

These fields can appear on:

  • Invoices
  • Sales receipts
  • Estimates
  • Credit memos
  • Refund receipts
  • Purchase orders

With the upcoming removal of tags in 2025, custom fields will play an even bigger role in organizing your financial data.


How to Create and Manage Custom Fields

Creating a Custom Field

  1. Access Custom Fields:

    • Click the Gear icon in the upper-right corner.
    • Under the Lists header, select Custom Fields.
      Navigating to Custom fields in QBO
  2. Add a New Field:

    • Click on Add Field in the upper-right corner.
    • Name your field (e.g., “Customer PO” or “Sales Rep”).
    • Choose where this field will apply, such as invoices, sales receipts, or estimates.
    • Decide whether the field should appear on printed forms.
    • Click Save to create the field.
      Add Custom Field pop-out in QBO

Renaming or Inactivating a Custom Field

  • To rename a field, click Edit under ACTIONS, update the name field, and click Save.
  • To make a field inactive, click the dropdown next to Edit and select Make Inactive. Inactive fields won’t appear on new transactions but remain on historical ones.
  • To reactivate a field, toggle the Include Inactive slider, locate the field, and click Make Active.
    Make a custom field inactive and toggle inactive fields on/off in QBO

Using Custom Fields on Forms

Custom fields can be applied across various QuickBooks forms, enhancing functionality and providing clarity for your clients and team.

Sales Receipts, Credit Memos, and Refund Receipts

Custom fields appear in the middle section of the forms.

Custom fields on Sales Receipts in QBO

In the digital and printed versions custom fields appear below the BILL TO section.

Where custom fields show up on the printed version of a sales receipt in QBO

Invoices and Estimates

Custom fields can be found in the middle of your invoices and estimates below the Bill to box.

Custom fields on the invoice screen in QBO

Once added, these fields appear to the right of Invoice or Estimate details on the PDF view:

Purchase Orders

On purchase orders, custom fields appear below the Mailing address.

Custom fields on a Purchase Order in QBO

In the print preview, these fields appear to the right of the Purchase Order details:

Custom fields on a Purchase Order in QBO


Searching for Data Using Custom Fields

QuickBooks allows you to search for transactions based on custom field content. Here’s how:

  1. Click on the magnifying glass in the upper-right corner.
  2. Click the Advanced transaction search link at the bottom of the search box.
    Navigating to the Advanced transaction search in QBO
  3. Click on More Filters.
    Opening More Filters in the QBO advanced transaction search
  4. Your custom fields will appear at the bottom of the More Filters pop-out.
  5. Enter the content for the custom field you want to search for.
    Searching for transactions with a specific custom field in QBO using the Advanced transaction search
  6. Hit Enter to display all transactions associated with that content.

An advanced transaction search in QBO filtered by a custom field

This feature is invaluable for quickly finding transactions tied to specific projects, sales reps, or other internal references.


Leveraging Custom Fields in Reports

Custom fields can be incorporated into reports for more tailored insights. For example:

Sales by Customer Detail Report:

Group by a custom field

  • Select your custom field from the Group by drop-down to group transactions by a custom field type.
    Sales by Customer Detail Report in QBO with transactions grouped by a custom field

Sort by a custom field

  • Add a custom field column by clicking Customize > Columns > Select your custom field.
    Customizing a report in QBO to add a column for a custom field
  • Sort by your custom field by clicking Sort > Select your custom field.
    Sort a QBO report by a custom field

Save Customized Reports

  • Once your report is tailored to your liking, save it for future use by clicking the Save Customization button.

Saving a customized report in QBO

Custom fields in reports provide a granular view of your business data, enabling better decision-making.


Best Practices for Using Custom Fields

  1. Plan Ahead:

    • Figure out how many custom fields you have available. Different QBO plans have different number of custom fields. 
      • Simple Start: 1
      • Essentials: 4
      • Plus: 4
      • Advanced: 12
    • Determine the purpose of your custom fields before creating them to avoid clutter and running out.
  2. Use Consistent Naming Conventions:

    • Clear, descriptive names ensure your team understands each field’s purpose.
  3. Limit Field Usage:

    • Only activate fields that are essential for your operations to maintain clarity.
  4. Regularly Review and Update Fields:

    • Deactivate unused fields and rename outdated ones to keep your system streamlined.
  5. Experiment with Reporting:

    • Explore how custom fields can enhance reports to gain deeper insights into your business.

Conclusion

Custom fields in QuickBooks Online work well for personalizing your accounting workflow. From enhancing communication on invoices to generating insightful reports, these fields empower you to manage your business more effectively.

Start by creating custom fields that align with your unique needs, and explore how they can streamline your processes. With these tools, you’ll have greater control over your financial data.

Ready to take full advantage of custom fields? Log in to QuickBooks Online today and start exploring their potential!

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below is a collection of videos that cover this topic.

If you have questions about the custom fields in QuickBooks Online, click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

Setting Client Expectations: How to Create a Better Bookkeeping Relationship

Learn how to improve your bookkeeping practice by setting client expectations early to avoid frustration and promote professional relationships.

Guide to Custom Fields in QuickBooks Online

Learn how to create and manage custom fields in QuickBooks Online to track important information and tailor your accounting processes.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.