Templates Accounting Business USA

Templates Accounting Business without VAT/Sales Tax USA

Double entry Accounting for company | USA | Account numbers

In this article

    Double entry Accounting for company | USA | Account numbers

    Double entry Accounting for company | USA | Account numbers

    USA
    Double-Entry Accounting
    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

    Starter Company

    Basic Currency: USD

    Double-entry

    Table: Accounts
    Group Description Sum In Gr1
             
        BALANCE SHEET    
             
        ASSETS    
      11200 Bank Account USD 12  
      11201 Bank Account CAD 12  
      11202 Bank Account EUR 12  
      11300 Petty Cash 12  
    120   Accounts Receivable 12 1
      12200 Allowance for Bad Debts 12  
      12400 Accounts Receivable - Other 12  
      12500 Due from Shareholder 12  
      12600 Due from Employees 12  
      12700 Investments 12  
      12800 Income Taxes Recoverable 12  
      12850 Sales Taxes Recoverable 12  
      13000 Inventory 12  
      14000 Prepaid Expenses 12  
      14100 Prepaid Deposits 12  
    12   Total Current Assets 100  
             
      15110 Furniture and Equipment 15  
      15120 Furn. & Equip. - Acc. Am. 15  
      15210 Computer Equipment 15  
      15220 Computer Equip. - Acc. Am. 15  
      15310 Vehicle 15  
      15320 Vehicle - Acc. Am. 15  
    15   Total Long Term Assets 100  
    100   TOTAL ASSETS 00 1
             
        LIABILITIES & EQUITY    
        LIABILITIES    
    220   Accounts Payable 22 1
      22200 Accrued Liabilities 22  
      22300 Accounts Payable - Other 22  
      22400 Visa payable 22  
      23500 Sales tax payable 22  
      23510 Sales Tax automatic 22  
      23800 Accrued Payroll 22  
      23900 Source Deductions Payable 22  
      24000 Corporate Tax Payable - Fed. 22  
      24100 Corporate Tax Payable - Prov. 22  
      25300 Line of Credit 22  
      25400 Due to Shareholder 22  
      25900 Current Portion of Debt - ST 22  
    22   Total Current Liabilities 2  
             
      26200 Term Loan 26  
      26300 Current Portion of Debt - LT 26  
    26   Total Long Term Liabilities 2  
    2   Total Liabilities 2-3  
             
        EQUITY    
      31000 Common Shares 3  
      38000 Retained Earnings 3  
    3800   (Profit)/Loss for the period 3 1
      39000 Dividends 3  
    3   Total Equity 2-3  
    2-3   TOTAL LIABILITIES & EQUITY 00 1
             
             
        INCOME STATEMENT    
             
        REVENUE    
      41100 Sales 4  
      41900 Other Income 4  
      44000 Exchange Gain/Loss 4  
    4   TOTAL REVENUE L01 1
             
        COST OF SALES    
      51100 Inventory - Opening 5  
      51200 Purchases 5  
      52000 Freight 5  
      52200 Inventory - Closing 5  
      52300 Direct Materials 5  
      52400 Subcontractors 5  
      55100 Salaries and Wages 5  
      55200 CPP Expense 5  
      55300 EI Expense 5  
      55400 WSIB Expense 5  
      55500 Benefit Plan 5  
      55600 EHT Premiums 5  
    5   Total COST OF SALES L01  
    L01   GROSS MARGIN L02 1
        EXPENSES    
      61050 Accounting 6  
      61100 Advertising & Marketing 6  
      61200 Amortization 6  
      61400 Bad Debts 6  
      61500 Bank Charges & Interest 6  
      61550 Business Tax & Licences 6  
      61600 Courier 6  
      61620 Computing expenses 6  
      61650 Consulting Fees 6  
      61700 Dues & Subscriptions 6  
      61800 Education & Training 6  
      61900 Equipment Rental 6  
      62000 Insurance 6  
      62100 Interest on Debt 6  
      62200 Legal Fees 6  
      62250 Management Salaries 6  
      62300 Meals & Entertainment 6  
      62400 Miscellaneous 6  
      62500 Office Supplies 6  
      62600 Rent 6  
      62700 Repairs & Maintenance 6  
      63100 Supplies 6  
      63200 Telephone & Internet 6  
      63300 Travel & Parking 6  
      63400 Utilities 6  
      63500 Vehicle Expenses 6  
    6   Total EXPENSES L02 1
    L02   Income Before Income Taxes L03  
      90000 Income Tax Provision 9  
    9   Total Income Taxes L03 1
             
    L03   NET (INCOME)/LOSS 3800 1
             
    00   Total Debit/Credit Balance should be 0    
             
             
        Customers/Debtors    
      C0001 Customer A 120A  
      C0002 Customer B 120A  
      C0003 Customer C 120A  
      C0004 Customer D 120A  
      C0005 Test client 120A  
      C0006 R J Sample Co 120A  
    120A   Total Customers 120 1
             
             
        Suppliers/Creditors    
      S0001 Supplier A 220A  
      S0002 Supplier B 220A  
      S0003 Supplier C 220A  
      S0004 Supplier D 220A  
      S0005 Supplier E 220A  
    220A   Total Suppliers 220 1
             
        Cost and profit centers    
        Departments (CC1)    
      .OTT Department 1 TDE  
      .TOR Department 2 TDE  
    TDE   Total Department Expenses    
             
        Projects (CC2)    
      ,JOB1 Project 1 TPR  
      ,JOB2 Project 2 TPR  
    TPR   Total Projects    
             
        Other (CC3)    
      ;OT-1 Other 1 TOT  
      ;OT-2 Other 2 TOT  
    TOT   Total Other    
             
        Segments    
      : Branch TS1  
      :01 Ottawa TS1  
      :02 Wancouver TS1  
    TS1   Total Branch    
             
      :: Sectors TS2  
      ::01 Sales TS2  
      ::02 Reasearch TS2  
    TS2   Total sectors    

    Multi-currency Accounting for company | USA | Account numbers

    In this article

      Multi-currency Accounting for company | USA | Account numbers

      Multi-currency Accounting for company | USA | Account numbers

      USA
      Double-Entry Accounting with 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

      Starter Company

      Basic Currency: USD

      Double-entry with foreign currencies

      Table: Accounts
      Group Description Currency Sum In Gr1
                 
          BALANCE SHEET      
                 
          ASSETS      
        11200 Bank Account USD USD 12  
        11201 Bank Account CAD CAD 12  
        11202 Bank Account EUR EUR 12  
        11300 Petty Cash USD 12  
      120   Accounts Receivable   12 1
        12200 Allowance for Bad Debts USD 12  
        12400 Accounts Receivable - Other USD 12  
        12500 Due from Shareholder USD 12  
        12600 Due from Employees USD 12  
        12700 Investments USD 12  
        12800 Income Taxes Recoverable USD 12  
        12850 Sales Taxes Recoverable USD 12  
        13000 Inventory USD 12  
        14000 Prepaid Expenses USD 12  
        14100 Prepaid Deposits USD 12  
      12   Total Current Assets   100  
                 
        15110 Furniture and Equipment USD 15  
        15120 Furn. & Equip. - Acc. Am. USD 15  
        15210 Computer Equipment USD 15  
        15220 Computer Equip. - Acc. Am. USD 15  
        15310 Vehicle USD 15  
        15320 Vehicle - Acc. Am. USD 15  
      15   Total Long Term Assets   100  
      100   TOTAL ASSETS   00 1
                 
          LIABILITIES & EQUITY      
          LIABILITIES      
      220   Accounts Payable   22 1
        22200 Accrued Liabilities USD 22  
        22300 Accounts Payable - Other USD 22  
        22400 Visa payable USD 22  
        23500 HST Charged on Sales USD 22  
        23510 HST Paid on Purchases USD 22  
        23520 HST Instalments USD 22  
        23530 HST Payable USD 22  
        23600 PST Payable USD 22  
        23700 GST & QST Payable USD 22  
        23800 Accrued Payroll USD 22  
        23900 Source Deductions Payable USD 22  
        24000 Corporate Tax Payable - Fed. USD 22  
        24100 Corporate Tax Payable - Prov. USD 22  
        25300 Line of Credit USD 22  
        25400 Due to Shareholder USD 22  
        25900 Current Portion of Debt - ST USD 22  
      22   Total Current Liabilities   2  
                 
        26200 Term Loan USD 26  
        26300 Current Portion of Debt - LT USD 26  
      26   Total Long Term Liabilities   2  
      2   Total Liabilities   2-3  
                 
          EQUITY      
        31000 Common Shares USD 3  
        38000 Retained Earnings USD 3  
      3800   (Profit)/Loss for the period   3 1
        39000 Dividends USD 3  
      3   Total Equity   2-3  
      2-3   TOTAL LIABILITIES & EQUITY   00 1
                 
                 
          INCOME STATEMENT      
                 
          REVENUE      
        41100 Sales USD 4  
        41900 Other Income USD 4  
        44000 Exchange Gain/Loss USD 4  
      4   TOTAL REVENUE   L01 1
                 
          COST OF SALES      
        51100 Inventory - Opening USD 5  
        51200 Purchases USD 5  
        52000 Freight USD 5  
        52200 Inventory - Closing USD 5  
        52300 Direct Materials USD 5  
        52400 Subcontractors USD 5  
        55100 Salaries and Wages USD 5  
        55200 CPP Expense USD 5  
        55300 EI Expense USD 5  
        55400 WSIB Expense USD 5  
        55500 Benefit Plan USD 5  
        55600 EHT Premiums USD 5  
      5   Total COST OF SALES   L01  
      L01   GROSS MARGIN   L02 1
          EXPENSES      
        61050 Accounting USD 6  
        61100 Advertising & Marketing USD 6  
        61200 Amortization USD 6  
        61400 Bad Debts USD 6  
        61500 Bank Charges & Interest USD 6  
        61550 Business Tax & Licences USD 6  
        61600 Courier USD 6  
        61620 Computing expenses USD 6  
        61650 Consulting Fees USD 6  
        61700 Dues & Subscriptions USD 6  
        61800 Education & Training USD 6  
        61900 Equipment Rental USD 6  
        62000 Insurance USD 6  
        62100 Interest on Debt USD 6  
        62200 Legal Fees USD 6  
        62250 Management Salaries USD 6  
        62300 Meals & Entertainment USD 6  
        62400 Miscellaneous USD 6  
        62500 Office Supplies USD 6  
        62600 Rent USD 6  
        62700 Repairs & Maintenance USD 6  
        63100 Supplies USD 6  
        63200 Telephone & Internet USD 6  
        63300 Travel & Parking USD 6  
        63400 Utilities USD 6  
        63500 Vehicle Expenses USD 6  
      6   Total EXPENSES   L02 1
      L02   Income Before Income Taxes   L03  
        90000 Income Tax Provision   9  
      9   Total Income Taxes   L03 1
                 
      L03   NET (INCOME)/LOSS   3800 1
                 
      00   Total Debit/Credit Balance should be 0      
                 
                 
          Customers/Debtors      
        C0001 Customer A USD 120A  
        C0002 Customer B USD 120A  
        C0003 Customer C USD 120A  
        C0004 Customer D USD 120A  
        C0005 Test client USD 120A  
        C0006 R J Sample Co USD 120A  
      120A   Total Customers   120 1
                 
                 
          Suppliers/Creditors      
        S0001 Supplier A USD 220A  
        S0002 Supplier B USD 220A  
        S0003 Supplier C USD 220A  
        S0004 Supplier D USD 220A  
        S0005 Supplier E USD 220A  
      220A   Total Suppliers   220 1
                 
          Cost and profit centers      
          Departments (CC1)      
        .OTT Department 1 USD TDE  
        .TOR Department 2 USD TDE  
      TDE   Total Department Expenses      
                 
          Projects (CC2)      
        ,JOB1 Project 1 USD TPR  
        ,JOB2 Project 2 USD TPR  
      TPR   Total Projects      
                 
          Other (CC3)      
        ;OT-1 Other 1 USD TOT  
        ;OT-2 Other 2 USD TOT  
      TOT   Total Other      
                 
          Segments      
        : Branch   TS1  
        :01 Ottawa   TS1  
        :02 Wancouver   TS1  
      TS1   Total Branch      
                 
        :: Sectors   TS2  
        ::01 Sales   TS2  
        ::02 Reasearch   TS2  
      TS2   Total sectors      
      Table: Exchange rates
      Ref.Currency Currency Text
        CAD Canadian Dollar
        EUR Euro

      Templates Accounting Business with VAT/Sales Tax USA

      Cash Manager with Sales Tax | USA

      In this article

        Cash Manager with Sales Tax | USA

        Cash Manager with Sales Tax | USA

        USA
        Cash Manager with VAT/Sales tax
        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.

        Sole Proprietorship (accounts literals) | Incomes & Expenses Accounting with Sales Tax | USA

        In this article

          Sole Proprietorship (accounts literals) | Incomes & Expenses Accounting with Sales Tax | USA

          Sole Proprietorship (accounts literals) | Incomes & Expenses Accounting with Sales Tax | USA

          USA
          Income & Expense Accounting with vat/sales tax
          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

          Sole proprietorship

          Basic Currency: CAD

          Income & Expense accounting with VAT/Sales tax

          Table: Accounts
          Group Description Sum In
              Financial position  
              Assets 1
            Cash Cash 1
            Bank Bank assets 1
            Visa Credit card Visa 1
          1   Total Assets 1-2
                 
              Liabilities 2
            Suppliers Suppliers 2
            Loan Bank loan 2
            ST Sales Tax owned 2
            STA Sales Tax (automatic account) 2
          2   Total Liabilities 1-2
          1-2   Net Assets  
          Table: Categories
          Group Category Description Sum In
              CASH FLOW  
                 
              INCOME 3
            Sales Cash sales 3
            Miscellaneous income Miscellaneous cash receipts 3
            Interest income Interest income 3
            Tax refund Income tax refund 3
          3   TOTAL INCOME 3-4
                 
              EXPENSES 4
            Product costs Direct product/service costs 4
            Salaries Salaries direct 4
            Payroll taxes Payroll taxes and benefits direct 4
            Supplies Supplies 4
            Advertising Advertising and promotion 4
            Automobile Automobile/Transportation 4
            Bank charges Bank service charges 4
            Licenses Business licenses and permits 4
            Charity Charitable contributions 4
            Computer Computer and internet 4
            Education Continuing education 4
            Subscriptions Dues and subscriptions 4
            Insurance Insurance 4
            Meals Meals and entertainment 4
            Merchant fees Merchant account fees 4
            Office supplies Office supplies 4
            Postage Postage and delivery 4
            Printing Printing and reproduction 4
            Legal services Professional and Legal services 4
            Rent Rental payments 4
            Subcontractor Subcontractor 4
            Telephone Telephone 4
            Travel Travel 4
            Utilities Utilities 4
            Website Website development 4
            Other costs Other costs 4
            Interest expense Interest expense 4
            Tax expense Income tax expense 4
          4   TOTAL EXPENSES 3-4
                 
          3-4   OPERATING RESULT 00
                 
                 
              CAPITAL IN 6
            Loan injections Loan injections 6
            Owners injections Cash injections by owners 6
            Sales fixed assets Sales of fixed assets 6
          6   TOTAL CAPITAL IN 5-6
                 
              CAPITAL OUT 5
            Loan reimbursements Loan reimbursements 5
            Owners disbursements Cash disbursements to owners 5
            Purchases fixed assets Purchases of fixed assets 5
          5   TOTAL CAPITAL OUT 5-6
                 
          5-6   CHANGE IN CAPITAL 00
                 
          00   NET CASH CHANGE - Inflow(+) Outflow(-)  
                 
                 
          Table: VAT codes
          VAT Code Description %VAT
            Last update: Jan xx, 2020  
               
            State X1 (paid ST, county)  
            Sales tax charged County A1  
          CZipCode1 ST Charged for City 1 7.00
          CZipCode2 ST Charged for City 2 7.20
            Sales tax paid County A1  
          PZipCode1 ST paid for City 1 7.00
          PZipCode2 ST paid for City 2 7.20
            Total sales tax for County A2 1.50
               
          CZipCode3 ST Charged for City 3 7.10
          CZipCode4 ST Charged for City 4 7.30
            Sales tax paid County A1  
          PZipCode3 ST paid for City 1 7.10
          PZipCode4 ST paid for City 2 7.30
            Total sales tax for County A1 1.60
            Sales tax Exeptions for State X1  
          EX1-01 Tax exeption State X1 for purpose 1  
          EX1-02 Tax exeption State X1 for purpose 2  
            Total State X1 5.00
               
            State X2 (no paid, no county)  
            Sales tax charged State X2  
          CZipCode10 ST Charged for City 10 7.00
          CZipCode11 ST Charged for City 11 7.20
            Sales tax paid State X2  
          PZipCode10 ST paid for City 10 7.00
          PZipCode11 ST paid for City 11 7.20
               
            Sales tax Exeptions for State X2  
          EX2-01 Tax exeption State X1 for purpose 1  
          EX2-02 Tax exeption State X1 for purpose 2  
            Total State X2 5.00
               
            State X3 (no paid, county)  
            Sales tax charged County A20  
          CZipCode20 ST Charged for City 20 7.00
          CZipCode21 ST Charged for City 21 7.20
            Total sales tax for County A20 1.50
               
            Sales tax charged County A30  
          CZipCode30 ST Charged for City 30 7.00
          CZipCode31 ST Charged for City 31 7.20
            Total sales tax for County A20 1.50
               
            Sales tax Exeptions for State X1  
          EX3-01 Tax exeption State X1 for purpose 1  
          EX3-02 Tax exeption State X1 for purpose 2  
            Total State X1 5.00
               
            State X4 (no paid tax, no county)  
          CZipCode40 ST Charged for City 40 7.00
          CZipCode41 ST Charged for City 41 7.20
               
            Sales tax Exeptions for State X4  
          EX4-01 Tax exeption State X1 for purpose 1  
          EX4-02 Tax exeption State X1 for purpose 2  
            Total State X4 5.00
               
               
            Total final for control  
               

          Accounting for company | USA | Double entry with Sales Tax | Account numbers

          In this article

            Accounting for company | USA | Double entry with Sales Tax | Account numbers

            Accounting for company | USA | Double entry with Sales Tax | Account numbers

            USA
            Double-Entry Accounting with vat/sales tax
            Business

            Excel-like, ready to use, customizable template for accounting and financial forecasting for small company in the United States of America. Financial reporting and projections based on the double entry method. Create your Sales Tax Code for easily calculation and reporting.

            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 documentation

            Description

             

            Sales Tax

            Sales Tax in USA is a very diversified and complex thema. The approach we take here is to let user to create customized tax codes for exactly the City he sell to. 

            In the Sales Tax Code table you have some example of predefined tax code, for States with different situations.

            Sales Tax Codes

            You can create Sales Tax Code specific to a city or a County or State. The percentage is the one that is charged to the customer. 

            • You can setup as many codes you needs.
              Just insert a new line, like in Excel.
            • You can use as tax code the zip code of the city of the customers.
            • You can specify the parameters that should apply to this code, for charged, paid or transactions with no tax.
            • When you enter the transaction you select the Tax Code and the software will automatically calculate the sales tax and register on the defined account.

            Sales Tax Grouping

            You create groups that help you organize Tax Codes hierarchically and define the structure that you desire.
            With the command>Sales tax report you can see the transactions summed with the different levels.
            The template already has example of multi-level grouping by:

            • Type of transaction:
              • Sales Tax Charged
                When the business sell.
              • Sales Tax Paid (optional)
                When the business buy.
              • Sales Tax Exemptions.
                Sell of goods that are not taxable.
            • County (optional).
              For States where counties also add their sales tax.
            • State
              Totals for all Codes that are related to the specific state.

             

             

             

            Template preview

            Starter Company

            Basic Currency: USD

            Double-entry with VAT/Sales tax

            Table: Accounts
            Group Description Sum In Gr1
                     
                BALANCE SHEET    
                     
                ASSETS    
              11200 Bank Account USD 12  
              11201 Bank Account CAD 12  
              11202 Bank Account EUR 12  
              11300 Petty Cash 12  
            120   Accounts Receivable 12 1
              12200 Allowance for Bad Debts 12  
              12400 Accounts Receivable - Other 12  
              12500 Due from Shareholder 12  
              12600 Due from Employees 12  
              12700 Investments 12  
              12800 Income Taxes Recoverable 12  
              12850 Sales Taxes Recoverable 12  
              13000 Inventory 12  
              14000 Prepaid Expenses 12  
              14100 Prepaid Deposits 12  
            12   Total Current Assets 100  
                     
              15110 Furniture and Equipment 15  
              15120 Furn. & Equip. - Acc. Am. 15  
              15210 Computer Equipment 15  
              15220 Computer Equip. - Acc. Am. 15  
              15310 Vehicle 15  
              15320 Vehicle - Acc. Am. 15  
            15   Total Long Term Assets 100  
            100   TOTAL ASSETS 00 1
                     
                LIABILITIES & EQUITY    
                LIABILITIES    
            220   Accounts Payable 22 1
              22200 Accrued Liabilities 22  
              22300 Accounts Payable - Other 22  
              22400 Visa payable 22  
              23500 Sales tax payable 22  
              23510 Sales Tax automatic 22  
              23800 Accrued Payroll 22  
              23900 Source Deductions Payable 22  
              24000 Corporate Tax Payable - Fed. 22  
              24100 Corporate Tax Payable - Prov. 22  
              25300 Line of Credit 22  
              25400 Due to Shareholder 22  
              25900 Current Portion of Debt - ST 22  
            22   Total Current Liabilities 2  
                     
              26200 Term Loan 26  
              26300 Current Portion of Debt - LT 26  
            26   Total Long Term Liabilities 2  
            2   Total Liabilities 2-3  
                     
                EQUITY    
              31000 Common Shares 3  
              38000 Retained Earnings 3  
            3800   (Profit)/Loss for the period 3 1
              39000 Dividends 3  
            3   Total Equity 2-3  
            2-3   TOTAL LIABILITIES & EQUITY 00 1
                     
                     
                INCOME STATEMENT    
                     
                REVENUE    
              41100 Sales 4  
              41900 Other Income 4  
              44000 Exchange Gain/Loss 4  
            4   TOTAL REVENUE L01 1
                     
                COST OF SALES    
              51100 Inventory - Opening 5  
              51200 Purchases 5  
              52000 Freight 5  
              52200 Inventory - Closing 5  
              52300 Direct Materials 5  
              52400 Subcontractors 5  
              55100 Salaries and Wages 5  
              55200 CPP Expense 5  
              55300 EI Expense 5  
              55400 WSIB Expense 5  
              55500 Benefit Plan 5  
              55600 EHT Premiums 5  
            5   Total COST OF SALES L01  
            L01   GROSS MARGIN L02 1
                EXPENSES    
              61050 Accounting 6  
              61100 Advertising & Marketing 6  
              61200 Amortization 6  
              61400 Bad Debts 6  
              61500 Bank Charges & Interest 6  
              61550 Business Tax & Licences 6  
              61600 Courier 6  
              61620 Computing expenses 6  
              61650 Consulting Fees 6  
              61700 Dues & Subscriptions 6  
              61800 Education & Training 6  
              61900 Equipment Rental 6  
              62000 Insurance 6  
              62100 Interest on Debt 6  
              62200 Legal Fees 6  
              62250 Management Salaries 6  
              62300 Meals & Entertainment 6  
              62400 Miscellaneous 6  
              62500 Office Supplies 6  
              62600 Rent 6  
              62700 Repairs & Maintenance 6  
              63100 Supplies 6  
              63200 Telephone & Internet 6  
              63300 Travel & Parking 6  
              63400 Utilities 6  
              63500 Vehicle Expenses 6  
            6   Total EXPENSES L02 1
            L02   Income Before Income Taxes L03  
              90000 Income Tax Provision 9  
            9   Total Income Taxes L03 1
                     
            L03   NET (INCOME)/LOSS 3800 1
                     
            00   Total Debit/Credit Balance should be 0    
                     
                     
                Customers/Debtors    
              C0001 Customer A 120A  
              C0002 Customer B 120A  
              C0003 Customer C 120A  
              C0004 Customer D 120A  
              C0005 Test client 120A  
              C0006 R J Sample Co 120A  
            120A   Total Customers 120 1
                     
                     
                Suppliers/Creditors    
              S0001 Supplier A 220A  
              S0002 Supplier B 220A  
              S0003 Supplier C 220A  
              S0004 Supplier D 220A  
              S0005 Supplier E 220A  
            220A   Total Suppliers 220 1
                     
                Cost and profit centers    
                Departments (CC1)    
              .OTT Department 1 TDE  
              .TOR Department 2 TDE  
            TDE   Total Department Expenses    
                     
                Projects (CC2)    
              ,JOB1 Project 1 TPR  
              ,JOB2 Project 2 TPR  
            TPR   Total Projects    
                     
                Other (CC3)    
              ;OT-1 Other 1 TOT  
              ;OT-2 Other 2 TOT  
            TOT   Total Other    
                     
                Segments    
              : Branch TS1  
              :01 Ottawa TS1  
              :02 Wancouver TS1  
            TS1   Total Branch    
                     
              :: Sectors TS2  
              ::01 Sales TS2  
              ::02 Reasearch TS2  
            TS2   Total sectors    
            Table: Sales Tax Codes
            VAT Code Description %VAT
              Last update: Jan xx, 2020  
                 
              State X1 (paid ST, county)  
              Sales tax charged County A1  
            CZipCode1 ST Charged for City 1 7.00
            CZipCode2 ST Charged for City 2 7.20
              Sales tax paid County A1  
            PZipCode1 ST paid for City 1 7.00
            PZipCode2 ST paid for City 2 7.20
              Total sales tax for County A2 1.50
                 
            CZipCode3 ST Charged for City 3 7.10
            CZipCode4 ST Charged for City 4 7.30
              Sales tax paid County A1  
            PZipCode3 ST paid for City 1 7.10
            PZipCode4 ST paid for City 2 7.30
              Total sales tax for County A1 1.60
              Sales tax Exeptions for State X1  
            EX1-01 Tax exeption State X1 for purpose 1  
            EX1-02 Tax exeption State X1 for purpose 2  
              Total State X1 5.00
                 
              State X2 (no paid, no county)  
              Sales tax charged State X2  
            CZipCode10 ST Charged for City 10 7.00
            CZipCode11 ST Charged for City 11 7.20
              Sales tax paid State X2  
            PZipCode10 ST paid for City 10 7.00
            PZipCode11 ST paid for City 11 7.20
                 
              Sales tax Exeptions for State X2  
            EX2-01 Tax exeption State X1 for purpose 1  
            EX2-02 Tax exeption State X1 for purpose 2  
              Total State X2 5.00
                 
              State X3 (no paid, county)  
              Sales tax charged County A20  
            CZipCode20 ST Charged for City 20 7.00
            CZipCode21 ST Charged for City 21 7.20
              Total sales tax for County A20 1.50
                 
              Sales tax charged County A30  
            CZipCode30 ST Charged for City 30 7.00
            CZipCode31 ST Charged for City 31 7.20
              Total sales tax for County A20 1.50
                 
              Sales tax Exeptions for State X1  
            EX3-01 Tax exeption State X1 for purpose 1  
            EX3-02 Tax exeption State X1 for purpose 2  
              Total State X1 5.00
                 
              State X4 (no paid tax, no county)  
            CZipCode40 ST Charged for City 40 7.00
            CZipCode41 ST Charged for City 41 7.20
                 
              Sales tax Exeptions for State X4  
            EX4-01 Tax exeption State X1 for purpose 1  
            EX4-02 Tax exeption State X1 for purpose 2  
              Total State X4 5.00
                 
                 
              Total final for control  
                 

            Multi-currency Accounting for company | USA | with Sales Tax | Account numbers

            In this article

              Multi-currency Accounting for company | USA | with Sales Tax | Account numbers

              Multi-currency Accounting for company | USA | with Sales Tax | Account numbers

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

              Quickly enter transactions and prepare Financial statements and sales tax report, for a company that is working in multiple currencies.

              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

              Starter Company

              Basic Currency: USD

              Double-entry with foreign currencies and VAT/Sales tax

              Table: Accounts
              Group Description Currency Sum In Gr1
                         
                  BALANCE SHEET      
                         
                  ASSETS      
                11200 Bank Account USD USD 12  
                11201 Bank Account CAD CAD 12  
                11202 Bank Account EUR EUR 12  
                11300 Petty Cash USD 12  
              120   Accounts Receivable   12 1
                12200 Allowance for Bad Debts USD 12  
                12400 Accounts Receivable - Other USD 12  
                12500 Due from Shareholder USD 12  
                12600 Due from Employees USD 12  
                12700 Investments USD 12  
                12800 Income Taxes Recoverable USD 12  
                12850 Sales Taxes Recoverable USD 12  
                13000 Inventory USD 12  
                14000 Prepaid Expenses USD 12  
                14100 Prepaid Deposits USD 12  
              12   Total Current Assets   100  
                         
                15110 Furniture and Equipment USD 15  
                15120 Furn. & Equip. - Acc. Am. USD 15  
                15210 Computer Equipment USD 15  
                15220 Computer Equip. - Acc. Am. USD 15  
                15310 Vehicle USD 15  
                15320 Vehicle - Acc. Am. USD 15  
              15   Total Long Term Assets   100  
              100   TOTAL ASSETS   00 1
                         
                  LIABILITIES & EQUITY      
                  LIABILITIES      
              220   Accounts Payable   22 1
                22200 Accrued Liabilities USD 22  
                22300 Accounts Payable - Other USD 22  
                22400 Visa payable USD 22  
                23500 Sales tax payable USD 22  
                23510 Sales Tax automatic USD 22  
                23800 Accrued Payroll USD 22  
                23900 Source Deductions Payable USD 22  
                24000 Corporate Tax Payable - Fed. USD 22  
                24100 Corporate Tax Payable - Prov. USD 22  
                25300 Line of Credit USD 22  
                25400 Due to Shareholder USD 22  
                25900 Current Portion of Debt - ST USD 22  
              22   Total Current Liabilities   2  
                         
                26200 Term Loan USD 26  
                26300 Current Portion of Debt - LT USD 26  
              26   Total Long Term Liabilities   2  
              2   Total Liabilities   2-3  
                         
                  EQUITY      
                31000 Common Shares USD 3  
                38000 Retained Earnings USD 3  
              3800   (Profit)/Loss for the period   3 1
                39000 Dividends USD 3  
              3   Total Equity   2-3  
              2-3   TOTAL LIABILITIES & EQUITY   00 1
                         
                         
                  INCOME STATEMENT      
                         
                  REVENUE      
                41100 Sales USD 4  
                41900 Other Income USD 4  
                44000 Exchange Gain/Loss USD 4  
              4   TOTAL REVENUE   L01 1
                         
                  COST OF SALES      
                51100 Inventory - Opening USD 5  
                51200 Purchases USD 5  
                52000 Freight USD 5  
                52200 Inventory - Closing USD 5  
                52300 Direct Materials USD 5  
                52400 Subcontractors USD 5  
                55100 Salaries and Wages USD 5  
                55200 CPP Expense USD 5  
                55300 EI Expense USD 5  
                55400 WSIB Expense USD 5  
                55500 Benefit Plan USD 5  
                55600 EHT Premiums USD 5  
              5   Total COST OF SALES   L01  
              L01   GROSS MARGIN   L02 1
                  EXPENSES      
                61050 Accounting USD 6  
                61100 Advertising & Marketing USD 6  
                61200 Amortization USD 6  
                61400 Bad Debts USD 6  
                61500 Bank Charges & Interest USD 6  
                61550 Business Tax & Licences USD 6  
                61600 Courier USD 6  
                61620 Computing expenses USD 6  
                61650 Consulting Fees USD 6  
                61700 Dues & Subscriptions USD 6  
                61800 Education & Training USD 6  
                61900 Equipment Rental USD 6  
                62000 Insurance USD 6  
                62100 Interest on Debt USD 6  
                62200 Legal Fees USD 6  
                62250 Management Salaries USD 6  
                62300 Meals & Entertainment USD 6  
                62400 Miscellaneous USD 6  
                62500 Office Supplies USD 6  
                62600 Rent USD 6  
                62700 Repairs & Maintenance USD 6  
                63100 Supplies USD 6  
                63200 Telephone & Internet USD 6  
                63300 Travel & Parking USD 6  
                63400 Utilities USD 6  
                63500 Vehicle Expenses USD 6  
              6   Total EXPENSES   L02 1
              L02   Income Before Income Taxes   L03  
                90000 Income Tax Provision   9  
              9   Total Income Taxes   L03 1
                         
              L03   NET (INCOME)/LOSS   3800 1
                         
              00   Total Debit/Credit Balance should be 0      
                         
                         
                  Customers/Debtors      
                C0001 Customer A USD 120A  
                C0002 Customer B USD 120A  
                C0003 Customer C USD 120A  
                C0004 Customer D USD 120A  
                C0005 Test client USD 120A  
                C0006 R J Sample Co USD 120A  
              120A   Total Customers   120 1
                         
                         
                  Suppliers/Creditors      
                S0001 Supplier A USD 220A  
                S0002 Supplier B USD 220A  
                S0003 Supplier C USD 220A  
                S0004 Supplier D USD 220A  
                S0005 Supplier E USD 220A  
              220A   Total Suppliers   220 1
                         
                  Cost and profit centers      
                  Departments (CC1)      
                .OTT Department 1 USD TDE  
                .TOR Department 2 USD TDE  
              TDE   Total Department Expenses      
                         
                  Projects (CC2)      
                ,JOB1 Project 1 USD TPR  
                ,JOB2 Project 2 USD TPR  
              TPR   Total Projects      
                         
                  Other (CC3)      
                ;OT-1 Other 1 USD TOT  
                ;OT-2 Other 2 USD TOT  
              TOT   Total Other      
                         
                  Segments      
                : Branch   TS1  
                :01 Ottawa   TS1  
                :02 Wancouver   TS1  
              TS1   Total Branch      
                         
                :: Sectors   TS2  
                ::01 Sales   TS2  
                ::02 Reasearch   TS2  
              TS2   Total sectors      
              Table: Sale Tax Codes
              VAT Code Description %VAT
                Last update: Jan xx, 2020  
                   
                State X1 (paid ST, county)  
                Sales tax charged County A1  
              CZipCode1 ST Charged for City 1 7.00
              CZipCode2 ST Charged for City 2 7.20
                Sales tax paid County A1  
              PZipCode1 ST paid for City 1 7.00
              PZipCode2 ST paid for City 2 7.20
                Total sales tax for County A2 1.50
                   
              CZipCode3 ST Charged for City 3 7.10
              CZipCode4 ST Charged for City 4 7.30
                Sales tax paid County A1  
              PZipCode3 ST paid for City 1 7.10
              PZipCode4 ST paid for City 2 7.30
                Total sales tax for County A1 1.60
                Sales tax Exeptions for State X1  
              EX1-01 Tax exeption State X1 for purpose 1  
              EX1-02 Tax exeption State X1 for purpose 2  
                Total State X1 5.00
                   
                State X2 (no paid, no county)  
                Sales tax charged State X2  
              CZipCode10 ST Charged for City 10 7.00
              CZipCode11 ST Charged for City 11 7.20
                Sales tax paid State X2  
              PZipCode10 ST paid for City 10 7.00
              PZipCode11 ST paid for City 11 7.20
                   
                Sales tax Exeptions for State X2  
              EX2-01 Tax exeption State X1 for purpose 1  
              EX2-02 Tax exeption State X1 for purpose 2  
                Total State X2 5.00
                   
                State X3 (no paid, county)  
                Sales tax charged County A20  
              CZipCode20 ST Charged for City 20 7.00
              CZipCode21 ST Charged for City 21 7.20
                Total sales tax for County A20 1.50
                   
                Sales tax charged County A30  
              CZipCode30 ST Charged for City 30 7.00
              CZipCode31 ST Charged for City 31 7.20
                Total sales tax for County A20 1.50
                   
                Sales tax Exeptions for State X1  
              EX3-01 Tax exeption State X1 for purpose 1  
              EX3-02 Tax exeption State X1 for purpose 2  
                Total State X1 5.00
                   
                State X4 (no paid tax, no county)  
              CZipCode40 ST Charged for City 40 7.00
              CZipCode41 ST Charged for City 41 7.20
                   
                Sales tax Exeptions for State X4  
              EX4-01 Tax exeption State X1 for purpose 1  
              EX4-02 Tax exeption State X1 for purpose 2  
                Total State X4 5.00
                   
                   
                Total final for control  
                   
              Table: Exchange rates
              Ref.Currency Currency Text
                CAD Canadian Dollar
                EUR Euro