Table of Contents

FNB Bank Statement Integration

Use this guide to configure and verify direct import of FNB statement transactions into bank reconciliation.

Outcome

After this guide:

  1. Statement transactions are retrieved from FNB API for selected date ranges.
  2. Bank reconciliation lines are created automatically.
  3. Re-import does not duplicate previously imported transactions.

Before You Start

  1. Confirm FNB credentials are issued for the target environment.
  2. Confirm Bank Integration Setup is editable.
  3. Confirm the Bank Account No. in Business Central matches the account registered at FNB.
  4. Prepare a date range with known transactions for testing.

Step 1: Configure FNB Credentials

  1. Open Bank Integration Setup.
  2. In the FNB section, enter FNB Client ID, FNB Client Secret, and FNB API Base URL.
  3. Enter base URL without trailing slash.
  4. Save.

Environment base URLs:

Environment Base URL
Integration https://api.i.fnb.co.za/apigateway
Pre-production https://api.p.fnb.co.za/apigateway
Production https://api.fnb.co.za/apigateway

Pass criteria:

  1. Credentials are saved.
  2. Base URL matches credential environment.

Step 2: Verify Bank Account Identity

  1. Open Bank Account Card used for reconciliation import.
  2. Confirm Bank Account No. exactly matches FNB registered account number.
  3. Save if corrected.

Pass criteria:

  1. Bank Account No. is correct.

Step 3: Run First Import

  1. Open Bank Acc. Reconciliation.
  2. Set Statement Date.
  3. Run Import FNB Bank Statement action.
  4. On request page, enter Start Date and End Date.
  5. Confirm End Date is on or after Start Date.
  6. Complete import.

Pass criteria:

  1. Import completes without authentication or request errors.
  2. Reconciliation lines are created for returned transactions.

Step 4: Validate Imported Data

  1. Review new reconciliation lines.
  2. Confirm key fields are populated as expected: transaction date, description, reference, and amount.

Pass criteria:

  1. Imported lines are usable for matching and posting workflows.

Step 5: Validate Duplicate Protection

  1. Re-run import for the same date range.
  2. Confirm previously imported transactions are skipped.

Pass criteria:

  1. No duplicate lines are created for already imported transactions.

Completion Checklist

The setup is complete when all checks below are true:

  1. Credentials and base URL are correct.
  2. Bank account number is correctly aligned with FNB.
  3. Initial import creates reconciliation lines.
  4. Repeat import skips duplicates.