Income, Expense, & Cash Flow Tracking with Incorporated Budget and Variance Calculations - $25.00
This workbook is for those that want to not only track income, expenses, and cash flow, but also want to see how they are doing against their plan or budget.
It takes the Income, Expense, & Cash Flow workbook and adds a Budget spreadsheet. But it goes beyond that and includes automatic calculations that show you how your actual income and expenses compare to your budget.
This workbook contains an Actual & Budget Summary that is fully automated. It shows actual income and expenses side-by-side with your budgeted income and expenses and calculates "variances" as well as monthly and year-to-date totals. Click on the thumbnail screenshot below to see a larger image of the Monthly Summary (a new window should open).
Note: The split-screen view is not how the spreadsheet actually appears, it's just to show the various sections here.
The Budget spreadsheet is pretty straightforward, but here is a screenshot of that as well (again, a new window should open).
And, of course, there are the twelve monthly spreadsheets with 31 daily columns where actual income and expenses are entered. Click on the thumbnail screenshot below to see a larger view of a sample monthly spreadsheet (a new window should open).
Note that the monthly sample screenshot is scrolled toward the end of the month.
Features:
Pre-defined income categories and over 40 pre-defined expense categories common to full-timers
Easily change category names for your needs
Change a category name in the Actual & Budget Summary, and all the other spreadsheets update automatically - no need to change category names in each spreadsheet
Easy input of budgeted income and expenses in Budget spreadsheet
Budget totals automatically transfer to Actual & Budget Summary - no duplicate input or copying and pasting
Easy input of income on day received by category in monthly spreadsheets
Easy input of expenses on day incurred by category in monthly spreadsheets
Monthly income and expense totals by category automatically transfer to the Actual & Budget Summary - no duplicate input or copying and pasting
Actual & Budget Summary provides monthly totals of income and expenses and year-to-date totals of income and expenses by category
Actual & Budget Summary also automatically calculates monthly and year-to-date cash flow
Actual & Budget Summary also automatically calculates differences (or "variances") between actual income/expenses and budgeted income/expenses by category, and in total, for each month and year-to date
Certain cells are locked to prevent inadvertent changes that could cause the calculations to not work
Though certain cells are "locked", all rows, columns, and cells can be formatted to your personal viewing preferences
Experienced Excel users can easily unlock all cells for full customization
Click on the "Add To Cart" button below to purchase this workbook.
Back To Top
Custom Designed Workbooks - $50.00 and up
Many people will not need all the pre-defined categories in the workbooks above. However, deleting rows and columns in those workbooks without messing up the automatic calculations can be dicey at best.
So, for those that don't want extra rows they don't need, and for those that don't want to mess with changing and moving category names, we can customize the above templates for exactly what you want. Custom designed workbooks based on the above templates will be $50.
But if you want something even more sophisticated or something with a very specific look and feel, we can do that as well. We can agree on a price based on the difficulty of the task and the level of customization you want.
If you are interested in a custom designed workbook, send us a little information about what you are looking for via our Contact Form, and we'll be in touch to discuss your needs.
Back To Top
Administrative Items
Guarantee
Due to the nature of these downloadable products, we cannot provide refunds. However, if you find a formula or calculation flaw, we will certainly fix it.
I've done lots of testing, but there are many, many formulas and there could be something I missed. If so, we guarantee we will correct the problem subject to the next section "End User Changes".
End User Changes
We have "Protected" each of the spreadsheets and locked certain cells so that users cannot inadvertently "break" the spreadsheets and workbooks.
However, for more experienced users, we have made it easy to "Unprotect" the spreadsheets which makes the operation of the workbooks vulnerable if certain changes are made.
The End User assumes the risk of "Unprotecting" and "Unlocking" cells and making changes to the formulas or adding and deleting rows and columns which can affect the automation. If such changes are made and the workbook stops functioning as designed, we will assist with fixing the workbook, but there will be an hourly fee to do so.
Downloads & Payments
The workbook downloads and shopping cart are managed by E-junkie.
Payments are processed through E-junkie via PayPal. Credit cards, debit cards, and PayPal accounts may be used for payment.
Once you "checkout" you should get an automated "thank you" email from E-junkie with a link to your order information. That should be followed by a second email that includes a link to download your workbook and a notice that you have 24 hours to perform the download.
That second email will also include our email address in case you have any comments, questions, or problems.
We hope these workbooks save you lots of time. I know they are much better than the ones I've been using for the last few years. :)