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.
- 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.