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
Quicken and OFX
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.