How to Import Bank Transactions Into QuickBooks Online – NerdWallet – Live Webinar

One of the time-saving features in QuickBooks Online QBO , is the ability to automatically download bank transactions. Those transactions can then be matched to existing ones in QBO, or entered as new. Note the arrow in the screenshot of the QBO company home page.

One of the bits of handy information on this page is the bank balance. According to the bank though, it is The above screenshot is the banking page. We navigated here by selecting Banking in the Transactions section of the menu located in the left-hand blue panel. There are twenty-five bank transactions that need to be either matched or entered into QBO. Choosing this option filters the QBO bank account transaction list to those that are recognized as a match between our records and the bank.

This leaves us with nine transactions in the list. QBO has not found definite matches for these nine. It did find a possible match for one, but it waits for us to make a decision and complete the transaction.

The circled transaction above is a possible match. If we click on the transaction, a window showing more detail opens. In that window we learn that there are two possible matches.

QBO lets us verify which should be the accurate match, and this transaction can then be processed. The others need to be added.

Notice that they each have a link in the right-hand column to Add. A profit and loss report with a large amount in uncategorized expense is not very helpful. The above screenshot shows the first transaction after it has been selected by clicking on it with the mouse.

Now, with this detail window open, QBO gives us the option to select the correct account. The vendor is Books by Bessie. It is a deposit. Now we can click Add. When we do, the transaction is added to our check register, posting to the correct account. We can repeat that process with the remaining amounts in just a couple of minutes. Our check register is updated and these transactions will already be marked as cleared when we reconcile the bank account.

Your email address will not be published. QuickBooks Online Banking. QuickBooks Online for Construction. QuickBooks Desktop Basics. QuickBooks Desktop Advanced. Our YouTube Channel. Email Us 1. Hector Garcia June 18, We must have transactions to enter. Hector Garcia. Share on linkedin. Share on facebook. Share on twitter. Share on whatsapp. Share on email. Share on print. Hector Garcia am No Comments. Leave a Reply Cancel reply Your email address will not be published.

Popular Courses. Youtube Linkedin Facebook Twitter. QuickBook Training Courses in Miami. Bookkeeping Services Tax Preparation. Buy QuickBooks. Free Resources. Contact Us.

Quickbooks automatic download bank transactions –

 
Dive even deeper in Small Business. Many or all of the products featured here are from our partners who compensate us. Import transactions into QuickBooks from Excel. Three simple ways to access your business account information with QuickBooks. You have an option to indicate that the first row in the CSV file is a header row a.