{"id":5398,"date":"2023-04-03T06:21:47","date_gmt":"2023-04-03T06:21:47","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?p=5398"},"modified":"2025-03-25T10:56:05","modified_gmt":"2025-03-25T10:56:05","slug":"mapping-of-receivable-lockbox-file-in-sage-intacct","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/","title":{"rendered":"Mapping Of Receivable Lockbox File In Sage Intacct"},"content":{"rendered":"\n<p>In the previous blog, we discussed the last version of Receivable Lockbox which contains the below features.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Automated processing of receivables lockbox files into Sage Intacct<\/strong><strong><\/strong><\/li><li><strong>Matching transactions<\/strong><strong><\/strong><\/li><li><strong>Data validation and accuracy<\/strong><strong><\/strong><\/li><li><strong>Apply receipts against open invoices.<\/strong><strong><\/strong><\/li><\/ul>\n\n\n\n<p>Please refer the link below to review the earlier version of Receivable Lockbox: <a href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2019\/03\/30\/sage-intacct-custom-applications-lockbox-file-processing\/\">https:\/\/www.greytrix.com\/blogs\/sageintacct\/2019\/03\/30\/sage-intacct-custom-applications-lockbox-file-processing\/<\/a><\/p>\n\n\n\n<p>In this blog, we will be discussing more about the newly added feature \u201cbank File Mapping\u201d. As we are aware of the files that are generated by the bank need to be mapped according to the fields of the application where we are going to import those. To do this in a much easier way, we have added new screen wherein we can map the required fields along with setting the index in the custom screen.<\/p>\n\n\n\n<p>Please see below screenshot for your reference.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png\" alt=\"Receivable Lockbox\"\/><\/a><\/figure><\/div>\n\n\n<p>\u00a0<\/p>\n<p><strong>Bank File Mapping<\/strong><\/p>\n<ul>\n<li>Go to sage intact &gt; Receivables Lockbox &gt; Bank File Mapping.<a style=\"font-size: inherit;\" href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/2.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/2.png\" alt=\"Bank File Mapping\" \/><\/a><\/li>\n<\/ul>\n\n\n<p>Once we set the required data along with the indexes for those required fields, on save the data will be stored into the custom objects and it will further retrieve by our program at the time of processing the bank files. In the earlier version of Receivable Lockbox those indexes were hardcoded into the program according to the bank format of the file and here in the latest version, we can add the mapping into the screen itself, so that it can be modified as per the bank format very easily.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the previous blog, we discussed the last version of Receivable Lockbox which contains the below features. Automated processing of receivables lockbox files into Sage Intacct Matching transactions Data validation and accuracy Apply receipts against open invoices. Please refer the link below to review the earlier version of Receivable Lockbox: https:\/\/www.greytrix.com\/blogs\/sageintacct\/2019\/03\/30\/sage-intacct-custom-applications-lockbox-file-processing\/ In this blog, we\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[647,146,645,646],"class_list":["post-5398","post","type-post","status-publish","format-standard","hentry","category-sage-intacct","tag-bank-file-mapping","tag-file-import","tag-mapping-of-receivable-lockbox-file-in-sage-intacct","tag-receivable-lockbox"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mapping of Receivable Lockbox Files in Sage Intacct<\/title>\n<meta name=\"description\" content=\"learn more about the recently introduced &quot;bank File Mapping&quot; feature.\" \/>\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.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mapping of Receivable Lockbox Files in Sage Intacct\" \/>\n<meta property=\"og:description\" content=\"learn more about the recently introduced &quot;bank File Mapping&quot; feature.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage Intacct \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-03T06:21:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-25T10:56:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/\",\"name\":\"Mapping of Receivable Lockbox Files in Sage Intacct\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png\",\"datePublished\":\"2023-04-03T06:21:47+00:00\",\"dateModified\":\"2025-03-25T10:56:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/8ac414c989344a55601e96b46e8720fb\"},\"description\":\"learn more about the recently introduced \\\"bank File Mapping\\\" feature.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mapping Of Receivable Lockbox File In Sage Intacct\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\",\"name\":\"Sage Intacct \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/8ac414c989344a55601e96b46e8720fb\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mapping of Receivable Lockbox Files in Sage Intacct","description":"learn more about the recently introduced \"bank File Mapping\" feature.","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.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/","og_locale":"en_US","og_type":"article","og_title":"Mapping of Receivable Lockbox Files in Sage Intacct","og_description":"learn more about the recently introduced \"bank File Mapping\" feature.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/","og_site_name":"Sage Intacct \u2013 Tips, Tricks and Components","article_published_time":"2023-04-03T06:21:47+00:00","article_modified_time":"2025-03-25T10:56:05+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/","name":"Mapping of Receivable Lockbox Files in Sage Intacct","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png","datePublished":"2023-04-03T06:21:47+00:00","dateModified":"2025-03-25T10:56:05+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/8ac414c989344a55601e96b46e8720fb"},"description":"learn more about the recently introduced \"bank File Mapping\" feature.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-content\/uploads\/2023\/04\/1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2023\/04\/03\/mapping-of-receivable-lockbox-file-in-sage-intacct\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/"},{"@type":"ListItem","position":2,"name":"Mapping Of Receivable Lockbox File In Sage Intacct"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/","name":"Sage Intacct \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/8ac414c989344a55601e96b46e8720fb","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/5398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/comments?post=5398"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/5398\/revisions"}],"predecessor-version":[{"id":5399,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/5398\/revisions\/5399"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/media?parent=5398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/categories?post=5398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/tags?post=5398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}