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

Income & Expense Tracking - Worksheet!

Accelerate wealth. Build a business that pays freedom. Join more than 70,000 entrepreneurs and register for the Fastlane Entrepreneur forum. Remove ads? Join the INSIDERS.

Max Shapira

Contributor
Read Millionaire Fastlane!
Read Unscripted!
Jan 15, 2019
15
89
27
31
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 to Fastlane Insiders.

Attachments

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

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
34
49
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

  • Sticky
MARKETPLACE  NEW: The Best School for Going Fastlane (50% Off Deal Now On)
Hi Rob, I've sent you a PM as I’m trying to join since midweek. Cheers
  • Sticky
MARKETPLACE  Freelance University: Solve Every Freelance Problem (Especially on Upwork)
FU. 4 DAYS. 50% OFF BLACK FRIDAY SALE! If you're an Upwork freelancer, you'd be a fool not to...
  • Sticky
MARKETPLACE  You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
One year ago, I was just your average software developer who always consumed content about...
  • Sticky
MARKETPLACE  For Sale: Food Brand with 4 Years of Happy Customers in a Fast-Growing Niche
So to get certified, it cost a fortune? How much exactly? That sucks that these "health...
MARKETPLACE  Fox Web School "Legend" Group Coaching Program 2021
Fox's Web School helps you learn a specialized skill which you can use to get to Fastlane. It's...
MARKETPLACE  Not sure how to start? This free book will teach you how to build a successful web design business
Hi Fox. Starting the book and got through the introduction. Had a conversation with Andy Black...


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

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom