Doing your own books takes four habits.
The IRS does not ask for a bookkeeper or a particular system: “You can choose any recordkeeping system suited to your business that clearly shows your income and expenses.”
Whatever you choose, the work each month is the same.
| Habit | What you do each month |
|---|---|
| 1. A separate business account | Keep the business's money in its own account, apart from your personal one. |
| 2. Each transaction, with what it was | Record every deposit and payment: a sale, an expense in its category, or neither, such as a loan or money you put in. |
| 3. The receipt or invoice | Keep it with the transaction. The statement shows that you paid; the receipt shows what for. |
| 4. Each account reconciled | Check that the opening balance, plus deposits, minus withdrawals, equals the statement's closing balance. A difference is a missing, doubled or wrong entry. |
Marigold Ceramics checkingOctober statement
1Business onlyTransaction2What it was2What it wasAmount
- STRIPE TRANSFER+5,113.65Sales income
- HALLWAY STUDIOS LLC−2,400.00Rent
- Oct 14 · KILNWORKS SUPPLY−412.80SuppliesReceipt3Kept
- Oct 22 · AMZN MKTP US*2K41−86.00What was it?
6 more transactions
- Opening
- 14,220.55
- Deposits
- + 8,412.60
- Withdrawals
- − 5,137.94
- Closing
- = 17,495.21
Three ways to do your own books.
They differ in who enters the transactions, who checks them, and who decides what each one was.
Spreadsheet
Enters the transactions
You type each row.
Checks them against the statement
You do. A spreadsheet checks only what your formulas check, not your statements.
Decides what each payment was
You do.
Accounting app
Enters the transactions
The bank feed brings them in, and the app suggests a category for you to review.
Checks them against the statement
You reconcile each account in the app, with its suggested matches. Some plans do part of it for you.
Decides what each payment was
You do, or a rule you set.
Your AI with CollieTax
Enters the transactions
Your assistant reads your bank and card statements.
Checks them against the statement
CollieTax checks the rows against the totals the statement prints, and records them only when they agree. A file that prints no totals is marked unverified.
Decides what each payment was
You answer only what the statements cannot tell.
The questions that come next.
Can I just use Excel for bookkeeping?
Yes, for simple books: one row per transaction, with its date, amount and category. A spreadsheet does not check itself against your statements, so you reconcile each month yourself.
Does Excel have a bookkeeping template?
Yes. In November 2026, Microsoft's accounting templates for Excel include a check register ledger, a monthly bank reconciliation and a profit and loss statement. A template gives you the columns, and you still fill in every row.
Can I teach myself bookkeeping?
Yes, for your own business's books: start with IRS Publication 583, Starting a Business and Keeping Records, which illustrates a recordkeeping system. Tax questions, such as equipment, inventory, a car you use for business and personal trips, or payroll, are for a tax professional.
When does doing it yourself stop working?
Get help, or change how you keep the books, when:
- Months go by without the books being done.
- An account does not agree with its statement, and you cannot find why.
- You hire employees. Payroll has its own taxes and filings.
- You need accrual books, which also record what customers owe you and what you owe.
- A lender or landlord asks for reports you cannot produce.
What CollieTax adds, and the price.
CollieTax keeps double-entry books for your assistant. An entry that does not balance is rejected, and your answers can become rules for the months that follow.
Ask for the profit and loss for any period, the balance sheet, or a link to every entry beside its statement.
The price: In your own assistant, free under 15 transactions a month, then from $29 a month for each set of books. With a CollieTax bookkeeper, from $199 a month.
Sources and further reading
- IRS: Publication 583, Starting a Business and Keeping Records
- IRS: Recordkeeping (the burden of proof)
- IRS: What kind of records should I keep
- QuickBooks: Categorize and match online bank transactions
- Xero: Connect your bank
- Microsoft: Accounting spreadsheet templates for Excel
General information and product guidance. Examples are illustrative; your records and filing situation determine the work required. Sources and product descriptions were checked for this update.
Put the workflow to work.
Give this to your assistant. It reads the page, then does the work with you.
Read https://collietax.com/blog/can-i-do-my-own-bookkeeping.md, then start my business's books from last month's bank and card statements, and ask me only what the statements can't tell, with CollieTax.