In this article
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 WebAppTemplate preview
Starter Company
Basic Currency: USD
Double-entry with foreign currencies and VAT/Sales tax
| Group | Account | 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 |
| 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 | ||
| Ref.Currency | Currency | Text |
|---|---|---|
| CAD | Canadian Dollar | |
| EUR | Euro |