In this article

Banana Accounting Templates

Family Budget and Household accounts | Multi-currency

Universal
Double-Entry Accounting with foreign currencies
Private

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

Get started with this template

Template preview

Smith family

Basic Currency: EUR

Double-entry with foreign currencies

Accounts
Group Description Currency Gr
    BALANCE SHEET    
         
    ASSETS    
         
    Liquidity    
  1000 Cash Mary EUR 100
  1005 Cash George EUR 100
  1010 Current Account Bank EUR 100
  1015 Current account USD USD 100
  1020 Current Account PostBank EUR 100
100   Total Liquidity   10
         
    Other Assets    
  1500 Flat EUR 110
  1550 Furniture EUR 110
110   Total Other Assets   10
         
10   TOTAL ASSETS   00
         
    LIABILTIES    
  2010 Credit Card Mary EUR 20
  2015 Credit Card George EUR 20
  2020 Other short term debt EUR 20
  2100 Mortgage EUR 20
  2150 Profit or Loss carried forward EUR 20
210   Profit or Loss for the period EUR 20
  2200 Own Capital EUR 20
20   TOTAL LIABILITIES   00
         
         
    PROFIT & LOSS STATEMENT    
         
    REVENUE    
         
  4000 Salary Mary EUR 4
  4001 Salary George EUR 4
  4050 Other revenues EUR 4
  4100 Accessory activity EUR 4
4   TOTAL REVENUE   02
         
    EXPENSES    
         
    Fixed Costs    
  3000 Interest on Mortgage EUR 30
  3002 Light, Gas, Water EUR 30
  3004 Television, monthly fee EUR 30
  3006 Car insurance and stamp duty EUR 30
  3008 Health Insurance EUR 30
  3010 Telephone and Internet subscription EUR 30
  3012 Household Insurance EUR 30
  3014 Gym subscription EUR 30
  3016 Daily Newspaper subscription EUR 30
30   Total Fixed Costs   3
         
    Survival Costs    
  3200 Food Purchase EUR 32
  3202 Personal hygiene products EUR 32
  3204 Home hygiene products EUR 32
  3206 Clothing, shoes, etc. EUR 32
  3208 Medical expenses EUR 32
  3210 Pharmacy EUR 32
  3212 Taxes EUR 32
  3214 Petrol, Motorway tolls, Train, Bus EUR 32
  3216 Hairdresser EUR 32
  3218 Domestic Animals EUR 32
  3220 Schooling Fees EUR 32
32   Total Vital Costs   3
         
    Optional Costs    
  3400 Café, Restaurant, Take away EUR 34
  3402 Dancing, Night Club EUR 34
  3404 Cigarettes EUR 34
  3406 Beautician EUR 34
  3408 Gym EUR 34
  3410 Shopping EUR 34
  3412 Cosmetics EUR 34
34   Total Optional Costs   3
         
    Culture Costs    
  3600 Cinema EUR 36
  3602 Music EUR 36
  3604 Theatre EUR 36
  3606 Shows EUR 36
  3608 Books, newspapers and magazines EUR 36
36   Total Cultural Costs   3
         
    Extra Costs    
  3800 Travels, Holidays EUR 38
  3802 Gifts EUR 38
  3804 Various Home repairs EUR 38
  3806 Car repairs EUR 38
  3808 Medical expenses EUR 38
  3810 Household objects (furniture, utensils, linen ...) EUR 38
  3812 Babysitters and occasional domestic workers EUR 38
38   Total Extra Costs   3
         
    Other Activity    
  3900 Cost Accessory Activity EUR 39
  3910 Total Costs Accessory Activity EUR 39
39   Total Costs Other activities   3
         
3   TOTAL EXPENSES   02
         
02   RESULT FOR ACCOUNTING PERIOD   210
         
00   Difference should be = 0 (blank cell)    
         
         
    COST CENTERS    
         
  : Cost Centers by family member    
  :MA Mary EUR  
  :GEO George EUR  
  :SA Sarah EUR  
Exchange rates
Ref.Currency Currency Text
EUR USD Exchange Rate Euro/Usd

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