YouTube2Text

How I Use Claude to Automate Tax and Bookkeeping (Beginner Tutorial) — Transcript

by Softgirlnocode · 1,867 words · 276 segments · language en · Watch on YouTube

Full transcript

  1. 0:00So, what is Claude code? The name
  2. 0:02itself, it's a little misleading. Claude
  3. 0:03code is basically Claude, but instead of
  4. 0:06living in a browser, it lives inside of
  5. 0:08your computer's terminal. And your
  6. 0:10terminal is just a text interface for
  7. 0:13your computer. When you chat with Claude
  8. 0:14normally, it gives you answer, but it
  9. 0:16doesn't really do anything on your
  10. 0:18computer. It can't create files, it
  11. 0:20can't touch your Google Drive, or
  12. 0:22organize your desktop for you. But
  13. 0:24Claude code can. Think of it like the
  14. 0:26difference between calling a contractor
  15. 0:28on the phone for advice versus actually
  16. 0:30letting them into your house to do the
  17. 0:32work. Claude code is the contractor
  18. 0:34walking through your front door, rolling
  19. 0:36up their sleeves, and building the
  20. 0:38thing. Now, how do you access it? You
  21. 0:40want to access it through an IDE. IDE
  22. 0:42stands for integrated developer
  23. 0:44environment, basically just a coding
  24. 0:46workspace. VS Code is the one I use. It
  25. 0:49is completely free. It might seem
  26. 0:51unfamiliar at first when you open it up
  27. 0:54for the first time, but this is really
  28. 0:55what it is. On the left side, you have
  29. 0:57your folder structure, all your files,
  30. 1:00scripts, documents, and on the right
  31. 1:02side, you have your chat window where
  32. 1:04you talk to Claude in plain English.
  33. 1:06Claude code's real power is its ability
  34. 1:08to write code so well that it can
  35. 1:10basically build any program or system
  36. 1:12for you. To get its full capacity, you
  37. 1:15have to use it as a terminal through an
  38. 1:17IDE, and that's where you get the best
  39. 1:19quality output and the most efficient
  40. 1:21use of your tokens. If you're using
  41. 1:23Claude code through the built-in Claude
  42. 1:24interface or the Chrome extension,
  43. 1:26you're essentially using a lighter
  44. 1:28version of it. It is good for quick
  45. 1:30tasks, but it can't fully execute Python
  46. 1:33scripts on your machine, and you will
  47. 1:34burn through your token limit faster
  48. 1:36because the back and forth is less
  49. 1:38efficient. When you access it through an
  50. 1:39IDE like VS Code, you're giving it real
  51. 1:42workspace. It can see your entire folder
  52. 1:44structure, write scripts, run them,
  53. 1:46catch errors, fix them, and iterate all
  54. 1:49in one session. So, if you're serious
  55. 1:51about building something and automation
  56. 1:53a tool, I would definitely install VS
  57. 1:55Code. It is free, takes 5 minutes to set
  58. 1:57up, and the difference between getting
  59. 1:5920% of what Claude code can do versus
  60. 2:01the whole thing. Now that we established
  61. 2:03the basic, let's install VS Code and
  62. 2:05start setting it up. Open VS Code, go to
  63. 2:07extension tab, and search Claude code to
  64. 2:10install it, and you will see this one
  65. 2:12from Anthropic. Once you do that, you
  66. 2:14will see the Claude code icon appear as
  67. 2:16an agent window, and then you can start
  68. 2:18using it as your chat interface. And
  69. 2:20next, before you open anything, go to
  70. 2:22your desktop and create a folder. In my
  71. 2:24case, it's called Bookkeeper Tax. Then,
  72. 2:27open VS Code and open that folder as
  73. 2:29your workspace. Now, Claude code is
  74. 2:31going to operate within that folder.
  75. 2:33Then, the next thing you want to do is
  76. 2:34go to setting and enable allow
  77. 2:37dangerously skip permission. What this
  78. 2:39does is is stop Claude from pausing
  79. 2:41every 2 minutes to ask, "Can I run this
  80. 2:44command? Can I access this file?" It
  81. 2:46lets it work continuously without having
  82. 2:48you click approve all the time. Now, the
  83. 2:50next step is to generate Claude MD file.
  84. 2:52This is a very important thing you need
  85. 2:54to set up before you start building
  86. 2:56anything. MD file is basically a
  87. 2:58permanent briefing document Claude reads
  88. 3:00automatically at the start of every
  89. 3:02single session. It is where you define
  90. 3:04what the project is, what's the folder
  91. 3:06structure, how should files be
  92. 3:08organized, what are some of the rules,
  93. 3:10so you're just setting up the
  94. 3:11guardrails. Now, how do you get a Claude
  95. 3:13MD file? You have two options. Option
  96. 3:15one, you can find a template online.
  97. 3:17There are great creators sharing Claude
  98. 3:19MD files everywhere on GitHub, YouTube.
  99. 3:21I use one from a YouTuber called Nate.
  100. 3:23He is an incredible resource for AI
  101. 3:25automation. I will drop his file in the
  102. 3:27description, so you can start from the
  103. 3:29same foundation I did. Option two is you
  104. 3:31can build one yourself by giving Claude
  105. 3:33high-level context about your projects,
  106. 3:35or you can use the shortcut {slash} init
  107. 3:38at any point, and Claude will generate a
  108. 3:40Claude MD file based on everything it
  109. 3:42knows about your project so far. So,
  110. 3:44even if you don't have one set up up
  111. 3:46front, you can always generate one once
  112. 3:48you have started building. Now, I'm
  113. 3:49going to drop my Claude MD file, and you
  114. 3:52can see that it outlines folder
  115. 3:54structure, the role of each folder.
  116. 3:56There's a workflow folder for the
  117. 3:58high-level process logic, and we also
  118. 4:00have an agent folder for decision-making
  119. 4:03layer, and we also have a tools folder
  120. 4:05where we want all the Python scripts to
  121. 4:07be stored at. It also defines a
  122. 4:09self-improvement loop, folder
  123. 4:10structures. But, having the Claude MD
  124. 4:12means you're defining the architecture,
  125. 4:14keeps it consistent across all your
  126. 4:16projects. You can see there's a lot more
  127. 4:18specification inside of the Claude MD
  128. 4:21file. For example, API keys and secrets
  129. 4:23to be stored in a hidden folder. That's
  130. 4:26what this dot prefix on the folder name
  131. 4:28means, it's hidden by default. This
  132. 4:31matters if your project ever gets pushed
  133. 4:33to GitHub, you want to make sure nobody
  134. 4:35sees your credentials. Now, just type
  135. 4:36"Initiate this project based on Claude
  136. 4:38MD file", and Claude reads and creates
  137. 4:41the entire folder structure, every
  138. 4:42subfolder, just like how it's indicated
  139. 4:45inside of the Claude MD file. And now,
  140. 4:47you're ready to cook. Now, Claude code
  141. 4:48has different mode, and you want to
  142. 4:49first switch to planning mode. This
  143. 4:51tells Claude, "Don't start creating
  144. 4:53files yet, just give the full plan, and
  145. 4:55let's strategize and brainstorm first."
  146. 4:57You always want to see the whole plan
  147. 4:59before execution starts. It's way easier
  148. 5:01to redirect at the planning stage rather
  149. 5:04than it's already started building and
  150. 5:07then it's going down the wrong
  151. 5:08direction. And here's what I asked it to
  152. 5:10do. I just kind of blurted out using
  153. 5:12Whisper Flow. "I want to automate the
  154. 5:14bookkeeping process for my one-person
  155. 5:16business. This should be an ongoing
  156. 5:17automation to help me keep track
  157. 5:19invoices and expenses with the goal of
  158. 5:22organizing my monthly record and making
  159. 5:24year-end tax reporting easier. I'm a
  160. 5:26Canadian resident, so please incorporate
  161. 5:28all Canadian tax compliance requirements
  162. 5:30in your planning. For invoices,
  163. 5:32auto-generate based on number sequence,
  164. 5:35track in Google Sheets, generate a PDF
  165. 5:38and upload it to the corresponding
  166. 5:39folder in Google Drive. For expenses, I
  167. 5:42want to import a bank statement or
  168. 5:44credit card transaction statement, have
  169. 5:46expenses have expenses categorized
  170. 5:48intelligently, update my expense
  171. 5:50tracker, and create formula directly
  172. 5:52inside Google Sheet." see it immediately
  173. 5:54went into research mode and started
  174. 5:55asking me smart and relevant questions,
  175. 5:58like do I have GST/HST registration,
  176. 6:01which bank do I use? So, it's actually
  177. 6:02really interesting to kind of see what
  178. 6:04the thought process is and how he plans
  179. 6:06out the whole thing. But, in under 30
  180. 6:08seconds, we have a pretty comprehensive
  181. 6:10plan. We have the system architecture
  182. 6:12with Google Sheets, it will create and
  183. 6:14research all the expense categories and
  184. 6:16its deductibility and corresponding tax
  185. 6:18document line ID. I have all the Python
  186. 6:20scripts, setting up Google Sheets,
  187. 6:22generating invoices, logging invoices,
  188. 6:25uploading PDF to Drive, categorizing
  189. 6:27expenses, logging expenses, and all the
  190. 6:30SOP it will create for the workflow
  191. 6:32folder. This looks pretty good to me. I
  192. 6:34think we're just going to roll with it.
  193. 6:36Now, it literally took 2 minutes. You
  194. 6:38can see now I have eight tools and three
  195. 6:40workflows all created under my folder
  196. 6:43structure, and you can review them. It
  197. 6:45also tells me exactly what I need to do
  198. 6:46next, which is to enter my credentials
  199. 6:48so it can connect to Google API. Now,
  200. 6:51I'm going to set this up and come back.
  201. 6:52All right. Now, everything it needs to
  202. 6:54be set up has been set up, and we can
  203. 6:56run a test now. And all you need to do
  204. 6:58is tell it the invoice details.
  205. 7:00"Generate invoice 003 for client Google,
  206. 7:03one standard video, $1,000." Let's see
  207. 7:06what it comes back with. It followed up
  208. 7:07with a good question. It's asking if
  209. 7:09it's Google Canada or Google US because
  210. 7:12the tax treatment is going to be
  211. 7:14different. Now, let's select this, and
  212. 7:16now, after it runs for like 20 seconds,
  213. 7:18three steps have been completed. We have
  214. 7:20our PDF generated with the correct
  215. 7:22information. Some of them I left as
  216. 7:25placeholder for this demonstration
  217. 7:27purpose, and we also have our PDF
  218. 7:29uploaded to the right folder in my
  219. 7:30Google Drive, and we have Google Sheet
  220. 7:32updated with the invoice summary with a
  221. 7:35direct link to the Drive file. And I can
  222. 7:38take this further. I can add a step
  223. 7:40where it automatically emails the PDF to
  224. 7:42the client, and that will be a true
  225. 7:44end-to-end automation. But for now,
  226. 7:46we're just going to leave it like this.
  227. 7:48And now, we're going to test the expense
  228. 7:50side. Okay, so I dropped my February
  229. 7:522026 bank statement into the chat. So,
  230. 7:55it's asking me to set up an Anthropic
  231. 7:57API connection so it can do live search
  232. 7:59to figure out what category of vendor
  233. 8:01belongs to on my statement. For now, I'm
  234. 8:03just going to ask it to skip that and
  235. 8:05search it live for this time. The good
  236. 8:07news is it has a memory file. Once it
  237. 8:10learns the vendor, it will remember it
  238. 8:12for the next time. So, in about 20
  239. 8:14seconds, it processed 40 lines of
  240. 8:16transaction. Every expense was
  241. 8:18categorized with deductibility status,
  242. 8:21the CRA category, and ITC eligibility.
  243. 8:24That's the input tax credit for HST in
  244. 8:26Canada. You can claim back your HST on
  245. 8:29any business expense. I love how
  246. 8:31everything is built on formulas, so when
  247. 8:32I go into the sheet and change anything,
  248. 8:35like marking an expense as
  249. 8:37non-deductible or change the percentage,
  250. 8:40it automatically updates my monthly
  251. 8:42summary and my tax summary report. So,
  252. 8:45it all feeds into the final tax
  253. 8:47calculation. Notice that this entire
  254. 8:49time, I didn't look at the code base
  255. 8:51once. The only thing I was managing were
  256. 8:54understanding the overall structure of
  257. 8:56what was being built, reviewing the plan
  258. 8:58before execution, and giving feedback
  259. 9:00when something needed adjusting. Any
  260. 9:02question I had, I just asked Claude
  261. 9:04directly, "Hey, where did you put this
  262. 9:05file? How do I get the API key? I can't
  263. 9:08find this." And it just answers
  264. 9:10everything very clearly. I hope that got
  265. 9:12you excited to start building. The
  266. 9:14learning curve is really not coding.
  267. 9:16It's just understanding the structure
  268. 9:17and be comfortable with using a
  269. 9:19terminal, using IDE. I'm leaving my
  270. 9:21Claude MD file and my full prompt in the
  271. 9:23description, so you can start from the
  272. 9:25same foundation I used. I will keep
  273. 9:27sharing what I learn and translating it
  274. 9:28as plainly as possible. Thank you so
  275. 9:30much for watching. I'll see you in the
  276. 9:32next one.

About this transcript

This page contains the full transcript of How I Use Claude to Automate Tax and Bookkeeping (Beginner Tutorial) by Softgirlnocode, generated from the public captions YouTube serves with the video. The transcript has 1,867 words across 276 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.

What you can do with it

Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.

Free YouTube transcript tool

YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.