In this article

    Double-Entry Accounting for a Family Budget and Household accounts (foreign currencies)

    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.

    Open in Banana WebApp

    Run Banana Accounting Plus on your browser without any installation. Customize the template, enter the transactions and save the file on your computer.

    Open template in WebApp Open tutorial in WebApp

    Template preview

    Smith family

    Basic Currency: EUR

    Double-entry with foreign currencies

    Table: Accounts
    Group Description Currency Sum In
        BALANCE SHEET    
             
        ASSETS    
             
        Liquidity    
      Cash Mary Cash Mary EUR Liquidity
      Cash George Cash George EUR Liquidity
      Bank EUR Current Account Bank EUR EUR Liquidity
      Bank USD Current Account Bank USD USD Liquidity
      Post Current Account Post EUR Liquidity
    Liquidity   Total Liquidity   Assets
             
        Other Assets    
      Flat Flat EUR Other Assets
      Furniture Furniture EUR Other Assets
    Other Assets   Total Other Assets   Assets
             
    Assets   TOTAL ASSETS   Difference
             
        LIABILTIES    
      Card Mary Credit Card Mary EUR Liabilities
      Card George Credit Card George EUR Liabilities
      Other debts Other short term debts EUR Liabilities
      Mortgage Mortgage EUR Liabilities
      Carried forward Profit or Loss carried forward EUR Liabilities
    Debts   Profit or Loss for the period EUR Liabilities
      Own capital Own Capital EUR Liabilities
    Liabilities   TOTAL LIABILITIES   Difference
             
             
        PROFIT & LOSS STATEMENT    
             
        REVENUE    
             
      Salary Mary Salary Mary EUR Revenue
      Salary George Salary George EUR Revenue
      Other revenues Other revenues EUR Revenue
      Accessory revenues Accessory activity EUR Revenue
    Revenue   TOTAL REVENUE   Result
             
        EXPENSES    
             
        Fixed Costs    
      Rent Rent or Interest on Mortgage EUR Fixed costs
      Energy Light, Gas, Water EUR Fixed costs
      Television Television, monthly fee EUR Fixed costs
      Car insurance Car insurance and stamp duty EUR Fixed costs
      Health insurance Health Insurance EUR Fixed costs
      Telephone Telephone and Internet subscription EUR Fixed costs
      Household insurance Household Insurance EUR Fixed costs
      Gym Gym subscription EUR Fixed costs
      Newspaper Daily Newspaper subscription EUR Fixed costs
      University University fees Sarah EUR Fixed costs
    Fixed costs   Total Fixed Costs   Expenses
             
        Vital Costs    
      Food Food Purchase EUR Vital costs
      Hygiene Personal hygiene products EUR Vital costs
      Home products Home hygiene products EUR Vital costs
      Clothing Clothing, shoes, etc. EUR Vital costs
      Medical Medical expenses EUR Vital costs
      Pharmacy Pharmacy EUR Vital costs
      Taxes Taxes EUR Vital costs
      Travel Petrol, Motorway tolls, Train, Bus EUR Vital costs
      Hairdresser Hairdresser EUR Vital costs
      Animals Domestic Animals EUR Vital costs
      School Schooling Fees EUR Vital costs
    Vital costs   Total Vital Costs   Expenses
             
        Optional Costs    
      Restaurant Café, Restaurant, Take away EUR Optional costs
      Dancing Dancing, Night Club EUR Optional costs
      Cigarettes Cigarettes EUR Optional costs
      Beautician Beautician EUR Optional costs
      Shopping Shopping EUR Optional costs
      Cosmetics Cosmetics EUR Optional costs
    Optional costs   Total Optional Costs   Expenses
             
        Culture Costs    
      Cinema Cinema EUR Cultural costs
      Music Music EUR Cultural costs
      Theatre Theatre EUR Cultural costs
      Shows Shows EUR Cultural costs
      Books Books, newspapers and magazines EUR Cultural costs
    Cultural costs   Total Cultural Costs   Expenses
             
        Extra Costs    
      Holidays Travels, Holidays EUR Extra costs
      Gifts Gifts EUR Extra costs
      Home repairs Various Home repairs EUR Extra costs
      Car repairs Car repairs EUR Extra costs
      Household objects Household objects (furniture, utensils, linen ...) EUR Extra costs
      Babysitter Babysitters and occasional domestic workers EUR Extra costs
    Extra costs   Total Extra Costs   Expenses
             
        Other Activity    
      Accessory cost Cost Accessory Activity EUR Accessory
      Exchange Exchange rate differences EUR Accessory
    Accessory   Total Costs Other activities   Expenses
             
    Expenses   TOTAL EXPENSES   Result
             
    Result   RESULT FOR ACCOUNTING PERIOD   Debts
             
    Difference   Difference should be = 0 (blank cell)    
             
             
        SEGMENTS    
             
      : Segments by family member    
      :MA Mary EUR Members
      :GEO George EUR Members
      :SA Sarah EUR Members
    Members   Total family members    
    Table: Exchange rates
    Ref.Currency Currency Text
    EUR USD Exchange Rate Euro/Usd
    Tell us how we can help you better
    If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

    Share this article: Twitter | Facebook | LinkedIn | Email