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?

3replies 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.

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

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

Like Follow
  • 9 days agoLast active
  • 3Replies
  • 52Views
  • 2 Following