---
title: "Import Payment Gateway Statements for Bank Reconciliation"
canonical: "https://kb.myframeworks.com.au/space/CO/403144715/Import%20Payment%20Gateway%20Statements%20for%20Bank%20Reconciliation"
format: markdown
---
**Import payment gateway statement files** to automatically **create customer payment records** and general ledger transactions during bank reconciliation. Frameworks supports BPay Biller Remittance Files (.brf) and FatZebra payment gateway export files (.csv).

> 📝 ## Prerequisites
> 📝 
> 📝 - Access to the **Bank Reconciliation** screen
> 📝 - Bank statement imported or entered into Frameworks
> 📝 - Payment gateway statement file downloaded from your payment provider
> 📝 - BPay files: .brf format from ANZ or NAB
> 📝 - FatZebra files: .csv format from FatZebra payment gateway

---

## Import BPay Statement Files

BPay statement imports create customer payment records from BPay Biller Remittance Files. This process matches BPay payments from your bank statement to customer accounts using BPay reference numbers.

### Supported BPay File Formats

Frameworks currently supports BPay .brf (Biller Remittance File) format from:

- ANZ (Australia and New Zealand Banking Group)
- NAB (National Australia Bank)

### Steps

1. In the **Bank Reconciliation** screen, locate the unreconciled bank statement record for the BPay deposit batch.
2. Click the **Customer Payment** icon for the statement record to open the **Bank Statement Payment Entry** window.
3. Click the **Bpay Import** button to open the **Import Details** window.
4. Click **Choose File** and select the .brf file from your computer.
5. Click **Upload** to import the BPay statement file.
6. Review the imported payment details displayed in the **Bank Statement Payment Entry** window.
7. Click **Post** to create the customer payments and add the balanced transactions to the **Reconciled** tab.

### Result

Frameworks creates customer payment records for each BPay payment in the .brf file. The system matches payments to customer accounts using the BPay reference numbers. The balanced general ledger transactions appear in the **Reconciled** tab, and customer payments are available for allocation to invoices.

> ❌ If BPay reference numbers do not match existing customer records, the import displays an error message identifying which payments require manual review.

---

## Import FatZebra Statement Files

FatZebra statement imports create customer payment records from FatZebra payment gateway export files. This process matches credit card and EFTPOS payments from your bank statement to customer accounts.

### FatZebra File Format

Frameworks imports FatZebra statement files in .csv (comma-separated values) format exported from the FatZebra payment gateway dashboard.

### Steps

1. In the **Bank Reconciliation** screen, locate the unreconciled bank statement record for the FatZebra payment batch.
2. Click the **Customer Payment** icon for the statement record to open the **Bank Statement Payment Entry** window.
3. Click the **FatZebra Import** button to open the **Import Details** window.
4. Click **Choose File** and select the .csv file from your computer.
5. Click **Upload** to import the FatZebra statement file.
6. Review the imported payment details displayed in the **Bank Statement Payment Entry** window.
7. Click **Post** to create the customer payments and add the balanced transactions to the **Reconciled** tab.

### Result

Frameworks creates customer payment records for each FatZebra transaction in the .csv file. The system matches payments to customer accounts using transaction reference data. The balanced general ledger transactions appear in the **Reconciled** tab, and customer payments are available for allocation to invoices.

> ❌ If transaction references do not match existing customer records, the import displays an error message identifying which payments require manual review.

> ✅ ## Related Tasks
> ✅ 
> ✅ - [Create Customer Payments from a Bank Statement](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/402980894) - for manual payment entry
> ✅ - Allocate customer payments to invoices - see [Processing Customer Payments](https://sterlandsupport.atlassian.net/wiki/spaces/CO/pages/30516976)