Importing credit-card statements, done right.

Step-by-step workflows for QuickBooks, Xero, and Excel — plus answers to the sign-convention questions that confuse almost everyone the first time.

• QuickBooks

  How to import a credit-card statement into QuickBooks

  Step-by-step: download your PDF statement, convert it to QBO format, and import it into QuickBooks Online or Desktop — including the sign convention gotcha most people hit.

• Xero

  How to import a credit-card statement into Xero

  How to bring a PDF credit-card statement into Xero using its bank-statement CSV import — date formats, sign conventions, and how to map the columns correctly.

• QuickBooks

  Why are credit-card payments negative in my QuickBooks export?

  If your exported file shows purchases as negatives and payments as positives, that's not a bug — it's the accounting sign convention. Here's what it means and why it actually makes sense.

• General

  How to convert a PDF bank statement to Excel

  The complete guide to turning a PDF credit-card or bank statement into a usable spreadsheet — manual options, free converters, and what to watch out for with scanned or image-based PDFs.

• Payment platforms

  How to import a PayPal, Venmo, or Cash App statement into QuickBooks or Xero

  PayPal, Venmo, and Cash App only export the last 90 days as CSV — everything older comes as PDF. This guide covers the full workflow: PDF in, accounting-ready file out, imported into QuickBooks Online or Xero with the correct sign convention for fees, transfers, and refunds.

• Quicken

  Quicken import: QIF vs QFX vs Web Connect — which one should I use?

  Quicken accepts three flavors of import file — QIF, QFX (Web Connect), and Direct Connect. QFX is the modern default and what most banks provide. This guide explains the differences, which format your Quicken version supports, and how to import each from a converted PDF statement.

• Freelancer

  Tracking PayPal, Venmo, and Cash App income for taxes (1099-K workflow)

  If you're a freelancer paid through PayPal, Venmo, or Cash App, the IRS 1099-K threshold changes have made statement reconciliation critical. This guide walks through the tax-time workflow: pull statements, categorize business vs. personal, cross-check against 1099-K, and file Schedule C.

• General

  How to convert a bank (checking) statement to Excel or QuickBooks

  The end-to-end workflow for PDF bank statements: extract deposits and withdrawals with correct signs, reconcile against the ending balance, and export to Excel, QuickBooks (.qbo), Quicken (.qif), or Xero. Works for personal and business checking.

• Freelancer

  Tracking business credit-card expenses for taxes (a freelancer's workflow)

  A practical workflow for self-employed people: pull a year of credit-card statements out of online banking, get them into Excel, categorize for Schedule C, and have everything ready for tax filing — in an evening instead of a weekend.