Automated Personal Finance Spreadsheets1. See what it's all about:
Overview video Customer Interviews 2. Select the right tool: Excel Budget Spreadsheet Forecasting Spreadsheet Free Budget Template Save $ with the Finance Bundle (scroll down) 3. Develop the personal finance management habit that will benefit your whole life: 30 second read
|
The Excel Budget Spreadsheet & Forecasting Spreadsheet come with:
|
Free Upgrades When you buy an xlyourfinances' spreadsheet you receive free access to future versions of that product. Transferring your information from one version to the next is easy and can be done in minutes. |
Instructional Videos Step-by-step video instructions walk you through how to use the automated spreadsheets. No need for advance Excel knowledge, but you will learn some Excel tricks as you watch! |
Satisfaction Guaranteed I am confident you will love what xlyourfinances can do for you. If you are dissatisfied, e-mail me within 30 days and I will refund your money upon satisfactory completion of a brief survey. |
The Excel Budget Spreadsheet
Gain control of your finances with better budgeting & tracking, secure and off-line, w/ your own customizable personal finance spreadsheet.
This financial spreadsheet automates personal budgeting and results.
Price: $56.99
For Excel 2010, '13, '16, '19 and 365 (Now compatible w/ Microsoft 365 for MAC)
| |||
Once you click "Buy Now" and you will be taken to Paypal to complete your purchase.
You then will receive an e-mail with a link to download your own xlyourfinances forecasting spreadsheet.
You then will receive an e-mail with a link to download your own xlyourfinances forecasting spreadsheet.
|
|
|
Summary transcript of "Overview video"
If you ever tried a do it yourself project at home without the right tools, you know how frustrating this can be. Think of personal finance as one big do-it-yourself project, if you don't have the right tools, it's going to be tough! The average family has over a thousand transactions a year, it is next to impossible to make sense of all these transactions without the right tool. When it comes to downloading these transactions, the first thing you realize is that your bank and credit card companies do not use the same format. This is where xlyourfinances shines. You can easily align and label your data with a few clicks. Xlyourfinances already knows which transactions have been posted and which ones are ok to post and with one click remove the ones that were already posted. Once posted, they now appear on the transactions tab where you can filter, sort, and edit all your data in one place. Using the powerful autofilter in Excel, you can quickly find what you have posted, narrowing it down by description, date, or amount. Everything gets accumulated into the summary tab. You can easily see by financial account and category what you 've earned and spent over multiple years or by months within one year.
The toughest thing about budgeting is predicting the future. This is made a little bit easier if you know what was spent in the past. xlyourfinances pulls the past 3 years to help you predict what you think will happen this year. As you work down through the categories to make the changes you think are necessary. You can drill down just by double clicking on any category. This will show the expenses for any period and compare it to the budget for the same pro-rated period of time.
As the month progresses, you can see your actual spending beside your budget. The budget is prorated by the number of days that have occurred in the month. You can also compare how you are doing YTD. The red, yellow or green lights are quick indicators of areas you are doing good or are having trouble in.
Now that you see how easy budgeting is now that you have all your transactions and historical data in one place, let's move on to the big picture.
If you ever sit down with a financial advisor, one of the first things they will do is make you put together a personal finance statement. All it is, is a list of your assets and liabilities to determine your net worth. Xlyourfinances allows you to add assets and liabilities and track them over the years to see if you are improving or not. The importance of doing this is that when you are making mortgage payments you do not always see the benefit, but over time you can see that you are building equity and increasing your net worth. So the big picture is to see how you're doing over the years to make sure you are achieving your goals.
Xlyourfinances makes it possible to truly maintain your personal finances in Excel. Automated, customizable, personal finance spreadsheet features:
Stores unlimited years | Unlimited financial accounts | Unlimited categories | Auto-labels transactions | One click removes duplicates from downloads | Easily reconciles to your financial accounts | Cash Forecast | Simplifies budgeting | Summary reports show actual vs. budget for any time period | Monthly and yearly summaries | Personal financial statement | Access to step-by-step video instructions | Free Upgrades!
Xlyourfinances is the right tool for the job, I hope you give it a try, Thank you!
If you ever tried a do it yourself project at home without the right tools, you know how frustrating this can be. Think of personal finance as one big do-it-yourself project, if you don't have the right tools, it's going to be tough! The average family has over a thousand transactions a year, it is next to impossible to make sense of all these transactions without the right tool. When it comes to downloading these transactions, the first thing you realize is that your bank and credit card companies do not use the same format. This is where xlyourfinances shines. You can easily align and label your data with a few clicks. Xlyourfinances already knows which transactions have been posted and which ones are ok to post and with one click remove the ones that were already posted. Once posted, they now appear on the transactions tab where you can filter, sort, and edit all your data in one place. Using the powerful autofilter in Excel, you can quickly find what you have posted, narrowing it down by description, date, or amount. Everything gets accumulated into the summary tab. You can easily see by financial account and category what you 've earned and spent over multiple years or by months within one year.
The toughest thing about budgeting is predicting the future. This is made a little bit easier if you know what was spent in the past. xlyourfinances pulls the past 3 years to help you predict what you think will happen this year. As you work down through the categories to make the changes you think are necessary. You can drill down just by double clicking on any category. This will show the expenses for any period and compare it to the budget for the same pro-rated period of time.
As the month progresses, you can see your actual spending beside your budget. The budget is prorated by the number of days that have occurred in the month. You can also compare how you are doing YTD. The red, yellow or green lights are quick indicators of areas you are doing good or are having trouble in.
Now that you see how easy budgeting is now that you have all your transactions and historical data in one place, let's move on to the big picture.
If you ever sit down with a financial advisor, one of the first things they will do is make you put together a personal finance statement. All it is, is a list of your assets and liabilities to determine your net worth. Xlyourfinances allows you to add assets and liabilities and track them over the years to see if you are improving or not. The importance of doing this is that when you are making mortgage payments you do not always see the benefit, but over time you can see that you are building equity and increasing your net worth. So the big picture is to see how you're doing over the years to make sure you are achieving your goals.
Xlyourfinances makes it possible to truly maintain your personal finances in Excel. Automated, customizable, personal finance spreadsheet features:
Stores unlimited years | Unlimited financial accounts | Unlimited categories | Auto-labels transactions | One click removes duplicates from downloads | Easily reconciles to your financial accounts | Cash Forecast | Simplifies budgeting | Summary reports show actual vs. budget for any time period | Monthly and yearly summaries | Personal financial statement | Access to step-by-step video instructions | Free Upgrades!
Xlyourfinances is the right tool for the job, I hope you give it a try, Thank you!
The Forecasting Spreadsheet
PLAN OUT THE NEXT 5 TO 50 YEARS!
This financial spreadsheet helps you forecast ​your financial future!
Price: $56.99
For Excel 2010, '13, '16, '19 and 365 (Now compatible w/ Microsoft 365 for MAC)
| |||
Once you click "Buy Now" and you will be taken to Paypal to complete your purchase.
You then will receive an e-mail with a link to download your own xlyourfinances forecasting spreadsheet.
You then will receive an e-mail with a link to download your own xlyourfinances forecasting spreadsheet.
|
|
THE FORECAST WILL HELP YOU ANSWER IS THERE ENOUGH MONEY FOR: RETIREMENT? COLLEGE? A DREAM VACATION? HOME REMODEL? CAN YOU AFFORD: NEXT CAR? EATING OUT? CLOTHING? ENTERTAINMENT? YOUR TARGET RATE OF RETURN ON INVESTMENTS |
Summary transcript of "Forecasting Video"
Xlyourfinances forecasting spreadsheet, is a powerful tool for helping you predict your future financial position. This video is a brief overview of how the spreadsheet works. A good thing to have in mind is how far out into the future you want to try to forecast. The nice thing is you can make as many forecasts as you would like. So if you want to forecast the next five years, you can make a copy and label that five years, and from there you could create a five year forecast. The longer you try to forecast the less accurate it's going to be. None of us know what the future brings, however, through this forecasting spreadsheet, you can get some comfort as to whether you are on the right path or not. If I make this much per year and spend this much, how much money do I have leftover for what I want to try to do in the future. Whether it's planning for vacation, saving for your kids college, or saving for retirement. What makes it more complicated than just am I spending less than I'm earning, is layering in what kind of investment return you realistically plan on getting off your savings, and the unexpected large expenses that might come down the road. So, with that said, let's get started on some of the basics of the spreadsheet. There is a paycheck breakdown tab where you can calculate pre-tax and post tax items that come out of your paycheck which is very important as you calculate where all your money is going (Roth 401(k), HSA, health insurance etc.).
Everything is on an annual amount: annual earnings, annual spend, annual return on investment.
At the top, you can put in your current age and then at your retirement age you are able to separate working years from retirement years. The first section is cash flow, money coming in versus money going out, we need to make sure that the cash position is positive. If it is a negative cash flow year, you see the next section is “Coverage”, which is available collateral, available unsecured credit and available savings. This evaluates whether you have enough collateral or savings, and if need be, unsecured credit (i.e. credit cards), to cover the year’s shortfall. That is what coverage means, can you cover your negative cash flow for the year. Obviously if you're using credit cards to ‘cover’ the year, you are building up a liability that you're going to have to pay off someday. All these things are impacting assets and liabilities, which as you know, assets minus liabilities equal your net worth. So as the years go along you can see if your net worth is improving or getting worse based on what you think is going to happen.
There are two default sections, one general section where you can put in your general spending (i.e. fixed and variable expenses). If you want, you can go into more detail and list out as many categories as you would like. The next section is large expenses. These would be expenses like vacations, home remodeling, college, buying a car etc. In addition to the default sections, you can also add a loan, a loan with an asset and an investment. In the instructional videos we walk through exactly how to do this and how you can change variables and scenarios at different points in the future.
You can see how this activity of listing out your financial position and projecting it into the future is very helpful for identifying if you're going to have enough cash year to year, and whether you are on the right track to accomplish your goals. I hope you give it a try and I look forward to walking it through with you. Thank you!
Xlyourfinances forecasting spreadsheet, is a powerful tool for helping you predict your future financial position. This video is a brief overview of how the spreadsheet works. A good thing to have in mind is how far out into the future you want to try to forecast. The nice thing is you can make as many forecasts as you would like. So if you want to forecast the next five years, you can make a copy and label that five years, and from there you could create a five year forecast. The longer you try to forecast the less accurate it's going to be. None of us know what the future brings, however, through this forecasting spreadsheet, you can get some comfort as to whether you are on the right path or not. If I make this much per year and spend this much, how much money do I have leftover for what I want to try to do in the future. Whether it's planning for vacation, saving for your kids college, or saving for retirement. What makes it more complicated than just am I spending less than I'm earning, is layering in what kind of investment return you realistically plan on getting off your savings, and the unexpected large expenses that might come down the road. So, with that said, let's get started on some of the basics of the spreadsheet. There is a paycheck breakdown tab where you can calculate pre-tax and post tax items that come out of your paycheck which is very important as you calculate where all your money is going (Roth 401(k), HSA, health insurance etc.).
Everything is on an annual amount: annual earnings, annual spend, annual return on investment.
At the top, you can put in your current age and then at your retirement age you are able to separate working years from retirement years. The first section is cash flow, money coming in versus money going out, we need to make sure that the cash position is positive. If it is a negative cash flow year, you see the next section is “Coverage”, which is available collateral, available unsecured credit and available savings. This evaluates whether you have enough collateral or savings, and if need be, unsecured credit (i.e. credit cards), to cover the year’s shortfall. That is what coverage means, can you cover your negative cash flow for the year. Obviously if you're using credit cards to ‘cover’ the year, you are building up a liability that you're going to have to pay off someday. All these things are impacting assets and liabilities, which as you know, assets minus liabilities equal your net worth. So as the years go along you can see if your net worth is improving or getting worse based on what you think is going to happen.
There are two default sections, one general section where you can put in your general spending (i.e. fixed and variable expenses). If you want, you can go into more detail and list out as many categories as you would like. The next section is large expenses. These would be expenses like vacations, home remodeling, college, buying a car etc. In addition to the default sections, you can also add a loan, a loan with an asset and an investment. In the instructional videos we walk through exactly how to do this and how you can change variables and scenarios at different points in the future.
You can see how this activity of listing out your financial position and projecting it into the future is very helpful for identifying if you're going to have enough cash year to year, and whether you are on the right track to accomplish your goals. I hope you give it a try and I look forward to walking it through with you. Thank you!
Buy the finance bundle and save!
The xlyourfinances bundle includes both the Budgeting
spreadsheet and the Forecasting Spreadsheet!
Price: $99.99
For Excel 2010, '13, '16, '19 and 365 (Now compatible w/ Microsoft 365 for MAC)
| |||
The Free Budget Template
Works with Excel 2010, 2013, 2016, 2019 and 365 (Now compatible w/ Microsoft 365 for MAC)
Price: Free
Price: Free
Unlimited Categories | Prorated Month to Date and Year to Date Budget | Enter past years' actual for easy budgeting and comparison | Get a Red, Yellow or Green light if you are 'on budget' or not
This version is the budget tab extracted from the full version.
You won't have your actual expenses feeding in automatically, but you can manually enter them and create a working budget.
This version is the budget tab extracted from the full version.
You won't have your actual expenses feeding in automatically, but you can manually enter them and create a working budget.
|
|
|
Eric - Customer interview
Eric is a young business professional who purchased the program around the time he got married.
I followed up with Eric to see if he would be willing to do a personal finance interview and he agreed.
I followed up with Eric to see if he would be willing to do a personal finance interview and he agreed.
Tell me about your personal finance journey and where you think you are on that journey? How has your view of finances changed since you started using xlyourfinances? What advice would you give for someone who is struggling with their finances? |
How did you handle your personal finances before you started using xlyourfinances? What do you like about the spreadsheet, any favorite features? Were there any surprises or 'aha' moments once you started using xlyourfinances? |
What level would you recommend someone be at before using xlyourfinances?
Beginner. The spreadsheet is designed to be very easy to use, so that anyone can pick it up and use it. All of the heavy Excel lifting is already built in. No formulas, no formatting, just copy and paste your data in and categorize how you want.
Christie - Customer interview
Christie heard about XLYourFinances (xlyf) from a mutual friend. She had been using the spreadsheet for approximately 18 months. I followed up with Christie to see if she would be willing to do a personal finance interview and she agreed.
Tell me about your personal finance journey and where you think you are on that journey? How has your view of your finances changed since you started using xlyourfinances? Were there any surprises or 'a-ha' moments once you started using xlyourfinances? |
How did you handle your personal finances before you started using xlyourfinances? What do you like about the spreadsheet. Any favorite features? What advice would you give for someone who is struggling with their finances? |
Any other thoughts or ideas you would like to share?
I appreciate that you refer to this as a "personal financial journey", because it's exactly that, a journey. A process. Keep learning and keep building on the good habits you already have in place.
Change and growth are always possible, but they usually don't happen overnight.
This website contains icons purchased from www.thenounproject.com
XLYourFinances.com is owned and operated by XLYourFinances, LLC.
All XLYourFinances.com spreadsheets are copyright protected, © 2010-2021.
XLYourFinances.com is owned and operated by XLYourFinances, LLC.
All XLYourFinances.com spreadsheets are copyright protected, © 2010-2021.
Automated Spreadsheets are not very common. I have yet to find any for sale anywhere else on the internet. Once you start using it, you won't know how you ever maintained your finances without it. If you have any questions about the spreadsheet, just send me an e-mail at xlyourfinances 'at' gmail 'dot' com and I will get back to you as soon as possible.
Thank you,
Brad Hoffer
Thank you,
Brad Hoffer