{"id":39865,"date":"2019-08-09T13:11:23","date_gmt":"2019-08-09T17:11:23","guid":{"rendered":"https:\/\/pslohio.wpengine.com\/?page_id=39865"},"modified":"2022-08-25T15:26:01","modified_gmt":"2022-08-25T19:26:01","slug":"manually-importing-bank-transactions","status":"publish","type":"page","link":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/","title":{"rendered":"Manually Importing Your Bank Transactions"},"content":{"rendered":"\n<div style=\"padding:55.78% 0 0 0;position:relative;\"><iframe src=\"https:\/\/player.vimeo.com\/video\/604224557?h=ea9c2f1beb&amp;badge=0&amp;autopause=0&amp;player_id=0&amp;app_id=58479\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture\" allowfullscreen=\"\" style=\"position:absolute;top:0;left:0;width:100%;height:100%;\" title=\"Manually Importing Your Bank Transactions\"><\/iframe><\/div><script src=\"https:\/\/player.vimeo.com\/api\/player.js\"><\/script>\n\n\n<h2><span style=\"font-weight: 400;\">Background<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">You can manually import your bank or credit card transactions into Patriot as often as needed.\u00a0 You can also connect your bank account for automatic imports. For more details about having an automatic feed from your bank into the accounting software, see <a href=\"\/accounting\/training\/help\/connecting-bank-accounts-accounting-journal-entries\/\" target=\"_blank\" rel=\"noopener noreferrer\">Connecting Your Bank Accounts for Accounting Journal Entries<\/a>.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">How to manually import a bank transaction<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Here are some FAQs about the file format:<\/span><\/p>\n<p><b>Which transaction fields can I import?<\/b><br \/><span style=\"font-weight: 400;\">You can import the Post Date, Description, Amount, and Amount 2 (if your bank exports deposits\/withdrawals as two separate columns).\u00a0 Any other fields in the file will not be imported.<\/span><\/p>\n<p><b>What are the fields required in order to import transactions?<\/b><br \/><span style=\"font-weight: 400;\">Your import file needs to include all three items:\u00a0 the Post Date, Description, and up to two Amount columns (if your bank exports deposits\/withdrawals as two separate columns).<\/span><\/p>\n<p><b>What file types can I use?\u00a0<\/b><br \/><span style=\"font-weight: 400;\">.xls, .xlsx, .csv<\/span><\/p>\n<p><b>Is there a limit on how many transactions I can import?<\/b><br \/><span style=\"font-weight: 400;\">We recommend you limit your file to 200 entries or less for each upload.<\/span><\/p>\n<p><b>How should the file be formatted?<\/b><br \/><span style=\"font-weight: 400;\">Each bank transaction record should be on a single row in your file, with a column for each field to import. The first row of your file can include a header that labels each column, but it is not required.\u00a0 You can indicate if your file does not have a header row.\u00a0 You cannot have any extra lines, borders, or footers in your file.<\/span><\/p>\n<p><b>Do the order of the fields matter?<\/b><br \/><span style=\"font-weight: 400;\">No, the fields (columns) can be in any order from your bank or former software. You\u2019ll match the fields to our fields after you import the file.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Here is a sample of downloaded activity from a credit card account. Keep in mind, you can have two amount columns, but any more columns will not be imported into the software.<\/span><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-39878 size-full\" src=\"https:\/\/www.patriotsoftware.com\/wp-content\/uploads\/2019\/08\/sample-xls.png\" alt=\"\" width=\"459\" height=\"128\" srcset=\"https:\/\/www.patriotsoftware.com\/wp-content\/uploads\/2019\/08\/sample-xls.png 459w, https:\/\/www.patriotsoftware.com\/wp-content\/uploads\/2019\/08\/sample-xls-300x84.png 300w\" sizes=\"(max-width: 459px) 100vw, 459px\" \/><\/p>\n<h3><span style=\"font-weight: 400;\">When you are ready to import your file<\/span><\/h3>\n<ul>\n<li><span style=\"font-weight: 400;\">First, you will need to log in to your online bank account software and download a file containing your bank transaction activity.\u00a0 Choose the .csv or Excel format option.\u00a0 Save this file to your computer.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Go to<strong> Accounting &gt; Financial Tasks &gt; Manage Imported Transactions<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click \u201cManually Import Transactions.\u201d<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select the bank or credit card account you want to import, and drag and drop or choose the downloaded file from your computer.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">If your file does not contain a header row, and your data to be imported begins on row 1, uncheck the box &#8220;The first row in my file is a header row.\u00a0 Otherwise, leave the box checked if you have a header row, like the example pictured above.\u00a0 <\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click Continue.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">Match your data to Patriot fields<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Next, your column headers from your file will appear.\u00a0 Choose the matching Patriot data field for the Post Date, Description, Amount, and Amount 2 (only if your file has two amount columns).\u00a0 If your file contains extra columns that won&#8217;t be used, just leave those unselected.\u00a0 Click Continue when you are finished.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Review Your Imported Transactions<\/span><\/h3>\n<p>You&#8217;ll be able to review and accept or dismiss and categorize transactons. Check out our help article, <a href=\"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manage-pending-bank-transactions\/\">Managing Your Imported Bank Transactions<\/a> for more info.<\/p>","protected":false},"excerpt":{"rendered":"<p>Background You can manually import your bank or credit card transactions into Patriot as often as needed.\u00a0 You can also connect your bank account for automatic imports. For more details about having an automatic feed from your bank into the accounting software, see Connecting Your Bank Accounts for Accounting Journal Entries.\u00a0 How to manually import [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":314,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-training-help-template.php","meta":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bank Transaction: Manually Importing Transactions into Patriot Software<\/title>\n<meta name=\"description\" content=\"Patriot Software customers can use manual bank transaction imports to update their accounts as often as necessary. Learn more about manually importing.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bank Transaction: Manually Importing Transactions into Patriot Software\" \/>\n<meta property=\"og:description\" content=\"Patriot Software customers can use manual bank transaction imports to update their accounts as often as necessary. Learn more about manually importing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/\" \/>\n<meta property=\"og:site_name\" content=\"Patriot Software\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-25T19:26:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.patriotsoftware.com\/wp-content\/uploads\/2019\/08\/sample-xls.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bank Transaction: Manually Importing Transactions into Patriot Software","description":"Patriot Software customers can use manual bank transaction imports to update their accounts as often as necessary. Learn more about manually importing.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/","og_locale":"en_US","og_type":"article","og_title":"Bank Transaction: Manually Importing Transactions into Patriot Software","og_description":"Patriot Software customers can use manual bank transaction imports to update their accounts as often as necessary. Learn more about manually importing.","og_url":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/","og_site_name":"Patriot Software","article_modified_time":"2022-08-25T19:26:01+00:00","og_image":[{"url":"https:\/\/www.patriotsoftware.com\/wp-content\/uploads\/2019\/08\/sample-xls.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/","url":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/","name":"Bank Transaction: Manually Importing Transactions into Patriot Software","isPartOf":{"@id":"https:\/\/www.patriotsoftware.com\/#website"},"datePublished":"2019-08-09T17:11:23+00:00","dateModified":"2022-08-25T19:26:01+00:00","description":"Patriot Software customers can use manual bank transaction imports to update their accounts as often as necessary. Learn more about manually importing.","breadcrumb":{"@id":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/manually-importing-bank-transactions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.patriotsoftware.com\/"},{"@type":"ListItem","position":2,"name":"Accounting (Master Page)","item":"https:\/\/www.patriotsoftware.com\/accounting\/"},{"@type":"ListItem","position":3,"name":"Accounting Training","item":"https:\/\/www.patriotsoftware.com\/accounting\/training\/"},{"@type":"ListItem","position":4,"name":"Accounting Software Help","item":"https:\/\/www.patriotsoftware.com\/accounting\/training\/help\/"},{"@type":"ListItem","position":5,"name":"Manually Importing Your Bank Transactions"}]},{"@type":"WebSite","@id":"https:\/\/www.patriotsoftware.com\/#website","url":"https:\/\/www.patriotsoftware.com\/","name":"Patriot Software","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.patriotsoftware.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"patriotsoftware":[],"_links":{"self":[{"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/pages\/39865"}],"collection":[{"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/comments?post=39865"}],"version-history":[{"count":0,"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/pages\/39865\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/pages\/314"}],"wp:attachment":[{"href":"https:\/\/www.patriotsoftware.com\/wp-json\/wp\/v2\/media?parent=39865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}