Import Bank Statements

Import Bank Statements

Import bank statements from CSV/XLSX files for reconciliation.

Time: 5–10 minutes per import Module: Account Bank Statement Import, Account Bank Statement Import CSV Permissions: Accountant

---

Prerequisites

• Bank journal configured
• Bank account linked
• Statement file from bank (CSV/XLSX)
• Access to Accounting menu

---

Overview

The Bank Statement Import system enables:

• CSV file import
• XLSX file import
• Automatic transaction parsing
• Bank reconciliation support
• Multi-format compatibility
• Statement history tracking

---

Import Workflow

Download from Bank
        ↓
Prepare File Format
        ↓
Import to System
        ↓
Map Columns (if needed)
        ↓
Review Transactions
        ↓
Reconcile Entries

---

Steps

1. Download Bank Statement

From your bank:

1. Log into online banking

2. Navigate to statements/exports

3. Download in supported format:

   • CSV (Comma Separated Values)
   • XLSX (Excel format)

4. Save to computer

2. Prepare File Format

Ensure file contains:

Required Column	Description
Date	Transaction date
Amount	Transaction amount
Label/Description	Transaction detail

Optional Column	Description
Reference	Bank reference
Partner	Payee/payer name
Balance	Running balance

3. Import Statement

1. Navigate to Accounting → Bank → Bank Statements
2. Click Import
3. Select import method:

Method	Description
Import CSV	For CSV files
Import XLSX	For Excel files

4. Upload file
5. Click Load File

4. Map Columns

If columns not auto-detected:

1. System shows mapping screen
2. Match your columns:

Your Column	Maps To
Trans Date	Date
Amount	Amount
Description	Label
Ref No	Reference

3. Click Import

5. Review Imported Statement

After import:

1. Statement created automatically

2. Review transactions:

   • Date accuracy
   • Amount correctness
   • Description clarity

3. Verify totals match bank

6. Validate Statement

Confirm import is correct:

1. Open statement

2. Review all lines

3. Check:

   • Starting balance
   • Ending balance
   • Transaction count

4. Click Validate to confirm

7. Reconcile Transactions

Match with system entries:

1. Open bank statement

2. For each line:

   • Find matching entry
   • Click to match
   • Or create new entry

3. Complete reconciliation

---

Field Reference

Bank Statement (account.bank.statement)

Field	Technical Name	Type	Required	Description
Name	name	Char	Yes	Statement name
Journal	journal_id	Many2one	No	Bank journal
Accounting Date	accounting_date	Date	No	Post date
State	state	Selection	Yes	Status
Is Reconciled	is_reconciled	Boolean	No	All matched
Lines	line_ids	One2many	Yes	Transactions
Move Lines	move_line_ids	One2many	No	Journal entries
Line Count	move_line_count	Integer	Computed	Entry count

Analytic Distribution (account.analytic.distribution.model)

Field	Technical Name	Type	Description
Sequence	sequence	Integer	Order
Analytic Account	analytic_id	Many2one	Cost center
Analytic Tags	analytic_tag_ids	Many2many	Tags
Product	product_id	Many2one	Product filter
Partner	partner_id	Many2one	Partner filter
Account	account_id	Many2one	GL account
User	user_id	Many2one	User filter
Company	company_id	Many2one	Company
Start Date	date_start	Date	Valid from
End Date	date_stop	Date	Valid to

---

Supported File Formats

CSV Format

Date,Description,Reference,Amount,Balance
2024-01-15,Fee Payment - John Doe,FEE001,5000.00,105000.00
2024-01-15,Salary Payment,SAL001,-25000.00,80000.00
2024-01-16,Fee Payment - Jane Smith,FEE002,5000.00,85000.00

CSV Settings

Setting	Value
Delimiter	Comma (,)
Text Qualifier	Double quote (“)
Encoding	UTF-8
Date Format	YYYY-MM-DD

XLSX Format

Same columns as CSV in Excel spreadsheet format.

---

Views Available

View	Features
List	All statements
Form	Statement details
Kanban	Visual cards

Statement Dashboard

Shows:

• Pending reconciliation
• Recent imports
• Balance summary

---

Common Import Scenarios

Fee Collections

Import: Daily Fee Collections
Source: Fee collection bank account
Frequency: Daily

Contains:
- Student fee payments
- Online payments
- Check deposits

Salary Payments

Import: Monthly Salary Statement
Source: Salary bank account
Frequency: Monthly

Contains:
- Staff salary credits
- Statutory deductions
- Net payments

---

Troubleshooting

Issue	Cause	Solution
Import fails	Wrong format	Check file format
Dates wrong	Date format issue	Use YYYY-MM-DD
Amounts wrong	Decimal separator	Use period (.)
Missing rows	Header issue	Check first row
Encoding error	Character set	Save as UTF-8

---

Best Practices

1. Regular imports: Import frequently
2. Verify before import: Check file accuracy
3. Backup files: Keep original statements
4. Reconcile promptly: Match after import
5. Standard format: Use consistent format
6. Document mapping: Note column mappings

---

Security Notes

Role	Capabilities
Accountant	Full import access
Auditor	View statements

---

Related Tasks

• Configure Accounting
• Manage Fee Collection
• Bank Reconciliation