{"id":1001171,"date":"2018-06-01T12:38:27","date_gmt":"2018-06-01T16:38:27","guid":{"rendered":"http:\/\/blog.bmcgiverncpa.com\/?p=1001171"},"modified":"2020-01-22T04:08:04","modified_gmt":"2020-01-22T04:08:04","slug":"working-with-downloaded-transactions-in-quickbooks-online","status":"publish","type":"post","link":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/2018\/06\/01\/working-with-downloaded-transactions-in-quickbooks-online\/","title":{"rendered":"Working with Downloaded Transactions in QuickBooks Online"},"content":{"rendered":"<p style=\"text-align: center;\"><em>Downloading transactions into QBO is the easy part. You still have work to do once they\u2019re on board.<\/em><\/p>\n<p>Its ability to download financial transactions is one of the five best things about QuickBooks Online. Without it, you\u2019d spend a lot of time on tedious data entry, verifying which checks and deposits had cleared and entering new ones.<\/p>\n<p>Instead, you can easily connect to your bank and bring in all your activity from the previous hours or day. QuickBooks Online stores this neatly in a register and provides tools for you to further describe and classify each transaction.<\/p>\n<p><strong>Setting Up the Connection<\/strong><\/p>\n<p>Haven\u2019t connected your financial institution to QuickBooks Online yet? It\u2019s easy. Click the <strong>Banking <\/strong>link in the toolbar, then <strong>Add Account <\/strong>in the upper right. The <strong>Find your bank <\/strong>window opens. Start entering the name of your bank, credit card company, or service like PayPal in the blank field. A list of potential matches will drop down; you simply select the one you want. A window like this will open:<!--more--><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-1001172 size-full\" src=\"http:\/\/www.bmcgiverncpa.com\/wp-content\/uploads\/2018\/03\/QBO-1217-image-1.jpg\" alt=\"\" width=\"327\" height=\"363\" srcset=\"https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBO-1217-image-1.jpg 327w, https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBO-1217-image-1-270x300.jpg 270w\" sizes=\"(max-width: 327px) 100vw, 327px\" \/><\/p>\n<p style=\"text-align: center;\"><em>All you need to do to start downloading transactions into QuickBooks Online is select your financial institution and enter the <strong>User ID <\/strong>and <strong>Password <\/strong>you use to connect directly to the site.<\/em><\/p>\n<p>You will have to go through some security procedures, and then QuickBooks Online will download 90 days of transactions (you can shorten this if you\u2019d like). You\u2019ll also be asked which QBO account should receive the transactions. After a few minutes, the register for that account will appear, displaying the transactions you just downloaded.<\/p>\n<p><em>Warning: The mechanics of connecting to your bank and downloading your first batch of transactions may sound easy, but if everything is not absolutely clear to you as you\u2019re going through the process, please contact us sooner rather than later.<\/em><\/p>\n<p><strong>Working with Transactions<\/strong><\/p>\n<p>Once you\u2019ve downloaded a set of transactions, you\u2019ll want to look at them. Again, click the <strong>Banking <\/strong>link in the navigation toolbar. Your accounts will appear in small boxes at the top of the page, along with two balances: the one that came from the financial institution and the one in QuickBooks Online. Select the one you want by clicking on it, and its register will open.<\/p>\n<p><em>Tip: QuickBooks Online generally updates your accounts once daily. If you want to launch a manual update at any time, click on <strong>Update<\/strong> in the upper right corner.<\/em><\/p>\n<p>Let\u2019s look at one downloaded transaction to see what you can do with it. Make sure the <strong>For Review <\/strong>column is highlighted above the register. Select a transaction by clicking on it. A window like this will open below it:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-1001173\" src=\"http:\/\/www.bmcgiverncpa.com\/wp-content\/uploads\/2018\/03\/QBO-1217-image-2.jpg\" alt=\"\" width=\"801\" height=\"288\" srcset=\"https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBO-1217-image-2.jpg 801w, https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBO-1217-image-2-300x108.jpg 300w, https:\/\/www.bmcgiverncpa.com\/blog\/wp-content\/uploads\/2018\/03\/QBO-1217-image-2-768x276.jpg 768w\" sizes=\"(max-width: 801px) 100vw, 801px\" \/><\/p>\n<p style=\"text-align: center;\"><em>QuickBooks Online does more than simply download financial transactions: It lets you define them in greater detail.<\/em><\/p>\n<p>There are several options here, including:<\/p>\n<ul>\n<li><strong>Add to register. <\/strong>If you\u2019re satisfied with the information as is, just click the <strong>Add <\/strong>button to the right (not pictured here).<\/li>\n<li>If you want to split the amount\/category (<strong>Supplies<\/strong>, <strong>Tools<\/strong>, etc.)\/class of a transaction, click <strong>Split <\/strong>(also off to the right and not pictured). A window will open to let you specify that.<\/li>\n<li><strong>Assign categories<\/strong>. QuickBooks Online may automatically make assignments to obvious categories, which you can change if incorrect. You can also click the down arrow to the right of that field and select your own from the list.<\/li>\n<li><strong>Bill an expense to a customer<\/strong>. Did you purchase something that needs to be billed to a customer? Click in the box under <strong>Billable<\/strong> and select the correct one from the drop-down list that opens.<\/li>\n<li><strong>Find matches. <\/strong>This can get complicated, and we recommend you let us work with you on it. Let\u2019s say you entered an invoice in QuickBooks Online, and an income item for that exact amount gets downloaded from your bank. QBO will assume that those two \u201cmatch,\u201d and display them in the <strong>In QuickBooks <\/strong> You can click <strong>Undo <\/strong>if this is incorrect. But you can also click <strong>Find match <\/strong>in the transaction window, and QBO will open a list of possibilities.<\/li>\n<\/ul>\n<p>As you can see from browsing the lists of downloaded transactions, there\u2019s a lot to learn here. We\u2019d be happy to get together and walk you through your first explorations of these powerful features.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Its ability to download financial transactions is one of the five best things about QuickBooks Online. Without it, you\u2019d spend a lot of time on tedious data entry, verifying which checks and deposits had cleared and entering new ones.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[79,47],"tags":[73,77,78,80,53],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1001171"}],"collection":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=1001171"}],"version-history":[{"count":1,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1001171\/revisions"}],"predecessor-version":[{"id":1001216,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/1001171\/revisions\/1001216"}],"wp:attachment":[{"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=1001171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=1001171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=1001171"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.bmcgiverncpa.com\/blog\/index.php\/wp-json\/wp\/v2\/yst_prominent_words?post=1001171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}