Seven Ways to Search QuickBooks

STE Corporation is a CPA firm that provides accounting services in Chicago, Illinois

SCHEDULE A CONSULTATION
Home » Seven Ways to Search QuickBooks

Over time, your QuickBooks company can grow in size to the point that it becomes difficult to find specific transactions. For instance, let’s say that you hire a new employee, and want to order another desk to match the ones in your office.

You vaguely remember the last time that you ordered a desk, but can’t remember which vendor, or how much you paid. In this article we’ll discuss seven ways that you can search QuickBooks to find transactions such as this, or when necessary, determine if a transaction was deleted.

#1: Registers
QuickBooks maintains a register for each account on your balance sheet, which includes bank accounts, inventory, accounts receivable, and other assets. There are also registers for accounts payable, loan accounts, and owners’ equity.

Depending upon what you’re looking for, a register might be a fast way to find what you’re looking for, such as that desk we mentioned at the start:

  • Choose Edit, and then Use Register (or press Ctrl-R). Alternatively, you can choose Banking, and then Use Register.
  • As shown in Figure 1, choose your Furniture account from the list, and then click OK. QuickBooks will then present a window similar to Figure 2.


Figure 1: Every balance sheet account’not just cash accounts’has a register.

  • As also shown in Figure 2, you can use the Go To button to search the register. This can help you narrow your search within a register that contains many transactions.


Figure 2: The register displays a searchable listing of all transactions within a balance sheet account.

Keep in mind that registers are just one way to find transactions in QuickBooks, and won’t always be appropriate for every situation. For instance, income and expense accounts don’t have a register’in those cases you need to take another approach.

#2: Simple Find
Think of the Simple Find feature as an expanded version of the Go To feature within a QuickBooks register. Choose Edit, and then Find (or press Ctrl-F) to display the window shown in Figure 3.

If necessary, click the Simple tab at the top of the window. You can then carry out searches based on transaction type, such as Invoice, Estimate, Bill, Check, and so on:

  • Choose a transaction type from the list.
  • Optionally limit your search by completing the Customer/Job, Date, Transaction #, and Amount. It’s not necessary to complete these additional fields, however without doing so you’ll return a list of all transactions of a given type, which may or may not be helpful.


Figure 3: Simple Find allows you to search within a single transaction type.

Once your list of transactions appears on the screen, you have several options:

  • Double-click on a transaction to view it, or click once on the transaction and then click the Go To button.
  • Click the Report button to display a Find report onscreen. As we’ll discuss later in this article, you can then click the Modify Report button to further refine the results of the Find report.
  • Click the Export button to export the results to a comma-separated values (CSV) file or Excel spreadsheet.

#3: Advanced Find
This feature, shown in Figure 4, is akin to the Simple Find on steroids. You can search QuickBooks based on any combination of dozens of criteria. For instance, Figure 4 shows a search on customers in the city of Middlefield who bought appliances costing $500 or more.

To use Advanced Filter, simply choose a field from the Filter column, and then set the desired criteria. Your input choices will vary based on the field that you choose.
For instance, if you click on Name City, you can enter a single city.

Conversely, you can make multiple selections when you choose a field like Item or Account. Keep adding new filters as needed. You can craft some very elaborate searches in this fashion. To eliminate a filter, click once on the item within the list on the right, and then hit the Delete key. Alternatively, the Reset button will also clear the decks for you.


Figure 4: Advanced Find allows you to specify criteria for dozens of available fields.

#4: Search
Current versions of QuickBooks feature a Search command on the Edit menu. You may be prompted to enable Google Desktop the first time that you choose this command. Doing so will allow you to use the same search terms and conventions that you use on the Internet to locate transactions within QuickBooks.

As shown in Figure 5, this feature is not automatically enabled, and doing so may cause minor performance degradation on your computer. As shown in Figure 6, Google Desktop automatically groups transactions by type, and you can choose to sort by date.


Figure 5: You must enable Google Desktop Search within QuickBooks.


Figure 6: Google Desktop search automatically groups transactions by type.

Indexing required: Google Desktop initially runs an indexing process on your QuickBooks data. The length of time required for this varies, based upon the size of your QuickBooks company.

You’ll get the best results from your search if you wait until Google Desktop has completed its initial index. New transactions will automatically be indexed after this one-time process completes.

#5: Customized Lists
By default, QuickBooks customer and vendor lists only display names and balance totals. You may not realize that you can add additional columns, such as phone number, and that each column is sortable:

  • Choose Customers, and then Customer Center (or press Ctrl-J).
  • Right-click on the customer list, and then choose Customize Columns.
  • As shown in Figure 7, you can add as many additional fields as you wish to the list, as well as move fields up and down within the list. Click OK once you’ve made your changes.


Figure 7: You can add or remove columns from list windows in QuickBooks.

  • As shown in Figure 8, you can resize the columns within the list. Place your mouse between field names, and then drag to the left or right to resize the field.


Figure 8: QuickBooks list columns are resizable and sortable.

  • Click the name of a field within the list to sort based on that column. As shown in Figure 8, you can use this technique to search for a customer simply based on telephone number.

#6: Report Filters
Some QuickBooks reports are like a fire hose of data, giving you far more information than you really need. Fortunately, every report has a Modify Report button in the upper-left-hand corner of the screen, which enables you to pare down the results of the report.

As shown in Figure 9, you can click the Filters tab of the Modify Report window and make the same choices that we discussed previously in the Advanced Filter dialog box.


Figure 9: Most QuickBooks reports allow you to apply filters to limit the amount of data shown.

#7: Audit Trail: If you’ve exhausted all of the previous methods to find a transaction in QuickBooks, one final place to look is the audit trail. Someone could have deleted the transaction, either on purpose, or accidentally.

The audit trail formerly was an optional feature in QuickBooks, but starting with the 2006 versions and onward, it’s always on, so you’ll always have a searchable record of every transaction ever entered in QuickBooks.

You cannot view the details of deleted transactions in the audit trail, but at least you’ll know why it didn’t appear through any of the other search methods:

  • Choose Reports, Accountant & Taxes, and then Audit Trail.
  • Once the report appears on screen, you can change the date range to pick a broader range if necessary. You can also click the Modify Report button and apply any filters that you wish. As shown in Figure 10, any deleted transactions will be marked as such.


Figure 10: The audit trail shows deleted transactions.

Summary
Hopefully you now have at least a couple of new ways to retrieve transactions or contact information from QuickBooks. Not every technique is appropriate for every search, but understanding these seven ways to search QuickBooks can broaden your skills, and help you retrieve information about anything within your accounting records.

Did You Know?
There are hundreds of add-on products available for QuickBooks that may be able to help you streamline business processes that you currently carry out by hand. Visit https://desktop.apps.com/home to search the list of available products by industry or business need.

Many applications are certified by QuickBooks, and most products include customer product ratings. Free trials are often available, so you can try products before you buy. The web site also includes a list of developers, so you can have a custom application written for you if can’t find an existing tool to meet your needs.

Previous Tip – Back to tips – Next Tip

Talk to one of our Accountants Today

OUR SERVICES

stecorporation - accounting icon

Accounting

  • Statuary Accounts
  • Management Accounts
  • Bookkeeping
  • Business Plan
stecorporation - tax icon

Tax

  • Tax Investigation
  • Capitol Gains Tax
  • Tax Advisory
  • Corporation Tax

STECorporation consultation

Consulting

  • Registered Office Address
  • Company Formation
  • Company Secretarial
  • Legal Helpline

QuickBooks/ Bookkeeping Services

All of the financial information and data for your business should be organized and in one place so it is easy to access.  With our bookkeeping services, we will organize and manage your financial information within the QuickBooks software so you can easily access it at any time.  While we manage your financial matters on a daily and monthly basis, you will be in control as we will keep you updated and ensure you can access and monitor your finances.  If you are applying for a loan, doing your taxes, or budgeting, having quick access to your financial information is important.  We can assist large businesses and provide small business bookkeeping.

Advisory Services

Our accountants can take on an advisory role with your company through our business consulting services.  We will work with you to understand your financial goals and help you make the right decisions to reach your goals and help your business grow and become more profitable.  Our business advisory services include advisement for investments, taxes, payroll, bookkeeping, administration, and more.

Estate Planning

It is important to manage your estate to help protect its value and ensure that your assets are distributed properly between your beneficiaries.  Our accountants can assist with your estate planning, including managing the taxes to preserve its value and ensuring that your assets are distributed according to your wishes.  Our estate accountants will identify ways to protect your estate from inflation and taxes and minimize what you are paying in taxes to maximize its value.

Sales Tax / Nexus

Sales tax rates and laws are decided locally and differ between states and cities.  This can make sales and use tax difficult to manage for businesses, especially those that operate in multiple cities and states.  Our certified public accountants can help manage your sales and use taxes by ensuring that you are in compliance with applicable sales tax laws and identifying opportunities for refunds and exemptions.  We have a thorough knowledge of sales tax laws and we can even help businesses that operate in multiple states with filing their taxes.  Using Nexus tax analysis, we can help multi-state businesses stay in compliance with all applicable tax laws.

Payroll Services

We provide payroll services to small businesses and international businesses that operate in the U.S.  Our accountants will streamline your payroll process and manage the tax withholdings and benefit deductions from employee paychecks.  We can also file the tax returns for your business that account for the tax withholdings.

Call the CPAs of STE Corporation

Contact our CPA firm if you want to work with our accountants to help manage the finances for your business in Park Ridge, IL.  You can call STE Corporation at (815) 836-0100 to talk to our professionals or schedule a free consultation.

FREQUENTLY ASKED QUESTIONS

For tax years 2018 through 2025 interest on home equity loans is only deductible when the loan is used to buy, build or substantially improve the taxpayer’s home that secures the loan. Prior to 2018, many homeowners took out home equity loans. Unlike other consumer-related interest expenses (e.g., car loans and credit cards) interest on a home equity loan was deductible on your tax return.
You may be able to take an immediate Section 179 expense deduction of up to $1,040,000 for 2020 ($1,020,000 in 2019), for equipment purchased for use in your business, instead of writing it off over many years. There is a phaseout limit of $2,590,000 in 2020 ($2,550,000 in 2019). Additionally, self-employed individuals can deduct 100 percent of their health insurance premiums. You may also be able to establish a Keogh, SEP or SIMPLE IRA plan and deduct your contributions (investments).
In 2020 (as in 2019), medical and dental expenses are deductible to the extent they exceed 10 percent of your adjusted gross income or AGI. If your employer offers a Flexible Spending Account (FSA), Health Savings Account or cafeteria plan, these plans permit you to redirect a portion of your salary to pay these types of expenses with pre-tax dollars.
If you’re planning to make a charitable gift, it generally makes more sense to give appreciated long-term capital assets to the charity, instead of selling the assets and giving the charity the after-tax proceeds. Donating the assets instead of the cash avoids capital gains tax on the sale, and you can obtain a tax deduction for the full fair-market value of the property.

Frequently-Asked-Questions-min

WHAT OUR CLIENTS SAY ABOUT US

“Everyone at STE has been amazing. As a small business owner it is essential to have people on your team that are experts in all areas. When it comes to finance and taxes Jim and the team at STE fill that need. Thanks for being great at what you do and always be there!”

“STE has been handling our personal, business accounting, and payroll for years. They are knowledgeable, easy to reach, and very welcoming. Would definitely recommend them.”

“I have had nothing but pleasant experiences at STE. They are knowledgeable and provide great service.”

“We have used STE Corporation for our payroll and tax service needs over the past 3+ years and extremely pleased with the partnership we have created.”

“My husband has operated his painting business since 2004, first as a sole proprietorship and later as an S corporation. STE has been instrumental in helping him grow his business and remain in compliance. I cannot thank Mike, Marybeth, Jim, and Lisa enough for helping him get organized and stay that way. They have truly been the business office he needed in order to focus on the part of his business he enjoys – painting and customer service Their professional staff literally have never let him down – payroll, state taxes, federal taxes, consultation, ledger reconciliation, profit and loss sheets, and probably lots of things I do not even know about! Hiring this firm was the best decision he could have made. He looks forward to visiting the office, everyone makes him feel like family. I appreciate their professionalism and efficiency. Thank you STE!”

OUR SERVICES

stecorporation - accounting icon

Accounting

  • Statuary Accounts
  • Management Accounts
  • Bookkeeping
  • Business Plan
stecorporation - tax icon

Tax

  • Tax Investigation
  • Capitol Gains Tax
  • Tax Advisory
  • Corporation Tax

STECorporation consultation

Consulting

  • Registered Office Address
  • Company Formation
  • Company Secretarial
  • Legal Helpline

QuickBooks/ Bookkeeping Services

All of the financial information and data for your business should be organized and in one place so it is easy to access.  With our bookkeeping services, we will organize and manage your financial information within the QuickBooks software so you can easily access it at any time.  While we manage your financial matters on a daily and monthly basis, you will be in control as we will keep you updated and ensure you can access and monitor your finances.  If you are applying for a loan, doing your taxes, or budgeting, having quick access to your financial information is important.  We can assist large businesses and provide small business bookkeeping.

Advisory Services

Our accountants can take on an advisory role with your company through our business consulting services.  We will work with you to understand your financial goals and help you make the right decisions to reach your goals and help your business grow and become more profitable.  Our business advisory services include advisement for investments, taxes, payroll, bookkeeping, administration, and more.

Estate Planning

It is important to manage your estate to help protect its value and ensure that your assets are distributed properly between your beneficiaries.  Our accountants can assist with your estate planning, including managing the taxes to preserve its value and ensuring that your assets are distributed according to your wishes.  Our estate accountants will identify ways to protect your estate from inflation and taxes and minimize what you are paying in taxes to maximize its value.

Sales Tax / Nexus

Sales tax rates and laws are decided locally and differ between states and cities.  This can make sales and use tax difficult to manage for businesses, especially those that operate in multiple cities and states.  Our certified public accountants can help manage your sales and use taxes by ensuring that you are in compliance with applicable sales tax laws and identifying opportunities for refunds and exemptions.  We have a thorough knowledge of sales tax laws and we can even help businesses that operate in multiple states with filing their taxes.  Using Nexus tax analysis, we can help multi-state businesses stay in compliance with all applicable tax laws.

Payroll Services

We provide payroll services to small businesses and international businesses that operate in the U.S.  Our accountants will streamline your payroll process and manage the tax withholdings and benefit deductions from employee paychecks.  We can also file the tax returns for your business that account for the tax withholdings.

Call the CPAs of STE Corporation

Contact our CPA firm if you want to work with our accountants to help manage the finances for your business in Park Ridge, IL.  You can call STE Corporation at (815) 836-0100 to talk to our professionals or schedule a free consultation.