QuickBooks Online QBO Tutorial for Beginners – August 2016

How would you like to learn QuickBooks in 90 minutes? This FREE video tutorial is specifically designed for beginners in mind. You will learn QuickBooks Online the right way from the start. It covers all the basics you need to learn and offers some helpful tips. If you are looking for step-by-step educational guidance and ready to learn QBO, this is the one. And this video is produced by Top International QuickBooks Trainer, VPController.

I have already received payments in QBO from multiple customers. How to make them match with a single deposit I see in my bank feed.

You’ve two ways to match with bank feed deposit.

1) Match it directly from the bank feed downloaded transactions.

Select a row for deposit in question. The row expands to show you “Find other matching transactions” button. Once you click this button, you will see a long list of possible match transactions. To easily locate your deposits, change payment date as you’ve recorded. Select payments (type = payment) to match with bank feed deposit amount. Make sure difference is zero. Save. Done.

find other matching transactions1
find other matching transactions1

2) Manual. This will take few steps, but you will see green MATCH sign once done.
a) Go back to “Receive Payment” (create+ sign > customer > receive payment > upper left corner clock, locate payment) screen for customer payment you’ve already recorded and change Deposit to: “Undeposited Funds” instead of a bank account. Do the same for other customer payments that you want to match to a batch deposit.
b) Bank Deposit (create + sign > other > bank deposit) – check existing payments from the list to match batch bank deposit. Make sure to check correct bank account if you’ve multiple bank accounts. Save. Done. Save and Close.
c) Go back to banking center (bank feed) and now you should see green Match sign for that deposit. Click Match. It should disappear from the list.

Note: #2 is recommended process in QBO if you’ve merchant card payments or use bank deposit slip from depositing checks from various customers.

If you found our answers useful then please contribute few bucks to support this forum. Thank you!

Thank you!

Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA

QuickBooks Canada

I just did a batch action from the banking center and added all expenses to the same category. How do I undo that action?

Using batch action in bank feed, you moved banking transactions from “New Transactions” tab to “In QuickBooks” column area.

In order to “Undo” transactions, go to “In QuickBooks” column and select items from the list to move it back to new transactions tab > select Batch actions > choose UNDO.

That will bring it back to “New Transactions” tab again.

undo batch action
undo batch action


If you found our answers useful then please contribute few bucks to support this forum. Thank you!

Thank you!

BUY QuickBooks Online - Anytime, Anywhere. Easily Track Sales, Bills and Expenses.
Beach Vacation Rentals under $100 a night
Save on Smartphones from Verizon Wireless!
Over 4000+ STD Test Centers Nationwide. Order Testing Today!

Sign up QuickBooks for a 30-day FREE Trial

QuickBooks USA

QuickBooks Canada

How do I permanently delete “Excluded” transactions in bank feeds?


You can permanently delete bank downloaded transactions in QuickBooks Online (QBO).

In order to permanently delete a bank downloaded transaction (or multiple transactions) from the banking center, you will first need to move it from “For Review” tab to “Excluded” tab.

To move from “For Review” tab to “Excluded” tab:

  • From the home page screen > Go to the left navigation bar Dasshboard
  • Click Banking
  • You’ll see the “For Review” tab, click the checkboxes to the left of the date for the transactions you want to exclude.
  • Once you’re done, click the “Batch Actions” drop-down arrow and select “Exclude Selected.” The transactions will be moved to the “Excluded” tab now.

You can permanently delete from the “Excluded” tab now.

To permanently delete-excluded bank transactions.

  • From the home page screen > Go to the left navigation bar dashboard
  • Select Banking
  • Select “Excluded” tab
  • Select Batch actions (drop-down arrow)
  • Select Delete
  • You can select to delete a transaction or multiple transactions here
  • Note: If you select UNDO it will move back to “For Review” tab.

How to permanently delete bank downloaded transactions in bank feeds

helpful videos

How to import credit card transactions from Excel CSV (.csv) file into QuickBooks Online?

The short video (below) will show you step-by-step instructions on how to import credit card transactions from Excel CSV file into QBO so that you will not import transactions the wrong way.

Confusion has to do with bank account field and Quickbooks field screen. It is the same field name for bank download as well credit card download. Users are importing a CSV file from credit card company and every transaction ended up being the opposite of what it should be…. expenses listed as credits (spent), credits listed as expenses (received).

Once you have downloaded transactions, there is no way to UNDO or delete downloaded transactions. You will have to move to “EXCLUDED” column and it will stay there forever which is not good.

So, I highly encourage you to watch the entire video. You do not want to miss a step.

import cc csv 1

import cc csv 2

import cc csv 3JPG

import cc csv 4

import cc csv 5

import cc csv 6

import cc csv 7

import cc csv 8.1

import cc csv 8.2

import cc csv 9

QuickBooks Online Bank Feed: How to import/export bank rules

Bank rules are great for controlling how incoming bank transactions are categorized before you accept them into QuickBooks. Rules save time and minimize typing mistakes!

This article explains how to import and export rules, which is convenient if you manage multiple companies (like accountants often do).

SOURCE: http://quickbooks.intuit.com/blog/how-to-import-export-quickbooks-online-bank-rules/#respond

Bank feed NEW manage rules in QuickBooks Online

From the home page screen > blue navigation bar on the left > transactions > banking > update > manage rules

On the Banking page, you can set up rules to tell QuickBooks what to do with bank items that meet particular conditions. Rules help you control, customize, and automate how you use the Banking page in QuickBooks.

Even without rules, QuickBooks makes it easier for you to accept bank transactions quickly. When QuickBooks downloads your bank transactions, it does the following:

Cleans up cryptic bank descriptions

Suggests logical categories based on bank descriptions

Remembers changes you made before, and applies those changes to similar transactions

Looks for matches among the transactions you already entered into QuickBooks

Rules go beyond the automatic processing to give you a finer level of control. They scan downloaded bank items for certain criteria you specify, and then assign particular payees, categories, classes, locations, and more to them. Rules can even help automatically split items between categories and more.

You might not need rules, but for frequently downloaded items they can save you lots of time. Here are some sample rules:

Categorize expenses at Mountain Hardware less than $50 as Landscaping

Categorize expenses at Riverview Office Supply greater than $600 as Capital Expenditure

Split income from Lakeside Law Firm as 30% Services and 70% Products

Split expenses from Hillside Communication as $40 Utilities and the remainder as Office Expenses

Rules like these can save you from having to update categories and adjust transactions one by one.

Source Quickbooks Online Help

Bank Feed Rule Form

How can I manually download transactions from my bank? How do I get more than 90 days of bank transactions? Should I use Web-Connect?

How to get more than 90 days of bank transactions?

You’ll start by signing in to your bank’s website and downloading a valid webconnect file.

Valid webconnect files:

  • .qbo (QuickBooks),
  • .qfx (Quicken) and
  • .ofx (MS Money)

Then SAVE it to your computer in a location that you can find.

Now go to QuickBooks Online:

  1. Go to Transactions>Banking
  2. Once you are on the Downloaded Transaction screen, click on File Upload at the top right.
  3. Next, you’ll start the Web Connect mini-interview.
  4. Click Browse and select your Web Connect file from your computer.
  5. Click Next.
  6. In the drop-down menu, select the account where you’d like to upload the transactions.
  7. Click Save and Finish.

NOTE: If you attempt to upload a file of the wrong format, a message will appear stating: The uploaded file isn’t a valid Web-Connect file.

ALSO REMEMBER: if the transactions precede the opening balance that was entered into QuickBooks Online, the opening balance will change.

Check out KB 2370 for help on troubleshooting web-connect errors.



How do I delete downloaded bank transaction that I don’t want to add or match?

Unfortunately, there is no way to delete downloaded banking transactions in new QuickBooks Online.

Since you cannot delete downloaded transactions, you will have to move all unwanted downloaded transactions to “Excluded” column.

Select the transactions (you like to delete) and then use the “Exclude Selected” option under Batch Actions. It will move from “New Transactions” column to “Excluded” column.

QBO developers claim, it will sit there forever harmlessly, but I do not buy it.

If you feel this “delete” feature need to be added in future revision, please add your voice here. I’ve already done it in this past.