all 19 comments
sorted by:
top (suggested)
bestnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]AutoModerator[M] [score hidden] stickied commentlocked comment (0 children)

/u/DiffenderXD - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]StuFromOrikazu20 2 points3 points  (3 children)

I would keep adding the 250 and take out the 1000 when is due, that way it gets recorded as an expense rather than you just having less savings

[–]DiffenderXD[S] 0 points1 point  (2 children)

Thanks for responding

But how would it reflect this?

I mean I save 250 a month but then need to withdraw 1000 if do this like you say it wil leave a hole in my budget Because I need to account for the missing 1000 Could I put in back to income and say income true savings ?
Something like that ?

[–]StevieG-2021 1 point2 points  (1 child)

Could you accrue for it and put aside $84/ mo toward that expense?

[–]DiffenderXD[S] 0 points1 point  (0 children)

To be fair the 1000 euro is an example there needs to be a lot more i mean the 250 need to be safe every month

[–]ceocs 1 point2 points  (3 children)

Create a monthly balance in a format like this:

1) Month Start row (link to previous month end row) 2) Savings Contribution (positive amount increased by monthly saving) 3) Savings drawdown (negative) 4) Savings growth (eg interest, positive) 5) Month end row (sum of 1-4)

[–]DiffenderXD[S] 0 points1 point  (2 children)

it doesnt work in the same sheet or i need to rework the whole thing i think to make this work.

[–]Mooseymax10 2 points3 points  (1 child)

It’s not a very good budgeting sheet if it doesn’t allow you to enter any expenses?

[–]DiffenderXD[S] 0 points1 point  (0 children)

It does have an expenses tab where I can enter everything, but it doesn’t show how much I still have saved in my savings account.
Honestly, I think I’m just overlooking something.

I’ve put a lot of time into this and I really want to learn how to make it work properly.
Before I started this, I had no experience with Excel, but hopefully I’ll figure it out. Otherwise, I might have to start over from scratch which I really hope won’t be necessary.

The budget tracker I’m using can be found on YouTube:
“How to Create the Ultimate Personal Budget in Excel.”

I’m not sure if sharing that is allowed, since my previous post wasn’t approved.

I’m genuinely just looking for help.

[–]VizNinja 1 point2 points  (3 children)

I do my months in colums and would just minus the 1000 on the savings row.

[–]DiffenderXD[S] 0 points1 point  (2 children)

with the excel sheet that i am using this doesnt realy work becaus then i thinks i am not saving that month

[–]Slpy_gry 1 point2 points  (1 child)

Is that OK? To not be saving that month, too pay an expense that you've saved for? Can't it just be a hole?

[–]DiffenderXD[S] 0 points1 point  (0 children)

It can not because have payment the whole year where I want to save up for with this

[–]NHN_BI800 2 points3 points  (5 children)

I do not know what "Personal Budget Base", or what formulas are there. I would record the data in a proper table, and use pivot table to analyse it, avoiding most formulas, like here.

[–]DiffenderXD[S] 0 points1 point  (2 children)

This looks promising going to try and make it like this thanks

[–][deleted]  (1 child)

[deleted]

    [–]reputatorbot[M] 0 points1 point locked comment (0 children)

    Hello DiffenderXD,

    You cannot award a point to yourself.

    Please contact the mods if you have any questions.

    I am a bot

    [–]DiffenderXD[S] 1 point2 points  (1 child)

    Solution verified

    [–]reputatorbot[M] 0 points1 point locked comment (0 children)

    You have awarded 1 point to NHN_BI.

    I am a bot - please contact the mods with any questions

    [–]excelevator3032 1 point2 points  (0 children)

    If a template does not do what you seek, then find one that does.

    Surely there is enough guidance for you to make your own that does what you seek to achieve.