bigtaff-Budget _ Expense Planner v1

Document Sample
bigtaff-Budget _ Expense Planner v1 Powered By Docstoc
					                   Whose expense do you want to track?
                   The Budget Planner allows you to enter the budget of more than one person
                   or if you prefer enter your family name. You can add your first 3 here...

                                     Person 1       Einstein
                                     Person 2         Zoe
                                     Person 3
                                More names can be entered on the Master Data sheet if required…



                   Tracking your Budget verses Actual spend
                   You can enter 3 types of budget, namely Income, Expense and Savings into the
                   planner, the frequency of application and any currency. The monthly value is
                   automatically calculated though each month can be adjusted independently
                 Budget                                        Budget     Budget %          Actual            Monthly         Monthly
                           Frequency      Unit Qty Currency                                                                                      Jan
                  Type                                         Amount     Difference       Amount           Amount (GBP)    Amount (USD)

                       I   Monthly              1              2,500.00             2%           2,400.00           2,450               3,568   2,700.00



                                                                                                                        The Planner automatically
                                                                                                                        Monthly amounts for you regard
                                                                                                                        frequency you've entered. Despi
Define your
                                                                                                                        adjust each monthly value indep
Budget Type:
(I)ncome                                                                   Enter your 'Budget'
(E)xpense                                                                  Amount for the
(S)avings                                                                  frequency and
                                                                           currency you've                       Enter the 'Actual Amount'
                                                                                                                 for the frequency and
                                                                                                                 currency you've specified
  How Frequent
  will this activity

                                                                  Enter a currency if
    Usually set to 1, however if you                              different to your
    want to recognise over-payments                               local currency
    or similar, use this cell as a
                                                                       Define your currencies
                                                                       You can enter your Budget in any currency, however, for the spreadsheet to functio
                                                                       you need to define a Local Currency and conversion rates between your local curren
                                                                       any other currency you may want to view on the dashboard. Useful if your income o
                                                                       are in multiple currencies.

                                                                            Local Currency        GBP       Enter exchange rates on the Master Data s
                                                                        Alternate Currency        USD       Defaults are in place but needless to say they c
                                                                                                            vary considerable over time.


                                                                       That's it, you're done, you just need to remember…
                                                                       I. Only enter your information into the cells that look like this
                                                                       ii. The Budget & Actual amounts should be entered as if they have the same Freque
                                                                       iii. To insert a row, copy another row in the relevant section and insert the copied ro
 ual        Monthly         Monthly
                                               Jan        Feb
ount      Amount (GBP)    Amount (USD)                                 (Optional) Add to or change the TAGS provided
,400.00           2,450              3,568   2,700.00                  The planner comes with a number of predefined categories but Tags
                                                                       allow you to analyse the Budget with your own categories or to simply
                                                                       slice and dice your numbers in another way.
                      The Planner automatically calculates the
                      Monthly amounts for you regardless of the
                      frequency you've entered. Despite this you can
                      adjust each monthly value independently          >>> CLICK HERE for the PLANNER

               Enter the 'Actual Amount'
               for the frequency and
               currency you've specified
ency, however, for the spreadsheet to function correctly
nd conversion rates between your local currency and
iew on the dashboard. Useful if your income or expenses



nter exchange rates on the Master Data sheet
efaults are in place but needless to say they can
ary considerable over time.


u just need to remember…
e cells that look like this
 ld be entered as if they have the same Frequency, Currency & Unit Qty
in the relevant section and insert the copied row.


ge the TAGS provided
predefined categories but Tags
your own categories or to simply



e PLANNER
     Current Year            2012
    Local Currency           GBP
Alternate Currency           USD                                                             Income
                                                                                            Expense


                                                                Balance (Income - Expense)
                                                                                             Savings
                                                                             Net (Balance + Savings)




         FILTER OPTIONS                                                   EXPENSE ANALYSIS
        Currency             GBP                   1

                                                                                           Income
           Graph           Annual                                                 Rental Property
                     Planner!$AB$5:$AB$115                                        Home Expenses
          Person             *All                                                  Transportation
                                                                               Health & Insurance
              Tag            *All                                                      Daily Living
                                                                                    Entertainment
                                              Annual Expense(GBP)           Savings & Investments
                                              Annual Income(GBP)                    Miscellaneous
                                             Monthly Analysis(GBP)                          TOTAL
                                               TAGS Analysis(GBP)




TAGS ANALYSIS                                                                          TAGS Analysis(GBP)

                       Expense (GBP) Income (GBP)
           Bank                     0.00                 0.00        ##    #N/A
  Communications                    0.00                 0.00        ##    #N/A          Vehicle
          Credit                    0.00                 0.00        ##    #N/A           15%
           Food                 2,600.00                 0.00        ##    2,600
          Health                    0.00                 0.00        ##    #N/A
        Insurance                 540.00                 0.00 ##            540
                                                                            Property
           Media                    0.00                 0.00 ##              36%
                                                                           #N/A
         Personal               2,474.95                 0.00 ##           2,475
        Pet      2,600.00        0.00   ##   2,600
  Property       6,000.00    7,262.04   ##   6,000
Retirement           0.00        0.00   ##   #N/A
     Salary          0.00   55,750.00   ##   #N/A
     Shares          0.00        0.00   ##   #N/A
   Utilities         0.00        0.00   ##   #N/A
                                                     TAGS Analysis(GBP)
    Vehicle      2,550.00        0.00   ##   2,550
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
      #N/A     #N/A         #N/A        ##   #N/A
                                                      Salary
      #N/A     #REF!                    ##   #REF!     88%
      #N/A     #REF!                    ##   #REF!
      #N/A     #REF!                    ##   #REF!
      #N/A     #REF!                    ##   #REF!
      #N/A     #REF!                    ##   #REF!
      #N/A     #REF!                    ##   #REF!
      #N/A     #REF!                    ##   #REF!
      #N/A     #REF!                    ##   #REF!
                                                                                                           6,000

                        Monthly         Annual                                                             5,000
                        Budget          Budget           Monthly Actual       Annual Actual                4,000
                         5,230            62,762             5,251                  63,012
                                                                                                           3,000
                         2,071            24,848             1,397                  16,765
                                                                                                           2,000
                                                                                                           1,000
                         3,159            37,914             3,854                  46,247
                                          2,000                                      2,000                        0
                                                                                                                                 Monthly Budget
(Balance + Savings)                       39,914                                    48,247
                                                                                                                        Income             Expense




         ANALYSIS                                                   Annual Expense(GBP)                                                                  INCOME
                      Expense (GBP)
                              0.00       #N/A                       Transportation
                              0.00       #N/A                            18%
                          6,000.00       6,000
                          3,090.00       3,090                                                                    Daily Living
                              0.00       #N/A       Home Expenses                                                    46%
                          7,640.00       7,640          36%
                              0.00       #N/A
                             34.95         35
                              0.00       #N/A
                                                                                                                   Savings &
                         16,764.95                                                                               Investments
                                                                                                                      0%



   TAGS Analysis(GBP)                                  MONTHLY ANALYSIS
                                                             ACTUALS                   Jan                       Feb                     Mar
                                                                     Income       5,405.17                  6,255.17                    5,105.17
                       Food             Insurance                   Expense       1,394.17                  1,394.17                    1,394.17
                       16%                 3%                                 Planner!$AD$5:$AD$115   Planner!$AE$5:$AE$115      Planner!$AF$5:$AF$115

                                                                        Net       4,011.00                  4,861.00                    3,711.00
                                     Personal
                                       15%
                                                              BUDGET                   Jan                       Feb                     Mar
                              Pet                            Budget Income        5,230.17                  5,230.17                    5,230.17
                              16%                           Budget Expense        2,070.68                  2,070.68                    2,070.68
                                                 Planner!$AU$5:$AU$115   Planner!$AV$5:$AV$115   Planner!$AW$5:$AW$115

                                    Budget Net       3,159.49                  3,159.49                3,159.49




TAGS Analysis(GBP)
                         7,000.00
              Property
                12%
                         6,000.00

                         5,000.00

                         4,000.00

                         3,000.00

                         2,000.00

                         1,000.00

                            0.00
                                           Jan                     Feb                     Mar                 Apr

                                                                                                 Income                  Expense
Monthly Budget                     Monthly Actual

                    Balance (Income - Expense)




                 INCOME ANALYSIS                                                              Rental Property                   Annual Income(GBP)
                                                                                                   12%
                                                                Income (GBP)
                                         Income                      55,750.00              55,750
                                Rental Property                       7,262.04              7,262
                                Home Expenses                             0.00               #N/A
                                 Transportation                           0.00               #N/A
                             Health & Insurance                           0.00               #N/A
                                     Daily Living                         0.00               #N/A
                                  Entertainment                           0.00               #N/A                                                                  Income
                          Savings & Investments                           0.00               #N/A                                                                    88%

                                  Miscellaneous                           0.00               #N/A
                                          TOTAL                      63,012.04




                           Apr                  May                     Jun                     Jul                  Aug                  Sep                    Oct
                       5,105.17              5,105.17               5,105.17              5,405.17               5,105.17             5,105.17               5,105.17
                       1,394.17              1,404.12               1,419.17              1,394.17               1,394.17             1,394.17               1,394.17
                 Planner!$AG$5:$AG$115   Planner!$AH$5:$AH$115 Planner!$AI$5:$AI$115   Planner!$AJ$5:$AJ$115                       Planner!$AL$5:$AL$115 Planner!$AM$5:$AM$115
                                                                                                               Planner!$AK$5:$AK$115

                       3,711.00              3,701.05               3,686.00              4,011.00               3,711.00             3,711.00               3,711.00

                           Apr                  May                     Jun                     Jul                  Aug                  Sep                    Oct
                       5,230.17              5,230.17               5,230.17              5,230.17               5,230.17             5,230.17               5,230.17
                       2,070.68              2,070.68               2,070.68              2,070.68               2,070.68             2,070.68               2,070.68
  Planner!$AX$5:$AX$115     Planner!$AY$5:$AY$115   Planner!$AZ$5:$AZ$115   Planner!$BA$5:$BA$115 Planner!$BB$5:$BB$115Planner!$BC$5:$BC$115 Planner!$BD$5:$BD$115

        3,159.49                3,159.49                3,159.49               3,159.49              3,159.49             3,159.49                3,159.49




                Monthly Analysis(GBP)




             May                      Jun                       Jul                     Aug                      Sep                      Oct                        Nov

Expense               Net             Budget Income                         Budget Expense                     Budget Net
ncome(GBP)




                   Nov                Dec
               5,105.17           5,105.17
               1,394.17           1,394.17
                                Planner!$AO$5:$AO$115
             Planner!$AN$5:$AN$115

               3,711.00           3,711.00

                   Nov                Dec
               5,230.17           5,230.17
               2,070.68           2,070.68
                      P
  Planner!$BE$5:$BE$115lanner!$BF$5:$BF$115

      3,159.49          3,159.49




Nov                    Dec
                                                                                                                                                                                                                                                                                                                         78086914-6dfc-41bf-80bc-1d9603587772.xlsx




                                                                                                                                                                                                                               REMEMBER: Your monthly numbers are calculated automatically based on the 'Actual Amount' you enter, however you can adjust each month individually
                                                                                                                                                                                                                               ACTUALS TRACKING                                                                                                                                     Monthly Actuals (GBP)                                                                                                                     Monthly Budget (GBP)
                                                                                                                                                                                                                                                                                                                                                                                     Actual   Actual    Actual                                                                                                                Budget   Budget    Budget   Budget
                                                                                                     Budget                                            Budget     Budget %      Actual        Monthly          Monthly                                                                                                                                                                                           Jan        Feb     Mar     Apr    May      Jun     Jul     Aug     Sep     Oct    Nov      Dec    Exchange                                         Jan     Feb     Mar     Apr     May     Jun     Jul     Aug     Sep     Oct     Nov     Dec
             Category           Person     Item                                         Tags                  Frequency        Unit Qty Currency                                                                                 Jan       Feb      Mar      Apr      May       Jun       Jul      Aug       Sep      Oct       Nov      Dec                     Comments           Monthly   Annual   Amount                                                                                                        Rate
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Diff   Monthly   Annual   Amount
                                                                                                      Type                                             Amount     Difference   Amount       Amount (GBP)     Amount (USD)                                                                                                                                                            (GBP)     (GBP)    (GBP)                                                                                                                  (GBP)    (GBP)     (GBP)    (GBP)
             Income
                  Income        Einstein   Salary                                       Salary         I      Monthly              1                   2,500.00           2%    2,400.00           2,450            3,568      ########                                                 ########                                                                                     2,450    29,400    2,400    2,700     2,400   2,400   2,400   2,400   2,400   2,700   2,400   2,400   2,400   2,400   2,400       1        50      2,500    30,000    2,500   2,500   2,500   2,500   2,500   2,500   2,500   2,500   2,500   2,500   2,500   2,500   2,500
                  Income        Einstein   Bonus                                        Salary         I      Annually             1                   1,000.00           5%                          79              115                 950.00                                                                                                                                      79       950        0            0    950       0       0       0       0       0       0       0       0       0       0        1         4       83       1,000    1,000     83      83      83      83      83      83      83      83      83      83      83      83
                  Income                   Tax Refund                                                  I                                                                                                                0                                                                                                                                                              0        0                                                                                                                      1
                  Income        Zoe        Salary                                       Salary         I      Monthly              1                   2,000.00         -5%     2,100.00           2,100            3,058                                                                                                                                                            2,100    25,200    2,100    2,100     2,100   2,100   2,100   2,100   2,100   2,100   2,100   2,100   2,100   2,100   2,100       1       -100     2,000    24,000    2,000   2,000   2,000   2,000   2,000   2,000   2,000   2,000   2,000   2,000   2,000   2,000   2,000
                  Income        Zoe        Bonus                                        Salary         I      Annually             1                     500.00        150%                           17               24                 200.00                                                                                                                                      17       200        0            0    200       0       0       0       0       0       0       0       0       0       0        1        25       42       500      500       42      42      42      42      42      42      42      42      42      42      42      42
                  Income                   Tax Refund                                                  I                                                                                                                0                                                                                                                                                              0        0                                                                                                                      1

                                                                                                                                  Sub total Income        6,000                     4,500           4,646            6,765                                                                                                                                                             0        0                                                                                                                      1

             Rental Property                                                                                                                                                                                                                                                                                                                                                           0        0                                                                                                                      1

       Renta l Property         Einstein   Rent Income                                 Property        I      Monthly              1                    605.17                    605.17            605              881                                                                                                                                                              605      7,262     605      605       605     605     605     605     605     605     605     605     605     605     605        1         0       605      7,262    605      605     605     605     605     605     605     605     605     605     605     605     605
       Renta l Property                    Tax Relief                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Renta l Property                                                                                E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
                                                                                                                          Sub total Rental Property         605                      605             605              881                                                                                                                                                              0        0                                                                                                                      1

             Home Expenses                                                                                                                                                                                                                                                                                                                                                             0        0                                                                                                                      1

       Home Expens es           Einstein   Mortgage                                    Property        E      Monthly              1                    500.00                    500.00            500              728                                                                                                                                                              500      6,000     500      500       500     500     500     500     500     500     500     500     500     500     500        1         0       500      6,000    500      500     500     500     500     500     500     500     500     500     500     500     500
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es           Einstein   Contents Insurance                          Insurance       E      Monthly              1                     35.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        35       35       420       35       35      35      35      35      35      35      35      35      35      35      35      35
       Home Expens es           Einstein   Electricity                                  Utilities      E      Quarterly            1                     80.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        27       27       320       80       27      27      27      27      27      27      27      27      27      27      27      27
       Home Expens es           Einstein   Gas                                          Utilities      E      Quarterly            1                    145.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        48       48       580      145       48      48      48      48      48      48      48      48      48      48      48      48
       Home Expens es           Einstein   Water                                        Utilities      E      Quarterly            1                     90.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        30       30       360       90       30      30      30      30      30      30      30      30      30      30      30      30
       Home Expens es           Einstein   Satellite - Sky                          Communications     E      Monthly              1                     70.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        70       70       840       70       70      70      70      70      70      70      70      70      70      70      70      70
       Home Expens es           Einstein   Internet                                 Communications     E      Quarterly            1                     74.50            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        25       25       298       75       25      25      25      25      25      25      25      25      25      25      25      25
       Home Expens es           Einstein   Mobile                                   Communications     E      Monthly              1                     25.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        25       25       300       25       25      25      25      25      25      25      25      25      25      25      25      25
       Home Expens es           Einstein   Credit Card 1 Repayment                       Credit        E      Monthly              1                     25.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        25       25       300       25       25      25      25      25      25      25      25      25      25      25      25      25
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es           Zoe        Mobile                                   Communications     E      Monthly              1                     25.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        25       25       300       25       25      25      25      25      25      25      25      25      25      25      25      25
       Home Expens es           Zoe        Loan                                        Credit          E      Monthly              2         USD        100.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0     1.45621     137      137      1,648     69      137     137     137     137     137     137     137     137     137     137     137     137
       Home Expens es           Zoe        Credit Card 2 Repayment                     Credit          E      Monthly              1         USD         50.00            0%                                           0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0     1.45621     34       34       412       34       34      34      34      34      34      34      34      34      34      34      34      34
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
       Home Expens es                                                                                  E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1

                                                                                                                          Sub total Home Expenses         1,220                      500             500              728                                                                                                                                                              0        0                                                                                                                      1

             Transportation                                                                                                                                                                                                                                                                                                                                                            0        0                                                                                                                      1

        Tra ns porta ti on      Einstein   Car Loan                                     Credit         E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
        Tra ns porta ti on      Einstein   Car Insurance                              Insurance        E      Monthly              1                     40.00          -11%       45.00             45               66                                                                                                                                                              45       540       45        45        45      45      45      45      45      45      45      45      45      45      45        1        -5       40       480       40       40      40      40      40      40      40      40      40      40      40      40      40
        Tra ns porta ti on      Einstein   Car Tax                                      Vehicle        E      Annually             1                    150.00                    150.00             13               18                                                                                                                                                              13       150       150       13        13      13      13      13      13      13      13      13      13      13      13        1         0       13       150      150       13      13      13      13      13      13      13      13      13      13      13      13
        Tra ns porta ti on      Einstein   Fuel                                         Vehicle        E      Weekly                                    100.00                                                         0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0       100        0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on      Einstein   Bus / Taxi / Train Fare                      Vehicle        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
        Tra ns porta ti on      Einstein   Repairs / Maintenance                        Vehicle        E      Monthly              1                     50.00                     50.00             50               73                                                                                                                                                              50       600       50        50        50      50      50      50      50      50      50      50      50      50      50        1         0       50       600       50       50      50      50      50      50      50      50      50      50      50      50      50
        Tra ns porta ti on      Einstein   Registration & Licenses                      Vehicle        E      Annually                                                                                                 0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on      Zoe        Car Loan                                     Credit         E      Monthly                                                                                                  0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on      Zoe        Car Insurance                              Insurance        E      Monthly                                                                                                  0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on      Zoe        Car Tax                                      Vehicle        E      Annually                                                                                                 0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on      Zoe        Fuel                                         Vehicle        E      Monthly              1                    100.00          -33%      150.00            150              218                                                                                                                                                              150      1,800     150      150       150     150     150     150     150     150     150     150     150     150     150        1        -50      100      1,200    100      100     100     100     100     100     100     100     100     100     100     100     100
        Tra ns porta ti on      Zoe        Bus / Taxi / Train Fare                      Vehicle        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
        Tra ns porta ti on      Zoe        Repairs / Maintenance                        Vehicle        E      Monthly                                                                                                  0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on      Zoe        Registration & Licenses                      Vehicle        E      Annually                                                                                                 0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Tra ns porta ti on                                                                             E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1

                                                                                                                           Sub total transportation         440                      395             258              375                                                                                                                                                              0        0                                                                                                                      1

             Health & Insurance                                                                                                                                                                                                                                                                                                                                                        0        0                                                                                                                      1

   Hea l th & Ins ura nce       Einstein   Doctor / Dentist                             Health         E      Annually                                                                                                     0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
   Hea l th & Ins ura nce       Zoe        Doctor / Dentist                             Health         E      Annually                                                                                                     0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
   Hea l th & Ins ura nce       Zoe        Life Insurance                             Insurance        E      Monthly                                                                                                      0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
   Hea l th & Ins ura nce       Zoe        Dog Insurance                                 Pet           E      Monthly                                    35.00                                                             0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        35        0       0       0       0       0       0       0       0       0       0       0       0
                                                                                                                    Sub total Health & Insurance             35                      -               -                 -                                                                                                                                                               0        0                                                                                                                      1

             Daily Living                                                                                                                                                                                                                                                                                                                                                              0        0                                                                                                                      1

            Da i l y Li vi ng   Einstein   Food Shopping                                Food           E      Weekly               1                    100.00         100%        50.00            217              316                                                                                                                                                              217      2,600     50       217       217     217     217     217     217     217     217     217     217     217     217        1        216      433      5,200    100      433     433     433     433     433     433     433     433     433     433     433     433
            Da i l y Li vi ng   Einstein   Personal Supplies                           Personal        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng   Einstein   Clothing                                    Personal        E      Monthly              1                    100.00                    100.00            100              146                                                                                                                                                              100      1,200     100      100       100     100     100     100     100     100     100     100     100     100     100        1         0       100      1,200    100      100     100     100     100     100     100     100     100     100     100     100     100
            Da i l y Li vi ng   Einstein   Dining / Eating Out                         Personal        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng   Einstein   Barber / Hairdresser                        Personal        E      Quarterly            1                     10.00                     10.00                 3             5                                                                                                                                                               3        40       10            3      3       3       3       3       3       3       3       3       3       3       3        1         0        3        40       10        3       3       3       3       3       3       3       3       3       3       3       3
            Da i l y Li vi ng   Einstein   Education / Lessons                         Personal        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng   Einstein   Health Club                                  Health         E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng   Zoe        Personal Supplies / Dry Cleaning            Personal        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng   Zoe        Doggie Walker                                 Pet           E      Weekly               1                     50.00                     50.00            217              316                                                                                                                                                              217      2,600     50       217       217     217     217     217     217     217     217     217     217     217     217        1         0       217      2,600     50      217     217     217     217     217     217     217     217     217     217     217     217
            Da i l y Li vi ng   Zoe        Eyebrows                                    Personal        E      Monthly                                                                                                  0                                                                                                                                                               0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
            Da i l y Li vi ng   Zoe        Barber / Hairdresser                        Personal        E      Monthly              1                    100.00                    100.00            100              146                                                                                                                                                              100      1,200     100      100       100     100     100     100     100     100     100     100     100     100     100        1         0       100      1,200    100      100     100     100     100     100     100     100     100     100     100     100     100
            Da i l y Li vi ng   Zoe        Education / Lessons                         Personal        E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng   Zoe        Health Club                                  Health         E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
            Da i l y Li vi ng                                                                          E                                                                                                               0                                                                                                                                                               0        0                                                                                                                      1
                                                                                                                              Sub total Daily Living        360                      310             637              927                                                                                                                                                              0        0                                                                                                                      1

             Entertainment                                                                                                                                                                                                                                                                                                                                                             0        0                                                                                                                      1

        Enterta i nment         Einstein   DVD's / Blue Ray                                            E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Enterta i nment         Einstein   Music                                        Media          E      Monthly                                                                                                      0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Einstein   Subscriptions                                Media          E      Annually                                                                                                     0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Einstein   Games                                        Media          E      Monthly                                                                                                      0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Einstein   Movies / Theatre / Concerts                  Media          E      Monthly                                                                                                      0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Einstein   Sporting Events                              Media          E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Enterta i nment         Einstein   Books                                        Media          E      Annually                                                                                                     0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Einstein   Holiday / Travel                            Personal        E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Enterta i nment         Einstein   Gizmo's / Gadgets / Electronics             Personal        E      Annually                                                                                                     0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Zoe        Books                                        Media          E      Monthly                                                                                                      0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Zoe        Movies / Theatre / Concerts                  Media          E      Monthly                                                                                                      0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment         Zoe        Holiday / Travel                            Personal        E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Enterta i nment         Zoe        Sporting Events                              Media          E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Enterta i nment         Zoe        Subscriptions                                Media          E      Annually                                                                                                     0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1         0        0        0        0         0       0       0       0       0       0       0       0       0       0       0       0
        Enterta i nment                                                                                E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
                                                                                                                           Sub total Entertainment            0                      -               -                 -                                                                                                                                                               0        0                                                                                                                      1

             Savings & Investments                                                                                                                                                                                                                                                                                                                                                     0        0                                                                                                                      1

Sa vi ngs & Inves tments        Einstein   Bank Account - Higher interest account        Bank          S                                                                        2,000.00                                   0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments        Einstein   Emergency Savings                             Bank          S                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments        Einstein   Interest Income                              Shares         I                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments        Einstein   Dividends                                    Shares         I                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments        Zoe        Retirement (401k, IRA)                     Retirement                                                                                                                           0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments                                                                                                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
                                                                                                                Sub total Savings & Investments               0                     2,000                3             -                                                                                                                                                               0        0                                                                                                                      1

             Miscellaneous                                                                                                                                                                                                                                                                                                                                                             0        0                                                                                                                      1

        Mi s cel l a neous      Einstein   Christmas Fund                              Personal        E      Annually             1                    200.00            0%                                               0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        17       17       200      200       17      17      17      17      17      17      17      17      17      17      17      17
        Mi s cel l a neous      Zoe        Christmas Fund                              Personal        E      Annually             1                    200.00            0%                                               0                                                                                                                                                           0        0         0            0      0       0       0       0       0       0       0       0       0       0       0        1        17       17       200      200       17      17      17      17      17      17      17      17      17      17      17      17
Sa vi ngs & Inves tments                                                                               E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments        Zoe        Flowers                                     Personal        E      One-off              1                                   -121%                             1                 1                                            9.95                                                                        27.5.2010                          1        10        0                                          10               0                                                1        -1        0        0        0                                                         0
Sa vi ngs & Inves tments        Einstein   Chocolates for Zoe                          Personal        E      One-off              1                                    -96%                             2                 3                                                    25.00                                                               1.6.2010                           2        25        0                                                  25       0                                                1        -2        0        0        0                                                         0
Sa vi ngs & Inves tments                                                                               E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
Sa vi ngs & Inves tments                                                                               E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
                           0                                                                           E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Mi s cel l a neous                                                                             E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Mi s cel l a neous                                                                             E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1
        Mi s cel l a neous                                                                             E                                                                                                                   0                                                                                                                                                           0        0                                                                                                                      1

                                                                                                                           Sub total Miscellaneous          400                      -               -                 -




            ., Clive                                                                                                                                                                                                                                                                                                                      Page 26                                                                                                                                                                                                                                                                                                                  5/5/2012
Master Data & References                                       Home

Data Validation Lists
  Category                Person
  Income                  *All
  Daily Living            Einstein   From 'Start Here' Sheet
  Entertainment           Zoe        From 'Start Here' Sheet
  Health & Insurance                 From 'Start Here' Sheet
  Home Expenses
  Miscellaneous
  Rental Property
  Transportation
  Savings & Investments
Home


  Tags             Frequency    Budget Indicator     Graph
  *All             Weekly           I      Income    Monthly
  Bank             Bi-weekly        E      Expense   Annual
  Communications   Monthly          S      Savings   Jan
  Credit           Bi-monthly                        Feb
  Food             Quarterly                         Mar
  Health           Annually                          Apr
  Insurance        Half-year                         May
  Media            One-off                           Jun
  Personal                                           Jul
  Pet                                                Aug
  Property                                           Sep
  Retirement                                         Oct
  Salary                                             Nov
  Shares                                             Dec
  Utilities
  Vehicle
Currencies        Last updated:     14-Jun-10
Local Currency   Alt Currency     Exchange Rate
     GBP             GBP                1
     GBP             USD             1.45621
     GBP             INR             68.0454
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
     GBP
GBP
GBP
GBP
GBP

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:5/5/2012
language:English
pages:32