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; } } }

Support importing split transactions via CSV

cobra1316

The import transactions via CSV functionality is very useful, but needs to add support for split transactions.

In my use case, I am downloading transactions from my Bank, but I receive a single monthly payment that needs to be split out amongst multiple categories that change frequently month-to-month. As a result, the existing memorization functionality doesn't work and I resort to manually entering the data which I receive via a separate monthly statement which has all of the detail.

It would greatly improve the experience if I could use the monthly statement to generate the split transactions directly in Quicken which could then be merged with the single transaction I get from my bank.

There are 3rd party tools that can help with this, but rely on the older QIF format which comes with its own host of issues.

Please consider this idea!

Find more posts tagged with

Windows

File Import

Reviewed

split transactions

Status: Reviewed

Comments

Chris_QPW

Is the payment actually split out in the CSV file from the Bank?

If so, what it the format? Given the ridge formatting that they are using for the CSV import I would think that if they support splits at all they would do it in one format and the CSV will have to conform.

On the other hand, if your payment is just one line in the Bank statement then support for that would be that you pre-enter a split transaction manually or with a reminder and Quicken should match it when downloading the payment in CSV format.

cobra1316

Hey @Chris_QPW, thanks for the comment.

The structure is as follows:

Monthly Payment: Investment Company —> Bank —> Quicken download

Split Detail: Investment Company —> Me transforming data —> CSV/Excel —> QIF —> Quicken

Present solution is using ImportQIF (*hat tip to you*) and importing the splits to Quicken before accepting the downloaded transaction from the Bank.

It would be alot easier if I could just create the CSV in the needed format and import directly to Quicken.

With the advancement in AI/LLM tools, generating & converting to a given CSV format is trivially easy.

Hope that helps.

Thanks!

Chris_QPW

Given that there hasn't been really any format established, then I think they should support the format that they export in CSV files from reports.

cobra1316

I'm flexible on the specific format so would leave it up to Quicken's engineers to adopt something reasonable and robust.

Jim_Harman

It would be nice to be able to import transactions with splits, but note that there have been multiple complaints about the export format for split transactions;. People would like to see the common information (Date, Account, Payee) repeated on each line because that makes it easier to import into a database. So if that format ever changes, we would not want that to break the split import.

See for example this Idea post (Scroll up if necessary)

https://community.quicken.com/discussion/comment/20530657#Comment_20530657