CSV Export - Apply the details to all fields for split transactions (account, date, payee, etc.)

Options
UrsulaA
UrsulaA Superuser ✭✭✭✭
edited February 22 in Feature Requests

From a post from @dsfreddy

dsfreddy Member ✭✭November 2023 edited November 2023

Have not found an explanation by Simplifi of the purpose of its split functionality. I am not sure a one to one correspondence between the list of transactions in Simplifi (called the register by some?) and what I'd see at my banks website is a fundamental requirement. My request is that split transactions, when exported, inherit traits from their parent record. Here is what these look like now:

account

state

postedOn

payee

usage

category

tags

notes

amount

Credit Card 1

CLEARED

9/28/2023

Our Dentist

SPLIT

$0.00

Health:Dentist-Jack

-152.42

Health:Dentist-Jill

-152.42

Checking 1

CLEARED

7/31/2023

Atm Wthdrwl On 07/31 @ 11:09 Us Debitcard, Pos, Withdrawal, Processed

SPLIT

$0.00

Cash & ATM:ATM-Jack

-60

Cash & ATM:ATM-Jill

-140

These child records should inherit account, state ("status" in transaction detail), postedOn ("date"), and payee from their parent record. It makes no sense to create a CSV file without that information. Displaying these child records in the transaction list is another matter. Not sure I care either way about that.

I would like to see this idea implemented without separating split transactions into individual/separate transactions.

Request is for child split records to inherit details from parent transaction records: account, state ("status" in transaction detail), postedOn ("date"), and payee

Original post below.

[edited title]

Simplifi User Since Nov 2023

Minter 2014-2023

Questionable Excel before 2014 to present

21 votes

Active · Last Updated

Comments

  • dsfreddy
    dsfreddy Member ✭✭✭
    Options

    Seconded!

  • bobodc1
    bobodc1 Member
    edited February 25
    Options

    Currently when you generate a CSV export, Split Transactions create a "non-contiguous" set of data. For example, the current method looks like this:

    While it's helpful to see Splits, I'm more interested in seeing the details of the split transaction. It would be great if either the CSV export could be updated or users could be given an option to generate an export which shows the details of split transactions only such that the other details (e.g. account, state, postedon, payee, etc.) are present.

    While the reporting in Simplifi is pretty good, there are several custom (read spreadsheet) reports I maintain to manage my finances. The current method of CSV export which does not give all details of split transactions forces me to manually tweak the transactions to fill the missing details. While this isn't a huge deal right now with only about 2 months of data, this will become a problem as I use Simplifi more and more.

    [Merged Post]

  • DavidB
    DavidB Member ✭✭✭
    Options

    Could not agree more. I was very surprised to see how this comes through in the CSV file.

  • UrsulaA
    UrsulaA Superuser ✭✭✭✭
    edited February 25
    Options

    This feature request is the same as the one I posted a few days ago. Please vote for it below.

    Hopefully the moderators will merge this request with mine. The more votes, the more likely the request will be considered.

    [Merged Post]

    Simplifi User Since Nov 2023

    Minter 2014-2023

    Questionable Excel before 2014 to present

  • DavidB
    DavidB Member ✭✭✭
    Options

    thirded!

  • bobodc1
    bobodc1 Member
    Options

    @UrsulaA thanks, I appreciate you flagging. Looks like they've merged now. Hope they are able to fix this soon.

  • Silverthorne
    Options

    The failure to include transaction details on split transactions is a major flaw for anyone who wants to use Simplifi data in external spreadsheets. The original poster, dsfreddy, requested to include "status", postedOn, and payee on each row for split transactions in the csv export. I would add the request to include the parent's "Description" in the export for each row for split transactions.

  • quick username
    quick username Member ✭✭
    edited May 24
    Options

    Fourth'd; but seeing how this only has 12 votes and other ideas with 30+ votes are being ignored (like hiding net worth)… I've already lost hope in this cause we're fighting for.

    With products like Mint that just, vanish, the basis for wanting a functional Excel budget is highlighted, and likely behind this groups desire to have fully functioning data exports.

  • quick username
    quick username Member ✭✭
    edited May 25
    Options

    This is how I am using Excel Power Query to back-fill the missing data in split transactions; by "filling down" the data from the next non-blank cell above the blank data cells in the splits.

    This is clunky to type up, and clunky to implement, but - where there is a will, there is a way. Hopefully simplify will obsolete the need for this workaround sooner than later and give the people what they need! And are paying for?

    =============================

    To fill in what simplifi thinks should be left blank… you can put Excel power queries to use. I'm not sure if home versions of Excel include power queries, if not, I'm sure macros can be used to do the same thing. Background: I have one table that gets updated with the simplifi CSV, and then a 2nd table that used power query to "process" the "raw csv" to do various data manipulations. Now, adding missing data is another one of the list of manipulations.

    Here's the incomplete CSV format simplifi format of split transactions. Unfortunately, some fields are totally blank and some are null (ie. ""). I learned "fill down" only works on "null" so we have to convert blanks to null, then use fill down to copy original data into the empty split transactions fields.


    Original → ,"Cap1 Card","CLEARED","2/10/2024","Wal-mart","","SPLIT","","gifts, cold meds","$0.00","","","","","",""
    Split 1 → ,,,,,,"HEALTHCARE:Health","",,"-28.56",,,,,,
    Split 2 → ,,,,,,"OTHER:Gifts","",,"-28.00",,,,,,

    This means we have to do two things. 1. Since not all fields are null (ie. ""), we much make the blank fields null.

    In power query, highlight the columns you want to back fill (for me: account, payee, state, postedOn) then do: right click on a highlighted column / replace values / look for (leave blank) / replace with: "null" (without quotes).

    The "blank to null" conversion step above is required for the next step (fill down) to work.

    Highlight the same columns you want to fill in missing data / right click one of them / click fill / click down.

  • PMc
    PMc Member
    Options

    In CSV downloaded transactions, the line items for the split transactions do not show the account name. There is a "master" line item with $0 that includes the account name, followed by line items for each split that do not include the account name. This prevents me from running account reports using the CSV, because the line items for split amounts are not associated with an account.

    Screenshot attached. —Thanks!