A DIY bookkeeping checklist works when it is short enough to finish and specific enough to catch real errors. These twelve monthly checks do both. Reconcile every account, clear every uncategorized item, match transfers, zero out Undeposited Funds, hunt negative balances, tie sales tax and payroll liabilities to what you will file, move personal spending out, review the agings, find duplicates and gaps, then lock the month. In practice, twenty to forty minutes once a month.
This guide is for owners who do their own books in QuickBooks Online or Xero and want to know they are doing it right, not just doing it. Each check below says what to look at, what “right” looks like, and also what the error means when you find one. The same twelve checks are on the free one-page PDF, and they are the list we run on every client file at Books LA before a month is closed.
Why a DIY bookkeeping checklist beats “the feed is caught up”
Most owners who keep their own books stop at categorizing the bank feed. The feed being current proves nothing about accuracy. For example, duplicates, transfers booked as expenses, a deposit counted twice, and sales tax sitting in income all survive a fully categorized feed. The checklist exists because those errors have a shape, and the shape is visible if you look in the right twelve places. Our guide to the monthly bookkeeping close explains the full professional routine; this is the owner’s version.
The 12 monthly checks
- 1. Reconcile every account to its statement. Bank, credit card, loan, and payment processor accounts, to the penny. A reconciled balance is the only balance you can trust. If you have never done it, our how to reconcile in QuickBooks Online guide has the steps and the three reasons it fails.
- 2. Clear every uncategorized transaction. Nothing stays in Uncategorized, Ask My Accountant, or Suspense. If you cannot identify it, note the question and ask. After all, a parked transaction is an unfinished entry.
- 3. Review the auto-categorized ones too. Bank rules and AI suggestions guess. Skim them for the vendor that changed, the transfer coded as an expense, the personal charge. Ten minutes here catches most of the quiet errors, especially the recurring ones.
- 4. Match transfers so they are not income or expense. Money moving between your own accounts is neither. The two sides of a transfer should net to zero. A transfer booked as income inflates revenue; one booked as an expense hides profit.
- 5. Check that Undeposited Funds is zero. A payment received and a deposit both booked to income counts the sale twice. This balance should clear every month. In fact, a growing balance is the single most common way DIY books overstate revenue.
- 6. Look for negative balances on the balance sheet. Negative cash, negative receivables, negative payables, or a loan that never goes down all mean something was booked backwards. The five monthly reports post shows where to look.
Checks 7 to 12: liabilities, people, and the lock
The first six checks prove the cash. The next six prove everything that sits on top of it.
- 7. Tie sales tax payable to what you will file. Sales tax collected is a liability, not income. The balance should equal the CDTFA return you are about to file. Our sales tax bookkeeping guide covers the setup.
- 8. Tie payroll liabilities to the payroll reports. Gross wages, taxes, and benefits per the payroll provider should match the books, and the deposits to the EDD and IRS should clear the liabilities. A liability that grows every month means a deposit was coded as an expense.
- 9. Move personal spending out. Personal charges on business cards go to owner draw or distributions, never to expenses. Owner deposits are contributions, not revenue. This is also the first thing a CPA or lender looks for, and the IRS recordkeeping guidance assumes it.
- 10. Review the AR and AP agings. Who owes you more than 60 days? Which bills are due before the next payroll? Old items that will never clear should be dealt with, not ignored, because they distort both reports.
- 11. Find duplicates and gaps. Two entries for one bill, a month with no rent, a card with no statement attached. Gaps are as telling as duplicates. A missing recurring charge usually means a feed broke; our bank feed guide explains the fix.
- 12. Lock the month and save the reports. Set the closing date, then save the profit and loss statement, balance sheet, and reconciliation reports as PDFs. What is locked stays true, and the saved reports are what the CPA, a lender, or an investor will ask for.
The order and the time it takes
Do the checks in the order above. Reconciliation comes first because nothing after it can be trusted until cash ties. The balance sheet checks (5, 6, 7, 8) come next because they catch errors the profit and loss hides. The agings and the cleanup (9, 10, 11) follow. Finally, locking is last, and it is not optional. For a small business with two or three accounts, the whole list takes twenty to forty minutes once the habit is set. Of course, the first month takes longer, because the first month finds everything the previous months missed.
What the checklist does not catch
It catches errors of completeness and placement. It does not judge whether a transaction belongs in Supplies or Equipment, whether a contractor should be an employee, or how a transaction is treated for income tax. Instead, those are questions for a bookkeeper’s judgment, your CPA, or an attorney. If the checklist keeps surfacing the same questions, that is useful information. Our post on bookkeeper vs DIY bookkeeping does the cost math for the moment the list stops fitting in forty minutes.
The California layer
Three of the twelve checks have a California edge. Sales tax payable (check 7) should match the CDTFA return by district, since Los Angeles-area rates vary by address. Payroll liabilities (check 8) include the EDD side: UI, ETT, SDI, and PIT withholding, with the DE 9 as the quarterly tie-out. And the gross receipts figure the City of Los Angeles business tax renewal asks for each February comes straight from a file that passed checks 4, 5, and 9, because transfers, double-counted deposits, and owner contributions all inflate it. The Q4 bookkeeping checklist has the current deadlines.
How Books LA handles this
These twelve checks are the owner’s version of our monthly close. We run the same list, plus the coding review and the reports note, on every client file before the month locks. If you run the checklist and find more than you expected, a $495 bookkeeping review will tell you what the file needs. Our Los Angeles bookkeeping services guide explains what the monthly service includes.
Frequently asked questions
How often should I run a DIY bookkeeping checklist?
Once a month, within two weeks of month-end, after every statement for the month has arrived. Weekly is unnecessary for most small businesses, while quarterly makes each error three times harder to find. The monthly rhythm matches the statements, the sales tax return, and the payroll filings.
What is the most important check on the list?
Reconciliation. If the bank and card accounts do not tie to their statements, every other number is unproven. The second most important is Undeposited Funds at zero, because a growing balance there means revenue is counted twice.
Can I do my own bookkeeping with QuickBooks Online?
Yes, if the books are small and you keep a monthly routine. The software records and sorts; the checklist is the judgment layer it does not provide. Most owners who struggle are not failing at the software. Instead, they are skipping the monthly checks.
Do I need to lock the month in QuickBooks or Xero?
Yes. A closing date stops transactions in a finished month from being edited or deleted by accident, which is the most common reason a reconciled beginning balance later stops matching. So set it after the reports are saved, every month.
What do I do with a transaction I cannot identify?
Leave it uncategorized, write down the date, amount, and payee, and ask whoever would know, usually the person who spent it. Do not guess into an expense account and do not park it in Ask My Accountant permanently. An honest open-items list is worth more than a tidy wrong one.
Where does the free checklist PDF come from?
It is the one-page version of the twelve checks on this page, built by Books LA for owners who keep their own books. Enter your email in the form above and the download link appears immediately. We will not add you to a list without asking.
When should I stop doing my own books?
When the checklist stops getting done, when it keeps surfacing questions you cannot answer, or when a lender, investor, or CPA needs the books to hold up to an outside look. Revenue alone is not the signal. Rather, the month the close does not happen is.
If the list turned up more than you expected, book a short call and we will go through last month with you.
This post is general information. Books LA provides bookkeeping services and does not advise on income tax. Questions about the tax treatment of a transaction belong with your CPA or enrolled agent.
