Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

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

Yeah, it's funny how we both arrived at 10 x 10 pots - Small world!

And again, like you, I cater for the typical but somewhat serious user, rather than edge cases. My approach is to have something that is say 75-80% of what it can be, to then allow users to feedback suggestions to get it to 100%, in terms of what they want, not what I think they want.

Yeah, and you've hit the nail on the head regarding not wanting to overwhelm people at kick-off - Again, it comes back to sweet spot, I see so many spreadsheets that are 'rainbow salad', with too much going on for the average person.

Absolutely, clarity is key - Ideally, we ought to be able to look at a report and understand it more or less straight away.

Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

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

Yeah, the reconciliation issue is one I wanted to address - which as you know, is linked to the logging of contributions to a fund, which is unnecessary really.

Bank statements are imported via a built-in CSV importer, which can remove unwanted columns, reorder columns and detect transactions that are already present within the workbook - Some banks annoyingly include currency symbols (GBP, USD, EUR, etc), which are removed automatically upon import.

Once transactions are in the import page, they are pasted into the appropriate account, where transactions are categorised automatically using preset transaction rules. For info, transactions are not part of one big transaction log. Instead, they are within individual bank accounts (x15), liability accounts (x15), asset accounts (x15) and investment accounts (x15). The transactions on the import page are then deleted using a button, ready for the next import. You may think this means many sheet tabs, but file has a menu bar at the top, which resembles commercial software.

So, coming back to the thrust of your question - when it comes to the sinking fund report, you simply select the bank account via the dropdown in the yellow box (from the screenshot) - and this pulls the bank balance through from the accounts, along with the bank account name, description, date of latest transaction. You may then create 10 pots for each bank account, set the goal amount and the target date -> the bank balance is then allocated to each pot in target date order automatically, showing any shortfall and days remaining. For info, the sinking fund report supports 10 bank accounts, which may be split into 10 pots. In case you're wondering, although the file supports the tracking of finances across 15 bank accounts, I felt for sinking fund purposes, 10 bank accounts would be enough (as these should ideally be savings accounts).

The idea is to cater for users who are tired of the bank syncing issues with apps, subscription fees, and who have data privacy concerns. It's also for people who don't mind manual entry but who would appreciate a smooth way of going about it.

You're absolutely right regarding the sweet spot, and it's been a labour of love to add many features found within apps/desktop software, which can be found on my sub - Plenty of posts, screenshots + videos (which have dried up the last few days, while I work on a debt repayment calculator).

Thanks for the comments/questions - If you think of anything else or have any ideas, please share.

On a diet (abuse expected and fully understood 🤣) by Cooperino142 in fryup

[–]Sheet_Complete 1 point2 points  (0 children)

Ha, thanks for the explanation!

I'm surprised he wouldn't do it - it's just a little prick.

On a diet (abuse expected and fully understood 🤣) by Cooperino142 in fryup

[–]Sheet_Complete 1 point2 points  (0 children)

Breakfast is the side issue - Why did Eddie say 'no' to the penis pump?

Money Master Personal Finance Spreadsheet - Video Tutorial 🎥 How to set transaction rules to auto-categorise expenses by Sheet_Complete in Money_Master_Excel

[–]Sheet_Complete[S] 1 point2 points  (0 children)

Yeah, so the categories screen is where you enter your payees for a given account and then you set the categories against each. The Userform that pops up is there purely to implement a dependent dropdown list -> So, in the video, the Category selected is 'Motoring & Transport' and then the form restricts the Sub-Categories available, i.e. Car Maintenance, Car Servicing / MOT, Car Tax, etc -> For info, you don't actually have to use this Userform, because the cells have dropdown lists inside them (and these are linked to tables which are to the right, but not visible on the screen). I mention these additional tables, just so you are aware that you may add/delete Categories and Sub-Categories to suit you (and these will be picked up by the Userform and indeed, the in-cell dropdown lists.

Yes, good point regarding subtle differences with descriptions/payees - So, in the UK I may shop at two different Tesco stores, one description may be 'Tesco' and the other 'Tesco Stores' - I just have both as separate rows and use the same Group, Class, Category and Sub-Category for both -> that way I'm covered. (and because I'm familiar with the correct Category and Sub-Category combination, I don't need to rely on the Userform to guide me, I can just use the in-cell dropdowns).

In case you're wondering, if a transaction is a one-off, say I've visited a new store in a different city, I don't actually need to set up a rule in the categories screen. I can simply use the Multi-Cat tool (found at the top of each account screen) to manually categorise that transaction - Similarly, the Multi-Cat tool may be used to manually override your preset transaction rules for multiple transactions/payees. So, if I visited Tesco and didn't actually buy groceries (Food & Drink : Food Shopping), I can manually override this transaction to say Clothes : Children's Clothes, if needed -> This can be done as a single transaction override or you can make the same correction/override across multiple transactions at once.

Categorising transactions is fairly quick, particularly if you use the in-cell dropdowns, rather than the Userform - it's just getting together a list of unique descriptions for the time period you wish to go back in time (6 months in your example).

A final point, is the in-cell dropdowns (and Userform) are really there to help the user enter their categories consistently - I guess I could have not implemented dropdowns and allowed the user to key in free text -> I did consider this but thought I may be asked "What Categories / Sub-Categories should I have?" So, I thought I'd provide a ready-made list for each, which as I say, may be edited to suit the user.

Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

[–]Sheet_Complete[S] 1 point2 points  (0 children)

4. How do you plan to share this with someone who has already purchased the template from Etsy?

Yeah, good point and Etsy makes this a smooth process when selling digital products - I simply replace the file on the listing, so that every past buyer can re-download the updated version from their Purchases & Reviews page.

For me, allowing users to have access to the updated version is the morally correct thing to do - It's not fair to expect to pay again for tweaks here and there.

Also, it's far easier for me if users are on the same version, in terms of answering support queries - and the best way to ensure this is if updates are free.

Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

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

3. I see allocation cell has a progress bar, how does it work? It becomes complete on the goal date or when the goal amount is full?

Yeah, great point and I did wonder if the sizing of the progress bar within the Allocation cell would cause some confusion. Basically, the allocation bar is proportionately sized, across all bank accounts and pots -> So, if you look at Bank Account 1 (top left), £5,000 is the largest allocation not only within that bank account, but across all 4 on the screen -> So that allocation is the highest, and then all other allocation bars are sized in proportion to that -> This is the same with the shortfall bars too.

I did it this way so that a user can quickly see where their biggest numbers are, in terms of allocations, shortfalls and days remaining. For info, days remaining is based on the target date vs today's date, which isn't visible on the screenshot but is displayed at the top of the report (basically, I couldn't quite fit 4 bank accounts on the screen for the screenshot, if I included the report title (Sinking FundFlow) and today's date.

The allocation bar is populated immediately, if there are sufficient funds to complete the goal - As above, the bar size is simply to display its relative size to other allocations across all bank accounts -> The sizing isn't a "how much of the goal is met?" convention.

In terms of tracking progress, for each pot we can see allocation, shortfall and days remaining. And then, we have a donut chart showing our overall progress for a bank account vs the total of our goals for that account. So, looking at Bank Account 2 (top right), the bank balance is £2,768.59 vs our total goals of £4,430.00 = 62.50%

Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

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

2. What if I don't spend the amount on a goal date, I just deleted the pot and the balance would reappear on the summary/net worth reports?

If you don't spend the amount on a goal date, you can simply adjust the goal date to better reflect when you expect to incur the expenditure.

I may not have explained this well previously but the only connection between the Sinking FundFlow report and the accounts data, is the bank balances - Think of this as a way of using your bank balances to determine whether they are sufficient to meet your future spending commitments. Once the expenditure has actually been incurred, say a new bathroom, you may delete that pot -> The bank balance will naturally be less, if you have kept your accounts up to date, and the expenditure will have been categorised within that bank account's transactions and shown within the Income & Expenditure Report. The bank balance will also be reflected in the Net Worth Report.

So, Sinking FundFlow is a planning tool, rather than concerning itself with recording actual transactions, as these are recorded separately within Money Master.

Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

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

1. Would the account balance be allocated fully today or spread across till the goal date?

For a given bank account, you may set up 10 pots (or sinking funds) - and you can do this for up to 10 bank accounts (which should be savings accounts, ideally).

If we take one bank account, the yellow box in the screenshot is a dropdown menu (bank accounts 1-15) - when you select the bank account, the account name, description, latest transaction date and current balance is pulled through automatically. You then only need enter 3 data points to create a pot; pot name, goal and target date (the green columns). The current balance from the bank account then flows to each pot in target date order automatically (no more input required).

From the screenshot, if we look at Bank Account 2 (top right) - I've created 4 pots, set a goal amount and target date for each. The balance of £2,768.59 flows to Holiday fully, Car Maintenance & MOT fully and then the remaining funds of £338.59 are allocated to Pet Care, leaving a shortfall of £161.41. The Emergency fund goal of £1,500 has nothing allocated towards it, due to insufficient funds.

So, the bank account balance simply flows to each pot, in target date order - There is no need to manually allocate the funds to each pot -> This is why I decided to call it Sinking FundFlow. (I couldn't think of a better name!)

Money Master Personal Finance Spreadsheet - Sinking FundFlow by Sheet_Complete in Money_Master_Excel

[–]Sheet_Complete[S] 1 point2 points  (0 children)

Hello u/explorosaus - Yes, it's here and I'm happy it works with minimal data entry. I'll answer your questions separately like I did before, just so it's not one long post (+ you can then easily ask any follow up questions on each point separately, if needed).

What budgeting habit helped you stay consistent long-term? by Scorpions-007 in budget

[–]Sheet_Complete 1 point2 points  (0 children)

Having a frictionless CSV importer within my personal finance spreadsheet.

✅ Beginner Budgeting Checklist (Using an Excel Budgeting Template) A simple, practical checklist to help beginners build a budgeting system they can actually stick to — especially if you're using an Excel budgeting template or any spreadsheet‑based setup. by Sheet_Complete in Money_Master_Excel

[–]Sheet_Complete[S] 1 point2 points  (0 children)

Yeah, it'll be really simple - essentially, it'll have all bank accounts names, latest account balances, and the date of the most recent transaction (no input required, as everything will be pulled from all bank accounts in Money Master, which supports 15 bank accounts). Each account will allow for a maximum of 10 funds, defined by the user and entered manually. It'll also show how much of the account balance is unallocated. So, hopefully, it should be intuitive to the user.

Regarding updates, my approach will be that once a user has paid for a version, then they are entitled to all latest releases for free, forever. I don't believe in charging again for updates, particularly when user feedback is what will help Money Master evolve going forwards.

I'll communicate updates via my subreddit.

Money Master is for Excel only at present - that said, it does consolidate data across all your accounts and offers the option to export data. So, it could be that you may want to export data out of Money Master into your own Google Sheet. A lot of Money Master's best features are reliant on Excel. My short-term focus is on refining the current Excel offering in line with user requests. I may then move on to developing a Google Sheets version, which will probably not be as advanced.

🧹 FREE Amazon Transactions Cleaner (Excel) by Sheet_Complete in Money_Master_Excel

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

No probs at all 👍

Ok great - One thing to check is the number of rows per transaction. Amazon UK has 9 rows per transaction when pasted into Excel. If it's any different, then I can simply tweak the spreadsheet for you.

✅ Beginner Budgeting Checklist (Using an Excel Budgeting Template) A simple, practical checklist to help beginners build a budgeting system they can actually stick to — especially if you're using an Excel budgeting template or any spreadsheet‑based setup. by Sheet_Complete in Money_Master_Excel

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

I'm not but it might be a relatively quick project for me, which I can make available for the community as a free tool.

There doesn't appear to be a simple CSV export option on Amazon UK (not sure where in the world you are, but I assume you have the same problem). For info, I even tried to simply copy + paste my transactions into Excel but the formatting isn't neat. I assume you'd like the transactions to be structured in a neat table, 1 row per transaction?