Free Finance learning guide
QuickBooks Bookkeeping for Beginners: Complete Step-by-Step Guide
QuickBooks Bookkeeping for Beginners: Complete Step-by-Step Guide — a free beginner-level guide covering learn quickbooks for bookkeeping. Learn with...
What you will learn
- Bookkeeping Fundamentals and QuickBooks Orientation
- Setting Up a New Company File
- Customizing the Chart of Accounts
- Managing Customers and Sales Transactions
- Managing Vendors and Purchase Transactions
- Banking, Bank Feeds, and Reconciliation
- Inventory Tracking
- Sales Tax Setup and Reporting
- Payroll Fundamentals
- Financial Reports and Period-End Close
- Data Security, Backups, and Troubleshooting
1. Bookkeeping Fundamentals and QuickBooks Orientation
The Language of Business Imagine you just opened a small bakery. On your first day, a customer walks in, buys a $4 latte, and hands you a crisp $5 bill. You make change, smile, and move on to the next customer. Later that evening, you sit down at your computer to figure out how the day went. You know you sold coffee, but you also had to buy milk, pay your barista, and use electricity to keep the ovens running. If you want your bakery to survive past its first month, you need a system to track every one of those movements. You need to know exactly what you own, exactly what you owe, and exactly how much you earned after all the flour dust settles. Bookkeeping is that system. At its core, bookkeeping is not about complex mathematics; it is about organizing financial information into specific, predictable categories so that business owners, investors, and tax authorities can understand the financial health of a company. Before we can learn how to use QuickBooks, we have to learn the language this software speaks. That language relies on five fundamental categories, collectively known as the accounting elements. The Five Building Blocks Every single financial transaction a business makes can be sorted into one of five buckets. Understanding what goes into each bucket is the foundation of all bookkeeping. 1. Assets An asset is anything of value that the business owns. If it holds value and can be used to benefit the business, it is an asset. Examples: The cash in your cash register, the money sitting in your bank account, the baking ovens you purchased, the delivery van you drive, and even the unsold bags of coffee beans on your shelf. 2. Liabilities A liability is something the business owes to someone else. These are obligations that will require the business to pay out cash or provide services in the future. Examples: A loan you took out from a bank to start the bakery, the unpaid bill from your coffee bean supplier, or the credit card balance you used to buy those baking ovens. 3. Equity Equity (often called owner's equity or net worth) is what is left over for the owner after you take all the assets and subtract all the liabilities. If you sold every single asset your business owned and used that cash to pay off every single liability, the money left in your hand would be your equity. Examples: The initial money you invested from your personal savings to start the business, and the profits the business has made that you have chosen to leave in the business rather than paying yourself. 4. Revenue Revenue (also called income …
2. Setting Up a New Company File
The Foundation of Your Digital Ledger Imagine trying to build a custom house on a dirt lot without pouring a concrete foundation. No matter how beautiful the cabinets or paint are, the structure will eventually shift and crack. In QuickBooks Online (QBO), your company file is that foundation. It is the secure, digital container that holds every transaction, customer, vendor, and report for one specific business. Before you can record a single sale or pay a single bill, you must build this container. QBO uses a setup wizard to guide you through this process. The wizard asks a series of questions about your business and uses your answers to build a customized framework. Getting these initial settings right is crucial, because changing a foundation later—after you have hundreds of transactions recorded—is difficult and sometimes impossible. Creating a New Company File To create a new company file, you will start with a blank slate and use the QBO setup wizard. If you already created a QBO account just to look around, you will want to start fresh. QBO allows you to have multiple company files under one user email address, so you do not need to buy a new subscription to practice. To begin the setup wizard: 1. Log in to your QuickBooks Online account. 2. In the top right corner, click the Settings gear icon. 3. Select Company settings (or look for the option to add a new company if you are starting completely from scratch on the Intiut website). 4. QBO will launch a guided setup wizard. Follow the on-screen prompts, clicking "Next" only when you are sure the information on the current screen is correct. The wizard will walk you through several distinct phases: entering your business identity, selecting an industry template, configuring your accounting rules, and setting up user access. Entering Your Business Information The first phase of the setup wizard asks for your business identity. This information is not just for internal record-keeping; it appears on the invoices your customers see and the tax forms you file with the government. Legal Name vs. Business Name You will be asked for both a Legal Name and a Business Name. Legal Name: The official name of the entity registered with the government. If you are a sole proprietor, this might be your personal legal name. If you are an LLC or Corporation, it is the exact name on your formation documents. Business Name: The name you use to the public, also known as a DBA (Doing Business As). If your legal name is "John Smith," but you operate as "Smith's Bakery," Smith's Bakery goes here. If you don't use a separate public name, the legal name and business …
3. Customizing the Chart of Accounts
Imagine walking into an office where every invoice, receipt, and bank statement is tossed into a single, massive pile on the floor. When the owner asks, "How much did we spend on advertising last month?" you would have to sift through thousands of papers to find the answer. In QuickBooks, the Chart of Accounts is the digital filing cabinet that prevents this chaos. It is the complete list of all the "buckets" or accounts you use to categorize every single financial transaction your business makes. When you set up your new company file in Chapter 2, QuickBooks automatically generated a standard Chart of Accounts based on the industry you selected. However, no two businesses are exactly alike. To get accurate, meaningful financial reports, you need to customize this list so it perfectly reflects how your specific business operates. The Six Major Account Types In Chapter 1, we introduced the fundamental accounting elements: assets, liabilities, equity, revenue, and expenses. QuickBooks organizes these elements into specific account types within the Chart of Accounts. To properly set up your books, you must be able to identify the six major account types you will encounter. The first five should be familiar from our earlier discussions on the accounting equation (Assets = Liabilities + Equity) and net income (Revenue - Expenses). 1. Assets An asset is anything the business owns that has value. In QuickBooks, asset accounts are used to track cash in the bank, money owed to you by customers, inventory on your shelves, and equipment purchased for the business. Common asset accounts include Checking, Savings, and Accounts Receivable. 2. Liabilities A liability is something the business owes to someone else. Liability accounts track debts and obligations. Common liability accounts include Accounts Payable (money you owe to vendors), Credit Cards, and business Loans. 3. Equity Equity represents the owner's claim on the business after all liabilities have been paid off. In QuickBooks, equity accounts track the owner's initial investment in the company, owner's draws (money taken out of the business for personal use), and retained earnings (accumulated profits from prior years). 4. Income Income (also referred to as Revenue) is the money your business earns from its primary operations, such as selling products or providing services. Common income accounts include Sales, Service Revenue, or Consulting Income. 5. Expenses An expense is the cost of running your day-to-day business operations. When you pay for rent, utilities, advertising, or office supplies, the transaction is categorized into an expense account. 6. Cost of Goods Sold (COGS) The sixth account type introduces a new, highly specific category. Cost of Goods Sold (COGS) represents the direct costs of producing or purchasing the goods you sell. If you run a …
4. Managing Customers and Sales Transactions
The Sales Cycle: From First Contact to Cash in the Bank Imagine a customer walks into your shop, agrees to a $2,000 project, and asks you to send a bill. A few days later, they mail you a check. How do you record that in your books? If you simply enter $2,000 into your checking account, your records will be missing crucial details—who the customer is, what they bought, and whether their account is fully paid. In the first three chapters, we built a foundation in bookkeeping fundamentals, set up a new company file, and customized our Chart of Accounts. Now, it is time to put that infrastructure to work by recording what keeps a business alive: revenue. In double-entry accounting, every sale impacts multiple accounts. When you make a sale, you are either increasing an asset (like Cash or Accounts Receivable) and increasing your revenue. If you sell on credit, you are also creating a temporary asset in the form of a promise from your customer to pay you later. QuickBooks simplifies this process through a structured series of forms that track the entire sales cycle from the initial quote to the final deposited payment. Managing Customer Profiles Before you can record a single sale, QuickBooks needs to know who is buying from you. QuickBooks uses Customer Profiles to store names, billing addresses, shipping addresses, email contacts, and payment terms for the people or businesses that buy from you. By setting up customer profiles, you avoid typing the same information every time you make a sale. It also allows you to run reports to see exactly how much a specific customer has purchased over the year and whether they owe you any outstanding money. Creating a Customer Profile To create a new customer in QuickBooks, you will generally use the following steps: 1. Navigate to the Customers menu (or the "Sales" tab on the dashboard) and select Customer Center. 2. Click New Customer & Job (or Add Customer depending on your version of QuickBooks). 3. Fill in the Customer Information tab: - Customer Name: The name as you want it to appear on your customer list (e.g., "Smith, John" or "Acme Corp"). - Company Name: If the customer is a business. - Billing Address: Where the customer receives their invoices. - Shipping Address: Where products should be delivered (if different from the billing address). - Contact Information: Phone numbers and email addresses. 4. Open the Payment Settings or Additional Info tab to assign Payment Terms. Payment Terms dictate when a customer is expected to pay. For example, "Net 30" means the customer has 30 days from the invoice date to pay. Assigning terms here saves you from manually entering …
5. Managing Vendors and Purchase Transactions
The Vendor Lifecycle: From Order to Payment Every business spends money to make money. Before you can generate revenue, you often have to buy supplies, pay for services, or purchase raw materials. The people and companies you buy from are your vendors (sometimes called suppliers). Managing vendors effectively is the flip side of managing customers. In Chapter 4, we tracked money coming into the business through sales. Now, we focus on money going out of the business through purchases. In double-entry accounting, every purchase impacts your accounting equation by either reducing an asset (like cash) or increasing a liability (like money you owe but haven't paid yet). The vendor lifecycle in QuickBooks generally follows three steps: 1. The Purchase Order (Optional): A formal request to a vendor to buy goods or services. 2. The Bill: The invoice you receive from the vendor requesting payment. 3. The Payment: The actual outflow of cash (or credit) to pay the bill. Let’s look at how to set up the people you buy from before we start tracking these transactions. Creating and Editing Vendor Profiles To keep your books organized, QuickBooks uses a Vendor Center. Just as you created customer profiles to track who owes you money, you create vendor profiles to track who you owe money to. When you create a vendor profile, you are telling QuickBooks to keep a running history of every transaction you have with that specific company. Adding a New Vendor To add a new vendor, navigate to the Expenses or Vendors tab (depending on your version of QuickBooks) and select Add Vendor or New Vendor. You will be prompted to fill in several fields: - Vendor Name: The name of the company or individual. - Display Name: How the vendor will appear in your lists. This must be unique. - Contact Information: Address, phone number, and email. This is essential if you plan to use QuickBooks to email purchase orders or payments directly to the vendor. - Terms: The payment terms you have agreed upon with the vendor (e.g., Net 30, which means the bill must be paid within 30 days). - Opening Balance: If you are setting up a vendor you already owe money to before you started using QuickBooks, you can enter that opening balance here. However, if you are migrating from another system, it is usually better to enter historical bills individually so your expenses are categorized correctly for the correct dates. Editing Existing Vendors Businesses change over time. A vendor might change their billing address, or you might negotiate new payment terms. To edit a vendor, go to the Vendor Center, locate the vendor in your list, and click Edit. One important feature inside …
6. Banking, Bank Feeds, and Reconciliation
The Bridge Between Your Bank and Your Books Imagine downloading your bank statement at the end of the month and realizing you have 342 transactions to record. Manually typing each one into your ledger would take days. Worse, by the time you finish, you might have made a dozen typos, turning your financial records into a guessing game. Historically, this manual data entry was the daily reality for bookkeepers. Today, accounting software like QuickBooks eliminates this bottleneck through a feature called Bank Feeds. A bank feed is a secure, direct connection between your financial institution and your QuickBooks company file. Instead of typing transactions by hand, QuickBooks automatically imports your daily bank and credit card activity. However, automation does not mean blind trust. As a bookkeeper, your job shifts from data entry to data review. You must ensure that every transaction QuickBooks imports is categorized correctly and eventually matches the real-world balance reported by your bank. This process is called reconciliation. In this chapter, we will build on the foundational knowledge of the Chart of Accounts and double-entry accounting to connect your bank accounts, automate transaction categorization, and reconcile your books to your monthly statements. Connecting Bank and Credit Card Accounts To begin using Bank Feeds, you must first connect your real-world financial accounts to QuickBooks. In Chapter 3, we discussed setting up your Chart of Accounts. When you connect a real-world bank account to QuickBooks, the software can automatically generate the corresponding asset or liability account in your Chart of Accounts, saving you a setup step. Because your checking account holds value that belongs to your business, it is an asset. Because a credit card balance represents money you owe to a lender, it is a liability. The Connection Process QuickBooks uses a secure portal to link with thousands of financial institutions. To connect your accounts: 1. Navigate to the Banking or Transactions tab on the left-hand navigation menu. 2. Click Link account (or Add account). 3. Enter the name of your bank or credit card provider in the search bar. 4. Log in using the same username and password you use for your bank’s website. 5. Select the specific accounts you want to link (e.g., Business Checking, Business Savings, Business Credit Card). 6. For each account selected, QuickBooks will ask you to map it to your Chart of Accounts. You can choose an existing account or let QuickBooks create a new one. 7. Choose the date you want to start importing transactions from. If your business is new, you might start from day one. If you are taking over a business mid-year, you will start from the last date the previous bookkeeper reconciled the books. Once connected, QuickBooks …
7. Inventory Tracking
Imagine you run a retail store that sells wireless keyboards. You buy them from a supplier for $25 each and sell them to customers for $50. A customer walks in, grabs the last keyboard off the shelf, and pays you $50. You hand over the product and make a $25 profit. But what happens behind the scenes in your bookkeeping? When you bought that keyboard, you didn't record it as an expense. You recorded it as an asset because it was something of value you owned, intended to be sold. The moment you hand that keyboard to the customer, two things must happen: your inventory asset decreases by $25, and your Cost of Goods Sold (an expense) increases by $25. If you try to track this manually on a spreadsheet, you will quickly run into problems. You might forget to update the spreadsheet when a box of keyboards arrives, or you might not know you are out of stock until a customer asks for one. QuickBooks solves this by linking your inventory quantities directly to your accounting. Every time you buy or sell an inventory item, QuickBooks automatically updates both the number of items you have in stock and the financial value of those items in your books. Inventory vs. Non-Inventory vs. Services Before setting up items in QuickBooks, it is important to understand the different types of products and services you can sell. QuickBooks categorizes items into three main types: Inventory Items: These are physical goods you buy, track, and sell. QuickBooks tracks the quantity on hand, the cost to buy them, and the sales price. (e.g., the wireless keyboard). Non-Inventory Items: These are physical goods you buy and sell, but you do not track the quantity on hand. This is often used for items you purchase specifically for a single customer job, or items that are too cheap and numerous to track individually (e.g., nails and screws for a contractor). Service Items: These are services you provide to customers, such as consulting hours or delivery fees. There is no physical product to track. In this chapter, we focus entirely on Inventory Items. Enabling Inventory Tracking By default, a new QuickBooks company file does not always have inventory tracking turned on. To use inventory features, you must first enable them in your company settings. To turn on inventory tracking: 1. Click the Gear icon in the top right corner of QuickBooks. 2. Select Account and Settings (or Company Settings in some versions). 3. Click on the Sales tab on the left menu. 4. Find the Products and services section and click the pencil icon to edit. 5. Check the box for Track inventory quantity on hand. 6. Click Save, …
8. Sales Tax Setup and Reporting
The Middleman Role: Understanding Sales Tax Imagine you own a retail store in a state that charges a 6% sales tax. A customer walks in, buys a $100 bicycle, and hands you $106 at the register. That extra $6 doesn't belong to you. You are simply holding it on behalf of the state government until it is time to send it to them. In accounting terms, that $6 is not Revenue. Because you owe that money to the government, it is a liability—specifically, a debt you must pay to a tax agency. When you sell products or services that are subject to sales tax, your business takes on the role of a tax collector. The government requires you to track exactly how much tax you have collected, report it accurately, and remit (pay) it to the proper tax authorities on a strict schedule. If you collect the tax but fail to remit it, your business will face severe penalties and interest charges. Because managing this process manually with spreadsheets is tedious and error-prone, QuickBooks includes a dedicated Sales Tax Center. This tool automates the math, tracks what you owe, and helps you record your payments to the tax agencies seamlessly. Setting Up Sales Tax: Agencies, Rates, and Codes Before you can collect a single penny of sales tax on an invoice or sales receipt, you must tell QuickBooks the rules of your specific location. Sales tax setup involves three distinct components: the agency you owe, the rate you charge, and the codes you use to categorize transactions. Tax Agencies A tax agency is the government entity that collects your sales tax. Depending on where your business operates, you might have to report to a single state agency, or you might have to report to a state agency, a county agency, and a city agency simultaneously. When you set up a tax agency in QuickBooks, the software automatically creates a new liability account in your Chart of Accounts to track the money you owe to that specific entity. Tax Rates A tax rate is the specific percentage of tax applied to a taxable sale. If your state charges 4% and your county charges 2%, you will charge a combined tax rate of 6%. In QuickBooks, you can create either a single (flat) tax rate or a combined tax rate. A combined tax rate allows you to group multiple component rates together under one name. For example, you might create a combined rate called "State & County" that bundles the 4% state rate and the 2% county rate. When you apply this combined rate to a sale, QuickBooks tracks the 4% and the 2% separately in the background, so when it is …
9. Payroll Fundamentals
The Anatomy of a Paycheck Imagine an employee earns a salary of $4,000 per month. When payday arrives, their bank deposit is only $2,850. Where did the remaining $1,150 go? The answer lies in the mechanics of payroll. As a bookkeeper, your job is to ensure that the gross pay (the total amount earned) is calculated correctly, that the right amounts are withheld for taxes and benefits, and that the net pay (the actual take-home amount) reaches the employee. Simultaneously, you must track the money withheld—because it doesn't belong to the company; it belongs to the government. In previous chapters, we managed Revenue by invoicing customers and Expenses by paying vendors. Payroll introduces a complex hybrid: an expense to the company and a Liability owed to third parties. If you do not track these liabilities accurately, your company can face severe penalties. Gross Pay, Net Pay, and Withholdings To understand payroll, you must first understand the lifecycle of a single paycheck. Three terms form the foundation: Gross Pay: The total amount an employee earns before any money is taken out. This is the company's payroll expense. Withholdings: Money deducted from the employee's gross pay. The employer acts as a middleman, holding this money temporarily before sending it to the government or benefit providers. Net Pay: The actual amount deposited into the employee's bank account (Gross Pay minus Withholdings). Employer Taxes: The Hidden Expense Withholdings come out of the employee’s pocket. However, payroll also introduces Employer Taxes. When you run payroll, the company owes its own taxes on top of the employee's gross pay. The most common employer taxes in the United States are: 1. FICA (Social Security and Medicare): The employer matches the amount the employee pays. 2. FUTA (Federal Unemployment Tax): A federal tax paid solely by the employer to fund unemployment benefits. 3. SUTA (State Unemployment Tax): A state-level tax, also paid solely by the employer (in most states). This means if an employee earns $4,000, the actual cost to the company might be $4,300 once employer taxes are factored in. QuickBooks tracks both the employee and employer sides of this equation simultaneously. Enabling Payroll and Company Settings QuickBooks is not automatically configured to run payroll. Because payroll involves strict legal compliance, Intuit requires you to activate a specific payroll service. To begin, navigate to the Payroll tab on your QuickBooks dashboard. You will be prompted to activate payroll. QuickBooks offers a few tiers of service, but the core bookkeeping mechanics remain the same across them. For this chapter, we will focus on the standard QuickBooks Online Payroll setup. General Tax and Accounting Preferences Once payroll is enabled, QuickBooks needs to know how to categorize payroll expenses. Because …
10. Financial Reports and Period-End Close
The Big Three: Your Financial Dashboard Imagine you are driving a car at 70 miles per hour, but the dashboard is completely blank. You don’t know how fast you are going, how much fuel is left, or if the engine is overheating. Running a business without looking at its financial reports is exactly the same. You might be moving forward, but you are entirely blind to the mechanics keeping you on the road. Throughout the previous modules, you have been entering data into QuickBooks—recording sales, paying bills, managing inventory, and running payroll. All of those daily transactions are the raw materials. Financial reports are the finished product. They take hundreds or thousands of individual transactions and distill them into a clear, readable picture of your business’s financial health. While QuickBooks can generate dozens of different reports, three of them form the absolute foundation of bookkeeping: the Profit & Loss report, the Balance Sheet, and the Statement of Cash Flows. Let’s look at how to generate and interpret each one. The Profit & Loss Report The Profit & Loss report (often called an Income Statement) is a summary of your business's financial performance over a specific period of time, such as a month, a quarter, or a year. It answers one fundamental question: Did we make money? The report is structured around a simple formula you already know: Revenue minus Expenses equals Net Income. When you pull a Profit & Loss (P&L) report in QuickBooks, you will see it laid out in sections: 1. Income/Revenue: All the money earned from selling your goods or services. 2. Cost of Goods Sold (COGS): The direct costs of producing those goods or services (like the raw materials or wholesale inventory you purchased). 3. Gross Profit: Income minus COGS. 4. Expenses: Your operating overhead, such as rent, utilities, and insurance. 5. Net Income: Your bottom line. Gross Profit minus Expenses. How to generate it: 1. In QuickBooks, go to the Reports menu. 2. Select Standard Reports (or "Company & Financial" depending on your QuickBooks version). 3. Choose Profit & Loss Standard. 4. Set the date range at the top of the report (e.g., "Last Month" or "This Fiscal Year"). 5. Click Run Report. How to interpret it: Look at the bottom line first. If your net income is positive, your business was profitable for that period. If it is negative, you operated at a loss. Next, scan the individual line items. If your revenue is high but your net income is low, look for unusually high expense lines. Perhaps your utilities spiked, or your software subscriptions grew faster than your sales. The Balance Sheet While the P&L shows performance over a range of time, the …
11. Data Security, Backups, and Troubleshooting
Imagine arriving at the office on a Monday morning, turning on your computer, and discovering that your QuickBooks company file—the digital vault containing years of customer information, vendor history, and financial records—won't open. A sudden power surge over the weekend corrupted the file. Or worse, imagine discovering that a well-meaning employee accidentally deleted dozens of transactions from the previous fiscal year while trying to clean up the ledger. Up to this point, you have learned how to record every type of transaction, manage inventory, run payroll, and close the books. But all of that meticulous work is vulnerable if the data isn't protected. In this final module, we shift from inputting data to safeguarding it. You will learn how to create safety nets for your financial data, control who can access it, and act as a detective when numbers don't add up. Backing Up and Restoring the QuickBooks Company File Your QuickBooks company file (often ending in .qbw) contains every piece of financial information for your business. If this single file is lost, corrupted, or infected by ransomware, your business operations can grind to a halt. A backup is a compressed, secondary copy of your company file. QuickBooks saves backups in a specific format (usually .qbb). This compressed file contains all your data but cannot be opened directly like a normal file; it must be "restored" first. Restoring is the process of unpacking that compressed backup file to replace a damaged or lost live company file. How to Create a Backup QuickBooks offers two primary ways to back up your data: local backups and automatic backups. 1. Local Backup: This creates a backup file on your computer’s hard drive or an external storage device, like a USB flash drive. To create one, you use the File menu, select Back Up Company, and then Create Local Backup. QuickBooks will guide you through a wizard where you can choose where to save the file. 2. Automatic Backup: You can schedule QuickBooks to back up your data automatically when you close the company file at the end of the day. This is highly recommended, as it removes the risk of human forgetfulness. The Golden Rule of Backups: The 3-2-1 Strategy Saving a backup on the same computer as your live company file is not enough. If the hard drive crashes, you will lose both the original file and the backup. IT professionals recommend the 3-2-1 backup strategy: Keep 3 total copies of your data (the live file plus two backups). Store the copies on 2 different types of media (e.g., your local hard drive and an external USB drive). Keep at least 1 copy off-site (e.g., cloud storage or a physical drive taken …
Continue learning
- QuickBooks Online for Small Business BeginnersQuickBooks Online for Small Business Beginners — a free beginner-level guide covering learn quickbooks online for small business accounting. Learn with...
- How to Read a Balance Sheet: Step-by-Step GuideHow to Read a Balance Sheet: Step-by-Step Guide — a free intermediate-level guide covering how to read a balance sheet. Learn with clear explanations,...
- Start a Freelance Bookkeeping Business: Beginner's GuideStart a Freelance Bookkeeping Business: Beginner's Guide — a free beginner-level guide covering how to start a freelance bookkeeping business. Learn...
- How to Get a Remote Bookkeeping Job: A Beginner's GuideHow to Get a Remote Bookkeeping Job: A Beginner's Guide — a free beginner-level guide covering how to get a remote bookkeeping job. Learn with clear...