{"id":2674,"date":"2025-04-01T08:10:00","date_gmt":"2025-04-01T08:10:00","guid":{"rendered":"https:\/\/cssi.com\/gp\/?p=2674"},"modified":"2025-03-28T20:12:08","modified_gmt":"2025-03-28T20:12:08","slug":"how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp","status":"publish","type":"post","link":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/","title":{"rendered":"How To Generate a List of Unreconciled Bank Transactions in GP"},"content":{"rendered":"\n

Creating a List of Unreconciled Bank Transactions in Dynamics GP?<\/h2>\n\n\n\n

Here is an easy way to create a SmartList of unreconciled Bank Transactions. Go to Microsoft Dynamics GP > SmartList. In SmartList, navigate to Financial > Bank Transactions. Select the option with the asterisk.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click on Columns and then the add button to add the columns that you would like to appear in the SmartList. Click OK when you are finished.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Next, click on the Search icon. Add the restrictions to the SmartList. Set the checkbook ID equal to your checkbook ID, set Voided equal to no and set Reconciled equal to No. Then click OK.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This will give you the list of unreconciled transactions. Click on Favorites and give your report a name. Then click Add > Add Favorite.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Contact CSSI for GP Technical Support and Training<\/h2>\n\n\n\n

For GP help and training, please contact CSSI<\/a>. Our team of experts stand by to assist!<\/p>\n","protected":false},"excerpt":{"rendered":"

Creating a List of Unreconciled Bank Transactions in Dynamics GP? Here is an easy way to create a SmartList of unreconciled Bank Transactions. Go to Microsoft Dynamics GP > SmartList. In SmartList, navigate to Financial > Bank Transactions. Select the option with the asterisk. Click on Columns and then the.<\/p>\n","protected":false},"author":4,"featured_media":2675,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[8],"tags":[229,48,27],"class_list":["post-2674","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-gp-tips","tag-great-plains","tag-microsoft-gp"],"acf":[],"yoast_head":"\nHow To Generate a List of Unreconciled Bank Transactions in GP - Dynamics GP Support in PA - CSSI Technologies LLC<\/title>\n<meta name=\"description\" content=\"Here's a new GP tip from the experts at CSSI: Here is an easy way to create a SmartList of unreconciled Bank Transactions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Generate a List of Unreconciled Bank Transactions in GP - Dynamics GP Support in PA - CSSI Technologies LLC\" \/>\n<meta property=\"og:description\" content=\"Here's a new GP tip from the experts at CSSI: Here is an easy way to create a SmartList of unreconciled Bank Transactions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/\" \/>\n<meta property=\"og:site_name\" content=\"Dynamics GP Support in PA - CSSI Technologies LLC\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-01T08:10:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2025\/03\/Unreconciled-bank-transactions.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"jtosolt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jtosolt@cssi.com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"jtosolt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/\"},\"author\":{\"name\":\"jtosolt\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\"},\"headline\":\"How To Generate a List of Unreconciled Bank Transactions in GP\",\"datePublished\":\"2025-04-01T08:10:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/\"},\"wordCount\":162,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/Unreconciled-bank-transactions.jpg\",\"keywords\":[\"gp tips\",\"great plains\",\"Microsoft GP\"],\"articleSection\":[\"blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/\",\"name\":\"How To Generate a List of Unreconciled Bank Transactions in GP - Dynamics GP Support in PA - CSSI Technologies LLC\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/Unreconciled-bank-transactions.jpg\",\"datePublished\":\"2025-04-01T08:10:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\"},\"description\":\"Here's a new GP tip from the experts at CSSI: Here is an easy way to create a SmartList of unreconciled Bank Transactions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/Unreconciled-bank-transactions.jpg\",\"contentUrl\":\"https:\\\/\\\/cssi.com\\\/gp\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2025\\\/03\\\/Unreconciled-bank-transactions.jpg\",\"width\":1500,\"height\":1000,\"caption\":\"Unreconciled bank transactions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/2025\\\/04\\\/01\\\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cssi.com\\\/gp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Generate a List of Unreconciled Bank Transactions in GP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#website\",\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/\",\"name\":\"Dynamics GP Support in PA - CSSI Technologies LLC\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cssi.com\\\/gp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/cssi.com\\\/gp\\\/#\\\/schema\\\/person\\\/2af2cbcbd389a279188e6b4608ddb4db\",\"name\":\"jtosolt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g\",\"caption\":\"jtosolt\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/jtosolt@cssi.com\"],\"url\":\"https:\\\/\\\/cssi.com\\\/gp\\\/author\\\/jtosolt\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Generate a List of Unreconciled Bank Transactions in GP - Dynamics GP Support in PA - CSSI Technologies LLC","description":"Here's a new GP tip from the experts at CSSI: Here is an easy way to create a SmartList of unreconciled Bank Transactions.","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:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/","og_locale":"en_US","og_type":"article","og_title":"How To Generate a List of Unreconciled Bank Transactions in GP - Dynamics GP Support in PA - CSSI Technologies LLC","og_description":"Here's a new GP tip from the experts at CSSI: Here is an easy way to create a SmartList of unreconciled Bank Transactions.","og_url":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/","og_site_name":"Dynamics GP Support in PA - CSSI Technologies LLC","article_published_time":"2025-04-01T08:10:00+00:00","og_image":[{"width":1500,"height":1000,"url":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2025\/03\/Unreconciled-bank-transactions.jpg","type":"image\/jpeg"}],"author":"jtosolt","twitter_card":"summary_large_image","twitter_creator":"@jtosolt@cssi.com","twitter_misc":{"Written by":"jtosolt","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#article","isPartOf":{"@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/"},"author":{"name":"jtosolt","@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db"},"headline":"How To Generate a List of Unreconciled Bank Transactions in GP","datePublished":"2025-04-01T08:10:00+00:00","mainEntityOfPage":{"@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/"},"wordCount":162,"commentCount":0,"image":{"@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#primaryimage"},"thumbnailUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2025\/03\/Unreconciled-bank-transactions.jpg","keywords":["gp tips","great plains","Microsoft GP"],"articleSection":["blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/","url":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/","name":"How To Generate a List of Unreconciled Bank Transactions in GP - Dynamics GP Support in PA - CSSI Technologies LLC","isPartOf":{"@id":"https:\/\/cssi.com\/gp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#primaryimage"},"image":{"@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#primaryimage"},"thumbnailUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2025\/03\/Unreconciled-bank-transactions.jpg","datePublished":"2025-04-01T08:10:00+00:00","author":{"@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db"},"description":"Here's a new GP tip from the experts at CSSI: Here is an easy way to create a SmartList of unreconciled Bank Transactions.","breadcrumb":{"@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#primaryimage","url":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2025\/03\/Unreconciled-bank-transactions.jpg","contentUrl":"https:\/\/cssi.com\/gp\/wp-content\/uploads\/sites\/2\/2025\/03\/Unreconciled-bank-transactions.jpg","width":1500,"height":1000,"caption":"Unreconciled bank transactions"},{"@type":"BreadcrumbList","@id":"https:\/\/cssi.com\/gp\/2025\/04\/01\/how-to-generate-a-list-of-unreconciled-bank-transactions-in-gp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cssi.com\/gp\/"},{"@type":"ListItem","position":2,"name":"How To Generate a List of Unreconciled Bank Transactions in GP"}]},{"@type":"WebSite","@id":"https:\/\/cssi.com\/gp\/#website","url":"https:\/\/cssi.com\/gp\/","name":"Dynamics GP Support in PA - CSSI Technologies LLC","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cssi.com\/gp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cssi.com\/gp\/#\/schema\/person\/2af2cbcbd389a279188e6b4608ddb4db","name":"jtosolt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6322382d65cc71df3e9c204b08e5722e704d53b70cbd527b85c7cb3a758a3d3d?s=96&d=mm&r=g","caption":"jtosolt"},"sameAs":["https:\/\/x.com\/jtosolt@cssi.com"],"url":"https:\/\/cssi.com\/gp\/author\/jtosolt\/"}]}},"_links":{"self":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts\/2674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/comments?post=2674"}],"version-history":[{"count":0,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/posts\/2674\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/media\/2675"}],"wp:attachment":[{"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/media?parent=2674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/categories?post=2674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cssi.com\/gp\/wp-json\/wp\/v2\/tags?post=2674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}