KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksNational Bank of Fujairah (NBF)Accountants
UAE

NBF Statement to Excel for Accountants

Trade finance, LC settlements, import finance — all separated from operating expenses. Built for SME accounting workflows on Zoho Books or Xero.

Start converting

Why NBF statements need trade-aware handling

National Bank of Fujairah serves trade-oriented SMEs — port operators, import/export businesses, industrial firms on the Gulf of Oman corridor. NBF statements carry letter of credit, trust receipt, import finance, and trade finance rows that need their own chart-of-accounts category. Lumping them with operating expenses produces wrong financial statements.

Kashfbank tags each trade finance category distinctly: LC Settlement, Import Finance, Trade Finance, Bank Charges. The reference codes are preserved in the descriptor so reconciliation against shipping documents and LC terms is a filter-and-match exercise.

Watch-outs in NBF PDFs

Trade finance reference codes are long alphanumeric strings. On narrow description columns in the source PDF they sometimes wrap across two visual lines. Naive PDF parsers split them into two rows. Kashfbank keeps the reference as a single string on a single row.

Low retail transaction volume means many pages contain only 3-5 entries with large whitespace. Page-boundary detection has to be explicit — and Kashfbank handles it. LC settlement entries often appear as paired debit/credit rows for the same underlying transaction; both are preserved so deduplication is a downstream choice.

What the export gives you

Standard columns, ready for Zoho Books, Xero, or QuickBooks. Trade finance reference codes intact.

  • Date, Description, Debit, Credit, Balance, Category, Currency
  • LC, trade finance, and import finance rows tagged separately
  • Bank charges tagged as financing/admin cost
  • Full reference code preserved as a single string in the descriptor

National Bank of Fujairah (NBF) statement format

Bilingual Arabic-English PDF. AED denominated. Dates DD/MM/YYYY. Columns: date, description, debit, credit, running balance. Trade finance and letter of credit entries clearly labelled with reference numbers. Customer name, IBAN, account type, and statement period in header. Running AED balance updated after each transaction.

LabelMeaning
LC SETTLEMENTLetter of credit settlement debit/credit
TRADE FINANCETrade finance facility drawdown or repayment
SALARY TRANSFERWPS salary credit from employer
ATM WITHDRAWALCash withdrawal from ATM
POS PURCHASECard payment at merchant

UAE specifics for this use case

UAE-based accountants using Zoho Books (UAE VAT edition) need the VAT column flagged; Kashf's Category field tags ZATCA-style VAT payment rows for easy filtering.

How to do it — step by step

1

Collect NBF PDFs from the client

Client pulls each month's statement from NBF Mobile and sends as a PDF batch.

2

Bulk upload

Drop all PDFs into Kashfbank. Each is converted independently and labeled with its source filename.

3

Review trade finance categorisation

Trade finance, LC settlement, and import finance rows are pre-tagged. Confirm the mapping matches the client's chart of accounts before import.

4

Export and reconcile

Download per file or merged. Match LC references against shipping documents and supplier invoices. Import into Zoho Books or Xero.

Common challenges

  • •GCC statements in Arabic with Hijri dates requiring dual-date output (Hijri + Gregorian)
  • •Scanned statements with low OCR quality — common in older Egyptian and Lebanese bank PDFs
  • •Multi-page statements where the bank splits across quarterly or monthly PDFs requiring merge
  • •Statements with running balance gaps that signal missing pages (critical for completeness in audit)

Frequently asked questions

How does Kashfbank tag NBF trade finance rows?

Trade finance, LC settlement, and import finance get distinct Category values. They are not mixed with operating expenses. The reference codes stay in the Description field for reconciliation against shipping documents.

What about LC settlements that appear as both a debit and a credit?

Both rows are preserved with the LC reference code. Deduplication or matching is done in your accounting tool — typically the LC settlement closes the original drawdown, so the pair shows the cycle complete.

Can I bulk-convert twelve months of NBF statements?

Yes. Upload all PDFs at once. Each is processed independently and labeled with its source filename. Download per file or merge in Excel.

Will the CSV import into Zoho Books UAE VAT edition?

Yes. Date, Description, Debit, Credit columns match Zoho's template. The trade finance categories need a one-time chart-of-accounts mapping in Zoho on first import — typically to a cost-of-goods-sold or finance-cost account.

Other use cases for National Bank of Fujairah (NBF)

Freelancers

Extract, categorize, and export freelance income and expenses from PDF bank statements — ready for 1099, self-assessment, or ZATCA filings.

Tax Preparation

Convert PDF bank statements to clean spreadsheets for Zakat, VAT, corporate tax, and self-assessment filings across GCC and international markets.

Loan Applications

Prepare clean, lender-ready bank statement exports that prove stable income and responsible financial behavior for personal and business loan applications.

National Bank of Fujairah (NBF) overviewUAE banks guide

Convert National Bank of Fujairah (NBF) Statement

Upload PDF, get Excel in seconds

Try it free

10 free credits on signup

Regulatory context

Regulator: Central Bank of the UAE (CBUAE)

Fiscal year: Jan 1 – Dec 31 (Gregorian)

Full country guide →

Statement info

AED

Statement language: English

Kashfbank

Turn your bank statement into a spreadsheet in seconds.

العربيةEnglish

Product

  • Dashboard
  • Pricing
  • Banks
  • Blog
  • RSS

Resources

  • All Banks
  • Saudi Arabia Banks
  • UAE Banks
  • PDF to CSV
  • PDF to Excel
  • SAR Statement to Excel
  • AED Statement to Excel
  • Blog
  • Pricing

Legal

  • Privacy Policy
  • Terms of Service
  • Contact

© 2026 Kashfbank. All rights reserved.

Powered by AI