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.

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

      • Chrissy
      • YNAB Technical Support Manager
      • chrissy_ynab
      • 1 yr ago
      • Reported - view

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

    • 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 1
Like Follow
  • 1 yr agoLast active
  • 4Replies
  • 96Views
  • 3 Following