Support importing split transactions via CSV

cobra1316
cobra1316 Quicken Windows Subscription Member ✭✭
edited January 20 in Manage Accounts and Transactions

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!

Tagged:
2
Up
2 votes

Reviewed · Last Updated

Comments

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    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.

    Signature:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/

  • cobra1316
    cobra1316 Quicken Windows Subscription Member ✭✭

    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
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    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.

    Signature:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/

  • cobra1316
    cobra1316 Quicken Windows Subscription Member ✭✭

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

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited January 20

    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
    QWin Premier subscription

Categories