Pending transactions should account for non-working days

  • 1
  • Idea
  • Updated 2 years ago
  • Not Planned
When I schedule transactions, I would like them to be treated like my bank treats payments, i.e. if it is a weekend/bank holiday, then the debit is delayed to the next working day.    This will stop me having to delete transactions during reconciliation when I realize they have automatically posted too early in the month, re-entering them manually / via bank transaction import later in the month.
Photo of Jon Morgan

Jon Morgan

  • 64 Posts
  • 26 Reply Likes
  • frustrated

Posted 3 years ago

  • 1
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1651 Posts
  • 216 Reply Likes
Hi Jon,

Thanks for the suggestion! I can see how that would be helpful. I've added this to our features tracker for future consideration.

For now, you can try what I do. If I make a transaction over the weekend, I'll schedule it on the web to post on the following Monday or Tuesday, so that my Goodbudget Account and real checking account continue to match.

Hope this helps!
Photo of Jon Morgan

Jon Morgan

  • 64 Posts
  • 26 Reply Likes
Thanks Karisa. You make a good point - it's almost the same scenario over the weekend except that you know at the time you post it that it won't post until the next working day so can manually account for it.

The scenario I had in mind above was specifically for those ongoing scheduled items (such as a monthly account transfer) which you set up once, but will fall on different working days each month.  For example, if I set up a standing order to move money on the 18th of each month, it would have been fine in May, but will be on the weekend in June and so won't happen until 20th.

The impact of doing what you've suggested btw is that the envelope isn't debited until after the weekend so if you're trying to keep an eye on what you've got left to spend over the weekend it becomes trickier (you have to dig into each envelope and look at the individual balances including pending) - but I think you've captured that as a suggestion under this post: https://getsatisfaction.com/goodbudget/topics/can_account_balances_reflect_pending_recurring_expense...
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1651 Posts
  • 216 Reply Likes
Hi Jon, 

I see! Thanks for clarifying and adding extra details. I've updated this request in our tracker. 

In reference to the other article, it sounds like you'd like even those long-time recurring transactions to reduce the balance of your Envelope. Is that right? So that you don't have do some digging to figure out what your Envelope balance will be when the transaction posts. 

Thanks!
Photo of Jon Morgan

Jon Morgan

  • 64 Posts
  • 26 Reply Likes
Yes, it would be great to reduce the envelope but not reduce the account until the scheduled working day.  So in the scenario above, on Day 1 of the month the envelope would be reduced by the scheduled value, on the 18th the transaction might move from scheduled to actual in the envelope but that the transaction would be pending in the account until the 20th June when it would become an actual in the account.
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1651 Posts
  • 216 Reply Likes
Hi Jon, 

My notes have been updated. Thanks, again!
Photo of Jon Morgan

Jon Morgan

  • 64 Posts
  • 26 Reply Likes
Awesome! Thanks for responding so actively Karisa. Really loving GoodBudget :)
Photo of Alan Switzer

Alan Switzer

  • 82 Posts
  • 54 Reply Likes
Automated scheduling tied to weekends and holidays could be tricky to implement. GB is used by people outside of the US, and of course, the holidays are different. To complicated it even further, some states or provinces within countries have their own holidays which may different from what the rest of the country does. GB would have to have a complete, constantly-updated list of various holidays by jurisdiction. Not an easy task.
Photo of Jon Morgan

Jon Morgan

  • 64 Posts
  • 26 Reply Likes
Having just updated my scheduled transactions - I do wonder if this is something still relatively easy to implement...  Yes there would be an overhead involved in maintaining the list of dates, but you'd do that maybe once every year/few years and potentially could utilise a web-service to populate this automatically anyway (a quick google showed me https://holidayapi.com/ exists for this purpose) or you could outsource the effort to maintain the list manually. You'd also only need to do it for the countries/states of people who are already using GB - something I'm sure could be pulled from the database. It would be a relatively easy win for people in the majority countries, then the less common countries/states can be added over time. If a person joins in a new location, worst case scenario would be that the behaviour defaults back to the current situation (i.e. not taking bank hols into account) until such time as that area could be added to the database.
Photo of Karisa Russell

Karisa Russell, Official Rep

  • 1651 Posts
  • 216 Reply Likes
Hi Jon, 

Thanks for the input! I'm no developer, so I can't say how easy or difficult this would be to implement. 

As of now, we don't have plans to work on this, but your request is still on our board so we don't forget it. Of course, I will keep you posted if and when our plans change to include this. 

Until then, you can keep an eye on our Roadmap to see what we are up to.

Thanks Jon!