{"id":760,"date":"2017-03-07T11:34:01","date_gmt":"2017-03-07T11:34:01","guid":{"rendered":"http:\/\/magnetgroupng.com\/Blog\/?p=760"},"modified":"2017-07-18T13:31:34","modified_gmt":"2017-07-18T13:31:34","slug":"import-nigerian-bank-statement-into-quickbooks","status":"publish","type":"post","link":"https:\/\/magnetgroupng.com\/Blog\/blog\/import-nigerian-bank-statement-into-quickbooks\/","title":{"rendered":"Import Nigerian Bank Statement Into QuickBooks"},"content":{"rendered":"<p>Have you been in a situation where you wished you could easily import all your banking transactions at a go into QuickBooks without combing through each transaction in order to save time and channel your effort to what&#8217;s more productive?<\/p>\n<p>QuickBooks has\u00a0made it applications easier for anyone to connect to using the API integration available to any developer.<\/p>\n<p><strong>This guide contains basic pictorial steps to import your bank statement into QuickBooks.<\/strong><\/p>\n<p>When you launch the application, here is how the window looks like with relevant label and their respective descriptions.<\/p>\n<p><a href=\"http:\/\/magnetgroupng.com\/Blog\/blog\/import-nigerian-bank-statement-into-quickbooks\/bank-statement\/\" rel=\"attachment wp-att-761\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-761 size-full\" src=\"http:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement.png\" alt=\"bank statement\" width=\"601\" height=\"156\" srcset=\"https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement.png 601w, https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-300x78.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p>A: This label shows all the banks from which you select the bank account you want to import your statement.<\/p>\n<p>B:\u00a0 Here you select the period within which all transactions in your statement falls in.<\/p>\n<p>C: Bank Statement: This is the button that lets you upload bank statement from your computer.<\/p>\n<p>You need follow the pre-built format acceptable by the application before it can successful import your bank statement in QuickBooks.<\/p>\n<p>D:\u00a0 The \u201c<strong>Get Template\u201d<\/strong> explains how the format of the bank statement is expected to be, in columns, before you can easily import into QuickBooks.<\/p>\n<p>E: This is where you check all transactions fields imported for accuracy.<\/p>\n<p>F: The <strong>\u201cGreen\u201d and \u201cRed\u201d<\/strong> colour signify any error or shows that your column is valid after importing the bank statement.<\/p>\n<p><strong>II: How to import your bank statement.<\/strong><\/p>\n<ul>\n<li>On the home screen, click label A, B and use C to load the statement as shown on the snapshot above.<\/li>\n<li>Follow the guide on the snapshot below:\n<ul>\n<li>A: Select the sheet name \u201cBank Statement Import\u201d. On your spread sheet, you will see the name at the footer section.<\/li>\n<li>B: Load data lets you import the statement shown below in excel format.<\/li>\n<li>C: Use the \u201cCheck Data\u201d to verify your import for error.<\/li>\n<li>D: This indicates successful transactions<\/li>\n<li>E: This indicate areas you should correct<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"http:\/\/magnetgroupng.com\/Blog\/blog\/import-nigerian-bank-statement-into-quickbooks\/bank-statement-2\/\" rel=\"attachment wp-att-762\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-762\" src=\"http:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-1.png\" alt=\"bank statement\" width=\"602\" height=\"296\" srcset=\"https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-1.png 602w, https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-1-300x148.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n<p>Once all errors are resolved, the save button appears for you to click and run the import.<\/p>\n<p><a href=\"http:\/\/magnetgroupng.com\/Blog\/blog\/import-nigerian-bank-statement-into-quickbooks\/bank-statement-3\/\" rel=\"attachment wp-att-763\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-763\" src=\"http:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-2.png\" alt=\"bank statement\" width=\"601\" height=\"166\" srcset=\"https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-2.png 601w, https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-2-300x83.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n<p>Here is a bank statement showing the transaction imported successdully.<\/p>\n<p><a href=\"http:\/\/magnetgroupng.com\/Blog\/blog\/import-nigerian-bank-statement-into-quickbooks\/bank-statement-4\/\" rel=\"attachment wp-att-764\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-764\" src=\"http:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-3.png\" alt=\"bank statement\" width=\"601\" height=\"180\" srcset=\"https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-3.png 601w, https:\/\/magnetgroupng.com\/Blog\/wp-content\/uploads\/2017\/03\/bank-statement-3-300x90.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you been in a situation where you wished you could easily import all your banking transactions at a go into QuickBooks without combing through each transaction in order to save time and channel your effort to what&#8217;s more productive? QuickBooks has\u00a0made it applications easier for anyone to connect to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-760","post","type-post","status-publish","format-standard","hentry","category-quickbooks"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/posts\/760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/comments?post=760"}],"version-history":[{"count":4,"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/posts\/760\/revisions"}],"predecessor-version":[{"id":838,"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/posts\/760\/revisions\/838"}],"wp:attachment":[{"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/media?parent=760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/categories?post=760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/magnetgroupng.com\/Blog\/wp-json\/wp\/v2\/tags?post=760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}