Notes to Advisors

Document Sample
Notes to Advisors Powered By Docstoc
					              EAST DORSET CAB - FINANCIAL STATEMENT

                                   Notes to advisors - December 2008

1. Substantial re-work to align with current bba reccommendations

2. New sheet 'Information' to collect client's details:
- Name and address
- Case ref number
- Date
- Caseworker initials
- Total number in household      }
- Number of children under 14    } These are used to calculate the trigger figures specific to this household
- number of children 14-18       }
- Number of vehicles             }
- Display trigger figures switch
- Display bureau address on Budget sheet

3. Sheet 'Income'
- Similar to previous version
- Client's information removed
- New assets box added
- Periodicity can be one of: weekly, 2 weekly, 4 weekly, monthly, quarterly, yearly

4. Sheet 'Expenditure'
- Similar to previous version
- Some groupings changed to align with trigger figures
- Trigger figures shown beside appropriate sub-total
- Periodicity as 'Income'

5. Sheet 'Debts'
- Changed to portrait layout
- Priority creditors increased to 8
- Input box for token payments which will override pro-rata calculations
- Token payments shown with cash remaining
- Rounded pro-rata payments switch
- Otherwise as previous version

6. Sheet 'Budget'
Similar to previous version
- Re-grouped to align with bba
- Client's and bureau's details automatically inserted

7. New sheet 'Creditors'
Pro-forma for collecting creditors' details as current paper version


8. New sheet 'Trigger'
- Contains published bba trigger figures
- Contains calculations for specific household
                                  Notes to advisors - February 2008

1. Working Tax Credit is now entered on 2 lines - the 'working' element and the 'childcare'
elements are separate.
2. Please remember to save the file in Bene & Budge with the naming convention of 'Client
surname then Initial - approx date - budget'
e.g. Bloggs J - Feb 08 - budget



                                  Notes to advisors - January 2007

1. Some terminology has been changed for consistency:
- the details of income, expenditure and debts are all part of the client's FINANCIAL STATEMENT,
- the summary sent to creditors is the BUDGET.

2. The only places where you can enter information are now shaded mauve, like this, and have a
dashed border like this. The rest are protected so that you cannot accidently overwrite them.
3. The sequential numbers for creditors are retained when you enter their names etc
4. The date printed has been removed from the bottom of the budget sent to creditors, so it's
important that you record the date the budget was compiled at the top of the Income page so that it will
be printed on the budget.
5. The word 'Signed' has been removed from the bottom of the summary budget sent to creditors, but
there is still space for the client to sign the budget.
6. A note of clarification has been added to the 'Benefits for Housing' item in Expenditure.

                                  Notes to advisors - October 2006

1. There is now space to add your INITIALS at the top of the Income sheet. They will also be printed
on the summary page sent to creditors.
2. Child Benefit and Child Tax Credit can now be entered separately.
3. Water and Sewerage can now be entered separately.
4. The BBA trigger figures from 13.15.14.10 have been added in comment boxes on the relevant cells
in the Expenditure sheet. They all have a little red mark in the top RH corner and will appear when the
mouse hovers over that cell.
4. Some columns have been widened to accommodate larger amounts.

                                    Notes to Advisors - June 2006

1. This Financial Statement is in line with the Common Financial Statement agreed by the MAT/BBA,
and so is in the format now expected by the majority of creditors.

2. It is spilt into different screens on which to record a Client's Income, Expenditure and Debts - see
the tabs at the bottom of this screen. The Summary page - the only one normally sent to creditors -
is created automatically from the information you enter on the other screens. Jan '07 - this page is
now called the Budget.
3. The breakdowns of income and expenditure are more detailed than in the old EDCAB Financial
Statement. This should result in more realistic summaries of each client's financial situation, and
hence more sustainable repayment regimes.
4. Information such as the client's name and address is copied automatically onto the other screens
so you only have to enter each piece of information once.
5. Jan '07 - this colour is no longer used to show which cells you can enter information into.
6. Each item of income and expenditure can be entered in either weekly, monthly or annual
amounts, and you have to put a W, M or Y in the adjacent column to show which it is. If you enter an
amount and don't show what the period is nothing will be added to the weekly or monthly columns.


7. Each part of this statement has to be printed invividually. The Income, Debts and Summary are on
one page each, the Expenditure is on 2 pages. Each shows the client's name.

8. Save the file in exactly the same way as for the old EDCAB financial staement - i.e in folder
Bene&Budge and with the client's CASE record. All the sections are stored together on one computer
file.
specific to this household
                                        FINANCIAL STATEMENT - INFORMATION


This sheet should not be shown to creditors         East Dorset Citizens Advice Bureau

                                                            Financial Statement 2009

       1. To compile the budget to help you manage your finances or to send to your creditors, you need to record information about your
       your income, your expenditure and your debts, selecting each of the first 4 tabs at the bottom of the screen in turn.

       2. On each screen you will need to enter your data in the cells that are shaded this colour.

       3. The summary budget - the only one which you need to send to your creditors - is created automatically from the data you enter i
       4 screens.

       4. To save the financial statement on your own computer click on File; Save As; then give an appropriate filename and select an ap
       folder in your computer in which to save it before clicking on Save.



       Your name(s)
       Your address
           "
           "
           "
           "
           "

       Date

       Number in household                                              Dependant children under 14
       Number of vehicles in household                                  Dependant children 14-18




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                                                                          6/1/2012
                                                         FINANCIAL STATEMENT - INFORMATION


         This sheet
Advice Bureau should not be shown to creditors

ment 2009

ur creditors, you need to record information about your household,
bs at the bottom of the screen in turn.

ed this colour.

 ors - is created automatically from the data you enter in the other


 As; then give an appropriate filename and select an appropriate




                  EDCABwebsite FS
                  02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                                   6/1/2012
                                   FINANCIAL STATEMENT - INCOME

This sheet should not be shown to creditors

       Your Name(s) and Address:


       Date:


       STAGE 1 - INCOME                                              Total Monthly Income

                                                   Amount    How often   Amount/wk Amount/mth Total/month


       Salary
        Client's earnings
        Partner's earnings

       Other Income
        Maintenance/Child Support paid to you
        Income from lodgers
        Income from non-dependents

       Pensions
        State Pension
        Occupational Pension
        Private pension
        War pension
        Partner's Pension
        Pension Credit

       Benefits
        Inc Spt/Job Seekers Allowance/ESA
        Child Benefit
        Child Tax Credit
        Working Tax Credit
        Working Tax Credit - childcare
        Benefits for maternity
        Benefits for widows and widowers
        Benefits for sickness and incapacity
        Benefits for disability and carers
        Housing Benefit
        Mortgage Interest PC/IS

                            Total Monthly Income


       ASSETS OR EQUITY                                     OTHER ASSETS
       House or Flat                                        Value of vehicle(s) less
       Total value of property(ies)                         HP outstanding)
       Mortgage outstanding                                 Savings
       Secured loans outstanding                            Other assets
                         Total property                                   Total other assets
                                                                    Total Assets and Equity


EDCABwebsite FS 02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                                                6/1/2012
                                          FINANCIAL STATEMENT - EXPENDITURE


This sheet should not be shown to creditors

       Your Name(s) and Address:


       Date:



       STAGE 2 - EXPENDITURE                                                 Total Monthly Expenditure

                                                                Amount       How often   Amount/wk   Amount/mth Total/month


       Housing Costs
         Rent
         Mortgage
         Other secured loans (2nd mortgage)
         Council Tax
         Mortgage Payment Protection Premium
         Ground Rent and Service Charge
         Contents Insurance
         Buildings Insurance
         Mortgage Endowment Policies/ISA
         Other housing costs*
         * If used, change this entry to your specific item of expenditure
       Utilities
         Gas
         Electricity
         Water
         Sewerage
         Coal/Oil/Calor gas/Wood

       Essential expenditure
         Court fines
         Adult care costs
         Childcare costs
         Maintenance/Child Support paid by Client
         HP/Conditional sale
         TV licence
         Pension and life insurance
         Other 1*
         Other 2*
         Other 3*
         * If used, change this entry to your specific item of expenditure
       Telephones
         Home telephone
         Mobile phone(s)
         Other




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                  Page 8 of 15                                                        6/1/2012
                                         FINANCIAL STATEMENT - EXPENDITURE


This sheet should not be shown to creditors




       Travel
         Public transport (work, school, shopping etc.)
         Other fares (e.g.Hospital Visits/taxis)
         Road Tax
         Insurance
         Petrol/Oil/Diesel
         MOT/Maintenance
         Breakdown/Recovery
         Parking charges/tolls
         Other

       Housekeeping
        Food/Milk
        Cleaning/Toiletries
        Papers/Magazines
        Cigarettes/Tobacco/Sweets
        Alcohol
        Nappies/Baby Items
        Laundry/Dry Cleaning
        Clothing/Footwear (inc School Uniform)
        Pet food
        Other

         Other
         School fees
         Dentist/prescriptions/glasses
         Health insurance
         Membership/Professional Subs
         Postage
         Hairdressing/Haircuts
         Cable, Satellite and Internet
         TV, video etc. rental
         Other appliance rentals
         Pub/Outings
         Lottery/pools etc.
         Hobbies (e.g.Gardening, Sport)
         Religious and Charitable giving
         Gifts (e.g. Christmas and Birthdays)
         Appliance repairs/maintenance
         Household maintenance
         Window Cleaning
         Maintenance Contracts
         Meals at work/school
         Pocket money and school trips
         Vet bills and pet insurance
         Other
         Other

                                                                         Total monthly expenditure




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                  Page 9 of 15                               6/1/2012
                                      FINANCIAL STATEMENT - EXPENDITURE


This sheet should not be shown to creditors




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls         Page 10 of 15            6/1/2012
                                                FINANCIAL STATEMENT - DEBTS


This sheet should not be shown to creditors

        Your Name(s) and Address:


        Date:



        Total Income/month
        Total Expenditure/month
        Total monthly money for all creditors
        Monthly payments on priority debts
        Money available for other creditors




        PRIORITY DEBTS                                                                         Payment   Time to
                                                                                     Balance     offer    repay
                                                                                      owed      /month    (y m)
        1
        2
        3
        4
        5
        6
        7
        8
                                                     Total owed for priority debts
                                                    Total priority debts repayment

        OTHER DEBTS                                                                            Payment   Time to
                                                                                     Balance     offer    repay
                                                                                      owed      /month    (y m)
        1
        2
        3
        4
        5
        6
        7
        8
        9
        10
        11
        12
        13
        14
        15
        16
        17
        18
        19
        20
        21
        22
        23
        24
        25
                                                       Total owed for other debts
                                                          Total monthly payment




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                 Page 11 of 15                                             6/1/2012
                                              FINANCIAL STATEMENT - DEBTS


This sheet should not be shown to creditors




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls              Page 12 of 15         6/1/2012
                                              FINANCIAL STATEMENT - DEBTS


This sheet should not be shown to creditors




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls              Page 13 of 15         6/1/2012
                                                 FINANCIAL STATEMENT - DEBTS


This sheet should not be shown to creditors




                                                            months       y     m




                                       rounded
                  pro-rata   rounded   min £1




EDCABwebsite FS
02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls                 Page 14 of 15             6/1/2012
                                                                        BUDGET FOR CREDITORS



            NAME AND ADDRESS                                                       THE HOUSEHOLD

                                                                                   Total number of people in the household
                                                                                   Number of dependant children under 14
                                                                                   Number of dependant children aged 14-18

                                                                                   Number of vehicles

                                                                                   Date budget compiled


            INCOME                                                                 PRIORITY DEBTS                                                       Payment
                                                                        Monthly                                                               Balance   Offer/mth

            Wages/Salary                                                            1
            Other Income                                                            2
            Pensions                                                                3
            Benefits                                                                4
                                                                                    5
                     income
            Monthly income
                                                                                    6
                                                                                    7
                                                                                    8
            EXPENDITURE                                                            Total owed for priority debts
                                                                        Monthly    Total priority debts monthly repayment
            Rent
            Ground rent and service charges
            Mortgage                                                               OTHER DEBTS                                                Balance   Payment
            Other secured loans                                                    Creditor                                                    owed     offer/mth
            Mortgage endowment and MPPI                                            1
            Building and contents insurance                                        2
            Other housing costs*                                                   3
            Pension and life insurance                                             4
            Council tax                                                            5
            Gas                                                                    6
            Electricity                                                            7
            Water/sewerage                                                         8
            Other utilities (coal, oil, calor gas)                                 9
            TV licence                                                             10
            Magistrates court fines                                                11
            Maintenance or child support                                           12
            Hire purchase/conditional sale                                         13
            Childcare costs                                                        14
            Adult care costs                                                       15
            Other 1*                                                               16
            Other 2*                                                               17
            Other 3*                                                               18
            Total phones                                                           19
            Total travel                                                           20
            Total housekeeping                                                     21
            Total other expenditure                                                22
                                                                                   23
                                                                                   24
            Total Monthly Expenditure
                                                                                   25

            Total available for creditors                                          Total owed for non-priority debts
            Total available for non-priority creditors                             Total non-priority debts monthly repayment


            I/we haveconsidered the use of any assets to make lump sum payments.   This is an accurate record of my/our financial position


                            Signed………………………………………………..                             Signed………………………………………………..                                Date…………………………….



EDCABwebsite FS - 02778cbf-4f14-4a5c-adf6-8cab418b78ba.xls

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:6/2/2012
language:
pages:15