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.

WARNING:
Rule 1 is not recommended for use with both CAMT.054 or similar bank feeds and Bank Statement (FINSTA), as it will generate duplicates in the Payment Reconciliation Journal that the user must handle manually.

If you need to import both CAMT.054 or similar bank feeds and FINSTA, use Rule 2 instead.

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 received from XTL contains only FINSTA data and/or bank-specific bank feed files such as CAMT.054 or similar bank feeds, and Import BARJ = true is enabled on the Bank Account Card, then:

• the FINSTA is imported directly to Bank Account Reconciliation

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

• the CAMT.054 or simular bank feed is imported to Payment Reconciliation Journal

• the CAMT.054 or simular bank feed can ONLY be posted using Post Only

• "Post and reconcile" is not possible as start/end balance amount of CAMT.054 or simular bank feed does not match start/end balance amount of FINSTA

WARNING:
Select Rule 2 only if both outgoing payments (DEBMUL) and incoming payments (CREMUL) are either:

• processed outside AMC Banking (by another system or manually), or

• received through another bank feed format, such as CAMT.054 and/or simular bank feed.

Otherwise, use Rule 5.

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

WARNING:
Select only Rule 3 if outgoing payments (DEBMUL) are processed outside AMC Banking,
either by another system or manually. Otherwise use Rule 5.

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

WARNING:
Select only Rule 4 if incoming payments (CREMUL) are processed outside AMC Banking,
either by another system or manually. Otherwise use Rule 5.

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