Skip to main content Skip to search

Latest QuickBooks News

Too Many Transactions in QuickBooks

Too Many Transactions in QuickBooks Online? Create Rules

Too Many Transactions in QuickBooks Online? Create Rules

It’s important to categorize transactions, but it takes time. If every day brings several dozen into QuickBooks Online, you can automate this process.

One of the cardinal rules of accounting is this: Go through your new transactions every day. If you wait until there are too many of them, you’re likely to give them short shrift. You may miss problems, just as you might skip categorizing some of them because it simply takes too long.

But correct categorization is essential. Your income taxes and reports will not be accurate if you fail to assign the right category to all of your transactions. QuickBooks Online makes this easy.The site also provides a way for you to accelerate the process by automating it. It allows you to create Rules. That is, if a transaction contains a specific piece of information, a name or an amount, QuickBooks Online allows you to indicate how it should be categorized. This kind of automation will save you time and may even prevent errors–as long as you use it carefully. Here’s how it works.

Defining Your Rules

We’ll use an easy example to explain how QuickBooks Online’s Rules work. Let’s say your shipping cost shave started to increase lately, and you want to make sure you’re seeing any UPS transactions that go above a specified dollar amount, and that they’re categorized accurately. Hover your mouse over Transactions in the toolbar and click on Banking(assuming you’re downloading your bank transactions). Select an account to work with by clicking on it, and make sure the For review bar is highlighted.

Click on a transaction to open it. (If you’ve never explored what you can do with a downloaded transaction, study this box carefully while you’re there, and contact us with any questions.) On the bottom line, you’ll see a link labeled. Create a rule. Click on it, and a panel slides out from the right, as pictured below:

Too Many Transactions in QuickBooks

The upper half of the Create rule panel

This portion of the Create rule panel is fairly self-explanatory. Give your rule a descriptive name(we entered UPS 25 Plus) and indicate whether it should be applied to Money in or Money out. If you want to select a specific bank account or card, click the down arrow in the field to the right and select it. Otherwise, choose All bank accounts. Next, decide whether a transaction has to meet Any of the conditions you’re going to specify or All of them. In this case, we want All.

Now you have to describe the conditions under which a transaction will be affected. We want transactions whose Description Contains The UPS Store. We also want to identify purchases from The UPS Store whose total is more than $25. So you’d click+ Add a condition. In the row that opens, click the down arrow in the Description field and select Amount. Click the down arrow again in the next field and choose Is greater than. The final field in the row should contain 25.00.

You could keep adding conditions, but that’s all we need for this rule. You can click Test rule if you want to find out how many transactions in your For review list would meet your specifications.

Next, you want to Assign attributes to the transactions selected. Your options here are Transaction type, Category, Payee, Tags, Class, and Memo. The first two are required and the third is recommended. The last three are optional. If you want QuickBooks Online to automatically confirm transactions this rule applies to, click the Auto-confirm button so it’s showing green. If you choose this option, your matching transactions will be modified to meet your criteria and moved directly into the Categorized queue. You won’t see them in For review. So consider this carefully.

Read more
Paid Upfront

How Do You Manage Vendors in QuickBooks?

In these days of supply chain issues, you need to keep track of your vendors. QuickBooks has this covered.

If you buy and resell products, or if you need to purchase materials to create your own items, good management of your company’s vendor records is critical. Maintaining a physical card file is way too inflexible. You can’t find or edit individual records quickly or easily. They get lost, or they’re illegible because you’ve updated the cards too many times.

Read more
tax time smoother

Billing Customers for Time and Expenses in QuickBooks Online

Sometimes, you have to spend money on your customers. Make sure you’re billing them for it.
Usually, money flows from your customers to your business. But there may be times when you have to
purchase items for a job whose costs will eventually be reimbursed. Or you, or an employee, might spend time providing services for customers and get paid for those hours by your company before you receive payment from the responsible party. If you’re a sole proprietor with no payroll and no reserves, of course, you just have to wait to be paid for your work.

In the first two cases, you’re spending money upfront that will eventually be paid back. In all three cases,
QuickBooks Online calls these billable expenses and billable time, and it does a good job of tracking these transactions – much better than if you were scribbling notes on a receipt or a paper timecard.

Read more

Keep Up with Payables: Entering Bills in QuickBooks

Did you resolve to pay bills on time in 2021? Here’s how QuickBooks can help.

Managing your paper bills manually is a dangerous practice. It’s too easy to lose them, for one thing, and it’s impossible to keep all of those vendors and amounts in your head. Even if you keep them in a safe place, how do you track their due dates? You can write them on a paper calendar, but it’s easy to miss them considering everything else that is probably scribbled there.
So what’s the solution? You need a system that will keep you from paying bills late, which can lead to finance charges and bad relationships with your vendors.

QuickBooks provides that. You can enter bills as they come in and designate them as paid when you send the check or authorize a credit card payment or bank transfer. Besides making these records available, the software offers other way

Read more