2017-03-08 00:00:00 QuickBooks Updates English Learn about 2017 QuickBooks Desktop in-between amount search. Use this search tool to create custom reports and to find old transactions. https://quickbooks.intuit.com/ca/resources/ca_qrc/uploads/2017/06/In-Between-Amount-Search-In-QuickBooks-Desktop-Lets-You-Filter-Amount-Ranges.jpg https://quickbooks.intuit.com/ca/resources/updates/use-in-between-amount-search-desktop-2017-filter-amount-ranges/ Use In-Between Amount Search in QuickBooks Desktop 2017 to Filter Amount Ranges

Use In-Between Amount Search in QuickBooks Desktop 2017 to Filter Amount Ranges

1 min read

As of 2017, the Pro, Premier, and Enterprise versions of QuickBooks Desktop allow you to search for transactions by ranges. This tool could let you create a report of all sales over $500 and less than $1,000, for example. To illustrate another scenario, imagine that you want to find an old business expense. You can remember it cost between $25 and $50, but you can’t remember where you made the purchase or the exact amount. You can also use the in-between search to look for this transaction. To search for a customer transaction, go to the customer centre of your Quickbooks software. Then, highlight a specific customer. From there, select edit and find from the menu bar at the top of the screen. Alternatively you may use the keyboard shortcut Crtl + F. Find the advanced tab, and select amount. Then, fill in the desired ranges and wait for the search results. You may use this same process in the vendor centre of the software to search for vendor transactions. To create a report that only shows numbers in a certain range, you should start with an existing report. For example, if you want to create a report of monthly sales between a certain range, you would start with a generic report of monthly sales. Once you have the initial report, open it in the report centre, select customize, and open the advanced tab. Find the search filters you want to use, and enter the ranges accordingly. The new report only features numbers in your designated range. The ability to search for numbers or transactions based on a range gives you the flexibility you need for organized bookkeeping and great customer service. With 2017 QuickBooks Desktop, you have this tool right at your fingertips. Consider using this tool to speed up searches and create new custom reports, or check out some of the other updates to the program.

References & Resources

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

What is Pay-Per-Click?

PPC, or Pay-Per-Click, is a form of digital media marketing whereby the…

Read more

A Guide to Google Ads

Google is the world’s most used search engine. In 2019 Google was…

Read more

Guide to Getting Clients through Local Search Engine Optimization

When a potential customer needs to find an accounting firm in your…

Read more