Quicken import troubleshooting: fix common CSV issues fast

1) “I exported, but it looks like transactions”

What happened: you exported register transactions (date/payee/category) instead of a Net Worth report.

Fix:

• Export the Net Worth / Net Worth & Balances report.
• Make sure it contains balances by account/debt.

2) “I don’t see an Export to CSV option”

What happened: some report views don’t offer CSV export directly.

Fix:

• Try a different Net Worth report view (not a “net worth over time” chart-only report).
• Export to Excel and then Save As CSV.
• If there’s a Copy to Clipboard option, paste into a spreadsheet and save as CSV.

3) “My balances look off”

What happened: most often it’s an as-of date mismatch or missing accounts.

Fix checklist:

• Confirm the report date (“as of”) is what you intended.
• Confirm hidden accounts aren’t excluded.
• Confirm property values weren’t updated manually (home/cars can introduce noise).

4) “I see duplicates after import”

What happened: accounts got renamed between exports or the labels are slightly different.

Fix:

• Keep account names consistent in Quicken.
• Use the “Review & link accounts” step to avoid creating duplicates.
• If you already created duplicates, rename or merge carefully before your next import.

5) “Some rows show $0 (or weird negatives)”

What happened:

• certain accounts may be $0 at export time
• or an overdraft/credit line shows as negative cash

Fix:

• $0 rows are usually fine—keep them if they’re real accounts.
• Negative “cash” balances are typically overdrafts and should be treated as liabilities. (FinlyLife may already flag this.)

6) “The CSV has commas/quotes and the columns don’t line up”

What happened: CSV formatting and quoting can get messy when names contain commas or special characters.

Fix:

• Open the CSV in Excel/Numbers and re-save as CSV.
• Avoid editing the raw CSV in a text editor unless you’re comfortable with CSV rules.
• If you renamed accounts with commas, consider removing commas from names for cleaner exports.

7) “Encoding or weird characters”

What happened: special characters in account names can export with a different encoding.

Fix:

• Open and re-save the file from a spreadsheet app.
• If needed, simplify account names that contain unusual characters.

8) “My totals differ between Quicken and FinlyLife”

This is usually one of:

• different as-of date
• hidden accounts excluded
• property values included in one but not the other
• liabilities categorized differently (for example negative cash vs a liability)

Fix:

• Confirm the report settings and as-of date.
• Decide whether you want to include property values (home/cars) consistently.
• Re-import after aligning settings.