Write to scheduled transactions?

I have debt payment snowball spreadsheet in a Google Docs sheet that I am attempting to integrate with YNAB through the API and Google Apps script.

For each debt payment in YNAB I have a scheduled monthly transaction.

My goal is to have the scheduled transaction amounts updated automatically from the snowball spreadsheet when the spreadsheet is updated. Essentially adding a snowball debt payment tool to YNAB.

The roadblock I'm facing is the lack of a writeable API for scheduled transactions. Are there plans to allow this at some point?

16replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • FiftyAndBroke , the API doesn't currently support writing scheduled transactions, but it's on the list!

    Like
      • Brian Lehman
      • Lover of order, hater of Chaos
      • seldumonde
      • 3 yrs ago
      • 2
      • Reported - view

      George Just wanted to add my vote to get adding scheduled transactions on the API. It is the final piece that I need to complete the way I want to use YNAB.

      Like 2
    • George Any progress on this?  

      Like
      • George
      • Developer
      • george_ynab
      • 3 yrs ago
      • Reported - view

      FiftyAndBroke Sorry, no news on adding support for scheduled transactions. I'll be sure to post if/when it is scheduled.

      Like
  • I would like to vote for this as well.  I have an app that I'm working on and when I pay bills for a given month, it's often a day or so before the next month...while I can update the category amount for the upcoming month, I can't put the transactions into the next month to match the categories. 

    Like 1
      • George
      • Developer
      • george_ynab
      • 3 yrs ago
      • Reported - view

      Jaron Lofquist Noted!

      Like
  • Plus one from mee too. Have successfully connected YNAB with my bank accounts and set up a Raspberry Pi to do the syncing twice every day. 

    Missing the possibility to automatically import future payments from my bank into YNAB. Would be even easier to manage my budget then.

    Like
      • Chrissy
      • YNAB Technical Support Manager
      • chrissy_ynab
      • 2 yrs ago
      • Reported - view

      Sten Thanks so much! I added your voice to this request! 

      Like
  • Another year has passed. Any updates on my top wish to have the option of importing Scheduled Transactions via https://api.youneedabudget.com/v1#/Scheduled_Transactions?
    The lack of this feature is honestly the single most annoying thing about my self-written ynab-syncing-with-my-bank-account application now - and has been for more than a year!

    Like 1
  • Plus one on this feature. I'm writting an application for credit cards future transactions and it's a bummer that posting future transactions in the API doens't work ):

    Like
  • +1 to this. Managing scheduled transactions in the api would be fantastic. 

    Like
  • I agree, adding scheduled transactions on the API or Zapier would be awesome. George

    Like
  • Got a response from YNAB at Twitter:

    Hey again! Thanks for asking! You're right - as of now, we still do not support creating scheduled transactions through the API. It's on our feature request list, but we don't have an ETA on this at this point.

    Apparently this is not a feature we'll be getting anytime soon ):

    Like
  • Dear YNAB Devs - please let us do cool stuff to realise our developer dreams?

    I have a cool idea for an integration where Hazel on Mac detects a particular bill from a particular business and extracts the due date and amount, files the PDF in DEVONthink and then queries the YNAB API for a matching scheduled transaction for that Payee, then updates the scheduled transaction with the new due date and amount. Unfortunately, the YNAB API doesn't allow updating of scheduled transactions.

    Now that I express these thoughts, I am thinking that I could just abandon/delete scheduled transactions for these types of bills, as they no longer serve a purpose, I have better information in the bill, I will just use that to directly create a new transaction on that date in the future. Unfortunately, when I try to create a future-dated transaction via /budgets/{budget_id}/transactions, the API responds with:

    {"error":{"id":"400","name":"bad_request","detail":"date must not be in the future or over 5 years ago"}}

    Given the above, in order to perform an update, I am left with waiting until the due date arrives and then making the API call. If I have exact information about a future transaction, why can't I update the budget when that information comes to hand?

    If I work within the constraints of the API, when the bill arrives I could query scheduled transactions using the API, find the transaction by filtering the JSON response, display a comparison of the due date and amount on the bill vs the YNAB scheduled transaction, then load the YNAB UI website to that budget/account to allow for the user (i.e. me) to update the scheduled transaction. That is a real -1 for automation, a step backwards. Let us do cool stuff with automation!

    Like
    • Cyan Cleric As you said, scheduled/future-dated transactions currently aren't supported by the API, but I can see how that would handy. To get your thoughts into the hands of our product team, can you submit a Feature Request?

      Like
      • Cyan Cleric
      • Software Engineer
      • Cyan_Cleric
      • 8 days ago
      • Reported - view

      Marisa done, thankyou.

      Like
Like9 Follow
  • 9 Likes
  • 8 days agoLast active
  • 16Replies
  • 1158Views
  • 12 Following