excel财务应用模板 预算管理 预算模版.xlsx

《excel财务应用模板 预算管理 预算模版.xlsx》由会员分享，可在线阅读，更多相关《excel财务应用模板 预算管理 预算模版.xlsx（11页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、Move from worksheet to worksheet by clicking the blue buttons at the top of each worksheet. Demo users: Income and the first 3 spending categories are open to demo users. Budget Planner 1 - 2 - 3 Quick Budget Create a quick and easy budget by filling out the white cells on the Quick Budget sheet. En

2、ter the Frequency by using the drop down menu provided in each cell. The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the Comparison sheet. Make sure Use this budget on Comparison sheet is selected. (If this box is not selected, the Budget By Month

3、figures will be used for comparison purposes instead.) Budget by Month Use the Budget By Month sheet to create a budget with greater detail. Select your first budget month by using the drop down box in the Income section. Make sure Use this budget on Comparison sheet is selected if you are building

4、a budget by month. (If this box is not selected, the Quick Budget sheet figures will be used for comparison purposes instead.) Use the Quick Budget sheet (for simple budgets) or the Track your actual income and spending on this sheet or use the Daily Spending Record Compare your budgeted income and

5、spending to your actuals. Are you over or under your budget? #1 - Build a Budget#2 - Track Income/Spending #3 - Compare Budget to Actuals Budget by Month sheet(click here). Budget by Month Home TrackingComparisonQuick Budget Start a Quick Budget (click here) Start a Budget by Month (click here) Trac

6、king Use this sheet to track your actual income and spending. These figures will be compared to your budgeted figures on the Comparison page. Comparison Use this sheet to monitor how well you are sticking to your budget. Compare different time periods by using the drop down box above the Income sect

7、ion Daily Spending Weve provided this sheet for those interested in tracking their spending on a daily basis. This simple record goes a long way in helping you stick to your budget. January February March April May June July August September October November Daily SpendingHelp Create a quick and eas

8、y budget by filling out the white cells on the Quick Budget sheet. Enter the Frequency by using the drop down menu provided in each cell. The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the Comparison sheet. Make sure Use this budget on Comparison

9、sheet is selected. (If this box is not selected, the Budget By Month figures will be used for Use the Budget By Month sheet to create a budget with greater detail. Select your first budget month by using the drop down box in Make sure Use this budget on Comparison sheet is selected if you are buildi

10、ng a budget by month. (If this box is not selected, Compare your budgeted income and spending to your actuals. Are you over or under your budget? #3 - Compare Budget to Actuals Comparison December Use this sheet to track your actual income and spending. These figures will be compared to your budgete

11、d figures on the Comparison page. Use this sheet to monitor how well you are sticking to your budget. Compare different time periods by using the drop down box above the Weve provided this sheet for those interested in tracking their spending on a daily basis. This simple record goes a long way in h

12、elping Use the on the Comparison sheet Category NameFrequencyAmountMonthlyYearly Income $2 $24 Salary/WagesMonthly$2 $2 $24 Salary/WagesMonthly$-$- OtherMonthly$-$- OtherWeekly$-$- OtherMonthly$-$- Spending $1 $12 Transportation$1 $12 Auto Loan/LeaseMonthly$1 $1 $12 Insurance Semi-Annually$-$- Johns

13、 bus passMonthly$-$- GasWeekly$-$- MaintenanceYearly$-$- RegistrationYearly$-$- InspectionYearly$-$- OtherMonthly$-$- OtherMonthly$-$- OtherMonthly$-$- Home$-$- MortgageMonthly$-$- RentMonthly$-$- MaintenanceMonthly$-$- InsuranceMonthly$-$- FurnitureSemi-Annually$-$- Household SuppliesMonthly$-$- Re

14、al Estate TaxQuarterly$-$- OtherMonthly$-$- OtherMonthly$-$- OtherMonthly$-$- Utilities$-$- Phone - HomeMonthly$-$- Phone - CellMonthly$-$- CableMonthly$-$- GasMonthly$-$- OtherMonthly$-$- WaterMonthly$-$- ElectricityMonthly$-$- InternetMonthly$-$- OtherMonthly$-$- OtherMonthly$-$- Health$-$- Dental

15、Monthly$-$- MedicalMonthly$-$- MedicationMonthly$-$- Vision/contactsMonthly$-$- Life InsuranceMonthly$-$- OtherMonthly$-$- OtherSemi-Annually$-$- OtherMonthly$-$- OtherMonthly$-$- OtherMonthly$-$- Entertainment$-$- MembershipsMonthly$-$- EventsQuarterly$-$- SubscriptionsMonthly$-$- MoviesMonthly$-$-

16、 MusicMonthly$-$- HobbiesWeekly$-$- Travel/ VacationYearly$-$- OtherMonthly$-$- OtherMonthly$-$- OtherMonthly$-$- Dining$-$- Dining outMonthly$-$- CoffeeWeekly$-$- TakeoutWeekly$-$- fast foodWeekly$-$- Lunch at workWeekly$-$- GroceriesMonthly$-$- OtherWeekly$-$- OtherYearly$-$- OtherMonthly$-$- Othe

17、rMonthly$-$- Kids$-$- ClothesMonthly$-$- Child careMonthly$-$- School suppliesMonthly$-$- BabysitterMonthly$-$- TuitionMonthly$-$- Music lessonsMonthly$-$- OtherBi-Weekly/Fortnight$-$- OtherYearly$-$- OtherMonthly$-$- OtherMonthly$-$- Miscellaneous$-$- 401kMonthly$-$- IRASemi-Annually$-$- DonationsM

18、onthly$-$- Dry CleaningMonthly$-$- New ClothesSemi-Annually$-$- College LoansMonthly$-$- Pocket MoneyWeekly$-$- GiftsMonthly$-$- Credit CardMonthly$-$- OtherMonthly$-$- OtherBi-Weekly/Fortnight$-$- OtherMonthly$-$- $12 $12 $24 Net Spending Income Budget Summary Spending Summary Chart: Enter what you

19、 plan on spending below. Next: Track your actual spending (click here) $12 $- $- $- $- $- $- $- TransportationHomeUtilitiesHealth EntertainmentDiningKidsMiscellaneous Yearly Quick Budget Use the on the Comparison sheet 112 Category NameJanFebMarAprMayJunJulAugSepOctNovDecFull Year Year to Date JanYe

20、ar to Date Dec Income $2 $4 $-$-$-$-$-$-$-$-$-$-$6 2 6 Salary/Wages$2 $4$6 2 6 Salary/Wages (Jane)$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 0 0 0 0 Spending $1 $-$-$-$-$-$-$-$-$-$-$-$1 1 1 Transportation$1 $-$-$-$-$-$-$-$-$-$-$-$1 1 1 Auto Loan/Lease$1$1 1 1 Insurance $- 0 0 Johns bus pass$- 0 0 Ga

21、s$- 0 0 Maintenance$- 0 0 Registration$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Home$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0 Mortgage$- 0 0 Rent$- 0 0 Maintenance$- 0 0 Insurance$- 0 0 Furniture$- 0 0 Household Supplies$- 0 0 Real Estate Tax$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Utili

22、ties$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0 Phone - Home$- 0 0 Phone - Cell$- 0 0 Cable$- 0 0 Gas$- 0 0 Other 0 0 Water$- 0 0 Electricity$- 0 0 Internet$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Health$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0 Dental$- 0 0 Medical$- 0 0 Medication$- 0 0 Vision/contacts$- 0 0 Life Insurance$- 0

23、0 Other$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Entertainment$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0 Memberships$- 0 0 Events$- 0 0 Subscriptions$- 0 0 Movies$- 0 0 Music$- 0 0 Hobbies$- 0 0 Travel/ Vacation$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Dining$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0

24、Dining out$- 0 0 Coffee$- 0 0 Takeout$- 0 0 fast food$- 0 0 Lunch at work$- 0 0 Groceries$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Kids$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0 Clothes$- 0 0 Child care$- 0 0 School supplies$- 0 0 Babysitter$- 0 0 Tuition$- 0 0 Music lessons$- 0 0 Other$- 0 0 O

25、ther$- 0 0 Other$- 0 0 Other$- 0 0 0 0 Miscellaneous$-$-$-$-$-$-$-$-$-$-$-$-$- 0 0 401k$- 0 0 IRA$- 0 0 Donations$- 0 0 Dry Cleaning$- 0 0 New Clothes$- 0 0 College Loans$- 0 0 Pocket Money$- 0 0 Gifts$- 0 0 Credit Card$- 0 0 Other$- 0 0 Other$- 0 0 Other$- 0 0 $5 $1 $6 Net Spending Income JanMarMay

26、JulSepNov $0 $0 $0 $1 $1 $1 $1 Spending Summary Budget SummaryChart: Spending by Month $1 $- $- $- $- $- $- $- TransportationHomeUtilities HealthEntertainmentDining KidsMiscellaneous Enter what you plan on spending below. Next: Track your actual spending (click here) Cells locked for Demo users Purc

27、hased Planner includes: -Additional categories/rows -Alternate currencies Full Year Quick Budget or 1 # Category NameJanFebMarAprMayJunJulAugSepOctNovDecFull Year Year to Date JanYear to Date Dec Income $3 $-$-$-$-$-$-$-$-$-$-$-$3$33 Salary/Wages$3$3$33 Salary/Wages$-$ -0 Other$-$ -0 Other$-$ -0 Oth

28、er$-$ -0 $ -0 Over Budget$ -0 Spending$2 $-$-$-$-$-$-$-$-$-$-$-$2$22 Transportation$2 $-$-$-$-$-$-$-$-$-$-$-$2$22 Auto Loan/Lease$2$2$22 Insurance $-$ -0 Johns bus pass$-$ -0 Gas$-$ -0 Maintenance$-$ -0 Registration$-$ -0 Inspection$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Home$-$-$-$-$-$-$-$-

29、$-$-$-$-$-$ -0 Mortgage$-$ -0 Rent$-$ -0 Maintenance$-$ -0 Insurance$-$ -0 Furniture$-$ -0 Household Supplies$-$ -0 Real Estate Tax$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Utilities$-$-$-$-$-$-$-$-$-$-$-$-$-$ -0 Phone - Home$-$ -0 Phone - Cell$-$ -0 Cable$-$ -0 Gas$-$ -0 Other$-$ -0 Water$-$

30、-0 Electricity$-$ -0 Internet$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Health$-$-$-$-$-$-$-$-$-$-$-$-$-$ -0 Dental$-$ -0 Medical$-$ -0 Medication$-$ -0 Vision/contacts$-$ -0 Life Insurance$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Entertainment$-$-$-$-$-$-$-$-$-$-$-$-$-$ -0 Me

31、mberships$-$ -0 Events$-$ -0 Subscriptions$-$ -0 Movies$-$ -0 Music$-$ -0 Hobbies$-$ -0 Travel/ Vacation$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Dining$-$-$-$-$-$-$-$-$-$-$-$-$-$ -0 Dining out$-$ -0 Coffee$-$ -0 Takeout$-$ -0 fast food$-$ -0 Lunch at work$-$ -0 Groceries$-$ -0 Other$-$ -0 Oth

32、er$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Kids$-$-$-$-$-$-$-$-$-$-$-$-$-$ -0 Clothes$-$ -0 Child care$-$ -0 School supplies$-$ -0 Babysitter$-$ -0 Tuition$-$ -0 Music lessons$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 $ -0 Miscellaneous$-$-$-$-$-$-$-$-$-$-$-$-$-$ -0 401k$-$ -0 IRA$-$ -0 Donat

33、ions$-$ -0 Dry Cleaning$-$ -0 New Clothes$-$ -0 College Loans$-$ -0 Pocket Money$-$ -0 Gifts$-$ -0 Credit Card$-$ -0 Other$-$ -0 Other$-$ -0 Other$-$ -0 $2 $-$-$-$-$-$-$-$-$-$-$- $1 $2 $3 Net Spending Income $3 $3 $2 $2 $1 $1 $0 JanMarMayJulSepNov SpendingIncome Tracking Summary Chart: Spending by M

34、onth Lets you know when spending is over Enter what you actually spend below. Next: Compare actual spending to your budget(click here) Track spending Daily Cells locked for Demo users Full Year Full Year Category NameBudgetTrackingCompare Income $24$3($21) Salary/Wages$24$3($21) Salary/Wages$0$0$0 O

35、ther$0$0$0 Other$0$0$0 Other$0$0$0 Spending$12 $2($10) Transportation$12$2($10) Auto Loan/Lease$12$2($10) Insurance $0$0$0 Johns bus pass$0$0$0 Gas$0$0$0 Maintenance$0$0$0 Registration$0$0$0 Inspection$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Home$0$0$0 Mortgage$0$0$0 Rent$0$0$0 Maintenance$0$0$0 I

36、nsurance$0$0$0 Furniture$0$0$0 Household Supplies$0$0$0 Real Estate Tax$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Utilities$0$0$0 Phone - Home$0$0$0 Phone - Cell$0$0$0 Cable$0$0$0 Gas$0$0$0 Other$0$0$0 Water$0$0$0 Electricity$0$0$0 Internet$0$0$0 Other$0$0$0 Other$0$0$0 Health$0$0$0 Dental$0$0$0 Med

37、ical$0$0$0 Medication$0$0$0 Vision/contacts$0$0$0 Life Insurance$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Entertainment$0$0$0 Memberships$0$0$0 Events$0$0$0 Subscriptions$0$0$0 Movies$0$0$0 Music$0$0$0 Hobbies$0$0$0 Travel/ Vacation$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0

38、Dining$0$0$0 Dining out$0$0$0 Coffee$0$0$0 Takeout$0$0$0 fast food$0$0$0 Lunch at work$0$0$0 Groceries$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 Kids$0$0$0 Clothes$0$0$0 Child care$0$0$0 School supplies$0$0$0 Babysitter$0$0$0 Tuition$0$0$0 Music lessons$0$0$0 Other$0$0$0 Other$0$0$0 Othe

39、r$0$0$0 Other$0$0$0 Miscellaneous$0$0$0 401k$0$0$0 IRA$0$0$0 Donations$0$0$0 Dry Cleaning$0$0$0 New Clothes$0$0$0 College Loans$0$0$0 Pocket Money$0$0$0 Gifts$0$0$0 Credit Card$0$0$0 Other$0$0$0 Other$0$0$0 Other$0$0$0 $1 $2 $3 $12 $12 $24 Net Spending Income Budget vs Tracking Summary -$10 Trans Ho

40、me Utili Healt Enter Dinin Kids Misce -$12 -$10 -$8 -$6 -$4 -$2 $0 Over BudgetUnder Budget Where Are You Overspending? (vs Budget) Budget Tracking Compare your budget to your actual spending below. Select period or month Over budget in red Under budget in green Full Year Category Name1st2nd3rd4th5th

41、6th7th8th9th10th11th12th13th14th15th16th17th18th19th20th21st22nd23rd24th25th26th27th28th29th30th31stMonth Spending $-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Transportation$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Auto Loan/Lease$- Insurance $- Johns bus

42、pass$- Gas$- Maintenance$- Registration$- Inspection$- Other$- Other$- Other$- Home$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Mortgage$- Rent$- Maintenance$- Insurance$- Furniture$- Household Supplies$- Real Estate Tax$- Other$- Other$- Other$- Utilities$-$-$-$-$-$-$-$-$-$-$-$-

43、$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Phone - Home$- Phone - Cell$- Cable$- Gas$- Other$- Water$- Electricity$- Internet$- Other$- Other$- Health$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Dental$- Medical$- Medication$- Vision/contacts$- Life Insurance$- Other$- Other$- Othe

44、r$- Other$- Other$- Entertainment$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Memberships$- Events$- Subscriptions$- Movies$- Music$- Hobbies$- Travel/ Vacation$- Other$- Other$- Other$- Dining$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Dining out$- Coffee$-

45、Takeout$- fast food$- Lunch at work$- Groceries$- Other$- Other$- Other$- Other$- Kids$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- Clothes$- Child care$- School supplies$- Babysitter$- Tuition$- Music lessons$- Other$- Other$- Other$- Other$- Miscellaneous$-$-$-$-$-$-$-$-$-$-$-$-

46、$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$-$- 401k$- IRA$- Donations$- Dry Cleaning$- New Clothes$- College Loans$- Pocket Money$- Gifts$- Credit Card$- Other$- Other$- Other$- Next: Compare actual spending to your budget(click here) HomeQuick BudgetBudget by MonthTrackingComparison HelpDaily SpendingComparison