AMC Banking 365 BC - Bank feeds import rules

Bank feed import rules

During import of bank feeds through AMC Banking 365 BC, a set of rules determines how data packages from XTL are imported and routed.

The import behavior depends on:

• which message types are included in the XTL data package

• which XTL bank account settings are enabled

• whether Import BARJ is enabled on the Bank Account Card in BC

Message Types from XTL

• FINSTA = Bank Account Statement

• CREMUL = Credit Notification (Incoming payments, also referred to as Posting Basis)

• DEBMUL = Debit Notification (Outgoing payments, also referred to as Posting Basis)

Parameter settings

This setup allows the settings on the bank account in XTL to control what is imported into Business Central.

In XTL, there are 3 settings on the bank account under Generate options:

1. Account Statement

   • Default = true

2. Credit Notification

   • Default = true

   • Generated by XTL from the FINSTA

3. Debit Notification

   • Default = true

   • Generated by XTL from the FINSTA

In Business Central, there are 1 settings on the bank account card:

1. Import BARJ
   Default = false

Import Rules

Rule 1

If the data package from XTL contains only FINSTA, and Import BARJ = false on the bank account card in BC, then:

• the FINSTA is imported to the Payment Reconciliation Journal

• when the Payment Reconciliation Journal is posted using "Post Only",
  the FINSTA is then also imported to Bank Account Reconciliation

• when the Payment Reconciliation Journal is posted using "Post and reconcile",
  the FINSTA is then during posting reconciled as a Bank Account Statement.

Rule 1 is used when:

• BC Import BARJ = false

• XTL Account Statement = true

• XTL Credit Notification = false

• XTL Debit Notification = false

Rule 2

If the data package from XTL contains only FINSTA, and Import BARJ = true on the bank account card, then:

• the FINSTA is imported directly to Bank Account Reconciliation

• no Payment Reconciliation Journal is created

Rule 2 is used when:

• BC Import BARJ = true

• XTL Account Statement = true

• XTL Credit Notification = false

• XTL Debit Notification = false

Rule 3

If the data package from XTL contains FINSTA + CREMUL, then:

• the CREMUL is imported to the Payment Reconciliation Journal

• no part of the FINSTA is imported to the Payment Reconciliation Journal

• when the CREMUL is posted using Post Only,
  the FINSTA is then imported to Bank Account Reconciliation

• "Post and reconcile" is not possible as start/end balance amount of CREMUL does not match start/end balance amount of FINSTA

Rule 3 is used when:

• BC Import BARJ = false

• XTL Account Statement = true

• XTL Credit Notification = true

• XTL Debit Notification = false

Rule 4

If the data package from XTL contains FINSTA + DEBMUL, then:

• the DEBMUL is imported to the Payment Reconciliation Journal

• no part of the FINSTA is imported to the Payment Reconciliation Journal

• when the DEBMUL is posted using "Post Only",
  the FINSTA is then imported to Bank Account Reconciliation

• "Post and reconcile" is not possible as start/end balance amount of DEBMUL does not match start/end balance amount of FINSTA

Rule 4 is used when:

• BC Import BARJ = false

• XTL Account Statement = true

• XTL Credit Notification = false

• XTL Debit Notification = true

Rule 5 (Default used rule)

If the data package from XTL contains FINSTA + DEBMUL + CREMUL, and Import BARJ = false, then:

• the DEBMUL and CREMUL are imported to the Payment Reconciliation Journal

• no FINSTA lines are imported to the Payment Reconciliation Journal

• when the DEBMUL/CREMUL is posted using "Post Only",
  the FINSTA is then imported to Bank Account Reconciliation

• when the Payment Reconciliation Journal is posted using "Post and reconcile",
  the FINSTA is then during posting reconciled as a Bank Account Statement.

Rule 5 is used when:

• BC Import BARJ = false

• XTL Account Statement = true

• XTL Credit Notification = true

• XTL Debit Notification = true

Compact Decision Table