Original payee name from bank

Is there a way to get the original payee or line in the csv from the bank for a transaction?

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Silver Orca Not currently.  Can you give me an idea of your use case?

    Reply Like
  • I want to import into ledger-cli. With ledger, you can run a `ledger convert` command to import a csv file, and then it will hash that line of the csv into a UUID to make sure you don't import duplicates.

     

    This is straight out of ledger's docs: https://www.ledger-cli.org/3.0/doc/ledger3.html#The-convert-command

    If you have this csv file:

     

    ,date,payee,note,amount,,,code,
    767718,12/13/2011,"Withdrawal","ACE HARDWARE 16335 S HOUGHTON RD",-8.80,,00001640.04,,
    767406,12/13/2011,"Withdrawal","ACE HARDWARE 16335 S HOUGHTON RD",-1.03,,00001648.84,,

     

    And you run this command:

     

    $ ledger convert download.csv --input-date-format "%m/%d/%Y"   --invert --account Assets:MyBank --rich-data   --file sample.dat --now=2012/01/13

     

    You'll get this:

     

    2011/12/13 * Withdrawal  ;ACE HARDWARE 16335 S HOUGHTON RD
        ; CSV: 767718,12/13/2011,"Withdrawal","ACE HARDWARE 16335 S HOUGHTON RD",-8.80,,00001640.04,,
        ; Imported: 2012/01/13
        ; UUID: dfdc3c3d5c54c6967dd39d5b4e4fd1ea76e87233
        Expenses:Unknown                             8.8
        Assets:MyBank
    
    2011/12/13 * Withdrawal  ;ACE HARDWARE 16335 S HOUGHTON RD
        ; CSV: 767406,12/13/2011,"Withdrawal","ACE HARDWARE 16335 S HOUGHTON RD",-1.03,,00001648.84,,
        ; Imported: 2012/01/13
        ; UUID: 63086448b1f29f7fd6efb11ea40660185a213f9d
        Expenses:Unknown                            1.03
        Assets:MyBank
    Reply Like
  • I want to use ynab for budgeting, mobile data entry, and syncing with the bank, and then import from ynab into ledger and just use ledger for expense tracking and reporting (rather than budgeting).

    Reply Like
  • Could you use the payee_name field that is returned with the transaction item?  This would be the originally imported payee name unless payee rename rules (Configured under 'Manage Payees' in YNAB) renamed it.  Also, it appears that ledger-cli allows for a "Transaction Number" field and using the id or import_id provided for transactions through the API might be a good candidate for use here to prevent duplicates.

    Reply Like
  • I need something immutable, so the payee_name won't work. The id or import_id could work, but only if I decide to only import into ledger from ynab and never directly from the bank...

    Reply Like
    • Silver Orca I'll add the request for the originally imported payee name to our list but in the meantime it sounds like you might be able to work around it with id/import_id (maybe; hopefully). 

      Reply Like
Like Follow
  • 1 yr agoLast active
  • 6Replies
  • 267Views
  • 2 Following