Barclays + Coconut: Bridge the Gap
Need to get your Barclays Bank UK bank statement into Coconut? Barclays uses DD/MM/YYYY and separate Money In and Money Out columns with a running balance column — which needs converting to CSV (Date, Description, Amount — Coconut accepts a single amount column with positive for income and negative for expenses) for Coconut import.
How BankScan AI Converts Barclays for Coconut
Convert statements from other bank accounts to CSV with BankScan AI and import them into Coconut to get a complete picture of your business finances. Barclays statements come in a clean tabular layout, but date formats and running balances can trip up basic parsers.
How It Works
Upload your Barclays PDF
Drag and drop your Barclays statement. Supports PDF, CSV with DD/MM/YYYY handling.
AI converts for Coconut
Our AI parses Barclays's layout, converts dates to DD/MM/YYYY, and outputs CSV.
Import into Coconut
In Coconut, go to Transactions > Import. Upload the CSV from BankScan AI to bring in transactions from external bank accounts alongside your Coconut banking data.
Coconut Import Tip
Date, Description, Amount — Coconut accepts a single amount column with positive for income and negative for expenses
Barclays to Coconut Features
- Barclays optimised — Trained on Barclays's separate Money In and Money Out columns with a running balance column with DD/MM/YYYY parsing
- Coconut formatted — Output as CSV with Date, Description, Amount — Coconut accepts a single amount column with positive for income and negative for expenses
- Date conversion — Converts DD/MM/YYYY to DD/MM/YYYY automatically
Import Barclays Data into Coconut
After converting your Barclays statement with BankScan AI:
- In Coconut, go to Transactions > Import
- Upload the CSV from BankScan AI to bring in transactions from external bank accounts alongside your Coconut banking data
Common Import Issues
Coconut is primarily a banking app — the import feature is designed for bringing in transactions from non-Coconut accounts. Large file imports may time out on mobile.
Import Barclays into Coconut Today
Automatic date conversion (DD/MM/YYYY to DD/MM/YYYY), column mapping, and format validation.
Import Barclays to Coconut Free