Self Employment Bookkeeping Template

	A	B	C	D	E	F
1						Contact: hello@avalonaccounting.ca
2	Self Employment Bookkeeping
3
4	Instructions
5	1. Copy this sheet: File > Make a Copy (or Download as Excel)
6	2. Fill in the blue shaded cells in the "Your Information" section below.
7	3. Enter your revenue and expense transactions in the blue shaded cells under the "Bookkeeping" section below.
8	4. You can enter each item on a separate line, or add up similar items and put the group total on one line.
9	5. Select a transaction type from the dropdown menu under "Transaction Type".
10	6. Include descriptions and specific dates for each transaction to help you remember what transactions relate to.
11	7. Enter all transaction amounts as positive numbers
12	8. If you're not sure of which expenses are eligible to be deducted, check out our guide here -->		What can you deduct?
13	9. Once you've finished entering your transactions, your income statement for the year will be completed on the income statement tab (see green tab below).
14
15	Example of Bookkeeping
16	Transaction Description	Date	Gross Amount	GST/HST	Net Amount	Transaction Type
17	Staples - Paper and supplies	February 20, 2016	58.00	2.76	55.24	Office Expenses
18	Telus Mobility - Phone bills for the year	July 1905	864.00	40.37	823.63	Telephone and Utilities
19	Sales - January web design work for Avalon Brewing Co.	January 2016	1,575.00	75.00	1,500.00	Revenue
20	Sales - Invoice #003	May 22, 2016	840.00	40.00	800.00	Revenue
21	Best Buy - MacBook Pro	September 30, 2016	2,260.00	105.61	2,154.39	Purchase of Capital Assets
22
23	Your Information
24	Your Name
25	Year
26	Do you charge GST/HST?
27	Did you work from a home office at all during the year?
28
29	Bookkeeping
30	Transaction Description	Date	Gross Amount	GST/HST	Net Amount	Transaction Type
31					0.00
32					0.00
33					0.00
34					0.00
35					0.00
36					0.00
37					0.00
38					0.00
39					0.00
40					0.00
41					0.00
42					0.00
43					0.00
44					0.00
45					0.00
46					0.00
47					0.00
48					0.00
49					0.00
50					0.00
51					0.00
52					0.00
53					0.00
54					0.00
55					0.00
56					0.00
57					0.00
58					0.00
59					0.00
60					0.00
61					0.00
62					0.00
63					0.00
64					0.00
65					0.00
66					0.00
67					0.00
68					0.00
69					0.00
70					0.00
71					0.00
72					0.00
73					0.00
74					0.00
75					0.00
76					0.00
77					0.00
78					0.00
79					0.00
80					0.00
81					0.00
82					0.00
83					0.00
84					0.00
85					0.00
86					0.00
87					0.00
88					0.00
89					0.00
90					0.00
91					0.00
92					0.00
93					0.00
94					0.00
95					0.00
96					0.00
97					0.00
98					0.00
99					0.00
100					0.00