Hello everyone,

I have a general question regarding how Sage X3 processes bank statements in MT940 format and how GL transactions are generated afterwards.

After importing an MT940 bank statement into Sage X3, the current process looks like this:

1. Navigate to:
   A/P–A/R Accounting → Bank Transactions → Cashbook → Bank Transaction Management

2. Open the imported bank statement and click Process bank transactions
   – this loads all individual lines into the Cashbook.

3. Then you must manually match these lines (Match statement / Match transaction).

4. After matching, you have to click Action → Manual entry and manually input:

   • Site
   • Ledger
   • GL account
   • BP details
   • and all other accounting information

So essentially, every Cashbook transaction must be completed manually before it can generate a GL posting.

Question

Is this really the standard or correct way to process bank statements in Sage X3 Cashbook?

Is there a way to import a bank statement in such a format that Sage X3 can automatically recognise:

• Date
• Description
• BP (Customer/Supplier)
• GL account
• Amount
• and Transaction type (Receipt/Payment)

…so that the system can automatically create GL entries without the need to manually re‑enter every line?

I would like to understand whether Sage X3 supports full automation of Cashbook import → classification → GL posting, and if so, what the correct configuration or file format should look like.

Thank you in advance for any insights!