In this article

Banana Accounting Templates

Family Budget and Household accounts | Income & Expense

Universal
Income & Expense Accounting
Private

Create your family or personal budget to manage your Household accounts and save money, using this simple template suitable for anyone with Income & Expense accounting.

Get started with this template

Template documentation

This template is based on the management of Household accounts. In the Budget table you will be able to enter all the fixed and variable revenues and costs that you forecast to arise during the year. Reports can be generated automatically, at any time and will allow you to have an immediate overview of the accounts in their current and forecasted status.

Create your file

  • Create a new file, starting from this template (Template ID  +10685), using one of the methods explained. 
  • With the command File → File properties sets the period, the family name and the basic currency.
  • With the command File Save as save the file. It is useful to enter the family name and year in the file name.
    For example "family-Smith-2020.ac2".

 

initial liquidity balance

The initial balances for accounts in Assets and Liabilities are to be entered here in the Opening column.

Revenue, Expenses and Budget columns are filled automatically and updated by the program, as values are entered in the Budget and Transactions tables.

Categories for Revenues and Expenses are already set up in the Categories table. Revenues and Expenses can also be allocated by activity as well as Cost centers available to indicate the amount of expenses for each family member.

Categories can be adapted by adding other items of expenses or revenues, or you can alter their order.

Expenses are subdivided as follows in the Categories table:

Fixed costs

These are the costs that are recurring on a monthly or annual basis (ie. rent, train passes, buses, gym etc). These are easy to budget as the is usually known in advance.

Variable costs

These are costs that may vary and are differentiated as follows:

  • Vital (indispensable for living) - Included in this category are the customary expenses such as food, children, pharmacy, transport etc. 
  • Optional (not strictly indispensable) - Costs such as bars and restaurants, cosmetics, cigarettes etc.
  • Culture - such as cinema, books, travel etc.
  • Extra - expenses for exceptional events such as repairs, purchase of furniture, gifts etc.

Budget your expenses throughout the year

In order to project your expenses for the whole year, you can enter all income and expenses in the Budget table. 

As a fundamental rule for budgeting, check your disposable income and set your objectives to be achieved.

  • Determining income it is very simple as it is generally fixed (ex salary, pay);
  • Defining expenses might take a bit more thinking, but shouldn't be too complicated either. Start by entering Fixed Costs, for which amounts are known (rent, regular subscription and passes, insurance premiums etc). Next, review all other variable costs. In Categories you can determine those that are vital, optional, culture and extras. Reviewing figures for the previous year, you might get a good idea for a weighted calculation of amounts to be budgeted.

Enter Transactions for the day

Enter the date, description and the amount for Income or Expense. By entering the reference abbreviation of the cost centre (for family members) in the CC1 column, amounts allocated to each of them will be displayed. 

Get ready for the moment of truth at month end!

Month end will be the appropriate moment to check your accounts and ascertain wether you have achieved your objectives.

Banana accounting will automatically generate a Balance Sheet for your Household and all you need to do is to verify how much you may have spent or saved, by comparing the actual balances with the respective budgeted amounts.

Realizing in time of certain wastes can be useful to form good intentions for the following month. Being made aware of non budgeted expenses will help you implement adjustments for the following month.

  • Select Enhanced balance sheet with groups ... in the Account1 menu
  • Options for current or budgeted balances are available in the active window that is displayed. 
  • Click Period in the menu to indicate your desired period (month, quarter, semester, year).

 

Here's your Balance Sheet for end of January:

 

 

 

 

 

 

 

 

 

You now have a Balance Sheet of your Household accounting at your disposal in a transparent way, without the hassle of having to go through manual calculations. You will have a clear vision of available liquidity and how you have spent your money or made savings. 

If you have achieved your objectives, you're allowed to give yourself a pat on the back, otherwise you have the necessary information to make decisions about things to improve in your spending habits to achieve them.

Template preview

Smith family

Basic Currency: EUR

Income & Expense accounting

Accounts
Group Description Gr
    ESTATE  
       
    ASSETS  
       
    Liquidity  
  1000 Cash Mary 100
  1005 Cash George 100
  1010 Current Account Bank 100
  1020 Current Account PostBank 100
100   Total Liquidity 10
       
    Other Assets  
  1500 Flat 110
  1550 Furniture 110
110   Total Other Assets 10
       
10   TOTAL ASSETS PN
       
    LIABILTIES  
  2010 Credit Card Mary 20
  2015 Credit Card George 20
  2020 Other short term debt 20
  2100 Mortgage 20
20   TOTAL LIABILITIES PN
       
PN   ESTATE NET WORTH  
Categories
Group Category Description Gr
    PROFIT & LOSS STATEMENT  
       
    REVENUE  
       
  4000 Salary Mary 4
  4001 Salary George 4
  4050 Other revenues 4
  4100 Secondary occupation 4
4   TOTALE ENTRATE 00
       
    EXPENSES  
       
    Fixed Cost  
  3000 Rent or Interest on Mortgage 30
  3002 Light, Gas, Water 30
  3004 Television, monthly fee 30
  3006 Car insurance and stamp duty 30
  3008 Health Insurance 30
  3010 Telephone and Internet subscription 30
  3012 Household Insurance 30
  3014 Gym subscription 30
  3016 Daily Newspaper subscription 30
  3018 University Fees 30
30   Total Fixed Cost 3
       
    Vital Costs  
  3200 Food Purchase 32
  3202 Personal hygiene products 32
  3204 Home hygiene products 32
  3206 Clothing, shoes, etc. 32
  3208 Medical expenses 32
  3210 Pharmacy 32
  3212 Taxes 32
  3214 Petrol, Motorway tolls, Train, Bus 32
  3216 Hairdresser 32
  3218 Domestic Animals 32
  3220 Schooling fees 32
32   Total Vital Costs 3
       
    Optional Costs  
  3400 Café, Restaurant, Take away 34
  3402 Dancing, Night Club 34
  3404 Cigarettes 34
  3406 Beautician 34
  3408 Gym 34
  3410 Shopping 34
  3412 Cosmetics 34
34   Total Optional Costs 3
       
    Culture Costs  
  3600 Cinema 36
  3602 Music 36
  3604 Theatre 36
  3606 Shows 36
  3608 Books, newspapers and magazines 36
36   Total Cultural Costs 3
       
    Extra Costs  
  3800 Travels, Holidays 38
  3802 Gifts 38
  3804 Home repairs 38
  3806 Car repairs 38
  3808 Medical expenses 38
  3810 Household objects (furniture, utensils, linen ...) 38
  3812 Babysitters and occasional domestic workers 38
38   Total Extra Costs 3
       
    Other Activity  
    Costs Other activities 39
39   Total Costs Other activities 3
       
3   TOTAL EXPENSES 00
       
00   RESULT  
       
    Cost Centers by family member  
  .MA Expenses Mary  
  .GEO Expenses George  
  .SA Expenses Sarah  

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email