Bank and payment app import problems, and how to fix them
Each page below starts from the message or mismatch you see, explains the cause from the software's own help pages, and has the converter set up to build a file that follows those rules. Your file is converted in your browser and never uploaded.
QuickBooks Online and QuickBooks Desktop
- QuickBooks Online says your bank file is too large
- QuickBooks Online will not accept your bank CSV
- QuickBooks Online reads the dates in your CSV wrong
- Your Venmo statement CSV will not import into QuickBooks
- Your Stripe payout does not match your sales
- QuickBooks Online says the file contains invalid transaction amount information
- QuickBooks cannot read your .qbo Web Connect file
- Duplicate transactions after a bank file import
- Your PayPal activity CSV does not import cleanly into QuickBooks
- Your Cash App CSV does not import cleanly into QuickBooks
- Your Etsy deposit does not match your sales
- Your Airbnb payout does not match your reservations
- QuickBooks Online says "The uploaded file is of a different type than these accounts."
- QuickBooks for Mac shows "QuickBooks was not able to complete your request. Please contact your financial institution. (OL-222)"
Xero
- Xero says "The file you uploaded does not contain valid statement data. Please check the file"
- Xero says "There was a problem importing the file"
Quicken, Wave and OFX
- Quicken will not import your bank or payment app CSV
- Wave says "Wave is having difficulty reading the dates of your transactions"
- Wave says "The CSV file must contain an amount, date and description column"
- Wave says "Wave is having difficulty reading the amounts of your transactions"
- Wave says "Wave can't find any transactions in your file"
Questions
- Why will my bank CSV not import into QuickBooks Online?
- QuickBooks Online reads a bank CSV with 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one date format for every row, and plain-number amounts. A manual upload must also be 350 KB or less, with up to 1,000 transactions. Each page above covers one of these errors.
- What is the difference between a QBO file and a CSV for QuickBooks?
- A .qbo file is a Web Connect file, the format banks offer for download, and QuickBooks Online and QuickBooks Desktop both read it. A CSV is a plain table that QuickBooks Online reads only in its 3-column or 4-column layout. The converter can write either from the same export.
- Why do I get duplicate transactions after importing a bank file?
- Intuit says duplicates can appear when an imported file overlaps your bank feed, or when the bank feed updates after a manual upload. Quicken says its CSV import does not check for existing transactions. Exclude the duplicates and import each period once.
- Why does my Stripe, Etsy or Airbnb payout not match the bank deposit?
- A payout is the net of many sales, refunds and fees, so it rarely equals one day of sales or one booking. The converter turns the platform's payout report into one QuickBooks Online journal entry per payout, with the bank line equal to the deposit.
- Does the converter upload my file?
- No. The page reads the file with your browser and converts it there. The privacy page lists the anonymous counts the site keeps.