nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Transaction report with complete data for each line?

Money2021

Greetings. I was wondering if there is any way to download transactions to analyze in Excel so that transactions with multiple categories are not missing the date, payee, etc. All I can seem to find so far are transaction logs that I would have to manually fill in this information if I wanted to do any sorting and creating my own reports. This would take way too much time. Thanks!!

Find more posts tagged with

Accepted answers

Jim_Harman

The issue here I think is that when there are split transactions and you export to Excel, the transaction details are only on the first line. See this Idea post for workarounds and to vote for improvements in this area.
https://community.quicken.com/discussion/7868904/export-all-transaction-to-excel-split-categories-are-formatted-incorrectly

All comments

Sherlock

I don't understand how a transaction can be missing a date, but it's fairly simple to locate missing fields within Quicken. If you're specifically looking to export Downloaded fields to Excel, that isn't supported. I suggest you vote for: Include Downloaded Payee in report/export

Jim_Harman

Sherlock

Jim_Harman said:

The issue here I think is that when there are split transactions and you export to Excel, the transaction details are only on the first line. See this Idea post for workarounds and to vote for improvements in this area.
https://community.quicken.com/discussion/7868904/export-all-transaction-to-excel-split-categories-are-formatted-incorrectly

If the split transactions don't contain entries with duplicate categories, sorting the report by Category may suffice.

Jim_Harman

Thanks @Sherlock, I think sorting by Category was the approach described in the first link in the Idea post, which is now lost.

Money2021

Thanks Jim. So this is something that others have mentioned and Quicken may or may not provide this kind of download. Oh well. I think it would be nice, but I can live without it I guess. Thanks!!