{"id":6479,"date":"2015-04-30T14:34:21","date_gmt":"2015-04-30T14:34:21","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=6479"},"modified":"2018-11-22T06:59:00","modified_gmt":"2018-11-22T06:59:00","slug":"how-to-do-manual-reconciliation-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2015\/04\/30\/how-to-do-manual-reconciliation-in-sage-x3\/","title":{"rendered":"Manual Bank Reconciliation in Sage ERP X3"},"content":{"rendered":"<p>This blog will help you in the manual Reconciliation process in Sage ERP X3.\u00a0A BANK RECONCILIATION\u00a0is a process performed by a company to ensure that the company&#8217;s records (check register, general ledger account, balance sheet, etc.) are correct with the bank&#8217;s records.<\/p>\n<p><strong><strong>New Release:\u00a0<\/strong><\/strong><span style=\"color: #993300;\"><a title=\"Sage ERP X3 integration with Salesforce.com \u2013 An introduction\" href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2015\/04\/23\/sage-erp-x3-integration-with-salesforce-com-an-introduction\/\" target=\"_blank\" rel=\"noopener\">Salesforce Integration with Sage ERP X3 &#8211; An Introduction<\/a><\/span><em><strong><span style=\"color: #993300;\"><br \/>\n<\/span><\/strong><\/em><\/p>\n<p>To achieve this Sage X3 has provided a feature for Manual Reconciliation; which is used to reconcile the drafts\/bills issued by the bank with the drafts\/bills in cash management.<\/p>\n<p>Navigate to path: <strong>A\/P &#8211; A\/R Accounting\u00a0&gt;\u00a0Paying Bank Notice &gt;\u00a0Manual Reconciliation<\/strong><\/p>\n<ul>\n<li>Bank<\/li>\n<li>Statement number.<\/li>\n<\/ul>\n<p>The drafts table proposed for the payment is initialized. Each line represents a specific draft\/bill. It is possible to directly export the paying bank notice from this function using the Bank file button. Warning, any notice exported can no longer be modified (neither in the manual reconciliation function nor in the payment cycle &#8211; Enter the paying bank notice). This export is only launched one all the lines in the notice have be correctly entered.<\/p>\n<ul>\n<li><strong>Drafts\/bills table<\/strong>: According to the RAPLCR parameter, either all the lines in the paying bank notice issued by the bank are displayed or only the non-reconciled (if the automatic reconciliation has already been run).<\/li>\n<\/ul>\n<p>The draft is identified in the first five columns that indicate the :<\/p>\n<ol>\n<li>due date<\/li>\n<li>currency<\/li>\n<li>amount<\/li>\n<li>drawer name<\/li>\n<li>drawee\u2019s reference<\/li>\n<\/ol>\n<p>The following columns are used to specify the acceptance of the proposed drafts.<\/p>\n<ul>\n<li><strong>Accepted lines: <\/strong>The accepted lines must, therefore, have the &#8220;Accepted&#8221; field set to Yes.<\/li>\n<\/ul>\n<ol>\n<li>If specifying the payment number in the field for this draft, the reconciliation is carried out and the payment cycle is not broken (this line is then visible during paying bank notice entry making it possible to continue the posting steps on the payment). When all the lines are assigned it is possible to export the notice either directly with the bank file button or in paying bank entry (if the modifications are still expected before the posing of the payments).<\/li>\n<li>It is still possible to directly export the notice to the issuing bank even if the payment number is not entered on some of the lines. It is then necessary to manually process the payments to complete the missing information.<\/li>\n<\/ol>\n<ul>\n<li><strong>Rejected lines<\/strong><strong>: <\/strong>The rejected lines have the field &#8220;Accepted&#8221; field set to No. It is then necessary to specify the reject code in the related field. The rejected lines are also exported during the related bank notice export. The issuing bank is also notified of the refusal of the drafts that they have proposed.<\/li>\n<\/ul>\n<ul>\n<li><strong>Abnormal lines<\/strong><strong>: <\/strong>It is possible to mark certain lines in the imported notice as being abnormal. This option is proposed by the right click menu. These lines cannot be exported or automatically reconciled.<\/li>\n<\/ul>\n<p>Thus, the non-reconciled lines can be accepted, totally or partially rejected. It is also possible to specify the lines that have problems.<\/p>\n<p><strong>Buttons:<\/strong><\/p>\n<p>The Ok button is used to validate the reconciliation if and only if a payment is posted to the line where the Payment Approval field is set to Yes.<\/p>\n<p>A paying bank notice is then created for the accepted payments in Paying bank entry, which makes it possible to continue with the reconciled payments cycle (posting).<br \/>\nThe End button is used to abandon the reconciliation.<\/p>\n<p>Bank File: It is used to launch the statement export.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU&#x2122; integrations include <a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a> and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage Enterprise Management (Sage X3)<\/a>. Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,\u00a0integrated applications such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a> and have developed add-ons such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight <\/a>\u00a0and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n<p>Greytrix is a recognized <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a> for GUMU&#x2122; Sage Enterprise Management \u2013 Sage CRM integration also listed on <a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on <a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n<p>For more information on Sage X3 Integration and Services, please contact us at\u00a0<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog will help you in the manual Reconciliation process in Sage ERP X3.\u00a0A BANK RECONCILIATION\u00a0is a process performed by a company to ensure that the company&#8217;s records (check register, general ledger account, balance sheet, etc.) are correct with the bank&#8217;s records. New Release:\u00a0Salesforce Integration with Sage ERP X3 &#8211; An Introduction To achieve this\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2015\/04\/30\/how-to-do-manual-reconciliation-in-sage-x3\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1243,1622,1623],"class_list":["post-6479","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-manual-reconciliation","tag-reconciliation","tag-reconciliation-in-sage-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/6479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=6479"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/6479\/revisions"}],"predecessor-version":[{"id":16544,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/6479\/revisions\/16544"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=6479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=6479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=6479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}