John Lewis Finance + FreeAgent: Bridge the Gap
Need to get your John Lewis Partnership Card bank statement into FreeAgent? John Lewis Finance uses DD MMM YYYY and credit card layout with Transaction Date, Description, Amount columns, plus Partnership Points summary section — which needs converting to CSV / OFX (Date, Description, Amount (single column) — FreeAgent also accepts OFX files which skip the column mapping step entirely) for FreeAgent import.
How BankScan AI Converts John Lewis Finance for FreeAgent
Convert your bank statement PDF with BankScan AI, then import the CSV into FreeAgent's bank statement upload. Dates and amounts are formatted to match FreeAgent's requirements. John Lewis credit card statements include partnership reward points alongside transactions. BankScan AI extracts the financial data while preserving reward details.
How It Works
Upload your John Lewis Finance PDF
Drag and drop your John Lewis Finance statement. Supports PDF with DD MMM YYYY handling.
AI converts for FreeAgent
Our AI parses John Lewis Finance's layout, converts dates to DD/MM/YYYY, and outputs CSV / OFX.
Import into FreeAgent
In FreeAgent, go to Banking > select your account > Import Bank Statement. Choose CSV or OFX format, upload the file, and FreeAgent will parse the transactions automatically.
FreeAgent Import Tip
Date, Description, Amount (single column) — FreeAgent also accepts OFX files which skip the column mapping step entirely
John Lewis Finance to FreeAgent Features
- John Lewis Finance optimised — Trained on John Lewis Finance's credit card layout with Transaction Date, Description, Amount columns, plus Partnership Points summary section with DD MMM YYYY parsing
- FreeAgent formatted — Output as CSV / OFX with Date, Description, Amount (single column) — FreeAgent also accepts OFX files which skip the column mapping step entirely
- Date conversion — Converts DD MMM YYYY to DD/MM/YYYY automatically
Import John Lewis Finance Data into FreeAgent
After converting your John Lewis Finance statement with BankScan AI:
- In FreeAgent, go to Banking > select your account > Import Bank Statement
- Choose CSV or OFX format, upload the file, and FreeAgent will parse the transactions automatically
Common Import Issues
FreeAgent can struggle with CSV files that have extra header rows or summary rows at the bottom. Ensure only transaction data rows are included.
Import John Lewis Finance into FreeAgent Today
Automatic date conversion (DD MMM YYYY to DD/MM/YYYY), column mapping, and format validation.
Import John Lewis Finance to FreeAgent Free