LedgerPortExcel to QBO converter
Turn a spreadsheet of bank transactions into a QBO (Web Connect) file that QuickBooks can import. Drop the Excel file as it is. It is converted in your browser and never uploaded.
Confirming your payment…
Your licence key. Keep it: it unlocks your other computers, and it is printed on your invoice.
Your file is read on this device. It is never uploaded.
| File | Transactions | Status |
|---|
More than one account? Give each its own number, and reuse it every time, so your software files each statement under the right account.
More file details (optional)
These only label the file. The default bank ID 3000 is one QuickBooks recognises; you still choose your real account during import.
Columns (change these if the preview looks wrong)
| Date | Description | Amount |
|---|
Not reading your file correctly? Send us the column names
Your pass has ended. Lifetime keeps you going for good, and the pass you bought is deducted from its price.
Your 10 free documents have been used. Unlock this file, and every file after it:
Pay with CardApple PayGoogle PayLink
14-day refund if it does not work with your file. Secure checkout by Stripe: card, Apple Pay or Google Pay, with an invoice by email. Your file stays open here while you pay.
Buying for a team? Firm plans start at 3 users, at $69 per user a year.
Your licence
- Never uploaded. The file is converted on your device; it works with the internet off.
- See it before you pay. Every transaction is previewed for free.
- 10 documents free. No card, no account, no key.
- 14-day refund if it does not work with your file.
From spreadsheet to QuickBooks in three steps
- Drop the workbook An .xlsx file from your bank, your client, or your own records. Or copy the rows and paste them here.
- Check the preview The date, description and amount columns are found for you. Change a column if the preview looks wrong.
- Import the QBO file In QuickBooks Desktop: File → Utilities → Import → Web Connect Files.
Why not import the spreadsheet directly?
QuickBooks Desktop cannot bring a spreadsheet of bank transactions into its bank feeds. Its Excel import is for lists such as customers and items. A QBO file goes through the Bank Feeds Center instead, where QuickBooks suggests payees and accounts, matches transactions you have already entered, and remembers what it has imported so nothing arrives twice. The guide to getting Excel data into QuickBooks Desktop compares the options.
What is read from the workbook
- Real date cells, whatever date format they are displayed in.
- Number cells, including negative amounts shown in brackets or in red.
- Text cells that hold dates or amounts, such as "03/01/2026" or "$1,234.56".
- Title rows above the table and total rows below it are recognised and left out.
Need another output? The same workbook converts to QFX for Quicken, OFX or QIF: choose the format after dropping the file.
Questions and answers
Do I have to save the workbook as CSV first?
No. Drop the .xlsx file as it is. Dates and amounts are read from the cells themselves, so regional date formats and number formatting in Excel do not get in the way.
Which sheet is used?
The visible sheet with the most rows. If your workbook has several, the page tells you which one it read. To use a different sheet, copy its rows and paste them onto the page.
Does it work with old .xls files?
Not the old binary format. Open the file in Excel, choose Save As, and pick Excel Workbook (.xlsx). Some banks' .xls downloads are really web pages or text files with an .xls name; those are read as they are.
Can I paste from Excel instead?
Yes. Select the rows in Excel, copy them, click on this page and press Ctrl+V (Cmd+V on a Mac).
What should the columns be?
A date, a description and an amount are enough. The amount can be one signed column, or separate columns for money out and money in. Column names do not have to match anything in particular.