Timestamp for when transaction was entered into the register

I've been using the API and browsing through the transactions table through Power Query, I can see the transactions id, date, amount, etc. I see that the date is the date at which you specified as enter the transaction in the register, but I cannot seem to find the column for the timestamp for when the transaction was actually entered into the register. Or that field is really missing?

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Jorelle Tuvillo there! We do not use timestamps within YNAB, just the transaction date. Transactions are dated, and the Transaction ID is formatted as described in : https://api.youneedabudget.com/v1#/Transactions/createTransaction

     

    Transactions imported through File Based Import or Direct Import (not through the API) are assigned an import_id in the format: 'YNAB:[milliunit_amount]:[iso_date]:[occurrence]'. For example, a transaction dated 2015-12-30 in the amount of -$294.23 USD would have an import_id of 'YNAB:-294230:2015-12-30:1’. If a second transaction on the same account was imported and had the same date and same amount, its import_id would be 'YNAB:-294230:2015-12-30:2’. Using a consistent format will prevent duplicates through Direct Import and File Based Import.
     

    Like
  • That's sad. I really hoped there was a timestamp column for when transactions were actually entered into the system.

    Like
    • Jorelle Tuvillo I can definitely pass that along as a feature request!

      Like
    • Chrissy   Please pass this request along.

      The ability to add a timestamp for each transactions would make things so much easier for those of us who primarily use cash (not out of choice)... I live in a country where only cash is used. My work around for the moment is to assign a number each transaction in the memo column. Then I can sort the rows of my wallet account spreadsheet based on the memo column. This works, but it adds time when entering a new transaction... especially on the mobile app. Another issue with this work around is if I transfer money to other accounts then the number I add in the memos do not match up, which presents more problems. Before I started using this work around there was a ton of red negative numbers in the balance column, which wouldn't happen if there were a way to include a timestamp.

      Like
Like Follow
  • 7 days agoLast active
  • 4Replies
  • 76Views
  • 3 Following