Manual Bank Reconciliation in Sage ERP X3

By | April 30, 2015

This blog will help you in the manual Reconciliation process in Sage ERP X3. A BANK RECONCILIATION is a process performed by a company to ensure that the company’s records (check register, general ledger account, balance sheet, etc.) are correct with the bank’s records.

New Release: Salesforce Integration with Sage ERP X3 – An Introduction

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.

Navigate to path: A/P – A/R Accounting > Paying Bank Notice > Manual Reconciliation

  • Bank
  • Statement number.

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 – Enter the paying bank notice). This export is only launched one all the lines in the notice have be correctly entered.

  • Drafts/bills table: 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).

The draft is identified in the first five columns that indicate the :

  1. due date
  2. currency
  3. amount
  4. drawer name
  5. drawee’s reference

The following columns are used to specify the acceptance of the proposed drafts.

  • Accepted lines: The accepted lines must, therefore, have the “Accepted” field set to Yes.
  1. 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).
  2. 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.
  • Rejected lines: The rejected lines have the field “Accepted” 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.
  • Abnormal lines: 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.

Thus, the non-reconciled lines can be accepted, totally or partially rejected. It is also possible to specify the lines that have problems.


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.

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).
The End button is used to abandon the reconciliation.

Bank File: It is used to launch the statement export.

About Us
Greytrix – 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.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.