American Express → Google Sheets for Pubs & Bars
As pub owner, you need American Express bank statements in Google Sheets format. American Express statements include card transactions, membership rewards, and payment summaries. BankScan AI extracts all transaction detail including merchant categories. BankScan AI handles the conversion — DD MMM YY, charge card layout with separate sections for new charges, payments, credits, and membership rewards summary, and all.
How It Works
Upload American Express PDF
Drop your American Express statement PDF. Supports PDF.
AI converts to Google Sheets
Parses American Express's DD MMM YY, extracts all transactions, outputs Google Sheets (cloud format).
Use in your pubs & bars work
Download and use with Xero, QuickBooks. Convert your pub bank statements to Excel to reconcile daily takings, match brewery and supplier invoices, and prepare VAT returns accurately.
American Express + Google Sheets + Pubs & Bars
- American Express expertise — Handles DD MMM YY and charge card layout with separate sections for new charges, payments, credits, and membership rewards summary
- Google Sheets output — Real-time collaboration, comment threads on specific transactions, version history, and the ability to share with clients via a simple link without email attachments.
- Built for pubs & bars — Saves 2-3 hours per week on daily takings reconciliation and brewery payment matching for a typical pub processing 300+ transactions per day
American Express to Google Sheets — For Pubs & Bars
Handles DD MMM YY, outputs perfect Google Sheets. Free tier available.
Convert American Express to Google Sheets Free