QuickBooks-Desktop-Tip (24)

Ever have to do a bunch of math and THEN input the results into QuickBooks? It’s not very efficient and can lead to additional errors. Well, QuickBooks has you covered…they make it easy to do basic math functions (addition, subtraction, multiplication, & division) within certain fields. This can greatly increase your productivity, especially if you have a bunch of numbers to work with. Depending on what screen you’re on (Bill/Check/Invoice/etc.), this function will work with Amount, Amount Due, Quantity, Rate, etc.

In the example below I had to add and subtract a bunch of numbers and was able to do this within the “Amount Due” field on a bill. I entered the first number in the Amount Due field then hit the “+” key, typed the next number and hit the “+”, etc. Once I had all the numbers input, I hit the “Enter” key on the keyboard. Use the “+” key for addition, the “‑” key for subtraction, the “/” for division, and the “*” for multiplication. Give it a try and see how it works!

Click on the screenshot below for a larger view.

Hope this helps!

More information like this can be found in my courses here.

Need help with your QuickBooks?  I can help you!  Click here for more info.

Author: Scott Meister, CPA

I help small businesses, accountants, bookkeepers, office managers, and business owners with their accounting needs. I’ve used QuickBooks since 2002 and train folks on how to use it efficiently. I create high-quality video training tutorials for QuickBooks and post them on QBScott.com. Certifications include: Certified Public Accountant (CPA) | Certified Bookkeeper (CB) | Advanced Certified ProAdvisor for QuickBooks Desktop | Advanced Certified ProAdvisor for QuickBooks Online | Certified ProAdvisor for QuickBooks Enterprise | Certified ProAdvisor for QuickBooks Point Of Sale