Credentials
Stored encrypted and decrypted only while a job is running. Use an IAM user scoped to the bucket below.
Temporary credentials
Leave empty for a long-lived IAM user key.
Location
Where browsing starts. Leave it empty to start at the top of the bucket. Saved work addresses objects by their full path, so this is a starting point rather than a restriction.
Convert QuickBooks Credit Card Statement to Fixed Width
Parse every charge, payment, fee, and interest line from QuickBooks credit card statements into structured, export-ready data.
Connectors
Read straight from the systems your data already lives in, instead of uploading a file.
Same statement. Clean data in any format.
Extract transactions from QuickBooks credit card statements into clean Excel, CSV, JSON, or SQL files. Payments, purchases, fees, and interest land in one table, with every date and amount kept exactly as the statement prints it.
- 3 sections1 table
- Header rowcolumn names
- 11 lines11 rows, nothing retyped
Sample only: drag the line to compare the two
Tailored workflows for every role
Whether you are filing an expense report, reconciling monthly books, or tracking company spend, export clean data formatted for your exact needs.
File expense reports in minutes
Extract corporate card charges, filter out personal purchases, and add custom fields for seamless reimbursement.
- Filter transactions by specific card number
- Add custom fields like Business Purpose or Project Code
- Export a clean file ready to attach to your expense claim
| Date | Merchant | Amount | Business Purpose |
|---|---|---|---|
| 08/15 | SOL NORTE CAFE | 18.40 | add purpose… |
| 08/19 | HARBOR & PINE HOTEL | 612.80 | add purpose… |
| 08/30 | LUMEN CLOUD HOSTING | 89.00 | add purpose… |
| 09/05 | KESSLER KITCHEN SUPPLY | 231.70 | add purpose… |
Reconcile statements without manual entry
Get every line of the statement in one table, in the order it was printed, ready to check against your ledger or import into accounting software.
- Credits keep their CR marker, so one filter separates them from charges
- Consolidate multi-page statements into a single table
- Export import-ready files formatted for your chart of accounts
| TRANS | DESCRIPTION | CARD | AMOUNT |
|---|---|---|---|
| 08/26 | PAYMENT - THANK YOU | 4417 | 1,250.00 CR |
| 09/02 | PAPER TRAIL OFFICE RETURN | 9023 | 32.50 CR |
| 08/15 | SOL NORTE CAFE SAN DIEGO CA | 4417 | 18.40 |
| 08/17 | CITYLINE TRANSIT | 9023 | 42.00 |
Gain complete visibility into company spend
Merge multi-card statements across accounts to analyze cash flow and track business overhead.
- Combine statements across team members into one master file
- Group expenses by vendor, date, or cardholder
- Audit financial activity without waiting on manual data entry
| Card | Jul | Aug | Sep |
|---|---|---|---|
| 4417 · J. Okafor | 318.28 | 994.26 | 956.54 |
| 9023 · M. Brandt | 628.55 | 235.55 | 363.97 |
Convert card statements from your own code
The API runs the same conversion. Post each month's statement and get the Fixed Width file back, ready for your books or expense system.
Explore the APIcurl -X POST "https://dataconverter.io/api/v1/convert/qbo-to-fixed-width" \ -H "Authorization: Bearer YOUR_TOKEN_HERE" \ -F "file=@northwind-4417-2026-09.qbo" \ --output northwind-4417-2026-09.txt✓ 200 OK · northwind-4417-2026-09.txt · 11 transactions
Frequently asked questions
Which card issuers are supported?
Any issuer. The converter reads the transactions from the statement itself, so it works with any bank or card layout rather than a fixed list.
How are payments and refunds shown?
Exactly as the statement prints them. A credit keeps its CR marker or minus sign in the amount column, so you can filter on it to split charges from credits before you import.
Can it read a scanned statement?
Yes. Scanned pages and photos are put through text extraction first, then the transactions are read the same way as from a digital PDF.