{"id":1633,"date":"2012-08-29T12:46:04","date_gmt":"2012-08-29T12:46:04","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=1633"},"modified":"2025-06-23T04:49:59","modified_gmt":"2025-06-23T04:49:59","slug":"migration-of-banks-from-quickbooks-to-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/","title":{"rendered":"Migration of Banks from QuickBooks to Sage 300 ERP"},"content":{"rendered":"

This blog is continuation of our series “How data is migrated from QuickBooks to Sage (Accpac) 300 ERP” using our Sage Certified GUMU solution.\u00a0GUMU QuickBooks migration utility converts all Master and Open transactions along with Sales, Purchase and GL historical data from QuickBooks to Sage (Accpac) 300 ERP.
\nIn our previous blog, we discussed about \u201cMigration of Purchase Invoices from QuickBooks to Sage 300<\/a><\/strong>\u201d.\u00a0We will now see how QuickBooks banks get migrated to Sage (Accpac) 300 through GUMU. Let\u2019s have a quick walk through at the QuickBooks banks screen from below path;
\nNavigate to QuickBooks>> Reports >> Accountant & Taxes >> Account Listing and click on customize Report. In filter tab, select filter \u201ctype\u201d then select type as \u201cbank\u201d and click ok button.<\/p>\n

\"\"<\/a><\/p>\n

Below Report displays QuickBooks banks.<\/p>\n

\"\"<\/a><\/p>\n

Follow similar steps and select type as \u201ccredit card\u201d to view Credit card details.<\/p>\n

\"\"<\/a><\/p>\n

Note<\/strong>: we need to select bank module while running the migration of banks through GUMU.<\/p>\n

After data migration in Sage (Accpac) 300 ERP, follow below path mentioned to check migrated Banks in Sage (Accpac) 300 ERP.<\/p>\n

Navigate to Common services >> Banks services >> Banks and click on finder\u00a0button. It would display the converted bank from QuickBooks to sage Accpac (300) ERP screen.<\/p>\n

\"\"<\/a><\/p>\n

During migration GUMU creates new bank code. After data migration from QuickBooks the field values of QuickBooks banks get converted with the following mapping.<\/p>\n

\"\"<\/a><\/p>\n

You might have seen that the QuickBooks report screen showing some amount in bank balance field but in Sage (Accpac) 300 ERP window screen bank balances are null. This is because the migrated bank Transaction entries of open balance amounts are not yet posted. So we need to post the same so it could be updated in Sage (Accpac) 300 bank balances.<\/p>\n

Navigate to Common services >> Bank services >> Bank transactions >> Bank Entry. Select bank transaction entry and click on post button.<\/p>\n

\"\"<\/a><\/p>\n

You would find a similar way to post Bank transaction in common services >> Bank services >> Post Entries Screen.<\/p>\n

After posting transactions navigate to common services >> Bank services >> Banks and check the bank balance.<\/p>\n

\"\"<\/a><\/p>\n

For more information, get back to us at erpmig@greytrix.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This blog is continuation of our series “How data is migrated from QuickBooks to Sage (Accpac) 300 ERP” using our Sage Certified GUMU solution.\u00a0GUMU QuickBooks migration utility converts all Master and Open transactions along with Sales, Purchase and GL historical data from QuickBooks to Sage (Accpac) 300 ERP. In our previous blog, we discussed about\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[328,700,2149,2357,2451],"class_list":["post-1633","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-bank","tag-data-migration","tag-quickbooks","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"\nMigration of Banks from QuickBooks to Sage 300 ERP<\/title>\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\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migration of Banks from QuickBooks to Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"This blog is continuation of our series “How data is migrated from QuickBooks to Sage (Accpac) 300 ERP” using our Sage Certified GUMU solution.\u00a0GUMU QuickBooks migration utility converts all Master and Open transactions along with Sales, Purchase and GL historical data from QuickBooks to Sage (Accpac) 300 ERP. In our previous blog, we discussed about\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-29T12:46:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-23T04:49:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/\",\"name\":\"Migration of Banks from QuickBooks to Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp\",\"datePublished\":\"2012-08-29T12:46:04+00:00\",\"dateModified\":\"2025-06-23T04:49:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migration of Banks from QuickBooks to Sage 300 ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migration of Banks from QuickBooks to Sage 300 ERP","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\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Migration of Banks from QuickBooks to Sage 300 ERP","og_description":"This blog is continuation of our series “How data is migrated from QuickBooks to Sage (Accpac) 300 ERP” using our Sage Certified GUMU solution.\u00a0GUMU QuickBooks migration utility converts all Master and Open transactions along with Sales, Purchase and GL historical data from QuickBooks to Sage (Accpac) 300 ERP. In our previous blog, we discussed about\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2012-08-29T12:46:04+00:00","article_modified_time":"2025-06-23T04:49:59+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/","name":"Migration of Banks from QuickBooks to Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp","datePublished":"2012-08-29T12:46:04+00:00","dateModified":"2025-06-23T04:49:59+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2012\/08\/12.bmp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/08\/29\/migration-of-banks-from-quickbooks-to-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Migration of Banks from QuickBooks to Sage 300 ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/1633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=1633"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/1633\/revisions"}],"predecessor-version":[{"id":36167,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/1633\/revisions\/36167"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=1633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=1633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=1633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}