Expenses: Excel Spreadsheet, Please

[Bright Eyes]

Mark,

Take a look at the attached excel sheet. I made a tab for Jan and Feb and the whole year. All you have to do is enter your spending amount in the correct tab (what day and category it is), and it will total it for you automatically by date and category. it will also give you the running (accumulated) total.

I made Jan and Feb views different so you can see which one you like better. and then the total yearly tab updates automatically also.

i use excel all day (im an accountant counting the days till cruising) so this only took a few minutes. also cuz i used OzMikes file to get started. let let me know if this works for you and ill make ya the whole year! trust me, i can do it alot faster than you (and i enjoy it ~snort snort~) i already have tons for my own finances

[Extemporaneous]

Originally Posted by Bright Eyes

Mark,

Take a look at the attached excel sheet. I made a tab for Jan and Feb and the whole year. All you have to do is enter your spending amount in the correct tab (what day and category it is), and it will total it for you automatically by date and category. it will also give you the running (accumulated) total.

I made Jan and Feb views different so you can see which one you like better. and then the total yearly tab updates automatically also.

i use excel all day (im an accountant counting the days till cruising) so this only took a few minutes. also cuz i used OzMikes file to get started. let let me know if this works for you and ill make ya the whole year! trust me, i can do it alot faster than you (and i enjoy it ~snort snort~) i already have tons for my own finances

Very Nice.
January looks more compact and printable.

Best Regards,
Mark Extemp.

[Randal Johnson]

All of this sounds like a lot of work. What I did was create an Excel sheet that I use to track my ATM withdrawals by month and year. I simply add the cash on hand at the first of the month and subtract it at the end of the month. I did add a column for major expences but basically this tracks how much money we dispose of, not necessarily for what though.

[Pelagic]

Hi Mark,

I have been doing this simple Excel spreadsheet on super yachts for years because everyone could understand and use it for their individual departments, even if they had never touched a computer before.

Or Stargazer I use the same for us (just simpler) Payment Codes but still with the ability to make payments in any currency to show me a running balance based on a monthly budget allowance.

I have made one up for Sea Life and it is really easy to use

Just enter your monthly guestimate Budget (In A$) on the first (this is put in as a minus number that automatically goes in the Credit Column)… That way all your payments do not need a minus.

Then just enter all your costs in whatever currency you are using and plug in the actual exchange rate you got as I show for Thai Baht or Malaysian, in column “G”

You do not type past column H as the rest are formulas.

If you accidentally type in the formula columns…no worries just select and “fill-down” those formula columns I,J,K to clean it up.

Column L is how I track any credit card or wire transfer payments.

Once you get used to it….very easy and once the entries are put in, learn how to use “DATA” and “sort” in the menus to organize by your payment codes or dates… whatever you like.

Hope this helps and seasons best!

[MarkJ]

Wow! I'll have to have a close look at Pelagics one (my mind is simple) that actually calculates the exchange of different currencies. Wow! LOl Sensational.

Let me have a day or 3 with these new ones from p and Bright eyes and work out how they all work!

This is sensational!


Thanks everyone