Why Convert John Lewis Finance Statements with BankScan AI?
Need to convert your own John Lewis Partnership Card business statement to Excel? BankScan AI prepares its DD MMM YYYY dates and credit card layout with Transaction Date, Description, Amount columns, plus Partnership Points summary section for review. BankScan is for one UK sole trader or owner-operated small business that keeps GBP sole-trader records.
Understanding John Lewis Finance Statement Formats
John Lewis credit-card statements include Partnership Points alongside transactions. BankScan AI presents detected financial and reward details for review. BankScan AI uses reviewed rules for supported John Lewis Partnership Card layouts (PDF) and presents the extracted columns, dates and descriptions for you to verify.
Why John Lewis Finance Statements Need Specialist Conversion
John Lewis Finance statements use DD MMM YYYY dates with credit card layout with Transaction Date, Description, Amount columns, plus Partnership Points summary section. Common parsing challenges include: Partnership Card reward point entries appear as non-financial rows mixed with transactions, Waitrose and John Lewis purchases carry different merchant category codes, and the shopping protection benefit claims use a unique format.
BankScan AI applies reviewed parsing rules for John Lewis Partnership Card layouts. Check the extracted dates, descriptions, amounts and balances against the source before using them.
How to Download Your John Lewis Finance Statement
In John Lewis Finance Online, click 'Statements', select the statement period, and download as PDF. The John Lewis Finance app also offers statement access under 'Account' > 'Statements'.
How It Works
Upload a supported John Lewis Finance statement
Drag and drop a John Lewis Finance statement in a currently reviewed PDF format.
AI prepares transaction rows
The scanner reads the DD MMM YYYY dates and prepares descriptions, amounts and running balances where present.
Review and download
Compare the extracted rows with the source statement, then download the reviewed spreadsheet for your records or a controlled import.
John Lewis Finance — Did You Know?
The John Lewis Partnership Card is issued by HSBC but branded and managed through the John Lewis Partnership. The statement format blends HSBC's underlying structure with John Lewis branding and the Partnership Points rewards tracking.
Reviewing a John Lewis Finance conversion
- John Lewis Finance format review — Designed for currently reviewed John Lewis Finance layouts in PDF files
- Source-led checking — Keep the original statement beside the working file and verify every extracted row before use
- Reviewable columns — Prepares credit card layout with Transaction Date, Description, Amount columns, plus Partnership Points summary section as rows you can check and correct
Turn Your Statement into a Spreadsheet
One £3.99 monthly plan for a UK sole trader, landlord or owner-operated small business that keeps sole-trader records. Start with a 7-day trial; a payment card is required and there is no charge for 7 days.
Start 7-day trial