In this article

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

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

    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.

    In Banana WebApp openen

    Open Banana Accounting Plus op uw browser zonder enige installatie. Pas het sjabloon aan, voer de transacties in en sla het bestand op uw computer op.

    Open template in WebApp Open tutorial in WebApp


    Company XX

    Basic Currency: USD

    Double-entry with foreign currencies and VAT/Sales tax

    Table: Accounts
    Group Description Currency Sum In
        BALANCE SHEET    
        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
        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
      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
      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
      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)    
      Cus-Redford Redford Inc USD TOTC
      Cus-Smith John Smith USD TOTC
      Cus-Black Simon Black GBP TOTC
    TOTC   Total Customers   Customers
      Sup-Johnson Johnson Inc EUR TOTS
      Sup-Marble Marble Inc USD TOTS
      Sup-Taylor Mary Taylor USD TOTS
    TOTS   Total Suppliers   Suppliers
        COST CENTERS    
      .Product A Product A USD Products
      .Product B Product B USD Products
      .Product C Product C USD Products
    Products   Total Products    
      ;Project A Project A USD Projects
      ;Project B Project B USD Projects
    Projects   Total Projects    
      :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
    Table: Exchange rates
    Ref.Currency Currency Text
    USD EUR Euro
    USD GBP Pound Sterling
    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