Convert Starling Bank CSV to QuickBooks (.QBO)
Works with Starling Bank CSV and Excel exports Nothing uploaded
Starling is a digital bank, so you export from the app or web: choose a date range and download either a PDF statement or a CSV. Business customers also get a richer Bookkeeping Transaction Data (CSV) export that bundles in VAT/tax info and external transactions. What Starling does not offer is a .QBO or Web Connect file, it integrates with Xero and FreeAgent directly, but QuickBooks users are left with a CSV to convert.
Starling's CSV is tidy: typical columns are Date, Counter Party, Reference, Type, Amount (GBP) and Balance (GBP). The amount is a single signed value (debits negative). The catch for QuickBooks is the layout, the payee sits in Counter Party while the detail is in Reference, there's a running balance QuickBooks doesn't want, and dates are UK DD/MM/YYYY which QuickBooks reads as US order.
QBO Maker combines Counter Party and Reference into a readable description, keeps the signed GBP amount, drops the balance column, fixes the date order, and emits a clean .QBO for QuickBooks Web Connect. It all happens locally in the browser, your Starling data is never uploaded. Convert your Starling CSV now.
.QBO QuickBooks accepts. For Starling Bank, its dates are usually DD/MM/YYYY, and amounts arrive as a single signed column (Amount (GBP), debits negative), both detected automatically.A typical Starling Bank export has columns like Date, Counter Party, Reference, Type, Amount (GBP), Balance (GBP), Spending Category and uses DD/MM/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import Starling Bank statements into QuickBooks
- Export your transactions from Starling Bank online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
Starling Bank-specific things to watch for
- Payee split across two columns. The merchant is in
Counter Partyand extra detail inReference; QBO Maker merges them so QuickBooks shows a meaningful description. - Running balance column.
Balance (GBP)is included and confuses QuickBooks' CSV importer, the converter ignores it (QuickBooks recalculates balances itself). - UK date order. Dates are DD/MM/YYYY; without conversion QuickBooks may shift them to US MM/DD. QBO Maker normalises them.
- Business bookkeeping export is wider. The Bookkeeping Transaction Data CSV adds VAT/tax and external-transaction columns, these extras are dropped so only ledger-relevant fields reach QuickBooks.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
Does Starling integrate with QuickBooks or export QBO?
Starling connects natively to Xero and FreeAgent, and many users rely on a QuickBooks bank feed, but Starling does not produce a .QBO or Web Connect download. To import history or fix a feed gap, convert a Starling CSV into a .QBO file here.
What does QBO Maker do with Starling's Counter Party and Reference fields?
It joins them into a single transaction description so the payee and any reference text appear together in QuickBooks, instead of one being lost during a plain CSV import.
Can I convert a Starling business bookkeeping export?
Yes. The wider Bookkeeping Transaction Data CSV converts the same way, QBO Maker reads the date, counter party, reference and signed amount and ignores the VAT and external-transaction extras. Free covers unlimited transactions; Pro removes the cap.
Is my Starling statement uploaded during conversion?
No. The conversion is 100% client-side in your browser, nothing leaves your device. You can verify the .QBO on the validator first.
Convert your Starling Bank statement now
Free, in your browser, nothing uploaded. We will set the date format and currency for you.
Open the converter