In this article

    Serial Invoice QR Code from Excel Data List

    Serial Invoice QR Code from Excel Data List

    With this extension, you can quickly print a series of invoices with Swiss QR Code based on a data list in Excel. Ideal for sending batch invoices to clients or members of an association.

    The Extensions are additional programs that extend the functionalities of Banana Accounting Plus.
    This extension allows you to create Swiss QR invoices for multiple recipients with the possibility of inserting a customised letter text. Data can be taken from Excel.

    In this article

      Double-Entry Accounting for a Corporation with foreign currencies and VAT/Sales tax

      Double-Entry Accounting for a Corporation with foreign currencies and VAT/Sales tax

      Universal
      Double-Entry Accounting with vat/sales tax and foreign currencies
      Business

      Start easily and FOR FREE the double-entry accounting, with foreign currencies and VAT management, of your Corporation and get immediately the Income Statement and the Balance Sheet. This ready-to-use generic template can be adapted according to your needs, to also manage the accounting of your company, sole proprietorship, partnership or small or medium business. Banana Accounting Plus is a professional software that is very intuitive and fast to use because it's similar to Excel. If you make mistakes you can always correct until everything is perfect.

      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

      Company XX

      Basic Currency: USD

      Double-entry with foreign currencies and VAT/Sales tax

      Table: Accounts
      Group Description Currency Sum In
          BALANCE SHEET    
               
          ASSETS    
               
          Bank Accounts    
        Business checking USD Business checking account Dollars (USD) USD Bank
        Business checking EUR Business checking account Euro (EUR) EUR Bank
        Business checking GBP Business checking account Pounds (GBP) GBP Bank
        Business savings Business savings account USD Bank
        Payroll checking Payroll checking USD Bank
        Cash Petty Cash - Out of Pocket expenses USD Bank
        Barter Barter checking USD Bank
      Bank   Total Bank Accounts   Assets
               
          Accounts receivable    
      Customers   Accounts receivable (Customers' register)   Receivable
      Receivable   Total Accounts Receivable   Assets
               
          Current Assets    
        Inventory Inventory USD C-Assets
        Undeposited Funds Undeposited Funds USD C-Assets
      C-Assets   Total Current Assets   Assets
               
          Fixed Assets    
        Equipment Equipment USD Fixed
        Furniture Furniture and Fixtures USD Fixed
        Vehicles Vehicles USD Fixed
        Acc-Depreciation Accumulated Depreciation USD Fixed
      Fixed   Total Fixed Assets   Assets
               
          Other Assets    
        Start up Start up costs (accountants use) USD Other
        Acc-Amortization Accumulated Amortization USD Other
        Notes Receivable 1 Notes Receivable 1 (officer, owner, related party) USD Other
        Notes Receivable 2 Notes Receivable 2 USD Other
      Other   Total Other Assets   Assets
               
      Assets   TOTAL ASSETS   00
               
          LIABILITIES    
               
          Accounts payable    
      Suppliers   Suppliers' register   Payable
      Payable   Total Accounts Payable   Liabilities
               
          Credit Cards used to purchase    
        American American Express - Credit card loan USD Cards
        Visa Visa - Credit card loan USD Cards
      Cards   Total Credit Cards   Liabilities
               
          Current Liabilities    
        Accrued Accrued Expenses USD C-Liabilities
        Payroll tax payable Payroll Tax Payable USD C-Liabilities
        Sales tax payable Sales Tax Payable USD C-Liabilities
        Deposits Deposits from Customers USD C-Liabilities
        Portion long term Current portion of long term liabilities USD C-Liabilities
        VAT due VAT due USD C-Liabilities
        VAT Automatically calculated VAT USD C-Liabilities
      C-Liabilities   Total Current Liabilities   Liabilities
               
          Long Term Liabilities    
        Loan Bank loan USD Long term
        Notes payable 1 Notes payable1 USD Long term
        Notes payable 2 Notes payable2 USD Long term
      Long term   Total Long Term Liabilities   Liabilities
               
      Liabilities   TOTAL LIABILITIES   00
               
          EQUITY    
        Capital Capital stock / Capital partner USD Equity
        Additional capital Additional Capital Contributed / Additional Paid in Capital USD Equity
        Retained earnings Retained earnings USD Equity
        Opening equity Opening balance equity USD Equity
        Shareholder 1 Distributions shareholder 1 / Dividends / Draws USD Equity
        Brought forward Profit or Loss brought forward USD Equity
      Profit or Loss   Profit or Loss of the current year USD Equity
      Equity   TOTAL EQUITY   00
               
               
          PROFIT/LOSS STATEMENT    
               
          INCOME    
        Services Income from services USD Income
        Products sold Income from parts / products sold USD Income
        Sales write offs Sales write offs USD Income
      Income   TOTAL INCOME   Gross Profit
               
          COST OF GOODS SOLD    
        Materials Materials, Direct product/service costs USD Cost Goods
        Labor Labor costs USD Cost Goods
        Outside services Outside services / Subcontractors USD Cost Goods
        Supplies Supplies costs USD Cost Goods
        Small tools Small tools USD Cost Goods
      Cost Goods   TOTAL COST OF GOODS SOLD   Gross Profit
               
      Gross Profit   GROSS PROFIT   Ordinary
               
          EXPENSES    
        Advertising Advertising, promotion, marketing costs USD Expenses
        Automobile Automobile expenses USD Expenses
        Bank charges Bank service charges USD Expenses
        Cleaning Cleaning USD Expenses
        Contributions Contributions USD Expenses
        Depreciation Depreciation expense USD Expenses
        Discounts Discounts taken USD Expenses
        Subscriptions Dues and subscriptions USD Expenses
        Insurance Auto Insurance, Life, Medical USD Expenses
        Interest expense Interest expense USD Expenses
        Licenses Business licenses and permits USD Expenses
        Maintenance Maintenance and repairs USD Expenses
        Meals Meals and entertainment USD Expenses
        Merchant fees Merchant credit card fees USD Expenses
        Office Office expenses (computer, postage, delivery, supplies) USD Expenses
        Payroll taxes Payroll taxes USD Expenses
        Professional fees Professional fees USD Expenses
        Rent Rental Payments USD Expenses
        Salaries Salaries USD Expenses
        Telephone Telephone, Fax USD Expenses
        Travel Travel USD Expenses
        Utilities Utilities USD Expenses
      Expenses   TOTAL EXPENSES   Ordinary
               
      Ordinary   NET ORDINARY INCOME   Result
               
          OTHER INCOME    
        Interest income Interest income USD O-Income
        Profit exchange Profit on Foreign Exchange USD O-Income
      O-Income   TOTAL OTHER INCOME   Result
               
          OTHER EXPENSE    
        Ask accountant Ask accountant USD O-Expense
        Loss exchange Loss on Foreign Exchange USD O-Expense
      O-Expense   TOTAL OTHER EXPENSE   Result
               
      Result   NET INCOME ( Profit(-) Loss(+) )   Profit or Loss
               
      00   Difference should be = 0 (blank cell)    
               
               
          CUSTOMERS/SUPPLIERS REGISTER    
               
          Customers    
        Cus-Redford Redford Inc USD TOTC
        Cus-Smith John Smith USD TOTC
        Cus-Black Simon Black GBP TOTC
      TOTC   Total Customers   Customers
               
          Suppliers    
        Sup-Johnson Johnson Inc EUR TOTS
        Sup-Marble Marble Inc USD TOTS
        Sup-Taylor Mary Taylor USD TOTS
      TOTS   Total Suppliers   Suppliers
               
               
          COST CENTERS    
               
          Products    
        .Product A Product A USD Products
        .Product B Product B USD Products
        .Product C Product C USD Products
      Products   Total Products    
               
          Projects    
        ;Project A Project A USD Projects
        ;Project B Project B USD Projects
      Projects   Total Projects    
               
               
          SEGMENTS    
               
          Branches    
        :BA Branch A USD Branches
        :BB Branch B USD Branches
      Branches   Total Branches    
               
      Table: VAT codes
      VAT Code Description %VAT
           
        VAT due  
      S0 VAT exempt sales  
      SE Foreign sales exempt  
      S5 Sales at 5% 5.00
      S10 Sales at 10% 10.00
      SD5 Discount on sales at 5% 5.00
      SD10 Discount on sales at 10% 10.00
           
        Recoverable VAT  
      P5 Purchase goods at 5% 5.00
      P10 Purchase goods at 10% 10.00
      PD5 Discount on purchases at 5% 5.00
      PD10 Discount on purchases at 10% 10.00
           
      I5 Purchases for investment or use 5% 5.00
      I10 Purchases for investment or use 10% 10.00
      ID5 Discount on purchases for investment or use 5% 5.00
      ID10 Discount on purchases for investment or use 10% 10.00
           
        TOTAL  
      Table: Exchange rates
      Ref.Currency Currency Text
      USD EUR Euro
      USD GBP Pound Sterling
           
      In this article

        Double-Entry Accounting for a Corporation with foreign currencies

        Double-Entry Accounting for a Corporation with foreign currencies

        Universal
        Double-Entry Accounting with foreign currencies
        Business

        Start easily and FOR FREE the double-entry accounting with foreign currencies of your Corporation and get immediately the Income Statement and the Balance Sheet. This ready-to-use generic template can be adapted according to your needs, to also manage the accounting of your company, sole proprietorship, partnership or small or medium business. Banana Accounting Plus is a professional software that is very intuitive and fast to use because it's similar to Excel. If you make mistakes you can always correct until everything is perfect.

        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

        Company XX

        Basic Currency: USD

        Double-entry with foreign currencies

        Table: Accounts
        Group Description Currency Sum In
            BALANCE SHEET    
                 
            ASSETS    
                 
            Bank Accounts    
          Business checking USD Business checking account Dollars (USD) USD Bank
          Business checking EUR Business checking account Euro (EUR) EUR Bank
          Business checking GBP Business checking account Pounds (GBP) GBP Bank
          Business savings Business savings account USD Bank
          Payroll checking Payroll checking USD Bank
          Cash Petty Cash - Out of Pocket expenses USD Bank
          Barter Barter checking USD Bank
        Bank   Total Bank Accounts   Assets
                 
            Accounts receivable    
        Customers   Accounts receivable (Customers' register)   Receivable
        Receivable   Total Accounts Receivable   Assets
                 
            Current Assets    
          Inventory Inventory USD C-Assets
          Undeposited Funds Undeposited Funds USD C-Assets
        C-Assets   Total Current Assets   Assets
                 
            Fixed Assets    
          Equipment Equipment USD Fixed
          Furniture Furniture and Fixtures USD Fixed
          Vehicles Vehicles USD Fixed
          Acc-Depreciation Accumulated Depreciation USD Fixed
        Fixed   Total Fixed Assets   Assets
                 
            Other Assets    
          Start up Start up costs (accountants use) USD Other
          Acc-Amortization Accumulated Amortization USD Other
          Notes Receivable 1 Notes Receivable 1 (officer, owner, related party) USD Other
          Notes Receivable 2 Notes Receivable 2 USD Other
        Other   Total Other Assets   Assets
                 
        Assets   TOTAL ASSETS   00
                 
            LIABILITIES    
                 
            Accounts payable    
        Suppliers   Suppliers' register   Payable
        Payable   Total Accounts Payable   Liabilities
                 
            Credit Cards used to purchase    
          American American Express - Credit card loan USD Cards
          Visa Visa - Credit card loan USD Cards
        Cards   Total Credit Cards   Liabilities
                 
            Current Liabilities    
          Accrued Accrued Expenses USD C-Liabilities
          Payroll tax payable Payroll Tax Payable USD C-Liabilities
          Sales tax payable Sales Tax Payable USD C-Liabilities
          Deposits Deposits from Customers USD C-Liabilities
          Portion long term Current portion of long term liabilities USD C-Liabilities
        C-Liabilities   Total Current Liabilities   Liabilities
                 
            Long Term Liabilities    
          Loan Bank loan USD Long term
          Notes payable 1 Notes payable1 USD Long term
          Notes payable 2 Notes payable2 USD Long term
        Long term   Total Long Term Liabilities   Liabilities
                 
        Liabilities   TOTAL LIABILITIES   00
                 
            EQUITY    
          Capital Capital stock / Capital partner USD Equity
          Additional capital Additional Capital Contributed / Additional Paid in Capital USD Equity
          Retained earnings Retained earnings USD Equity
          Opening equity Opening balance equity USD Equity
          Shareholder 1 Distributions shareholder 1 / Dividends / Draws USD Equity
          Brought forward Profit or Loss brought forward USD Equity
        Profit or Loss   Profit or Loss of the current year USD Equity
        Equity   TOTAL EQUITY   00
                 
                 
            PROFIT/LOSS STATEMENT    
                 
            INCOME    
          Services Income from services USD Income
          Products sold Income from parts / products sold USD Income
          Sales write offs Sales write offs USD Income
        Income   TOTAL INCOME   Gross Profit
                 
            COST OF GOODS SOLD    
          Materials Materials, Direct product/service costs USD Cost Goods
          Labor Labor costs USD Cost Goods
          Outside services Outside services / Subcontractors USD Cost Goods
          Supplies Supplies costs USD Cost Goods
          Small tools Small tools USD Cost Goods
        Cost Goods   TOTAL COST OF GOODS SOLD   Gross Profit
                 
        Gross Profit   GROSS PROFIT   Ordinary
                 
            EXPENSES    
          Advertising Advertising, promotion, marketing costs USD Expenses
          Automobile Automobile expenses USD Expenses
          Bank charges Bank service charges USD Expenses
          Cleaning Cleaning USD Expenses
          Contributions Contributions USD Expenses
          Depreciation Depreciation expense USD Expenses
          Discounts Discounts taken USD Expenses
          Subscriptions Dues and subscriptions USD Expenses
          Insurance Auto Insurance, Life, Medical USD Expenses
          Interest expense Interest expense USD Expenses
          Licenses Business licenses and permits USD Expenses
          Maintenance Maintenance and repairs USD Expenses
          Meals Meals and entertainment USD Expenses
          Merchant fees Merchant credit card fees USD Expenses
          Office Office expenses (computer, postage, delivery, supplies) USD Expenses
          Payroll taxes Payroll taxes USD Expenses
          Professional fees Professional fees USD Expenses
          Rent Rental Payments USD Expenses
          Salaries Salaries USD Expenses
          Telephone Telephone, Fax USD Expenses
          Travel Travel USD Expenses
          Utilities Utilities USD Expenses
        Expenses   TOTAL EXPENSES   Ordinary
                 
        Ordinary   NET ORDINARY INCOME   Result
                 
            OTHER INCOME    
          Interest income Interest income USD O-Income
          Profit exchange Profit on Foreign Exchange USD O-Income
        O-Income   TOTAL OTHER INCOME   Result
                 
            OTHER EXPENSE    
          Ask accountant Ask accountant USD O-Expense
          Loss exchange Loss on Foreign Exchange USD O-Expense
        O-Expense   TOTAL OTHER EXPENSE   Result
                 
        Result   NET INCOME ( Profit(-) Loss(+) )   Profit or Loss
                 
        00   Difference should be = 0 (blank cell)    
                 
                 
            CUSTOMERS/SUPPLIERS REGISTER    
                 
            Customers    
          Cus-Redford Redford Inc USD TOTC
          Cus-Smith John Smith USD TOTC
          Cus-Black Simon Black GBP TOTC
        TOTC   Total Customers   Customers
                 
            Suppliers    
          Sup-Johnson Johnson Inc EUR TOTS
          Sup-Marble Marble Inc USD TOTS
          Sup-Taylor Mary Taylor USD TOTS
        TOTS   Total Suppliers   Suppliers
                 
                 
            COST CENTERS    
                 
            Products    
          .Product A Product A USD Products
          .Product B Product B USD Products
          .Product C Product C USD Products
        Products   Total Products    
                 
            Projects    
          ;Project A Project A USD Projects
          ;Project B Project B USD Projects
        Projects   Total Projects    
                 
                 
            SEGMENTS    
                 
            Branches    
          :BA Branch A USD Branches
          :BB Branch B USD Branches
        Branches   Total Branches    
                 
        Table: Exchange rates
        Ref.Currency Currency Text
        USD EUR Euro
        USD GBP Pound Sterling
             
        In this article

          Income & Expense Accounting for a Corporation

          Income & Expense Accounting for a Corporation

          Universal
          Income & Expense Accounting
          Business

          Start easily and FOR FREE the income/expense accounting of your Corporation and get immediately the Income Statement and the Balance Sheet. The income and expense system is also ideal for those with limited accounting knowledge. This ready-to-use generic template can be adapted according to your needs, to also manage the accounting of your company, sole proprietorship, partnership or small or medium business. Banana Accounting Plus is a professional software that is very intuitive and fast to use because it's similar to Excel. If you make mistakes you can always correct until everything is perfect.

          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

          Company XX

          Table: Accounts
          Group Description Sum In
              BALANCE SHEET  
                 
              ASSETS  
                 
              Bank Accounts  
            Business checking Business checking account Bank
            Business savings Business savings account Bank
            Payroll checking Payroll checking Bank
            Cash Petty Cash - Out of Pocket expenses Bank
            Barter Barter checking Bank
          Bank   Total Bank Accounts Assets
                 
              Accounts receivable  
          Customers   Accounts receivable (Customers' register) Receivable
          Receivable   Total Accounts Receivable Assets
                 
              Current Assets  
            Inventory Inventory C-Assets
            Undeposited Funds Undeposited Funds C-Assets
          C-Assets   Total Current Assets Assets
                 
              Fixed Assets  
            Equipment Equipment Fixed
            Furniture Furniture and Fixtures Fixed
            Vehicles Vehicles Fixed
            Acc-Depreciation Accumulated Depreciation Fixed
          Fixed   Total Fixed Assets Assets
                 
              Other Assets  
            Start up Start up costs (accountants use) Other
            Acc-Amortization Accumulated Amortization Other
            Notes Receivable 1 Notes Receivable 1 (officer, owner, related party) Other
            Notes Receivable 2 Notes Receivable 2 Other
          Other   Total Other Assets Assets
                 
          Assets   TOTAL ASSETS Net
                 
              LIABILITIES  
                 
              Accounts payable  
          Suppliers   Suppliers' register Payable
          Payable   Total Accounts Payable Liabilities
                 
              Credit Cards used to purchase  
            American American Express - Credit card loan Cards
            Visa Visa - Credit card loan Cards
          Cards   Total Credit Cards Liabilities
                 
              Current Liabilities  
            Accrued Accrued Expenses C-Liabilities
            Payroll tax payable Payroll Tax Payable C-Liabilities
            Sales tax payable Sales Tax Payable C-Liabilities
            Deposits Deposits from Customers C-Liabilities
            Portion long term Current portion of long term liabilities C-Liabilities
          C-Liabilities   Total Current Liabilities Liabilities
                 
              Long Term Liabilities  
            Loan Bank loan Long term
            Notes payable 1 Notes payable1 Long term
            Notes payable 2 Notes payable2 Long term
          Long term   Total Long Term Liabilities Liabilities
                 
          Liabilities   TOTAL LIABILITIES Net
                 
              EQUITY  
            Capital Capital stock / Capital partner Equity
            Additional capital Additional Capital Contributed / Additional Paid in Capital Equity
            Retained earnings Retained earnings Equity
            Opening equity Opening balance equity Equity
            Shareholder 1 Distributions shareholder 1 / Dividends / Draws Equity
            Brought forward Profit or Loss brought forward Equity
          Equity   TOTAL EQUITY Net
                 
          Net   NET ASSETS  
                 
                 
              CUSTOMERS REGISTER  
            Cus-Redford Redford Inc TOTC
            Cus-Smith John Smith TOTC
            Cus-Black Simon Black TOTC
          TOTC   Total Customers Customers
                 
              SUPPLIERS REGISTER  
            Sup-Johnson Johnson Inc TOTS
            Sup-Marble Marble Inc TOTS
            Sup-Taylor Mary Taylor TOTS
          TOTS   Total Suppliers Suppliers
                 
                 
          Table: Categories
          Group Category Description Sum In
              PROFIT/LOSS STATEMENT  
                 
                 
              INCOME  
            Services Income from services Income
            Products sold Income from parts / products sold Income
            Sales write offs Sales write offs Income
          Income   TOTAL INCOME Gross Profit
                 
              COST OF GOODS SOLD  
            Materials Materials, Direct product/service costs Cost Goods
            Labor Labor costs Cost Goods
            Outside services Outside services / Subcontractors Cost Goods
            Supplies Supplies costs Cost Goods
            Small tools Small tools Cost Goods
          Cost Goods   TOTAL COST OF GOODS SOLD Gross Profit
                 
          Gross Profit   GROSS PROFIT Ordinary
                 
              EXPENSES  
            Advertising Advertising, promotion, marketing costs Expenses
            Automobile Automobile expenses Expenses
            Bank charges Bank service charges Expenses
            Cleaning Cleaning Expenses
            Contributions Contributions Expenses
            Depreciation Depreciation expense Expenses
            Discounts Discounts taken Expenses
            Subscriptions Dues and subscriptions Expenses
            Insurance Auto Insurance, Life, Medical Expenses
            Interest expense Interest expense Expenses
            Licenses Business licenses and permits Expenses
            Maintenance Maintenance and repairs Expenses
            Meals Meals and entertainment Expenses
            Merchant fees Merchant credit card fees Expenses
            Office Office expenses (computer, postage, delivery, supplies) Expenses
            Payroll taxes Payroll taxes Expenses
            Professional fees Professional fees Expenses
            Rent Rental Payments Expenses
            Salaries Salaries Expenses
            Telephone Telephone, Fax Expenses
            Travel Travel Expenses
            Utilities Utilities Expenses
          Expenses   TOTAL EXPENSES Ordinary
                 
          Ordinary   NET ORDINARY INCOME Result
                 
              OTHER INCOME  
            Interest income Interest income O-Income
          O-Income   TOTAL OTHER INCOME Result
                 
              OTHER EXPENSE  
            Ask accountant Ask accountant O-Expense
          O-Expense   TOTAL OTHER EXPENSE Result
                 
          Result   NET INCOME ( Profit(-) Loss(+) )  
                 
                 
              COST CENTERS  
                 
              Products  
            .Product A Product A Products
            .Product B Product B Products
            .Product C Product C Products
          Products   Total Products  
                 
              Projects  
            ;Project A Project A Projects
            ;Project B Project B Projects
          Projects   Total Projects  
                 
                 
              SEGMENTS  
                 
              Branches  
            :BA Branch A Branches
            :BB Branch B Branches
          Branches   Total Branches  
                 
                 
          In this article

            Double-Entry Accounting for a Corporation with VAT/Sales tax

            Double-Entry Accounting for a Corporation with VAT/Sales tax

            Universal
            Double-Entry Accounting with vat/sales tax
            Business

            Start easily and FOR FREE the double-entry accounting, with VAT management, of your Corporation and get immediately the Income Statement and the Balance Sheet. This ready-to-use generic template can be adapted according to your needs, to also manage the accounting of your company, sole proprietorship, partnership or small or medium business. Banana Accounting Plus is a professional software that is very intuitive and fast to use because it's similar to Excel. If you make mistakes you can always correct until everything is perfect.

            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

            Company XX

            Table: Accounts
            Group Description Sum In
                BALANCE SHEET  
                   
                ASSETS  
                   
                Bank Accounts  
              Business checking Business checking account Bank
              Business savings Business savings account Bank
              Payroll checking Payroll checking Bank
              Cash Petty Cash - Out of Pocket expenses Bank
              Barter Barter checking Bank
            Bank   Total Bank Accounts Assets
                   
                Accounts receivable  
            Customers   Accounts receivable (Customers' register) Receivable
            Receivable   Total Accounts Receivable Assets
                   
                Current Assets  
              Inventory Inventory C-Assets
              Undeposited Funds Undeposited Funds C-Assets
            C-Assets   Total Current Assets Assets
                   
                Fixed Assets  
              Equipment Equipment Fixed
              Furniture Furniture and Fixtures Fixed
              Vehicles Vehicles Fixed
              Acc-Depreciation Accumulated Depreciation Fixed
            Fixed   Total Fixed Assets Assets
                   
                Other Assets  
              Start up Start up costs (accountants use) Other
              Acc-Amortization Accumulated Amortization Other
              Notes Receivable 1 Notes Receivable 1 (officer, owner, related party) Other
              Notes Receivable 2 Notes Receivable 2 Other
            Other   Total Other Assets Assets
                   
            Assets   TOTAL ASSETS 00
                   
                LIABILITIES  
                   
                Accounts payable  
            Suppliers   Suppliers' register Payable
            Payable   Total Accounts Payable Liabilities
                   
                Credit Cards used to purchase  
              American American Express - Credit card loan Cards
              Visa Visa - Credit card loan Cards
            Cards   Total Credit Cards Liabilities
                   
                Current Liabilities  
              Accrued Accrued Expenses C-Liabilities
              Payroll tax payable Payroll Tax Payable C-Liabilities
              Sales tax payable Sales Tax Payable C-Liabilities
              Deposits Deposits from Customers C-Liabilities
              Portion long term Current portion of long term liabilities C-Liabilities
              VAT due VAT due C-Liabilities
              VAT Automatically calculated VAT C-Liabilities
            C-Liabilities   Total Current Liabilities Liabilities
                   
                Long Term Liabilities  
              Loan Bank loan Long term
              Notes payable 1 Notes payable1 Long term
              Notes payable 2 Notes payable2 Long term
            Long term   Total Long Term Liabilities Liabilities
                   
            Liabilities   TOTAL LIABILITIES 00
                   
                EQUITY  
              Capital Capital stock / Capital partner Equity
              Additional capital Additional Capital Contributed / Additional Paid in Capital Equity
              Retained earnings Retained earnings Equity
              Opening equity Opening balance equity Equity
              Shareholder 1 Distributions shareholder 1 / Dividends / Draws Equity
              Brought forward Profit or Loss brought forward Equity
            Profit or Loss   Profit or Loss of the current year Equity
            Equity   TOTAL EQUITY 00
                   
                   
                PROFIT/LOSS STATEMENT  
                   
                INCOME  
              Services Income from services Income
              Products sold Income from parts / products sold Income
              Sales write offs Sales write offs Income
            Income   TOTAL INCOME Gross Profit
                   
                COST OF GOODS SOLD  
              Materials Materials, Direct product/service costs Cost Goods
              Labor Labor costs Cost Goods
              Outside services Outside services / Subcontractors Cost Goods
              Supplies Supplies costs Cost Goods
              Small tools Small tools Cost Goods
            Cost Goods   TOTAL COST OF GOODS SOLD Gross Profit
                   
            Gross Profit   GROSS PROFIT Ordinary
                   
                EXPENSES  
              Advertising Advertising, promotion, marketing costs Expenses
              Automobile Automobile expenses Expenses
              Bank charges Bank service charges Expenses
              Cleaning Cleaning Expenses
              Contributions Contributions Expenses
              Depreciation Depreciation expense Expenses
              Discounts Discounts taken Expenses
              Subscriptions Dues and subscriptions Expenses
              Insurance Auto Insurance, Life, Medical Expenses
              Interest expense Interest expense Expenses
              Licenses Business licenses and permits Expenses
              Maintenance Maintenance and repairs Expenses
              Meals Meals and entertainment Expenses
              Merchant fees Merchant credit card fees Expenses
              Office Office expenses (computer, postage, delivery, supplies) Expenses
              Payroll taxes Payroll taxes Expenses
              Professional fees Professional fees Expenses
              Rent Rental Payments Expenses
              Salaries Salaries Expenses
              Telephone Telephone, Fax Expenses
              Travel Travel Expenses
              Utilities Utilities Expenses
            Expenses   TOTAL EXPENSES Ordinary
                   
            Ordinary   NET ORDINARY INCOME Result
                   
                OTHER INCOME  
              Interest income Interest income O-Income
            O-Income   TOTAL OTHER INCOME Result
                   
                OTHER EXPENSE  
              Ask accountant Ask accountant O-Expense
            O-Expense   TOTAL OTHER EXPENSE Result
                   
            Result   NET INCOME ( Profit(-) Loss(+) ) Profit or Loss
                   
            00   Difference should be = 0 (blank cell)  
                   
                   
                CUSTOMERS/SUPPLIERS REGISTER  
                   
                Customers  
              Cus-Redford Redford Inc TOTC
              Cus-Smith John Smith TOTC
              Cus-Black Simon Black TOTC
            TOTC   Total Customers Customers
                   
                Suppliers  
              Sup-Johnson Johnson Inc TOTS
              Sup-Marble Marble Inc TOTS
              Sup-Taylor Mary Taylor TOTS
            TOTS   Total Suppliers Suppliers
                   
                   
                COST CENTERS  
                   
                Products  
              .Product A Product A Products
              .Product B Product B Products
              .Product C Product C Products
            Products   Total Products  
                   
                Projects  
              ;Project A Project A Projects
              ;Project B Project B Projects
            Projects   Total Projects  
                   
                   
                SEGMENTS  
                   
                Branches  
              :BA Branch A Branches
              :BB Branch B Branches
            Branches   Total Branches  
                   
            Table: VAT codes
            VAT Code Description %VAT
                 
              VAT due  
            S0 VAT exempt sales  
            SE Foreign sales exempt  
            S5 Sales at 5% 5.00
            S10 Sales at 10% 10.00
            SD5 Discount on sales at 5% 5.00
            SD10 Discount on sales at 10% 10.00
                 
              Recoverable VAT  
            P5 Purchase goods at 5% 5.00
            P10 Purchase goods at 10% 10.00
            PD5 Discount on purchases at 5% 5.00
            PD10 Discount on purchases at 10% 10.00
                 
            I5 Purchases for investment or use 5% 5.00
            I10 Purchases for investment or use 10% 10.00
            ID5 Discount on purchases for investment or use 5% 5.00
            ID10 Discount on purchases for investment or use 10% 10.00
                 
              TOTAL  
            In this article

              Double-Entry Accounting for a Corporation

              Double-Entry Accounting for a Corporation

              Universal
              Double-Entry Accounting
              Business

              Start easily and FOR FREE the double-entry accounting of your Corporation and get immediately the Income Statement and the Balance Sheet. This ready-to-use generic template can be adapted according to your needs, to also manage the accounting of your company, sole proprietorship, partnership or small or medium business. Banana Accounting Plus is a professional software that is very intuitive and fast to use because it's similar to Excel. If you make mistakes you can always correct until everything is perfect.

              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

              Company XX

              Table: Accounts
              Group Description Sum In
                  BALANCE SHEET  
                     
                  ASSETS  
                     
                  Bank Accounts  
                Business checking Business checking account Bank
                Business savings Business savings account Bank
                Payroll checking Payroll checking Bank
                Cash Petty Cash - Out of Pocket expenses Bank
                Barter Barter checking Bank
              Bank   Total Bank Accounts Assets
                     
                  Accounts receivable  
              Customers   Accounts receivable (Customers' register) Receivable
              Receivable   Total Accounts Receivable Assets
                     
                  Current Assets  
                Inventory Inventory C-Assets
                Undeposited Funds Undeposited Funds C-Assets
              C-Assets   Total Current Assets Assets
                     
                  Fixed Assets  
                Equipment Equipment Fixed
                Furniture Furniture and Fixtures Fixed
                Vehicles Vehicles Fixed
                Acc-Depreciation Accumulated Depreciation Fixed
              Fixed   Total Fixed Assets Assets
                     
                  Other Assets  
                Start up Start up costs (accountants use) Other
                Acc-Amortization Accumulated Amortization Other
                Notes Receivable 1 Notes Receivable 1 (officer, owner, related party) Other
                Notes Receivable 2 Notes Receivable 2 Other
              Other   Total Other Assets Assets
                     
              Assets   TOTAL ASSETS 00
                     
                  LIABILITIES  
                     
                  Accounts payable  
              Suppliers   Suppliers' register Payable
              Payable   Total Accounts Payable Liabilities
                     
                  Credit Cards used to purchase  
                American American Express - Credit card loan Cards
                Visa Visa - Credit card loan Cards
              Cards   Total Credit Cards Liabilities
                     
                  Current Liabilities  
                Accrued Accrued Expenses C-Liabilities
                Payroll tax payable Payroll Tax Payable C-Liabilities
                Sales tax payable Sales Tax Payable C-Liabilities
                Deposits Deposits from Customers C-Liabilities
                Portion long term Current portion of long term liabilities C-Liabilities
              C-Liabilities   Total Current Liabilities Liabilities
                     
                  Long Term Liabilities  
                Loan Bank loan Long term
                Notes payable 1 Notes payable1 Long term
                Notes payable 2 Notes payable2 Long term
              Long term   Total Long Term Liabilities Liabilities
                     
              Liabilities   TOTAL LIABILITIES 00
                     
                  EQUITY  
                Capital Capital stock / Capital partner Equity
                Additional capital Additional Capital Contributed / Additional Paid in Capital Equity
                Retained earnings Retained earnings Equity
                Opening equity Opening balance equity Equity
                Shareholder 1 Distributions shareholder 1 / Dividends / Draws Equity
                Brought forward Profit or Loss brought forward Equity
              Profit or Loss   Profit or Loss of the current year Equity
              Equity   TOTAL EQUITY 00
                     
                     
                  PROFIT/LOSS STATEMENT  
                     
                  INCOME  
                Services Income from services Income
                Products sold Income from parts / products sold Income
                Sales write offs Sales write offs Income
              Income   TOTAL INCOME Gross Profit
                     
                  COST OF GOODS SOLD  
                Materials Materials, Direct product/service costs Cost Goods
                Labor Labor costs Cost Goods
                Outside services Outside services / Subcontractors Cost Goods
                Supplies Supplies costs Cost Goods
                Small tools Small tools Cost Goods
              Cost Goods   TOTAL COST OF GOODS SOLD Gross Profit
                     
              Gross Profit   GROSS PROFIT Ordinary
                     
                  EXPENSES  
                Advertising Advertising, promotion, marketing costs Expenses
                Automobile Automobile expenses Expenses
                Bank charges Bank service charges Expenses
                Cleaning Cleaning Expenses
                Contributions Contributions Expenses
                Depreciation Depreciation expense Expenses
                Discounts Discounts taken Expenses
                Subscriptions Dues and subscriptions Expenses
                Insurance Auto Insurance, Life, Medical Expenses
                Interest expense Interest expense Expenses
                Licenses Business licenses and permits Expenses
                Maintenance Maintenance and repairs Expenses
                Meals Meals and entertainment Expenses
                Merchant fees Merchant credit card fees Expenses
                Office Office expenses (computer, postage, delivery, supplies) Expenses
                Payroll taxes Payroll taxes Expenses
                Professional fees Professional fees Expenses
                Rent Rental Payments Expenses
                Salaries Salaries Expenses
                Telephone Telephone, Fax Expenses
                Travel Travel Expenses
                Utilities Utilities Expenses
              Expenses   TOTAL EXPENSES Ordinary
                     
              Ordinary   NET ORDINARY INCOME Result
                     
                  OTHER INCOME  
                Interest income Interest income O-Income
              O-Income   TOTAL OTHER INCOME Result
                     
                  OTHER EXPENSE  
                Ask accountant Ask accountant O-Expense
              O-Expense   TOTAL OTHER EXPENSE Result
                     
              Result   NET INCOME ( Profit(-) Loss(+) ) Profit or Loss
                     
              00   Difference should be = 0 (blank cell)  
                     
                     
                  CUSTOMERS/SUPPLIERS REGISTER  
                     
                  Customers  
                Cus-Redford Redford Inc TOTC
                Cus-Smith John Smith TOTC
                Cus-Black Simon Black TOTC
              TOTC   Total Customers Customers
                     
                  Suppliers  
                Sup-Johnson Johnson Inc TOTS
                Sup-Marble Marble TOTS
                Sup-Taylor Mary Taylor TOTS
              TOTS   Total Suppliers Suppliers
                     
                     
                  COST CENTERS  
                     
                  Products  
                .Product A Product A Products
                .Product B Product B Products
                .Product C Product C Products
              Products   Total Products  
                     
                  Projects  
                ;Project A Project A Projects
                ;Project B Project B Projects
              Projects   Total Projects  
                     
                     
                  SEGMENTS  
                     
                  Branches  
                :BA Branch A Branches
                :BB Branch B Branches
              Branches   Total Branches  
                     
              In this article

                Multi currency-accounting for enterprise in United Arab Emirates with VAT (account names)

                Multi currency-accounting for enterprise in United Arab Emirates with VAT (account names)

                UAE (United Arab Emirates)
                Double-Entry Accounting with vat/sales tax and foreign currencies
                Business

                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

                Template preview

                Company XX

                Basic Currency: AED

                Double-entry with foreign currencies and VAT/Sales tax

                Table: Accounts
                Group Description Currency Sum In
                    BALANCE SHEET    
                         
                    Assets    
                  Cash Cash AED Assets
                  Bank AED Bank Account AED AED Assets
                  Bank EUR Bank Account EUR EUR Assets
                  Bank USD Bank Account USD USD Assets
                Customers   Customers' register   Assets
                  Inventory Inventory AED Assets
                  Office furniture Office furniture AED Assets
                  Computer Computer AED Assets
                  Software Software AED Assets
                  Car Car AED Assets
                         
                Assets   Total Assets   00
                         
                    Liabilities    
                Suppliers   Suppliers' register   Liabilities
                  Visa Credit card loan AED Liabilities
                  Loan Bank loan AED Liabilities
                  VAT due VAT due AED Liabilities
                  VAT Automaticly calculated VAT AED Liabilities
                  Capital Capital AED Liabilities
                  Profit or Loss brought forward Profit or Loss brought forward AED Liabilities
                Profit or Loss of the current year   Profit or Loss of the current year   Liabilities
                Liabilities   Total Liabilities   00
                         
                    PROFIT/LOSS STATEMENT    
                         
                    REVENUES    
                  Sales Income from sales AED Revenues
                  Services Income from services AED Revenues
                  Miscellaneous income Miscellaneous cash receipts AED Revenues
                  Interest income Interest income AED Revenues
                  Profit on Foreign Exchange Profit on Foreign Exchange AED Revenues
                Revenues   TOTAL REVENUES   Result
                         
                    EXPENSES   Expenses
                  Product costs Direct product/service costs AED Expenses
                  Salaries Salaries direct AED Expenses
                  Pension Fund Pension fund AED Expenses
                  Advertising Advertising and promotion AED Expenses
                  Automobile Automobile/Transportation AED Expenses
                  Bank charges Bank service charges AED Expenses
                  Interest on Bank Loan Interest on bank loan AED Expenses
                  Licenses Business licenses and permits AED Expenses
                  Charity Charitable contributions AED Expenses
                  Internet Internet AED Expenses
                  Education Continuing education AED Expenses
                  Subscriptions Dues and subscriptions AED Expenses
                  Insurance Insurance AED Expenses
                  Meals Meals and entertainment AED Expenses
                  Merchant fees Merchant account fees AED Expenses
                  Office supplies Office supplies AED Expenses
                  Postage Postage and delivery AED Expenses
                  Printing Printing and reproduction AED Expenses
                  Legal services Professional and Legal services AED Expenses
                  Rent Rental payments AED Expenses
                  Electricity Electricity AED Expenses
                  Subcontractor Subcontractor AED Expenses
                  Telephone Telephone, Fax AED Expenses
                  Travel Travel AED Expenses
                  Utilities Utilities AED Expenses
                  Website Website development AED Expenses
                  Other costs Other costs AED Expenses
                  Interest expense Interest expense AED Expenses
                  Tax expense Tax expense AED Expenses
                  Loss on Foreign Exchange Loss on Foreign Exchange AED Expenses
                Expenses   TOTAL EXPENSES   Result
                         
                Result   OPERATING RESULT   Profit or Loss of the current year
                         
                00   Difference should be = 0 (blank cell)    
                         
                         
                    CUSTOMERS/SUPPLIERS REGISTER    
                         
                    Customers    
                  C-RED Redford Inc AED TOTC
                  C-SMI John Smith AED TOTC
                  C-BLA Simon Black AED TOTC
                TOTC   Total Customers   Customers
                         
                    Suppliers    
                  S-JOH Johnson Inc AED TOTS
                  S-MAR Marble Inc AED TOTS
                  S-TAY Mary Taylor AED TOTS
                TOTS   Total Suppliers   Suppliers
                Table: VAT codes
                VAT Code Description %VAT
                  Output VAT - VAT due  
                     
                OSR1 Sales at 5% standard rate Abu Dhabi (Box 1a) 5.00
                OSR2 Sales at 5% standard rate Dubai (Box 1b) 5.00
                OSR3 Sales at 5% standard rate Sharjah (Box 1c) 5.00
                OSR4 Sales at 5% standard rate Ajman (Box 1d) 5.00
                OSR5 Sales at 5% standard rate Umm Al Quwain (Box 1e) 5.00
                OSR6 Sales at 5% standard rate Ras Al Khaimah (Box 1f) 5.00
                OSR7 Sales at 5% standard rate Fujairah (Box 1g) 5.00
                OSTS Tax refunds provided to turists  
                ORCS Purchase of services with reverse charge - OUTPUT VAT - (Box 3) 5.00
                OZR Sales Zero Rated (Box 4)  
                OEX Sales Exempt (Box 5)  
                ORCI Import of goods with reverse charge - OUTPUT VAT calculated by UAE Custom - (Box 6) 5.00
                ORCA Adjustment values calculated by Custom on import of goods - (Box 7) 5.00
                     
                OOS Sales Out of Scope  
                OIG Sales to registered customers in other GCC implementing state (no UAE VAT)  
                     
                     
                  Input VAT - VAT recoverable  
                     
                ISR Purchases at 5% standard rate (Box 9) 5.00
                IRC Purchases of goods and services with reverse charge - INPUT VAT - (Box 10) 5.00
                     
                IZR Purchases Zero Rated  
                IEX Purchases Exempt  
                IOS Purchases Out of Scope  
                     
                  TOTAL  
                     
                     
                  : ADJ - adjustements are registered with the same VAT code used for the transactions that needs an adjustment  
                Table: Exchange rates
                Ref.Currency Currency Text
                AED EUR Euro
                AED USD US Dollars
                AED CNY Chinese Yuan
                In this article

                  Invoices to members in double-entry accounting

                  Invoices to members in double-entry accounting

                  Switzerland
                  Double-Entry Accounting
                  Education

                  With Banana Accounting Plus, in addition to managing the accounting of your non-profit organisation, printing the balance sheet and other necessary reports, you can also prepare and print invoices to members for the payment of membership fees. With the tutorial we provide, just a few steps are enough to print invoices easily and quickly. Open the tutorial from our WebApp or directly from the program, and save the file to your computer.

                  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 tutorial in WebApp

                  Template documentation

                  Create your file

                  To get started quickly, we recommend downloading the template provided at the beginning of this page, or opening it directly from the program as follows:

                  Template preview

                  Association XX

                  Basic Currency: CHF

                  Double-entry

                  Table: Accounts
                  Group Description Sum In
                      Balance Sheet  
                         
                      Assets  
                    Cash Cash Assets
                    Bank Bank Current Account Assets
                    Post Post Current Account Assets
                    Office Forniture Office Forniture Assets
                    Computer and Software Computer and Software Assets
                    Car Car Assets
                  Assets   Total Assets Net Assets
                         
                      Liabilities  
                    Suppliers Suppliers Total Liabilities
                    Visa Credit card loan Total Liabilities
                    Loan Bank loan Total Liabilities
                    Start-up Capital Start-up Capital Total Liabilities
                    Brought forward profit or loss Brought forward profit or loss Total Liabilities
                  Profit or loss of the current year   Profit or loss of the current year Total Liabilities
                  Total Liabilities   Total Liabilities Net Assets
                         
                  Net Assets   Net Assets  
                         
                         
                      PROFIT/LOSS STATEMENT  
                         
                      INCOME  
                    Donations Donations 4
                    Membership Membership payments 4
                    Sales Various Sales 4
                    Other Income Other income 4
                         
                  4   TOTAL INCOME 00
                         
                      EXPENSES  
                    Office Supplies Office supplies, printing material, photocopies 3
                    Postal Fees Postal fees 3
                    Rent Rent 3
                    Electricity Elecricity 3
                    Water Water 3
                    Teleohone and Fax Telephone and fax 3
                    Internet Internet 3
                    Publicity Publicity, flyers, printing 3
                    Cleaning Cleaning 3
                    Maintenance and repairs Maintenance and repairs 3
                    Goods and materials Goods and materials 3
                    Salaries Personnel expenses 3
                    Social Insurance expenses Social Insurance expenses 3
                    Vehicle and transport Vehicle and transport costs 3
                    Refund Volunteers Refund to volunteers 3
                    Fees and Permits Fees and other permits 3
                    Unexpected expenses Unexpected expenses 3
                    Unregistered expenses Small unregistered expenses 3
                    Other expenses Other expenses 3
                         
                  3   TOTAL EXPENSES 00
                         
                  00   RESULT  
                         
                         
                      COST CENTERS  
                         
                      Members  
                         
                    ;WEI Weisshaupt Urs TM
                    ;MUL Müller Susanne TM
                    ;SCH Schmid Peter TM
                    ;ROS Ross Michael TM
                    ;BIA Bianchi Peter TM
                  TM   Total members  
                         
                         
                      SEGMENTS  
                    :Project A Project A Total Projects
                    :Project B Project B Total Projects
                    :Project C Project C Total Projects
                  Total Projects   Total projects  
                  In this article

                    Audit Reports [BETA]

                    Audit Reports [BETA]

                    View on Github

                    The main purpose of this extension is to provide reports that can be easily copied into excel, summarising and showing the main accounting data that are normally taken as a basis by auditors when preparing their analysis.

                    Useful reports for Banana users who need to send their auditor accounting data, but also for auditors who use Banana themselves, as these reports are based on the functionalities already offered by Banana and therefore facilitate and speed up the collection of accounting data.

                    Reports

                    The following reports can be generated:

                    In this article

                      [UNI11] Layout 11 Programmable Invoice (Banana+)

                      [UNI11] Layout 11 Programmable Invoice (Banana+)

                      View on Github

                      Layout to print the invoice of Banana Accounting highly customizable and also programmable.
                      You can easily adapt the invoice to your desires, decide which elements to print and change texts.

                      Watch the video tutorial: Invoice customization (Layout UNI11).

                      Prerequisites

                      To use this extension you need to download and install Banana Accounting Plus.

                      Subscribe to

                      Share this article: Twitter | Facebook | LinkedIn | Email