Excel worksheet sample — Excel preview
Five worksheet excerpts, plus the front and back covers. View the sample below. Purchase the complete book using Buy Me on its product page.

Worksheet sample 1: Tracker
Read-only excerpt from the Excel workbook. The purchased workbook is editable.
| Dwayne World Finances Tracker: Monthly Budget | |||||||
| Moreover it is required in stewards, that a man be found faithful. 1 Corinthians 4:2 (KJV) | |||||||
| Edit pale gold cells. Amounts use one currency of your choice. No currency conversion. | |||||||
| Currency (type here): | |||||||
| New spending analysis: open Spending Review. Enter household transactions once in Money Log. | |||||||
| Month | Income | Spending limit | Planned | Actual | Net amount | Income less actual | Target less actual |
| January | 0 | 0 | 0 | ||||
| February | 0 | 0 | 0 | ||||
| March | 0 | 0 | 0 | ||||
| April | 0 | 0 | 0 | ||||
| May | 0 | 0 | 0 | ||||
| June | 0 | 0 | 0 | ||||
| July | 0 | 0 | 0 | ||||
| August | 0 | 0 | 0 | ||||
| September | 0 | 0 | 0 | ||||
| October | 0 | 0 | 0 | ||||
| November | 0 | 0 | 0 | ||||
| December | 0 | 0 | 0 |
Worksheet sample 2: Spending Review
Read-only excerpt from the Excel workbook. The purchased workbook is editable.
| Monthly Budget spending review | |||||||
| Choose a month or All months. Enter amounts once in Money Log. Gold cells are editable. | |||||||
| Review period | All months | Currency | Your currency | ||||
| No transactions entered. Add your income, bills and other spending in Money Log. | |||||||
| Cash flow | Amount | How to read your results | |||||
| Income | 0 | 1. Money Log: select month, type and category. Enter positive amounts; choose Expense refund for returned purchases. | |||||
| Savings withdrawals | 0 | 2. Category Budget: set monthly budgets and any reduction percentage you choose. Totals and percentages update. | |||||
| Expenses before refunds | 0 | 3. Bills: match each bill name exactly to the Money Log description. Paid amounts update automatically. | |||||
| Expense refunds | 0 | 4. Review the over-budget amounts, largest spending share and cutback potential before making changes. | |||||
| Net expenses | 0 | Savings and debt payments are shown separately from expenses. Savings withdrawals are not income. | |||||
| Debt payments | 0 | All months compares spending with 12 monthly budgets. Start a fresh copy for each new 12-month period. | |||||
| Giving | 0 | Pie charts show positive net amounts. Refunds exceeding purchases remain visible in the exact tables. | |||||
| Savings contributions | 0 | Tracker is the original purpose-specific tool. Its activity is not added to these household totals. | |||||
| Net cash outflow | 0 | Use one currency throughout. Small Business cash totals are not accounting profit or tax calculations. | |||||
| Money remaining | 0 | ||||||
| Outflow / income | |||||||
| User-selected cutback potential | 0 | ||||||
| Charts appear after positive transactions are entered. Exact amounts and percentages are in Category Budget. |
Worksheet sample 3: Monthly Summary
Read-only excerpt from the Excel workbook. The purchased workbook is editable.
| January to December cash flow | |||||||
| Month | Income | Savings withdrawals | Expense | Refunds | Net expenses | Debt payments | Giving |
| January | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| February | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| March | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| April | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| May | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| June | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| July | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| August | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| September | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| October | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| November | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| December | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Worksheet sample 4: Category Budget
Read-only excerpt from the Excel workbook. The purchased workbook is editable.
| Category budgets and cutbacks | |||||||
| Review period: All months | |||||||
| Monthly budget and cutback percentage are your choices. No reduction is assumed. | |||||||
| Category | Group | Monthly budget | Cutback % | Net expenses | % of expenses | % of income | Budget for period |
| Rent / mortgage | Housing | 0 | |||||
| Home maintenance | Housing | 0 | |||||
| Electricity | Utilities | 0 | |||||
| Water | Utilities | 0 | |||||
| Internet | Utilities | 0 | |||||
| Mobile phone | Utilities | 0 | |||||
| Gas / cooking fuel | Utilities | 0 | |||||
| Groceries | Food | 0 | |||||
| Dining out | Food | 0 | |||||
| Coffee / snacks | Food | 0 | |||||
| Fuel | Transport | 0 | |||||
| Bus / taxi | Transport | 0 | |||||
| Vehicle costs | Transport | 0 | |||||
| Insurance | Family | 0 |
Worksheet sample 5: Bills
Read-only excerpt from the Excel workbook. The purchased workbook is editable.
| Bills paid and remaining | |||||||
| Match Bill name to Money Log Description exactly. Amount paid includes expense refunds. | |||||||
| Review period: All months | |||||||
| Bill name | Category | Monthly plan | Plan for period | Net paid | Remaining | Paid % | Autopay / notes |
| Rent / mortgage | Rent / mortgage | 0 | |||||
| Electricity | Electricity | 0 | |||||
| Water | Water | 0 | |||||
| Internet | Internet | 0 | |||||
| Mobile phone | Mobile phone | 0 | |||||
| Gas / cooking fuel | Gas / cooking fuel | 0 | |||||
| Insurance | Insurance | 0 | |||||
| Vehicle costs | Vehicle costs | 0 | |||||
| School / childcare | School / childcare | 0 | |||||
| Subscriptions | Subscriptions | 0 | |||||
| Medical / dental | Medical / dental | 0 | |||||
| Other bill | Custom expense 1 | 0 | |||||
| Record bill payments once in Money Log. The plan here is separate from category budgets. |

