LedgerPort

QBO to CSV converter

Open a QBO file in Excel or Google Sheets by converting it to CSV. The file is converted in your browser and never uploaded. Free at any size.

Your file is read on this device. It is never uploaded.

Enter your licence key

The key is on the page you saw after paying, and on your invoice.

  1. Add your QBO file Drop it on the box above or click to choose it.
  2. Check the preview Confirm the dates, payees and amounts look right.
  3. Download Save the CSV file.

What is inside a QBO file

A QBO file is a bank statement written for QuickBooks. It is plain text, but not in a layout a spreadsheet can read. The converter pulls out each transaction's date, payee, memo and amount and writes them as rows.

Using the CSV

The CSV has three columns: date, description and amount, with money out as negative numbers. It opens directly in Excel, Google Sheets and Numbers, and it is the layout QuickBooks Online and Xero accept for manual bank uploads.

Questions and answers

Can I convert the CSV back to QBO later?

Yes. Use the CSV to QBO converter. Note that going through CSV loses the bank's original transaction IDs.

Is my file uploaded?

No. The file is read and converted by this page on your own device. It works with your internet connection switched off.

Is it free?

Yes. Turning a QBO Web Connect file into a spreadsheet is free, with no limit on the number of transactions and no account.