Excel sheet for dividing money

Dealing better with money

Since I work for myself I earn less, but it seems like I can do more. Not only do I have more time for fun things, there is also money for it.

Earn less and do more

I started to work more and more with the profit first idea. I already appeared to do it in part without knowing the term. I started making a budget for my company. At the time I knew what I had to earn to cover my fixed costs for Databeet. By also making a budget for private and including it in the Databeet budget, I had an idea what my fixed costs are for both private and Databeet and how much I have to earn.

Put aside

I didn’t leave it at that. I also started saving how small the amount was at the start of my career as an entrepreneur. That is why I built a buffer for myself and my company, Databeet.

Profit first
Profit first
een simpel systeem om je bedrijf te transformeren van een cash-eating monster in een money-making machine
Score 4.2 out of 5 stars.
€31,50
Op voorraad. Voor 23:59 besteld, morgen in huis
Free shipping!
Click to view this product at bol.com
 
Profit first
Profit first
een simpel systeem om je bedrijf te transformeren van een cash-eating monster in een money-making machine
Score 4.2 out of 5 stars.
€23,99
Direct beschikbaar
Free shipping!
Click to view this product at bol.com

Paying yourself

After reading Profit First I also started paying myself a salary. I did not leave it at that I started a savings account for each type of cost I had. Every invoice that I sent and was paid, I divided the invoice amount among the various saving accounts according to a fixed percentage per cost category. So I made one regular business account, 1 private account and 7 savings accounts. The 7 savings accounts I gave the following names:

  • Study: From this account I pay all the studies I want to do.
  • Marketing: With this I pay all the marketing stuff for my company.
  • VAT and Taxes: This account pays all my VAT and taxes
  • Travel costs: I sometimes travel for business. This is paid by this account.
  • Crowdfunding: With opening this account I am trying to work on my retirement money. I invest in crowfunding and bonds to make more money.
  • Profit: This account is my profit account. I am building a buffer with this account. So my company can survive difficult times and also buy special things.
  • Fixed charges: All the (fixed) cost of my company are paid from this.
  • And the Account named Guiselaine is my private account. The money in this account is to use on my private costs and savings.

As you can see in the picture each cost has a fixed percent of the invoice I earn going to it. I tried this for a year. I liked it and changed the fixed percentages till I found the right one for me. And when I noticed this was working I wanted to do this also for my private account.

Cost savings accounts for Business

Private Account

So now I am the proud owner of several private accounts, so that I also have a better grip on my money there. The accounts I made for the different costs look like this:

  • Fixed charges: Cost like rent, municipal taxes, water, electricity and heat, etc are paid from this account.
  • Savings: On this account I save to have a buffer and also special things I want.
  • Groceries: With this account I pay the groceries.
  • Travel: Yes I love to travel so I make sure an fixed amount is going to this to me important item.
  • Clothes: Yes, I need some clothes during the year so I make sure I have to money for it when needed by having a account for it.
  • House & Balcony: The house needs stuff like plants or when things break. With a separate account for this I know that when I need the money for it, it will be there.

In the table below you see how I a located the percentages. This works for me, for you it might be slightly different.

Private account

With doing this I am a proud owner of retirement money, a buffer and money to dedicate to my costs. I know what I have and what I spent. And I think I spent it smart.

If you whant to do this too. You can download the Excel Sheet I made especially for this. There is an English and a Dutch version!

Try it for yourself and be happy!

Using the Excel

Excel sheet for dividing money

As you can see I made an example for you in the picture above. If I earned 100 euros with my invoice I fill it in the yellow box below earnings and Excel divides the money for me to the different accounts with the fixed percentages I decided before.

The only thing left for me to do is transfer the money from my regular account to the different accounts. I do this with each invoice that is paid to me. You can also do this once a month if that suits you better.

In the second part of the picture you can see how the money is divided on my private account to my private costs and savings.

Have fun using this Excel template. Let me know if you have any questions or suggestions. In the mean while you can also read other blogs about Excel or use other Templates made in Excel. If you want to acquire more knowledge in Excel see this page for the courses Excel I give.

Blog Life

Varied vegetarian food

I have been eating less meat for a long time, but didn't no how to vary with vegetarian food.  I've...
Read More
Varied vegetarian food
Blog entrepreneur Hiking Investing Life

2nd quarter and charity 3rd quarter turnover

Business is starting to pick up again in terms of work. The second quarter turnover was better than the first,...
Read More
2nd quarter and charity 3rd quarter turnover
Blog

hip, Instagram cooking class

I had the taste of taking Instagram courses after the travel writing course and finance course. So when the opportunity...
Read More
hip, Instagram cooking class
Blog Curacao Reading

5 Less known slavery stories

There are a lot of books and movies out there about slavery and even some blockbusters, but today I want...
Read More
5 Less known slavery stories
Blog Investing Life

7 lessons I learned from the finance course on Instagram

Because I would like to reach FIRE (Financial independent and Retire early) in a few years and want to get...
Read More
7 lessons I learned from the finance course on Instagram
Blog Investing Life

7 Tips to save on groceries

Groceries always come out more expensive than you had in mind and then you also forget some ingredients and you...
Read More
7 Tips to save on groceries
Blog entrepreneur Hiking Life Travel

My after Corona Bucket List

I would like to share with you my bucket list for after Corona era. Actually, it is more of a...
Read More
My after Corona Bucket List
Blog Investing Life

I don’t want to know about my student debt

Last week I took part in the student debt challenge of Maaike van fuck that student debt (fuck die studieschuld)....
Read More
3 Replies
I don’t want to know about my student debt
Blog Life

Chocolate fair

For the second time I couldn't stop myself from going to the Chocolate fair in Amsterdam in February. It is...
Read More
Chocolate fair
Blog Hiking

Not one but two walking related conferences just before spring starts

This year I went to the Mountain climbing conference in Nieuwegein as well as the Walking & Cycling Fair in...
Read More
Not one but two walking related conferences just before spring starts
Blog Hiking Travel

Hiking between Cascais and Sintra

Cascais is the escape city for Lisbon, Portugal if you want to be by the sea. I traveled twice to...
Read More
Hiking between Cascais and Sintra
Blog Life

No I am not ….

No, I am not eating more Unfortunately, was it that easy. That I started eating more and by eating less...
Read More
No I am not ….
Blog Life

No reason Retroprints

Would you like to try out our retroprints in exchange for a blog on your website? Actually yes, I wanted...
Read More
No reason Retroprints
Blog Curacao Hiking

Caracasbaai peninsula

I would like to take a long walk on Curaçao. In the meantime, there are about three organizations that offer...
Read More
Caracasbaai peninsula
Blog Life

1 percent turnover to Wegloophuis Utrecht

1 percent turnover to charity This year 1 percent of my turnover goes to charity. A different charity each quarter....
Read More
1 percent turnover to Wegloophuis Utrecht
Blog Curacao entrepreneur

1st quarter 2020

1st quarter 2020 The first quarter of 2020 started with me as a digital nomad working on Curaçao. That means...
Read More
1st quarter 2020
Blog Hiking Travel

7 things I would like to do in Spain

I have been to Spain before and every time I discover new things that I would like to do. That's...
Read More
2 Replies
7 things I would like to do in Spain
Blog Hiking Life

The 5 types of hikers

In my opinion there are 5 types of hikers among the hikers. I would like to share with you those...
Read More
The 5 types of hikers
Blog Life Travel

5 reasons to live in southern Spain in winter

My dream is to escape the winter. I did that all winter in 2013/2014 by going to Australia and New...
Read More
5 reasons to live in southern Spain in winter
Blog Hiking Travel

7 reasons to walk a 4 Days hike

  While walking my 2nd Four Days Marche I have thought of 7 reasons why you should walk a 4...
Read More
7 reasons to walk a 4 Days hike
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300,"lazyload":""}
Sharing is appreciated

Leave a Reply

Your email address will not be published. Required fields are marked *