It would be really very useful if you could transfer money directly to the bills pot in a joint account directly from your personal account. At the moment I have to make two hops, which also messes up the spending summary on the personal account. Any chance of that happening?
While your profile ālinksā Personal Accounts and Joint Accounts (and any pots under either) for display purposes in the app, they are still separate accounts and so two hops may be unavoidable. The same goes for Summary - it currently shows a Summary per account.
Itās a nice idea though - and maybe a Summary re-work could handle such a feature.
Well, even my Halifax account allows me to do this. So I am sure that Monzo can find a way, given that one of their core goals is to provide much a better UI than traditional banks.
Simply put, I donāt want to see the money in my balance at all. It may seem a bit OTT but Iām a strong believer in āout of sight, out of mind.ā
Anyway, I figured it out. I literally just had to plonk a + time 2 hrs formula on the end of the last working day of the month formula in C1. The trigger should now fire off at 2am on the last working day of the month, taking into account the bank holidays for 2019. Using that as the IFTTT trigger, I shouldnāt have to mess with it again except to add next yearās bank holidays.
1 Like
Loving bills potās, already tested & used successfully.
This will defintely make things easier for me personally 
1 Like
Mine didnāt seem to work this morning, still was paid from my balance and had to withdraw the amount from the pot. Thought Iād set it up to come straight from the pot though, any ideas?
Thatās how it works. All interactions with accounts outside Monzo happen via the main balance.
1 Like
But surely I would have no need to withdraw Ā£5 from the pot if itās being paid directly from the pot?
It automatically withdraws the amount from the pot and the bill is paid from your main account.
The pot itself his just a holding ground for the money that you have put away to cover the direct debits assigned to that pot.
1 Like
Ah I see so it would look identical to a scheduled withdrawal on my transaction feed.
Pretty much. Hopefully in the future the pot withdrawal and the direct bebit will occupy the same line on your feed, kind of like the round up transactions, only instead of money being added to a pot after a transaction its for money being taken from the pot before the transaction.
3 Likes
Ahh my summary hasnāt worked, so my Sky bill is due to come out of a pot tomorrow, but my left to spend has dropped by the amount on the sky bill, not sure if anyone has seen this as well?
At the risk of derailing this thread. I just wanted to make sure youāve accounted for bank holidays 
I have a similar spreadsheet (though probably for a different financial task). I use the following formula to count how many days its been since my last pay day (which is last working day of the month, or previous working day if it falls on a bank holiday).
=if(workday(WORKDAY(EOMONTH(A1,0),+1,āUK Bank Holidays sheetā!A:A),-1,āUK Bank Holidays sheetā!A:A)=A1,0,B1+1)
Column A is dates, this formula is column B. List of UK bank holidays on a separate sheet
This formula is for google sheets, but I think a similar formula exists for excel. Using this figure I can compare balances across different pay cycle to see whether Iām above or below previous months on any given day.
Tiny preview, green is current cycle;
1 Like
I donāt think Summary is ātalkingā to the Bills Pots right now but then I guess thatās the joys of testing in labs. I hope this is taken into account soon though and definitely before it comes out of labs.
2 Likes
Mines doing that with my EE debit which is due tomorrow 
1 Like
It would be amazing if rather than appearing as 2 transactions the feed could appear like round ups do - I.e. the bill payment with an indicator that it came out of your bills pot 
7 Likes
It does indeed take bank holidays into account! The formula =WORKDAY(EOMONTH(B1,0)+1,-1,D:D)+TIME(2,0,0) is using the dates in the D column as holiday references so I just need to add them each year now
1 Like
Will it trigger a second time when itās no longer the last working day?
It should look like this, but instead of a small image in the corner for the category, it should be a small image (perhaps in another corner) to show the pot it came from.
1 Like
+1 for roundup style feed for this
4 Likes