How I Use Claude to Automate Tax and Bookkeeping (Beginner Tutorial) — Transcript
Full transcript
- 0:00So, what is Claude code? The name
- 0:02itself, it's a little misleading. Claude
- 0:03code is basically Claude, but instead of
- 0:06living in a browser, it lives inside of
- 0:08your computer's terminal. And your
- 0:10terminal is just a text interface for
- 0:13your computer. When you chat with Claude
- 0:14normally, it gives you answer, but it
- 0:16doesn't really do anything on your
- 0:18computer. It can't create files, it
- 0:20can't touch your Google Drive, or
- 0:22organize your desktop for you. But
- 0:24Claude code can. Think of it like the
- 0:26difference between calling a contractor
- 0:28on the phone for advice versus actually
- 0:30letting them into your house to do the
- 0:32work. Claude code is the contractor
- 0:34walking through your front door, rolling
- 0:36up their sleeves, and building the
- 0:38thing. Now, how do you access it? You
- 0:40want to access it through an IDE. IDE
- 0:42stands for integrated developer
- 0:44environment, basically just a coding
- 0:46workspace. VS Code is the one I use. It
- 0:49is completely free. It might seem
- 0:51unfamiliar at first when you open it up
- 0:54for the first time, but this is really
- 0:55what it is. On the left side, you have
- 0:57your folder structure, all your files,
- 1:00scripts, documents, and on the right
- 1:02side, you have your chat window where
- 1:04you talk to Claude in plain English.
- 1:06Claude code's real power is its ability
- 1:08to write code so well that it can
- 1:10basically build any program or system
- 1:12for you. To get its full capacity, you
- 1:15have to use it as a terminal through an
- 1:17IDE, and that's where you get the best
- 1:19quality output and the most efficient
- 1:21use of your tokens. If you're using
- 1:23Claude code through the built-in Claude
- 1:24interface or the Chrome extension,
- 1:26you're essentially using a lighter
- 1:28version of it. It is good for quick
- 1:30tasks, but it can't fully execute Python
- 1:33scripts on your machine, and you will
- 1:34burn through your token limit faster
- 1:36because the back and forth is less
- 1:38efficient. When you access it through an
- 1:39IDE like VS Code, you're giving it real
- 1:42workspace. It can see your entire folder
- 1:44structure, write scripts, run them,
- 1:46catch errors, fix them, and iterate all
- 1:49in one session. So, if you're serious
- 1:51about building something and automation
- 1:53a tool, I would definitely install VS
- 1:55Code. It is free, takes 5 minutes to set
- 1:57up, and the difference between getting
- 1:5920% of what Claude code can do versus
- 2:01the whole thing. Now that we established
- 2:03the basic, let's install VS Code and
- 2:05start setting it up. Open VS Code, go to
- 2:07extension tab, and search Claude code to
- 2:10install it, and you will see this one
- 2:12from Anthropic. Once you do that, you
- 2:14will see the Claude code icon appear as
- 2:16an agent window, and then you can start
- 2:18using it as your chat interface. And
- 2:20next, before you open anything, go to
- 2:22your desktop and create a folder. In my
- 2:24case, it's called Bookkeeper Tax. Then,
- 2:27open VS Code and open that folder as
- 2:29your workspace. Now, Claude code is
- 2:31going to operate within that folder.
- 2:33Then, the next thing you want to do is
- 2:34go to setting and enable allow
- 2:37dangerously skip permission. What this
- 2:39does is is stop Claude from pausing
- 2:41every 2 minutes to ask, "Can I run this
- 2:44command? Can I access this file?" It
- 2:46lets it work continuously without having
- 2:48you click approve all the time. Now, the
- 2:50next step is to generate Claude MD file.
- 2:52This is a very important thing you need
- 2:54to set up before you start building
- 2:56anything. MD file is basically a
- 2:58permanent briefing document Claude reads
- 3:00automatically at the start of every
- 3:02single session. It is where you define
- 3:04what the project is, what's the folder
- 3:06structure, how should files be
- 3:08organized, what are some of the rules,
- 3:10so you're just setting up the
- 3:11guardrails. Now, how do you get a Claude
- 3:13MD file? You have two options. Option
- 3:15one, you can find a template online.
- 3:17There are great creators sharing Claude
- 3:19MD files everywhere on GitHub, YouTube.
- 3:21I use one from a YouTuber called Nate.
- 3:23He is an incredible resource for AI
- 3:25automation. I will drop his file in the
- 3:27description, so you can start from the
- 3:29same foundation I did. Option two is you
- 3:31can build one yourself by giving Claude
- 3:33high-level context about your projects,
- 3:35or you can use the shortcut {slash} init
- 3:38at any point, and Claude will generate a
- 3:40Claude MD file based on everything it
- 3:42knows about your project so far. So,
- 3:44even if you don't have one set up up
- 3:46front, you can always generate one once
- 3:48you have started building. Now, I'm
- 3:49going to drop my Claude MD file, and you
- 3:52can see that it outlines folder
- 3:54structure, the role of each folder.
- 3:56There's a workflow folder for the
- 3:58high-level process logic, and we also
- 4:00have an agent folder for decision-making
- 4:03layer, and we also have a tools folder
- 4:05where we want all the Python scripts to
- 4:07be stored at. It also defines a
- 4:09self-improvement loop, folder
- 4:10structures. But, having the Claude MD
- 4:12means you're defining the architecture,
- 4:14keeps it consistent across all your
- 4:16projects. You can see there's a lot more
- 4:18specification inside of the Claude MD
- 4:21file. For example, API keys and secrets
- 4:23to be stored in a hidden folder. That's
- 4:26what this dot prefix on the folder name
- 4:28means, it's hidden by default. This
- 4:31matters if your project ever gets pushed
- 4:33to GitHub, you want to make sure nobody
- 4:35sees your credentials. Now, just type
- 4:36"Initiate this project based on Claude
- 4:38MD file", and Claude reads and creates
- 4:41the entire folder structure, every
- 4:42subfolder, just like how it's indicated
- 4:45inside of the Claude MD file. And now,
- 4:47you're ready to cook. Now, Claude code
- 4:48has different mode, and you want to
- 4:49first switch to planning mode. This
- 4:51tells Claude, "Don't start creating
- 4:53files yet, just give the full plan, and
- 4:55let's strategize and brainstorm first."
- 4:57You always want to see the whole plan
- 4:59before execution starts. It's way easier
- 5:01to redirect at the planning stage rather
- 5:04than it's already started building and
- 5:07then it's going down the wrong
- 5:08direction. And here's what I asked it to
- 5:10do. I just kind of blurted out using
- 5:12Whisper Flow. "I want to automate the
- 5:14bookkeeping process for my one-person
- 5:16business. This should be an ongoing
- 5:17automation to help me keep track
- 5:19invoices and expenses with the goal of
- 5:22organizing my monthly record and making
- 5:24year-end tax reporting easier. I'm a
- 5:26Canadian resident, so please incorporate
- 5:28all Canadian tax compliance requirements
- 5:30in your planning. For invoices,
- 5:32auto-generate based on number sequence,
- 5:35track in Google Sheets, generate a PDF
- 5:38and upload it to the corresponding
- 5:39folder in Google Drive. For expenses, I
- 5:42want to import a bank statement or
- 5:44credit card transaction statement, have
- 5:46expenses have expenses categorized
- 5:48intelligently, update my expense
- 5:50tracker, and create formula directly
- 5:52inside Google Sheet." see it immediately
- 5:54went into research mode and started
- 5:55asking me smart and relevant questions,
- 5:58like do I have GST/HST registration,
- 6:01which bank do I use? So, it's actually
- 6:02really interesting to kind of see what
- 6:04the thought process is and how he plans
- 6:06out the whole thing. But, in under 30
- 6:08seconds, we have a pretty comprehensive
- 6:10plan. We have the system architecture
- 6:12with Google Sheets, it will create and
- 6:14research all the expense categories and
- 6:16its deductibility and corresponding tax
- 6:18document line ID. I have all the Python
- 6:20scripts, setting up Google Sheets,
- 6:22generating invoices, logging invoices,
- 6:25uploading PDF to Drive, categorizing
- 6:27expenses, logging expenses, and all the
- 6:30SOP it will create for the workflow
- 6:32folder. This looks pretty good to me. I
- 6:34think we're just going to roll with it.
- 6:36Now, it literally took 2 minutes. You
- 6:38can see now I have eight tools and three
- 6:40workflows all created under my folder
- 6:43structure, and you can review them. It
- 6:45also tells me exactly what I need to do
- 6:46next, which is to enter my credentials
- 6:48so it can connect to Google API. Now,
- 6:51I'm going to set this up and come back.
- 6:52All right. Now, everything it needs to
- 6:54be set up has been set up, and we can
- 6:56run a test now. And all you need to do
- 6:58is tell it the invoice details.
- 7:00"Generate invoice 003 for client Google,
- 7:03one standard video, $1,000." Let's see
- 7:06what it comes back with. It followed up
- 7:07with a good question. It's asking if
- 7:09it's Google Canada or Google US because
- 7:12the tax treatment is going to be
- 7:14different. Now, let's select this, and
- 7:16now, after it runs for like 20 seconds,
- 7:18three steps have been completed. We have
- 7:20our PDF generated with the correct
- 7:22information. Some of them I left as
- 7:25placeholder for this demonstration
- 7:27purpose, and we also have our PDF
- 7:29uploaded to the right folder in my
- 7:30Google Drive, and we have Google Sheet
- 7:32updated with the invoice summary with a
- 7:35direct link to the Drive file. And I can
- 7:38take this further. I can add a step
- 7:40where it automatically emails the PDF to
- 7:42the client, and that will be a true
- 7:44end-to-end automation. But for now,
- 7:46we're just going to leave it like this.
- 7:48And now, we're going to test the expense
- 7:50side. Okay, so I dropped my February
- 7:522026 bank statement into the chat. So,
- 7:55it's asking me to set up an Anthropic
- 7:57API connection so it can do live search
- 7:59to figure out what category of vendor
- 8:01belongs to on my statement. For now, I'm
- 8:03just going to ask it to skip that and
- 8:05search it live for this time. The good
- 8:07news is it has a memory file. Once it
- 8:10learns the vendor, it will remember it
- 8:12for the next time. So, in about 20
- 8:14seconds, it processed 40 lines of
- 8:16transaction. Every expense was
- 8:18categorized with deductibility status,
- 8:21the CRA category, and ITC eligibility.
- 8:24That's the input tax credit for HST in
- 8:26Canada. You can claim back your HST on
- 8:29any business expense. I love how
- 8:31everything is built on formulas, so when
- 8:32I go into the sheet and change anything,
- 8:35like marking an expense as
- 8:37non-deductible or change the percentage,
- 8:40it automatically updates my monthly
- 8:42summary and my tax summary report. So,
- 8:45it all feeds into the final tax
- 8:47calculation. Notice that this entire
- 8:49time, I didn't look at the code base
- 8:51once. The only thing I was managing were
- 8:54understanding the overall structure of
- 8:56what was being built, reviewing the plan
- 8:58before execution, and giving feedback
- 9:00when something needed adjusting. Any
- 9:02question I had, I just asked Claude
- 9:04directly, "Hey, where did you put this
- 9:05file? How do I get the API key? I can't
- 9:08find this." And it just answers
- 9:10everything very clearly. I hope that got
- 9:12you excited to start building. The
- 9:14learning curve is really not coding.
- 9:16It's just understanding the structure
- 9:17and be comfortable with using a
- 9:19terminal, using IDE. I'm leaving my
- 9:21Claude MD file and my full prompt in the
- 9:23description, so you can start from the
- 9:25same foundation I used. I will keep
- 9:27sharing what I learn and translating it
- 9:28as plainly as possible. Thank you so
- 9:30much for watching. I'll see you in the
- 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.