ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Abdullah CPA Professional Corporation 2023
2
Self Employment Bookkeeping
3
4
5
6
7
8
9
10
Instructions
11
1. Copy this sheet: File > Make a Copy (or Download as Excel)
12
2. Fill in the blue shaded cells in the "Your Information" section below.
13
3. Enter your revenue and expense transactions in the blue shaded cells under the "Bookkeeping" section below.
14
4. You can enter each item on a separate line, or add up similar items and put the group total on one line.
15
5. Select a transaction type from the dropdown menu under "Transaction Type".
16
6. Include descriptions and specific dates for each transaction to help you remember what transactions relate to.
17
7. Enter all transaction amounts as positive numbers
18
8. If you're not sure of which expenses are eligible to be deducted, reach out to us-->
19
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).
20
10. Also check out this instruction video linked here -->
21
22
Example of Bookkeeping
23
Transaction DescriptionDateGross AmountGST/HSTNet AmountTransaction Type
24
Staples - Paper and suppliesFebruary 20, 202258.002.7655.24Office Expenses
25
Telus Mobility - Phone bills for the year 2022864.0040.37823.63Telephone and Utilities
26
Sales - January web design work forJanuary 1, 20221,575.0075.001,500.00Sales
27
Sales - Invoice #003 May 22, 2022840.0040.00800.00Sales
28
Best Buy - MacBook ProSeptember 30, 20222,260.00105.612,154.39Capital Asset - Computer Equipment
29
30
Your Information
31
Your Name
Abdullah CPA Professional Corporation
32
Year2023
33
Do you charge GST/HST?Yes
Please enter both the gross transaction amounts and GST/HST amounts.
34
Did you work from a home office at all during the year?Yes
Please fill out the Home Office Tab (see purple tab below).
35
36
Bookkeeping
37
Transaction DescriptionDateGross AmountGST/HSTNet AmountTransaction TypeClient/Vendor
38
0.00Software SubscriptionsTaxcycle
39
0.00AdvertisingInspirit art
40
0.00AdvertisingInspirit art
41
0.00AdvertisingInspirit art
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