| Banana Accounting Software

Free Cash manager for with GST/HST Management | Canada

Canada

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

Download template

Documentation: Cash Manager with VAT/Sales tax

Template preview

Show Preview

Sole proprietorship

Basic Currency: CAD

Cash Manager with VAT/Sales tax

Table: Accounts
Group	Account	Description	Sum In

	Cash	Cash and Bank assets

Table: Categories
Group	Category	Description	Sum In
		CASH FLOW

		INCOME	4
	Sales	Cash sales	4
	Miscellaneous income	Miscellaneous cash receipts	4
	Interest income	Interest income	4
	Tax refund	Income tax refund	4
4		TOTAL INCOME	0

		EXPENSES	3
	Product costs	Direct product/service costs	3
	Salaries	Salaries direct	3
	Payroll taxes	Payroll taxes and benefits direct	3
	Supplies	Supplies	3
	Advertising	Advertising and promotion	3
	Automobile	Automobile/Transportation	3
	Bank charges	Bank service charges	3
	Licenses	Business licenses and permits	3
	Charity	Charitable contributions	3
	Computer	Computer and internet	3
	Education	Continuing education	3
	Subscriptions	Dues and subscriptions	3
	Insurance	Insurance	3
	Meals	Meals and entertainment	3
	Merchant fees	Merchant account fees	3
	Office supplies	Office supplies	3
	Postage	Postage and delivery	3
	Printing	Printing and reproduction	3
	Legal services	Professional and Legal services	3
	Rent	Rental payments	3
	Subcontractor	Subcontractor	3
	Telephone	Telephone	3
	Travel	Travel	3
	Utilities	Utilities	3
	Website	Website development	3
	Other costs	Other costs	3
	Interest expense	Interest expense	3
	Tax expense	Income tax expense	3
	ST	Sales tax	3
3		TOTAL EXPENSES	0

0		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 14, 2016

	HST/GST Charged
7	HST charged on sales (included)	13.00
8	GST charged on sales (included)	5.00
17	HST charged on sales (tax entry only)
18	GST charged on sales (tax entry only)
	Total HST/GST charged on Sales
	Total HST/GST Charged

	HST Paid
1	HST paid on purchases (included)	13.00
2	HST paid on meals (included)	6.50
3	GST paid on purchases (included)	5.00
4	GST paid on meals (included)	2.50
11	HST paid on purchases (tax entry only)
12	GST paid on purchases (tax entry only)
	Total HST/GST paid on purchases
	Total HST/GST (payable) or recoverable

	Final total for control


	GST & QST Charged
9	GST & QST charged on sales (included)	14.98
19	GST & QST charged on sales (tax entry only)
	Total GST/QST charged on sales
	Total GST/QST Charged

	GST & QST Paid
5	GST & QST paid on purchases (included)	14.98
6	GST & QST paid on meals (included)	7.49
15	GST & QST paid on purchases (tax entry only)
	Total GST & QST paid on purchases
	Total GST & QST (payable) or recoverable

	Final total for control

Multi-Currency Accounting for Company | Canada | Account numbers

Canada

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

Download template

Documentation: Double-Entry Accounting with foreign currencies

Template preview

Show Preview

Starter Company Banana

Basic Currency: CAD

Double-entry with foreign currencies

Table: Accounts
Group	Account	Description	Currency	Sum In	Gr1

		BALANCE SHEET

		ASSETS
	11200	Bank Account	CAD	12
	11201	Bank Account USD	USD	12
	11202	Bank Account EUR	EUR	12
	11300	Petty Cash	CAD	12
120		Accounts Receivable		12	1
	12200	Allowance for Bad Debts	CAD	12
	12400	Accounts Receivable - Other	CAD	12
	12500	Due from Shareholder	CAD	12
	12600	Due from Employees	CAD	12
	12700	Investments	CAD	12
	12800	Income Taxes Recoverable	CAD	12
	12850	Sales Taxes Recoverable	CAD	12
	13000	Inventory	CAD	12
	14000	Prepaid Expenses	CAD	12
	14100	Prepaid Deposits	CAD	12
12		Total Current Assets		100

	15110	Furniture and Equipment	CAD	15
	15120	Furn. & Equip. - Acc. Am.	CAD	15
	15210	Computer Equipment	CAD	15
	15220	Computer Equip. - Acc. Am.	CAD	15
	15310	Vehicle	CAD	15
	15320	Vehicle - Acc. Am.	CAD	15
15		Total Long Term Assets		100
100		TOTAL ASSETS		00	1

		LIABILITIES & EQUITY
		LIABILITIES
220		Accounts Payable		22	1
	22200	Accrued Liabilities	CAD	22
	22300	Accounts Payable - Other	CAD	22
	22400	Visa payable	CAD	22
	23500	HST Charged on Sales	CAD	22
	23510	HST Paid on Purchases	CAD	22
	23520	HST Instalments	CAD	22
	23530	HST Payable	CAD	22
	23600	PST Payable	CAD	22
	23700	GST & QST Payable	CAD	22
	23800	Accrued Payroll	CAD	22
	23900	Source Deductions Payable	CAD	22
	24000	Corporate Tax Payable - Fed.	CAD	22
	24100	Corporate Tax Payable - Prov.	CAD	22
	25300	Line of Credit	CAD	22
	25400	Due to Shareholder	CAD	22
	25900	Current Portion of Debt - ST	CAD	22
22		Total Current Liabilities		2

	26200	Term Loan	CAD	26
	26300	Current Portion of Debt - LT	CAD	26
26		Total Long Term Liabilities		2
2		Total Liabilities		2-3

		EQUITY
	31000	Common Shares	CAD	3
	38000	Retained Earnings	CAD	3
3800		(Profit)/Loss for the period		3	1
	39000	Dividends	CAD	3
3		Total Equity		2-3
2-3		TOTAL LIABILITIES & EQUITY		00	1


		INCOME STATEMENT

		REVENUE
	41100	Sales	CAD	4
	41900	Other Income	CAD	4
	44000	Exchange Gain/Loss	CAD	4
4		TOTAL REVENUE		L01	1

		COST OF SALES
	51100	Inventory - Opening	CAD	5
	51200	Purchases	CAD	5
	52000	Freight	CAD	5
	52200	Inventory - Closing	CAD	5
	52300	Direct Materials	CAD	5
	52400	Subcontractors	CAD	5
	55100	Salaries and Wages	CAD	5
	55200	CPP Expense	CAD	5
	55300	EI Expense	CAD	5
	55400	WSIB Expense	CAD	5
	55500	Benefit Plan	CAD	5
	55600	EHT Premiums	CAD	5
5		Total COST OF SALES		L01
L01		GROSS MARGIN		L02	1
		EXPENSES
	61050	Accounting	CAD	6
	61100	Advertising & Marketing	CAD	6
	61200	Amortization	CAD	6
	61400	Bad Debts	CAD	6
	61500	Bank Charges & Interest	CAD	6
	61550	Business Tax & Licences	CAD	6
	61600	Courier	CAD	6
	61620	Computing expenses	CAD	6
	61650	Consulting Fees	CAD	6
	61700	Dues & Subscriptions	CAD	6
	61800	Education & Training	CAD	6
	61900	Equipment Rental	CAD	6
	62000	Insurance	CAD	6
	62100	Interest on Debt	CAD	6
	62200	Legal Fees	CAD	6
	62250	Management Salaries	CAD	6
	62300	Meals & Entertainment	CAD	6
	62400	Miscellaneous	CAD	6
	62500	Office Supplies	CAD	6
	62600	Rent	CAD	6
	62700	Repairs & Maintenance	CAD	6
	63100	Supplies	CAD	6
	63200	Telephone & Internet	CAD	6
	63300	Travel & Parking	CAD	6
	63400	Utilities	CAD	6
	63500	Vehicle Expenses	CAD	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	CAD	120A
	C0002	Customer B	CAD	120A
	C0003	Customer C	CAD	120A
	C0004	Customer D	CAD	120A
	C0005	Test client	CAD	120A
	C0006	R J Sample Co	CAD	120A
120A		Total Customers		120	1


		Suppliers/Creditors
	S0001	Supplier A	CAD	220A
	S0002	Supplier B	CAD	220A
	S0003	Supplier C	CAD	220A
	S0004	Supplier D	CAD	220A
	S0005	Supplier E	CAD	220A
220A		Total Suppliers		220	1

		Cost and profit centers
		Departments (CC1)
	.OTT	Department 1	CAD	TDE
	.TOR	Department 2	CAD	TDE
TDE		Total Department Expenses

		Projects (CC2)
	,JOB1	Project 1	CAD	TPR
	,JOB2	Project 2	CAD	TPR
TPR		Total Projects

		Other (CC3)
	;OT-1	Other 1	CAD	TOT
	;OT-2	Other 2	CAD	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
	USD
	EUR

Double Entry Accounting for Company | Canada | Account numbers

Canada

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

Download template

Documentation: Double-Entry Accounting

Template preview

Show Preview

Starter Company Banana

Basic Currency: CAD

Double-entry

Table: Accounts
Group	Account	Description	Sum In	Gr1

		BALANCE SHEET

		ASSETS
	11200	Bank Account	12
	11201	Bank Account USD	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	HST Charged on Sales	22
	23510	HST Paid on Purchases	22
	23520	HST Instalments	22
	23530	HST Payable	22
	23600	PST Payable	22
	23700	GST & QST Payable	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

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

Download template

Documentation: Double-Entry Accounting

Template preview

Show Preview

Starter Company

Basic Currency: USD

Double-entry

Table: Accounts
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

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

Download template

Documentation: Double-Entry Accounting with vat/sales tax

Template documentation

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.

Template preview

Show Preview

Starter Company

Basic Currency: USD

Double-entry with VAT/Sales tax

Table: Accounts
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

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 | 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

Download template

Documentation: Double-Entry Accounting with foreign currencies

Template preview

Show Preview

Starter Company

Basic Currency: USD

Double-entry with foreign currencies

Table: Accounts
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	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

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

Download template

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

Template preview

Show Preview

Starter Company

Basic Currency: USD

Double-entry with foreign currencies and VAT/Sales tax

Table: Accounts
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

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

Create UAE VAT report with Banana

Collecting all the necessary VAT information

To fill the online form, you need to calculate the VAT and collect all the information regarding issued and received invoices, VAT imposable and VAT amounts for the different required categories.

By using a specific tool, like Banana Accounting Software (lifetime license costs approximately US$ 135, VAT excluded) the process of collecting and calculating VAT is simplified.

Multi currency-accounting template for enterprise in United Arab Emirates

UAE (United Arab Emirates)

Double-Entry Accounting with foreign currencies

Business

Double entry accounting for the United Arab Emirates.

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

Download template

Documentation: Double-Entry Accounting with foreign currencies

Template preview

Show Preview

UAE-Multicurrency-VAT

Basic Currency: AED

Double-entry with foreign currencies

Table: Accounts
Group	Account	Description	Currency	Sum In
		BALANCE SHEET

		ASSETS

	101001	Trademark	AED	101NCA
101NCA		Intangible Non Current Assets		1NCA
	102001	Machineries and appliances	AED	102NCA
	102005	Furniture	AED	102NCA
	102010	Hardware	AED	102NCA
	102015	Software	AED	102NCA
102NCA		Tangible Non Current Assets		1NCA
	103001	Security Deposit	AED	103NCA
103NCA		Financial Non Current Assets		1NCA
1NCA		Non Current Assets		1
	107001	Inventory	AED	107CA
107CA		Inventory		1CA
10		Clients		108CA
	108001	Invoices to be issued	AED	108CA
108CA		Trade receivables		1CA
	109001	Advance Payment	AED	109CA
	109005	Prepaid Rent	AED	109CA
	109010	Prepaid License Fee	AED	109CA
	109015	Prepaid Insurance	AED	109CA
	109020	Rent Security Deposit	AED	109CA
109CA		Other Current Assets		1CA
	110001	input VAT on purchases (box 9)	AED	110CA
	110002	- Input VAT - adjustment unpaid suppliers older than 6 month (box 9)	AED	110CA
	110005	Input VAT - purchase with reverse charge (box 10)	AED	110CA
110CA		Tax Receivable		1CA
	112001	Cash	AED	112CA
	112005	Bank AED	AED	112CA
	112010	Bank EUR	EUR	112CA
	112015	Bank USD	USD	112CA
	112016	Bank CNY	CNY	112CA
112CA		Cash and cash equivalent		1CA
1CA		Current Assets		1
1		Total ASSETS		00

		LIABILITIES
	201001	Share Capital	AED	2SE
	201005	Reseve	AED	2SE
	201010	Retained (Profit) or Loss	AED	2SE
230		Profit or loss of the current year		2
2SE		Shareholders' Equity		2
	205001	Shareholders' loan - AED	AED	205NCL
	201002	Shareholders' loan - EUR	EUR	205NCL
	205010	Long term loan	AED	205NCL
205NCL		Financial Non Current Liabilities		2NCL
	207001	End of service gratuity	AED	207NCL
207NCL		Employee Benefit Provision		2NCL
2NCL		Non Current Liabilities		2
	210001	Bank Loan	AED	210CL
210CL		Financial Current Liabilities		2CL
20		Suppliers	AED	211CL
	211005	Invoices to be received	AED	211CL
211CL		Trade payables		2CL
	212200A	Automatic VAT	AED	212CL
	212200	VAT payable	AED	212CL
	212201	Automatic VAT Account	AED	212CL
	212202	VAT temporary reverse charge	AED	212CL
212CL		Tax liabilities		2CL
	213001	Payables vs personnel	AED	213CL
	213015	Accruals AED	AED	213CL
	213020	Other current liabilities	AED	213CL
213CL		Other Current Liabilities		2CL
2CL		Current Liabilities		2
2		Total LIABILITIES & EQUITY		00


		PROFIT/LOSS STATEMENT

		EXPENSES

	301001	Variation of inventories	AED	301MA
	301005	Purchase of materials	AED	301MA
	301015	Duty and freight	AED	301MA
301MA		Material		3OC
	302001	Licenses	AED	302SE
	302005	Administrative costs	AED	302SE
	302010	Professioanal consultancies	AED	302SE
	302015	Legal fee	AED	302SE
	302020	Accounting services	AED	302SE
	302025	Audit fee	AED	302SE
	302030	Utilities	AED	302SE
	302035	Maintenance and repairs	AED	302SE
	302040	IT services	AED	302SE
	302045	Office rent	AED	302SE
	302050	Travel expenses	AED	302SE
	302055	Marketing expenses	AED	302SE
	302060	Insurance	AED	302SE
302SE		Services Rental and Lease		3OC
	303001	Salary	AED	303PE
	303005	End of service	AED	303PE
	303010	Health insurance	AED	303PE
	303015	VISA	AED	303PE
	303020	Other personnel cost	AED	303PE
303PE		Personnel		3OC
	304001	Amort machineries and appliances	AED	304AM
	304005	Amort furniture	AED	304AM
	304010	Amort hardware	AED	304AM
304AM		Amortisation		3OC
	305001	provision for doubtful accounts	AED	305OT
	305015	other provision	AED	305OT
	305020	Negative adjustments	AED	305OT
305OT		Other costs		3OC
3OC		Operating costs		3
	306001	Bank interest payable	AED	3FC
	306005	Foreign currency losses	AED	3FC
3FC		Finance Costs		3
3		Total EXPENSES		02

		REVENUE
	401001	Sales	AED	401EI
401EI		External Incomes		4OI
	402001	Services Intragroup	AED	402II
402II		Intragroup Incomes		4OI
	403001	Positive adjustments	AED	403OI
	403005	Ohter Incomes	AED	403OI
403OI		Other Incomes		4OI
4OI		Operating revenues		4
	404001	Bank interest receivable	AED	4FI
	404005	Foreigh currency profit	AED	4FI
4FI		Finance Income		4
4		Total REVENUE		02

02		Profit(-) Loss(+) from Profit & Loss Statement		230

00		Difference should be = 0 (blank cell)


		Customers/Debtors
	11.001	Altmann&Sons	AED	10A
	11.002	Peter&Co.	AED	10A
	11.003	MC	AED	10A
	11.004	JDWater	AED	10A
	11.005	RossiCostruzioni	AED	10A
10A		Total Customers		10


		Suppliers/Creditors
	20.001	Smith&Co	AED	20A
	20.002	Doe&Sons	AED	20A
	20.003	BosiaSoftware	AED	20A
20A		Total Suppliers		20

Table: Exchange rates
Ref.Currency	Currency	Text
AED	EUR	Euro
AED	USD	US Dollars
AED	CNY	Chinese Yuan

Multi-Currency Accounting for Company GST/HST Tax | Canada | Account numbers

Canada

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

Business

Multi-Currency double entry template for financial planning and accounting in Canada, inclusive of GST/HST codes.

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

Download template

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

Template documentation

These double entry accounting template has been prepared by a CPA operating in Ontario for their internal accounting and financial planning.

Template preview

Show Preview

Starter Company Banana

Basic Currency: CAD

Double-entry with foreign currencies and VAT/Sales tax

Table: Accounts
Group	Account	Description	Currency	Sum In	Gr1

		BALANCE SHEET

		ASSETS
	11200	Bank Account	CAD	12
	11201	Bank Account USD	USD	12
	11202	Bank Account EUR	EUR	12
	11300	Petty Cash	CAD	12
120		Accounts Receivable		12	1
	12200	Allowance for Bad Debts	CAD	12
	12400	Accounts Receivable - Other	CAD	12
	12500	Due from Shareholder	CAD	12
	12600	Due from Employees	CAD	12
	12700	Investments	CAD	12
	12800	Income Taxes Recoverable	CAD	12
	12850	Sales Taxes Recoverable	CAD	12
	13000	Inventory	CAD	12
	14000	Prepaid Expenses	CAD	12
	14100	Prepaid Deposits	CAD	12
12		Total Current Assets		100

	15110	Furniture and Equipment	CAD	15
	15120	Furn. & Equip. - Acc. Am.	CAD	15
	15210	Computer Equipment	CAD	15
	15220	Computer Equip. - Acc. Am.	CAD	15
	15310	Vehicle	CAD	15
	15320	Vehicle - Acc. Am.	CAD	15
15		Total Long Term Assets		100
100		TOTAL ASSETS		00	1

		LIABILITIES & EQUITY
		LIABILITIES
220		Accounts Payable		22	1
	22200	Accrued Liabilities	CAD	22
	22300	Accounts Payable - Other	CAD	22
	22400	Visa payable	CAD	22
	23500	HST Charged on Sales	CAD	22
	23510	HST Paid on Purchases	CAD	22
	23520	HST Instalments	CAD	22
	23530	HST Payable	CAD	22
	23600	PST Payable	CAD	22
	23700	GST & QST Payable	CAD	22
	23800	Accrued Payroll	CAD	22
	23900	Source Deductions Payable	CAD	22
	24000	Corporate Tax Payable - Fed.	CAD	22
	24100	Corporate Tax Payable - Prov.	CAD	22
	25300	Line of Credit	CAD	22
	25400	Due to Shareholder	CAD	22
	25900	Current Portion of Debt - ST	CAD	22
22		Total Current Liabilities		2

	26200	Term Loan	CAD	26
	26300	Current Portion of Debt - LT	CAD	26
26		Total Long Term Liabilities		2
2		Total Liabilities		2-3

		EQUITY
	31000	Common Shares	CAD	3
	38000	Retained Earnings	CAD	3
3800		(Profit)/Loss for the period		3	1
	39000	Dividends	CAD	3
3		Total Equity		2-3
2-3		TOTAL LIABILITIES & EQUITY		00	1


		INCOME STATEMENT

		REVENUE
	41100	Sales	CAD	4
	41900	Other Income	CAD	4
	44000	Exchange Gain/Loss	CAD	4
4		TOTAL REVENUE		L01	1

		COST OF SALES
	51100	Inventory - Opening	CAD	5
	51200	Purchases	CAD	5
	52000	Freight	CAD	5
	52200	Inventory - Closing	CAD	5
	52300	Direct Materials	CAD	5
	52400	Subcontractors	CAD	5
	55100	Salaries and Wages	CAD	5
	55200	CPP Expense	CAD	5
	55300	EI Expense	CAD	5
	55400	WSIB Expense	CAD	5
	55500	Benefit Plan	CAD	5
	55600	EHT Premiums	CAD	5
5		Total COST OF SALES		L01
L01		GROSS MARGIN		L02	1
		EXPENSES
	61050	Accounting	CAD	6
	61100	Advertising & Marketing	CAD	6
	61200	Amortization	CAD	6
	61400	Bad Debts	CAD	6
	61500	Bank Charges & Interest	CAD	6
	61550	Business Tax & Licences	CAD	6
	61600	Courier	CAD	6
	61620	Computing expenses	CAD	6
	61650	Consulting Fees	CAD	6
	61700	Dues & Subscriptions	CAD	6
	61800	Education & Training	CAD	6
	61900	Equipment Rental	CAD	6
	62000	Insurance	CAD	6
	62100	Interest on Debt	CAD	6
	62200	Legal Fees	CAD	6
	62250	Management Salaries	CAD	6
	62300	Meals & Entertainment	CAD	6
	62400	Miscellaneous	CAD	6
	62500	Office Supplies	CAD	6
	62600	Rent	CAD	6
	62700	Repairs & Maintenance	CAD	6
	63100	Supplies	CAD	6
	63200	Telephone & Internet	CAD	6
	63300	Travel & Parking	CAD	6
	63400	Utilities	CAD	6
	63500	Vehicle Expenses	CAD	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	CAD	120A
	C0002	Customer B	CAD	120A
	C0003	Customer C	CAD	120A
	C0004	Customer D	CAD	120A
	C0005	Test client	CAD	120A
	C0006	R J Sample Co	CAD	120A
120A		Total Customers		120	1


		Suppliers/Creditors
	S0001	Supplier A	CAD	220A
	S0002	Supplier B	CAD	220A
	S0003	Supplier C	CAD	220A
	S0004	Supplier D	CAD	220A
	S0005	Supplier E	CAD	220A
220A		Total Suppliers		220	1

		Cost and profit centers
		Departments (CC1)
	.OTT	Department 1	CAD	TDE
	.TOR	Department 2	CAD	TDE
TDE		Total Department Expenses

		Projects (CC2)
	,JOB1	Project 1	CAD	TPR
	,JOB2	Project 2	CAD	TPR
TPR		Total Projects

		Other (CC3)
	;OT-1	Other 1	CAD	TOT
	;OT-2	Other 2	CAD	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: GST/HST codes
VAT Code	Description	%VAT
	Last update: Jan 14, 2016

	HST/GST Charged
7	HST charged on sales (included)	13.00
8	GST charged on sales (included)	5.00
17	HST charged on sales (tax entry only)
18	GST charged on sales (tax entry only)
	Total HST/GST charged on Sales
	Total HST/GST Charged

	HST Paid
1	HST paid on purchases (included)	13.00
2	HST paid on meals (included)	6.50
3	GST paid on purchases (included)	5.00
4	GST paid on meals (included)	2.50
11	HST paid on purchases (tax entry only)
12	GST paid on purchases (tax entry only)
	Total HST/GST paid on purchases
	Total HST/GST (payable) or recoverable

	Final total for control


	GST & QST Charged
9	GST & QST charged on sales (included)	14.98
19	GST & QST charged on sales (tax entry only)
	Total GST/QST charged on sales
	Total GST/QST Charged

	GST & QST Paid
5	GST & QST paid on purchases (included)	14.98
6	GST & QST paid on meals (included)	7.49
15	GST & QST paid on purchases (tax entry only)
	Total GST & QST paid on purchases
	Total GST & QST (payable) or recoverable

	Final total for control

Table: Exchange rates
Ref.Currency	Currency	Text
	USD
	EUR

Subscribe to

Share this article: Twitter | Facebook | LinkedIn | Email