The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success

Income & Expense Tracking - Worksheet!

Remove ads while supporting the Unscripted philosophy...become an INSIDER.

Max Shapira

Contributor
Read Millionaire Fastlane
I've Read UNSCRIPTED
Jan 15, 2019
15
88
27
30
Hi,

I'd like to share with you a powerful tool of mine which will assist you to track your income and expense effectively and stick to a budget. This excel sheet can work in every nation, you just need to adjust the currency correspondingly.

When you open the worksheet for the first time you'll notice two sheets at the bottom:
  • 2019 (the current year)
  • Account Balance - this is something you do one-time (at the beginning of each new year). You should insert the present amount of your current account balance. For instance, if the balance is positive you type merely the number, for example, "100". However, if it's vice versa and the balance is negative you should type "-100". Once you did it, you can hide that sheet at the bottom so it won't bother your eyes.
Disclaimer: You don't need to do it on the main sheet (2019). Meaning, wherever you fill a negative amount, which probably will be at the expense criteria, there's no need to type minus and the desirable number every single time. Fill your numbers in the right cells and the worksheet will do for you all the work.

Save this file as a MASTER and every year just start a new one.


Cheers,
Max Shapira
 

Don't like ads? Remove them while supporting the forum. Subscribe.

Attachments

  • Income & Expense Tracking.xlsx
    20.3 KB · Views: 23

Akash Acharya

New Contributor
Read Millionaire Fastlane
Mar 7, 2019
16
13
19
This is really comprehensive. But do you know what would compliment this spreadsheet? This app I found on Google play store called fyle (its pink you cant miss it). It can help you track receipts and what not. All you do is either type in the details of the receipt or snap a pic and you're good to go. You can pretty much keep track of what you spent on what specific day. Also it's free so there's that too lol. (I am not sponsoring the app nor do I have anything to do with the development team. I have personally used it for my personal expenses and I really like it. I think you guys will too.)
 

Olov

Contributor
Read Millionaire Fastlane
Jul 10, 2019
31
44
107
Cheers,
Max Shapira

I searched the forum for a good Excel template for the upcoming year - and this was exactly what I was looking for!

My Excel skills are that of a 5-year-old, so this was perfect for me. I have done a few changes to make it fit my projects, instead of my personal finances.

Big thanks for this share!
 

Sponsored Offers

Introducing MJ's Personal Unscripted Network, Join Now for FREE!
If you are in IDEA mode, text "IDEA" to the above number. If you are in LAUNCH/START mode, text...
MARKETPLACE 7 Days To Freedom: From Wantrepreneur/Wage Slave To Freelancer
7 Days To Freedom: How To Go From Wantrepreneur To Income Producing Freelancer In Just 7 Days...
  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
I have a long weekend off work.. bought your "Start a Freelance Business: Take Back Your...
  • Sticky
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2021
Adding in my 2 cents for anyone considering joining. Let me save you the deliberation - join...
MARKETPLACE Not sure how to start? This free book will teach you how to build a successful web design business
If there’s one thread I see repeated over and over again on the forum, it goes like this: “I...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
Thanks for clearing that up. What do you recommend for those who are still in the process of...
  • Sticky
MARKETPLACE Kill Bigger Incubator
I have not offered one of these in a while, but it looks like I have time to take on an...



Forum Sponsor

Over 100 Fastlane Students
More Details...

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom