Canada: Templates and Extensions

The Canada Section of the Banana Template Store offers free templates and specific extensions for Canada, designed for different types of users, purposes, and levels of accounting knowledge:

Templates are files in .ac2 format, with predefined charts of accounts and some sample entries.
Extensions are small add-ons that expand the program’s functionality with new features and integrations.

Templates are also accessible directly within the Banana Accounting program (menu File > New).

Templates Canada

Templates Accounting Business Canada

Templates Accounting Business without GST/HST Tax Canada

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

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

Templates Accounting Business with GST/HST Tax Canada

Free Cash manager for with GST/HST Management | Canada

Canada

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.

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

Sole Proprietorship with GST/HST Management | Canada | Incomes and Expenses Accounting

Canada

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

Download template

Documentation: Income & Expense Accounting with vat/sales tax

Template preview

Show Preview

Sole proprietorship

Basic Currency: CAD

Income & Expense accounting with VAT/Sales tax

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

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

Double entry accounting for business in Canada with GST/HST | Account numbers

Canada

Double-Entry Accounting with vat/sales tax

Business

Professional 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

Template documentation

Description

These double entry accounting template has been prepared by a CPA operating in Ontario for their internal accounting and financial planning. Following is a quote why is using Banana Accounting next to their other accounting solution.

"Here are some benefits that I see for your software:

Works well without requiring an internet connection – work can usually be completed faster without such delays.
It allows very high customization.
It allows easy and complete collaboration between an outside accountant and users.
Time saving – accounting records can be partially entered and completed later by the same person or the accountant.
The spreadsheet interface is easy to understand.
Every transaction can be entered in one form, as opposed to not knowing in what screen in which to enter something.
Data can be easily copied and pasted into a spreadsheet for further analysis.
Setup of a new data file is relatively easy with the appropriate template.
Your program can run on many platforms.
Tasks can be automated using internal application programs.
One can purchase an upgrade when it makes sense, as opposed to paying every day for the use of the software.
The purchase and upgrade prices are affordable."

There is also:

Template preview

Show Preview

Starter Company Banana

Basic Currency: CAD

Double-entry with VAT/Sales tax

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

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

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

Description

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

Extensions Canada

Bank of Nova Scotia (Canada) - import transactions .csv

Import

Canada

Import extension for importing CSV file of Bank of Nova Scotia (Canada) .

Import extension allows you to import transactions from a CSV file of Bank of Nova Scotia (Canada), using the command Import into Accounting.

Canada Invoice layout 01 for professional services

Invoices

Canada

Invoice layout for a CPA service business, with HST and currency "$". Colors and other setting can be customized.

View on Github

Attributes

Header

The header contains information specified in the File and accounting properties (menu File -> File and accounting properties -> Address).
It is displayed on the top-left of the page.

Invoice and customer information

Invoice number, invoice date, invoice number, expiration date of the invoice and page number are displayed here.
The expiration date of the invoice is automatically calculated, but it is possible to overwrite that information using the DocType column options.

Customer address

The customer address is taken from the Accounts table (address view).
It is possible to manually define an address on the transactions table using the DocType column options.
The address is displayed on the left of the page.

Items table

A table where are listed all the items of the invoice.
It is composed of four columns: description and total.
At the end of the items table are displayed Total net, HST amount and final Total of the invoice.

Invoice settings

User can change some settings of the invoice.
From the Menu Apps -> Manage apps… -> Installed -> select Style 1: Canada invoice -> click on the Settings button on the right:

enable/disable the header
- Set 1 to include the header on the top of the page (default value)
- Set 0 to not include it.
enable/disable the header
- Set 1 to include the payment slip on the bottom of the page of the page
- Set 0 to not include it. (default value)
Color1
- Defines the main color of the header used for the invoice label.
- Empty for default value (blue).
Color2
- Defines the color of the text.
- Empty for default value (black).

Colors can be standard colors (for example: “red”, "yellow", “blue”, “green”, “black”, "grey", etc) or in the Hexadecimal format (for example: #ff0000).

invoice canada
Example of invoice