Itâs not a huge issue, but when you go to the Scheduled tab, select a direct debit and click Set payment from pot, this is what you see if you donât have any regular pots.
Iâm currently trying to automate my Bills Pot deposit so it goes out on my payday. My idea is, since I get paid on the last working day of the month, I can use a formula on a spreadsheet to work out this date and, on payday, it will trigger a counter to change, which I can then use the âIf cell updatedâ trigger to set a pot payment.
The only issue I have with the formula is that I canât figure out how to make it go at a certain time in the day (2:00am). The IFTTT will trigger at midnight, but my BACS usually doesnât go in until between 01:00 and 02:00.
If you get paid via BACS, why not create a scheduled payment on the 31st - to transfer an amount from your main account to your bills pot, covering the next monthâs worth of scheduled D/Dâs - and then always choose to get paid early?
This means youâll collect the incoming BACS payment at 4pm (or later) on the 30th and the scheduled payment on the 31st will happen after 2:30(ish)am. No need for external sheets or IFTTT triggers.
EDIT: Given that months are not always 31 days, it would be safer to make the recurring transfer to the bills pot on the 1st and just have your salary paid in as normal. Unless you fancy getting it earlier and choose to get paid early in-app
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.
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?
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.
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.
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.
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
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