Ive been using the coplenty yearly 2.0 spreadsheet for about 3 months and getting serious about tracking my spending. I never thought I would be able to save $1000, but now i have $3000 in my savings account and it keeps growing every week. It has been so rewarding to take control over my finances and feel powerful about my money. Thank you, Ella for your down to earth and encouraging videos. You truly opened up a whole new world for me and i am so so grateful 💕
OMG thankyou for explaining the -500 for capturing savings you bring back in to spend. Ive been doing a weird double handling of capturing transfers back from savings as income and it messes with so many things!!! The negative seems so obvious now, even though its a negative, its actually a + to your balance 😂 Appreciate your no fuss explanations!
How do you record transfers from friends/family to reimburse for a payment you made. Or like a medicare refund? Also with a negative to that same expense type?
Can I just say - this has always been something i dreaded doing - facing my bills etc as I always thought "i always have extra anyway" --- i just started doing the spread sheet tonight, and man, what an eyeopener. I've been following you an instagram for a while. I've finally plucked up the courage to start. What an eye opener. It's scary but also quite refreshing in terms of mindset change! Please do more of this, beause clearly it's making a huge difference!!! (especially for us millenials).
Just downloaded a coplenty budget spreadsheet and setting it all up now along with you in this video!!! Thank you so much for your content. Loving it ✨
Love your vids! Can you please share how you structure your bank accounts and what money goes where? Do you have different banks etc. & if you have any tips for people who struggle with spending and feel like they need to save every dollar.
This video is great! And the spreadsheet really helps I bought 2 already that are broken so I can never track the entire year and end up going back to my pen and paper. Thanks
Hey Ella! Using the coplenty yearly 2.0 for the first time and wondering if you have any advice for how to add savings you already have into the spreadsheet so that it can show it accumulating and not starting from zero? Thank you, love the vids 🥰
I just purchased the spreadsheet as I'm 27 and my partner and I have just moved back into my parents because I can't save to save my life (no pun intended) and I am so excited to get this and properly understand how to budget and save!! Thank you so much for this video, have been looking for something like this foreverrrrr
How did you set up the savings/debt tracker tab? Like to show the money you already had in your bank account? I feel like that's where I messed up with mine. My 'left to spend' is in the negatives because some of my transactions for big purchases were using money I already had in savings(ie. from before I started tracking on the spreadsheet) so it looks like I'm in the negative but I'm really not. I have lots of 'buckets' in my Up bank account, some for set goals(such as an emergency fund, house fund which I did add under Savings) and others are more short term or used as sinking funds(ie. I have a Beauty account that I transfer XX amount to each paycheck). Just wasn't sure how to have that represented in the spreadsheet. I think I'm just going to have to start again from scratch with a new spreadsheet :') Edit: I also use the round-up feature in Up, which further complicates things 🤣
Can I ask how you use this spreadsheet with multiple bank accounts? For example if you have a business bank account and a personal bank account how do you differentiate on here?
I keep my business accounts seperate! for personal use, we only have 3 accounts: bills, savings and just general spending so it's easy to track on the spreadsheet e.g. if I put $200 towards electricity, i'll transfer to bills acct. If I put $500 in savings, I transfer into savings and whatever is left is in our spending account. Hope that makes sense!
love iit! When you paid money into your bills account, you overrode the actual tab - won't that skew the transactions tab? Just trying to figure out the best way for me to set these systems up half way through using this spreadsheet 😂
I have just started using Coplently Yearly 2.0 and liking it so far. Can I ask how do you record a transaction made on a credit card? ie. do you record it as 20 coffee (category) or 20 NAB Credit card (category) so you know how much to pay towards credit card. Thanks
Hi! I just do $20 coffee because I pay it off in full every month ☺️ the money may stay in my account until it's due but it's technically not my money, if that makes sense? Just helps me keep track that way and not spend more $$ than we have x
Hi Ella! Thank you for the video. I always have a question and it would be great if you can share your thoughts. So we use credit cards for 90% of our expenses (except for items we have to use chequeing account like mortgage). And we pay them off. But does that mean we pay off the expenses of the previous month? Like I would budget September but then then September paycheque is to pay off credit cards which I used for August expenses? I hope that makes sense. Other wise, we would technically need a month ahead expense? Thank you!
Hi! we just track and budget for whatever month we're in because even though we've put it on a CC we still owe it, regardless of when it's due. Hope that makes sense!
@@smileycitrus Hi Ella - I have the same question as above and still a bit confused! We have a CC for the points aswell, but I'm getting so confused on how to track it. So for example in September the bill for the previous period (22 July - 22 August) is due on September 5th. Do I put that payment (paying in full) in my September expenses, or do I just track the 22 July - 22 August purchases within the July and August period and dont worry about when its paid? Even though we need to make sure we have the money there on September 5th for the payment? So effectively just tracking the transactions on the CC in the month which they occur and dont worry about putting the payment in the spreadsheet as an expense. Hopefully that makes sense! :)
@@Samantha_Nol Hi! because we pay it off in full every month I disregard when the credit card payment actually comes out ☺️ we just track what we've spent in the month we're in and pay it off when it's due. We've been deducting our spending from the spreadsheet as the month goes so money is just sitting in our account ready to go!
Hi!! Love watching your videos! I just started my channel a couple of months ago and your videos have given me so much inspiration. Do you do anything special to retain the quality of your screen recording when you post? Mine always get just slightly grainy
We have started using this at the start if August this year. How do you imput your 'left to spend' in Jan 2025? Like, it is not zero as December just happened but there doesnt seem to be a logical place to put your 'starting' funds if that makes sense.
Hi Ella! I'm also having the same problem. I started using this sheet in June and my left to spend is completely out of whack because in June we had a high spend month and spent more than our income but it didn't make sense to put the amount we already had in our spending account because it wasn't actually income from that month.
It depends on the month! but overall yes because I have more time to make content and say yes to more opportunities ☺️ I've tried to keep my spending the same as when I worked a 9-5
i have a question on your spreadsheet (i use the same) I'd love to know, how do you fix up your numbers each month? for some reason my numbers are not exact in my spreadsheet when it comes to the totals. I think it gets messy bc my husband and i share bank accounts and if he runs out of money he will just take from our savings so it gets confusing when i'm trying to add up the transactions ie. I'll transfer $1000 into savings He transfers $50 $250 $37 into his account then spends it on groceries, fuel etc. So I get so frustrated on how to fix up the numbers. Any tips on how to simplify the mess? I've thought of giving him more $ ofcourse (giving as in i transfer it to him) however i find if he sees more $ in the account he'll just spend more. help!
![[LIVE] : ONE ลุมพินี 89 | คู่เอก "ยอดไอคิว vs คิริลล์"](http://i.ytimg.com/vi/Z3vYkHJ_5Ig/mqdefault.jpg)
Ive been using the coplenty yearly 2.0 spreadsheet for about 3 months and getting serious about tracking my spending. I never thought I would be able to save $1000, but now i have $3000 in my savings account and it keeps growing every week. It has been so rewarding to take control over my finances and feel powerful about my money. Thank you, Ella for your down to earth and encouraging videos. You truly opened up a whole new world for me and i am so so grateful 💕
oh my goodness, you should be so proud 🥹💕 thank you so much for sharing lovely!
Good for you ! I didn’t find real budgeting till I was in my 50s ! Awesome you are set up for life ! Glenda
@@smileycitrus do I need to purchase the spreadsheet every year?
OMG, I have waited for this video for so so sooooo long, love to see a women talking about finances♥♥♥
ahh thank you for your patience!! hope you enjoyed 🤍
Love opening youtube and seeing a new vid, always brightens my day 😊
aw hope you enjoy 🥰
I would love to see a video of how you manage your business accounts x
OMG thankyou for explaining the -500 for capturing savings you bring back in to spend. Ive been doing a weird double handling of capturing transfers back from savings as income and it messes with so many things!!!
The negative seems so obvious now, even though its a negative, its actually a + to your balance 😂
Appreciate your no fuss explanations!
How do you record transfers from friends/family to reimburse for a payment you made.
Or like a medicare refund?
Also with a negative to that same expense type?
you're so welcome!! honestly had no idea until recently either and now it seems so obvious 😂
I usually go back and adjust the transaction so it's just what i've paid, if that makes sense?
Can I just say - this has always been something i dreaded doing - facing my bills etc as I always thought "i always have extra anyway" --- i just started doing the spread sheet tonight, and man, what an eyeopener. I've been following you an instagram for a while. I've finally plucked up the courage to start. What an eye opener. It's scary but also quite refreshing in terms of mindset change! Please do more of this, beause clearly it's making a huge difference!!! (especially for us millenials).
Just downloaded a coplenty budget spreadsheet and setting it all up now along with you in this video!!! Thank you so much for your content. Loving it ✨
you're so welcome!! hope you love it 💕
Immediately purchased the spreadsheet from their US Etsy shop. Thanks so much for the discount, guidance & encouragement!
I hope you enjoy using it 🥰
you have seriously changed my life, thank you!!!
omg you're so welcome!! 🥹
Love your vids! Can you please share how you structure your bank accounts and what money goes where? Do you have different banks etc. & if you have any tips for people who struggle with spending and feel like they need to save every dollar.
This video is great! And the spreadsheet really helps I bought 2 already that are broken so I can never track the entire year and end up going back to my pen and paper.
Thanks
Hey Ella! Using the coplenty yearly 2.0 for the first time and wondering if you have any advice for how to add savings you already have into the spreadsheet so that it can show it accumulating and not starting from zero? Thank you, love the vids 🥰
Hi! I just add it as misc income to begin with so that it balances 🥰
just obsessed with your videos!! 🤍
thank you so much!! 🥹💕
I just purchased the spreadsheet as I'm 27 and my partner and I have just moved back into my parents because I can't save to save my life (no pun intended) and I am so excited to get this and properly understand how to budget and save!! Thank you so much for this video, have been looking for something like this foreverrrrr
best of luck ❤️
The yearly 2.0 spreadsheet has changed the game for me.
How did you set up the savings/debt tracker tab? Like to show the money you already had in your bank account?
I feel like that's where I messed up with mine. My 'left to spend' is in the negatives because some of my transactions for big purchases were using money I already had in savings(ie. from before I started tracking on the spreadsheet) so it looks like I'm in the negative but I'm really not.
I have lots of 'buckets' in my Up bank account, some for set goals(such as an emergency fund, house fund which I did add under Savings) and others are more short term or used as sinking funds(ie. I have a Beauty account that I transfer XX amount to each paycheck). Just wasn't sure how to have that represented in the spreadsheet. I think I'm just going to have to start again from scratch with a new spreadsheet :')
Edit: I also use the round-up feature in Up, which further complicates things 🤣
Good morning from Hawaii good tip on saving money on this video
When you’re tracking your bills, when the actual bill comes out of bank account, do you track it in your expenses?
no! I just track when I put the money into my bills account ☺️
Have you made a video about how much you spent on your wedding and how much in each area!?
yes I have!!
Can I ask how you use this spreadsheet with multiple bank accounts? For example if you have a business bank account and a personal bank account how do you differentiate on here?
I keep my business accounts seperate! for personal use, we only have 3 accounts: bills, savings and just general spending so it's easy to track on the spreadsheet e.g. if I put $200 towards electricity, i'll transfer to bills acct. If I put $500 in savings, I transfer into savings and whatever is left is in our spending account. Hope that makes sense!
@@smileycitrus Do you use a different spreadsheet for business purposes?
@blueeyedbraniac yes! it's completely seperate 🙂↕️
love iit! When you paid money into your bills account, you overrode the actual tab - won't that skew the transactions tab? Just trying to figure out the best way for me to set these systems up half way through using this spreadsheet 😂
you can do either or! just don't do both 😅
Hi just wondering how did you add the checklist and emoji in excel? was it a formula?
hi! the checklist comes with the template (the yearly 2.0) and I added the emojis with my keyboard (you can google the command)
Purchase the coplenty 2.0 basic to try out
I have just started using Coplently Yearly 2.0 and liking it so far. Can I ask how do you record a transaction made on a credit card? ie. do you record it as 20 coffee (category) or 20 NAB Credit card (category) so you know how much to pay towards credit card. Thanks
Hi! I just do $20 coffee because I pay it off in full every month ☺️ the money may stay in my account until it's due but it's technically not my money, if that makes sense? Just helps me keep track that way and not spend more $$ than we have x
How do you carry over the left to spend money?! I duplicate the tabs for each month but I think I’m doing it wrong 😢
Hi Ella! Thank you for the video. I always have a question and it would be great if you can share your thoughts. So we use credit cards for 90% of our expenses (except for items we have to use chequeing account like mortgage). And we pay them off. But does that mean we pay off the expenses of the previous month? Like I would budget September but then then September paycheque is to pay off credit cards which I used for August expenses? I hope that makes sense. Other wise, we would technically need a month ahead expense? Thank you!
Hi! we just track and budget for whatever month we're in because even though we've put it on a CC we still owe it, regardless of when it's due. Hope that makes sense!
@@smileycitrus Hi Ella - I have the same question as above and still a bit confused! We have a CC for the points aswell, but I'm getting so confused on how to track it. So for example in September the bill for the previous period (22 July - 22 August) is due on September 5th. Do I put that payment (paying in full) in my September expenses, or do I just track the 22 July - 22 August purchases within the July and August period and dont worry about when its paid? Even though we need to make sure we have the money there on September 5th for the payment? So effectively just tracking the transactions on the CC in the month which they occur and dont worry about putting the payment in the spreadsheet as an expense. Hopefully that makes sense! :)
@@Samantha_Nol Hi! because we pay it off in full every month I disregard when the credit card payment actually comes out ☺️ we just track what we've spent in the month we're in and pay it off when it's due. We've been deducting our spending from the spreadsheet as the month goes so money is just sitting in our account ready to go!
@@smileycitrus perfect, thanks Ella! It made more sense as I started typing it to ask you (standard overthinker) but just wanted to be sure :)
Hi!! Love watching your videos! I just started my channel a couple of months ago and your videos have given me so much inspiration. Do you do anything special to retain the quality of your screen recording when you post? Mine always get just slightly grainy
Hi lovely! thank you!! I don't! I just screen record in Quicktime and import directly into Final Cut Pro x
@@smileycitrus ok what I'm hearing is capcut is the problem, not me 😂
hey, :( how can i download it to my desktop excel sheet, i don't like using google drive :(
it's just for google sheets
We have started using this at the start if August this year.
How do you imput your 'left to spend' in Jan 2025? Like, it is not zero as December just happened but there doesnt seem to be a logical place to put your 'starting' funds if that makes sense.
Thanks Ella for the video also! 😊
Hi Ella!
I'm also having the same problem. I started using this sheet in June and my left to spend is completely out of whack because in June we had a high spend month and spent more than our income but it didn't make sense to put the amount we already had in our spending account because it wasn't actually income from that month.
Hi! you'll have to list whatever the difference in your account as "rollover" or misc income ☺️
I list it as "rollover" or misc income on the first month
Can you see/use this spreadsheet on a cell phone? I don’t have a computer and want to have a mobile option to track on.
yes! as long as you have the Google Sheets app x
@@smileycitrus thank you!
Do you make more money now without your travel agent job doing full-time content creation? Do you spend more money now, not having a 9 to 5?
It depends on the month! but overall yes because I have more time to make content and say yes to more opportunities ☺️ I've tried to keep my spending the same as when I worked a 9-5
@@smileycitrus you are goals!!
What’s the difference between 2.0 and 3.0 spreadsheet
there's a comparison on the website x
i have a question on your spreadsheet (i use the same)
I'd love to know, how do you fix up your numbers each month? for some reason my numbers are not exact in my spreadsheet when it comes to the totals. I think it gets messy bc my husband and i share bank accounts and if he runs out of money he will just take from our savings so it gets confusing when i'm trying to add up the transactions
ie.
I'll transfer $1000 into savings
He transfers
$50
$250
$37
into his account then spends it on groceries, fuel etc.
So I get so frustrated on how to fix up the numbers.
Any tips on how to simplify the mess? I've thought of giving him more $ ofcourse (giving as in i transfer it to him) however i find if he sees more $ in the account he'll just spend more. help!
Hi Ella how are you happy Wednesday night to you and I enjoy your channel and you are amazing supporter
Thank you! You too!
I have the V2.0 but it doesnt have the annual tracker???
do you have the Yearly 2.0?
I was a bit shook by the f bomb at the start,apart from that I enjoy your videos 👍🏽
I love the f bombs!
hard boiled egg energy sent me 🤣🤣🤣
I feel like any meals not cooked at home are considered eating out
that's fair! I like to get more detailed and distinguish between the two ☺️
Hey! whats the diary that you use for the thumbnail???? is it for budgeting too?? xoxox
it has a budget section! it's called the Steph Pase life planner x
I’ll leave it
💖💖💖
looking at this and find it very funny how you american/australian people spending so much money for a coffee.
us *australians have the best coffee culture so it makes sense
Thank you so much for everything you do and your financial transparency, it’s personally helping me a lot 🩷
oh i'm so glad 🥹💕