KashfbankBank Statement Converter
DashboardPricingBanksBlog
Get started
HomeBanksAttijariwafa BankAccountants
Morocco

Attijariwafa Bank Statement to Excel for Accounting Practices

Moroccan accounting practices process Attijariwafa statements every month — for SMEs, auto-entrepreneurs, salaried clients, and diaspora customers. Convert each PDF to a clean CSV and import directly into your tool.

Convert your client's statement

Why Moroccan accountants want a structured Attijariwafa export

Attijariwafa Bank is Morocco's largest bank by every standard metric and the most common business and personal account across the country. Casablanca-based SMEs, Rabat civil servant clients, auto-entrepreneurs in the creative economy, and pan-African subsidiary operations all run through Attijariwafa. Your client intake regularly includes Attijariwafa PDFs in bilingual French-Arabic format with French column labels and mixed-language transaction narrations.

The biggest time drain in Moroccan bookkeeping is rekeying transactions from PDF to Excel or directly to the accounting tool. An Attijariwafa statement for an active SME can run 30 to 100 pages over 12 months. At practice scale, manual rekeying is hours per month per accountant. Kashfbank converts each statement to a structured CSV in under a minute, with the French column labels mapped to standard accounting columns.

How Attijariwafa statements behave in bulk conversion

The standard Attijariwafa statement is a bilingual Arabic-French PDF. Columns in French: Date, Libellé, Débit (MAD), Crédit (MAD), Solde (MAD). RIB, Type de Compte, Agence, Période in the header. MAD two-decimal precision. Pan-African branch operations may produce transactions with country prefix codes for clients of Attijariwafa subsidiaries in Senegal, Tunisia, Côte d'Ivoire, and other African markets.

French labels in the transaction narration — 'Virement', 'Retrait GAB', 'Paiement TPE', 'Salaire', 'Remboursement', 'Intérêts' — are read and tagged by Kashfbank. Arabic transaction narrations are equally readable. The Excel export keeps the bilingual content on each row, so your bookkeeping tool can categorise by the French label or the Arabic narration depending on the firm's convention.

What to extract for the working papers

Bookkeeping and audit working papers pull a specific set of rows from the Attijariwafa statement. Income, expenses, tax payments, and FX-converted inbound transfers.

  • 'Salaire' credits — primary income for personal and sole-trader returns
  • 'Virement' inbound — client payments for SMEs, taxable as turnover
  • 'Intérêts' credits — net of 30% withholding, gross-up where the return requires
  • 'Paiement TPE' and 'Retrait GAB' debits — categorised by the channel
  • 'Remboursement' debits — split into principal and interest using the bank's amortisation schedule
  • DGI payments — tagged as Tax category in the export

Attijariwafa Bank statement format

Bilingual Arabic-French PDF (not English). Primary columns in French: Date, Libellé (description), Débit (MAD), Crédit (MAD), Solde (MAD). Account header uses French terms: RIB (Relevé d'Identité Bancaire), Type de Compte, Agence, Période. Transaction narrations mix French labels with Arabic text where customer has set Arabic-language preference. MAD two-decimal formatting. International transactions reference correspondent bank codes. Sub-Saharan African branch transactions may appear with country prefix codes.

LabelMeaning
VirementBank transfer (French: wire/transfer)
Retrait GABATM cash withdrawal (GAB = Guichet Automatique Bancaire)
Paiement TPEPOS card payment (TPE = Terminal de Paiement Électronique)
SalaireSalary credit
RemboursementLoan repayment instalment

Morocco specifics for this use case

Rules in Morocco differ — see our country guide

How to do it — step by step

1

Collect 12 months of client statements

Moroccan annual IR returns and corporate filings need 12 months. Request the bilingual PDF from each client, or have them pull it from Attijari Mobile or Attijari NET. Auto-entrepreneur regime clients need the full year for turnover tracking against the regime ceiling.

2

Upload each client file independently

Drop each PDF into Kashfbank. The file is processed independently and labelled with its source filename. Across a session you can run 10 to 20 client statements without losing track of which file is which.

3

Download the CSV and import into your tool

The CSV uses standard columns: Date, Description, Debit, Credit, Balance, Category, Currency. Most accounting tools used in Morocco (Sage, Cegid, QuickBooks for international clients) accept this format. MAD two-decimal precision is preserved. French column labels are mapped to standard English/Arabic accounting columns in the header.

4

Reconcile against the trial balance

For corporate clients, run the imported transactions against the trial balance. The closing Solde on the Attijariwafa statement should match the bank GL account at the same date. Pan-African inter-subsidiary transactions may need separate mapping if the client operates across multiple Attijariwafa Group entities.

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 the export handle the French column labels in the underlying PDF?

Kashfbank reads the French column labels (Date, Libellé, Débit, Crédit, Solde) and maps them to standard Excel columns (Date, Description, Debit, Credit, Balance). The Description column preserves the bilingual French-Arabic narration on each row. Your bookkeeping tool can categorise by either language depending on the firm's convention.

Can the practice process statements from many clients in a single session?

Yes. Each upload is processed independently and labelled with the source filename. The Kashfbank session can run 10 to 20 client PDFs without mixing data. Each export downloads as its own CSV file.

Does the export distinguish the 24-digit RIB from an IBAN?

Yes. The 24-digit RIB is the Moroccan domestic account identifier; some Attijariwafa accounts also have an IBAN for international transfers. Kashfbank parses the RIB from the header without confusing it with an IBAN. Both are preserved in the account information of the Excel export.

How are pan-African branch entries handled for SME clients with subsidiary operations?

Pan-African entries carry country prefix codes in the Libellé narration. Kashfbank preserves these codes. For clients with subsidiaries in Senegal, Tunisia, or other Attijariwafa Group markets, the country code lets you separate inter-subsidiary transactions from domestic Moroccan ones for the trial balance and consolidation work papers.

Other use cases for Attijariwafa Bank

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.

Attijariwafa Bank overviewMorocco banks guide

Convert Attijariwafa Bank Statement

Upload PDF, get Excel in seconds

Try it free

10 free credits on signup

Statement info

MAD

Statement language: Arabic / 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