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
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
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
Sole proprietorship
Basic Currency: CAD
Income & Expense accounting with VAT/Sales tax
| Group | Account | 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 |
| 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(-) | ||
| 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
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 WebAppTemplate 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.
- Sales Tax Charged
- 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
| Group | Account | 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 |
| 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
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 |