Personal Budgeting Tool: Specimen Layout for a Personal Budget
By Acceler8now.com Investing Education Team September, 2007
Need help with the layout of a personal budget? There is no one structure for designing your budget, provided it relates your expected incomes and expenditure and meets your budget objectives. A specimen layout is provided here as a guide. If you choose to use it, one option is to enter the columns and details in an excel worksheet and, if you know how to, insert summation and subtraction formulae in the right places. Thereafter, you simply enter your figures and the sub-totals and totals are imeediately thrown out.
You are not likely to have need for every item listed here and can enter zero where you have no budget for a particular item. On the other hand, an item that is not listed here will be added, if you need it. Feel free too to download and use our excel version of the template. Best of luck in managing your resources!
Personal Budget Template
|
|
CATEGORY |
CURRENT
AVERAGE
|
BUDGET
TARGET |
REMARK |
|
Expected Income: |
|
|
|
|
Salaries and Bonuses - net |
|
|
|
|
Trade Earnings |
|
|
|
|
Interest Earned - net |
|
|
|
|
Dividend - net |
|
|
|
|
Rent Income |
|
|
|
|
Other Investment Income |
|
|
|
|
Miscellaneous Income |
|
|
|
|
Total Income |
|
|
|
|
Less
Top-Level (Pay Yourself): |
|
|
|
|
Direct Investment - stocks, etc |
|
|
|
|
Saving Funds: education, house, etc |
|
|
|
|
Disposable Income |
|
|
|
|
|
|
|
|
|
Budgeted Spending: |
|
|
|
|
Housing & Household: |
|
|
|
|
Rent or mortgage payment |
|
|
|
|
Rates or property taxes |
|
|
|
|
House Repairs/Maintenance |
|
|
|
|
Estate/Security Dues |
|
|
|
|
Home Insurance |
|
|
|
|
Other Home |
|
|
|
|
Subscriptions: Cable, Internet, movie rentals, etc |
|
|
|
|
Repairs to household equipment - electronics, etc |
|
|
|
|
Toiletories & other household requirements |
|
|
|
|
Family Vacation |
|
|
|
|
Other Home Expenses |
|
|
|
|
Sub-total |
|
|
|
|
Feeding & Living Costs: |
|
|
|
|
Foodstuff & Groceries |
|
|
|
|
Lunch and Eating Out |
|
|
|
|
Domestic Entertainment |
|
|
|
|
Miscellaneous Feeding Expenses |
|
|
|
|
Domestic Help |
|
|
|
|
Others |
|
|
|
|
Sub-total |
|
|
|
|
Self-Maintenance: |
|
|
|
|
Clothing & Accessories |
|
|
|
|
Saloon, Barbing |
|
|
|
|
Others |
|
|
|
|
Sub-total |
|
|
|
|
Utilities: |
|
|
|
|
Electricity |
|
|
|
|
Water |
|
|
|
|
Generator Fuel and Maintenance |
|
|
|
|
Telephones |
|
|
|
|
Others |
|
|
|
|
Sub-total |
|
|
|
|
Education: |
|
|
|
|
School Fees |
|
|
|
|
House/Other Lessons |
|
|
|
|
Books, Newspapers, etc |
|
|
|
|
Other Related Expenses |
|
|
|
|
Sub-total |
|
|
|
|
Medical Expenses: |
|
|
|
|
Hospital Expenses |
|
|
|
|
Drug Purchases |
|
|
|
|
Fitness: Gym, nutriceuticals |
|
|
|
|
Other health-related costs |
|
|
|
|
Sub-total |
|
|
|
|
Transportation costs: |
|
|
|
|
Car Fueling and Maintenance |
|
|
|
|
Wages - Driver |
|
|
|
|
Licenses, fees, parking, etc |
|
|
|
|
Car Insurance premium |
|
|
|
|
Public transportation |
|
|
|
|
Others |
|
|
|
|
Sub-total |
|
|
|
|
Due Obligations |
|
|
|
|
Loan Repayment |
|
|
|
|
Other debts |
|
|
|
|
Sub-total |
|
|
|
|
Other Outlays |
|
|
|
|
Tithe |
|
|
|
|
Extended Family |
|
|
|
|
Other Charity |
|
|
|
|
Sub-total |
|
|
|
|
Miscellaneous |
|
|
|
|
Contingency Provision |
|
|
|
|
Miscellaneous Expense |
|
|
|
|
Sub-total |
|
|
|
|
Total Expenses |
|
|
|
|
Surplus/Shortage |
|
|
|
|
|
