Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

Using Sage X3 Bank Statement Import and Automatic Matching

12/19/2017

0 Comments

 
Sage X3 Bank Statement Import Screen
A recent release of Sage X3 improved efficiency of the financial management process by automatically generating the transaction matching open items or unbalanced operations when importing bank statements (MT940).  In this article, we’ll take a closer look at this new functionality that is available as of Sage X3 Version 11.

Advanced Bank Statement Reconciliation

The following functionality is now available to help you automate routine tasks associated with bank statement reconciliation and financial management:

  • Import Bank Statements - the standard file format is MT940. But you can also set up and define other formats including AR lockbox.
 
  • Automatic Matching & Review - run a process that automatically matches each bank operation in the statement to open items according to user-defined search criteria. You can also review results of the matching and make manual adjustments if necessary.
 
  • Payment Generation - you can generate payments after completion of the matching and post these payments using the standard payment functions (Payment entry/Remittance generation).

When compared to manual reconciliation, automating these tasks using Sage X3 creates a process that much more efficient and significantly minimizes the risk of mistakes.

See Also: Introducing Sage X3 Version 11

Bank Import Setup and Processing

A variety of setup options allow you to define how the import and reconciliation process plays out including defaults for payment attributes, bank import segments, bank file import formats, and many others.  Once setup options are configured, here’s the general approach to processing a bank import:

1. Obtain electronic bank statement and save file to your workstation or X3 server volume. Then, import file to Sage X3.

2. According to your settings, the import will extract transaction information and store the result in Sage X3.

3.
 After the import, you can start the automatic matching process and apply manual matches or adjustments if needed.

4. When finished, validate the import and generate payments (which can be posted manually or automatically in Sage X3).
 

VIDEO: See it in Action

Take a quick look at this short video if you'd like to see the bank import and automatic reconciliation features in action.

Need Sage X3 Support?

Get in touch with your authorized Sage X3 Partner or click below to find a consultant in your area.
Sage X3 Partner Locator
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy