QuickBooks is the bookkeeping software I see most in Houston small businesses, and that’s for good reason — it’s flexible, the bank feeds work well, and it integrates with almost everything. But more than half the QuickBooks files I’m handed to clean up have problems traceable to the first 30 days the software was in use. Get the setup right and the next ten years of bookkeeping is dramatically easier. Here’s how to do it.
Step 1: Pick the right version
QuickBooks Online is the right choice for almost every small business today. The desktop version is being phased out for most users and the cloud version means your CPA, bookkeeper, and team can all work in the same file from anywhere. Within QuickBooks Online, the four tiers are Simple Start, Essentials, Plus, and Advanced. Most Houston small businesses (under $5M revenue, fewer than 10 employees) need Plus — it adds inventory tracking, project costing, and class/location tracking. Essentials is fine if you’re a solo service business with no inventory.
Step 2: Set the start date carefully
Your QuickBooks file should start at a clean date — usually January 1 of the year you’re entering it, or the first day of the month after you set it up. Going back and entering historical transactions for years past is rarely worth it. Better to start fresh, enter opening balances correctly, and move forward.
Step 3: Build a real chart of accounts
This is where 80% of bookkeeping problems are created. The QuickBooks default chart of accounts is generic and creates two issues: it’s either too detailed for what you need (50 expense accounts you’ll never use) or too vague to give you useful information. Take an hour to design a chart of accounts that mirrors how you actually think about the business:
- Income: Break out your revenue streams (e.g., “Tax Preparation Income”, “Bookkeeping Income”, “Advisory Income” rather than just “Sales”)
- Cost of Goods Sold / Cost of Services: Direct costs of delivering revenue — subcontractors, materials, software directly tied to a service
- Operating Expenses: Rent, utilities, insurance, marketing, professional fees, office supplies. Keep this list practical — don’t create “Office Supplies”, “Office Materials”, and “Stationery” as three separate accounts
- Payroll: Wages, payroll taxes, benefits as separate accounts
- Owner’s draws / distributions / contributions: Equity accounts, never income or expense
Step 4: Connect your bank and credit card feeds
This is the killer feature of cloud accounting. QuickBooks pulls transactions automatically from your bank and credit cards once you connect the feeds. Connect every business account — checking, savings, credit cards, lines of credit. Do not connect personal accounts. Mixing personal and business in QuickBooks is the second-most-common bookkeeping mistake I see (we cover this in our 7 bookkeeping mistakes article).
Step 5: Set up banking rules
For recurring transactions — your monthly software subscriptions, utility bills, regular vendor payments — create rules so QuickBooks categorizes them automatically as they come through the feed. Done well, banking rules can categorize 70-80% of your transactions without any human touch. Don’t over-do it though — a rule that miscategorizes silently is worse than no rule at all.
Step 6: Set up your customers and vendors correctly
Every customer and vendor should be entered with full contact info, payment terms, and (for vendors who require a 1099) a W-9 on file. The end of January is much less painful when this is done as you go. For 1099 tracking, mark vendors as “Track for 1099” in their setup — QuickBooks will tally them automatically come tax time.
Step 7: Configure sales tax
If you sell taxable goods or services in Texas, set up sales tax through QuickBooks’ built-in feature. It tracks rates by location automatically (helpful in Houston where city, county, and special district rates stack). Filing sales tax returns out of QuickBooks is far easier than reconstructing them at quarter-end.
Step 8: Set up payroll
QuickBooks Payroll integrates seamlessly with QuickBooks Online and handles federal, Texas, and local tax calculations, payments, and filings automatically. Gusto and ADP also work well and integrate. Whatever you choose, do not run payroll out of your personal checkbook — the IRS and Texas Workforce Commission will both find you. We cover the basics in our payroll tax article and offer full-service payroll if you’d rather hand it off.
Step 9: Reconcile every month
The single most important habit. Within the first week of the new month, reconcile every bank account, credit card, and loan to the statement. Reconciling means making sure QuickBooks matches the bank exactly — same ending balance, same cleared transactions. If you only do one bookkeeping task each month, do this. Books that are reconciled monthly catch fraud, errors, missing deposits, and duplicates while they’re still fresh.
Step 10: Run reports and actually look at them
Once a month, pull your Profit & Loss and Balance Sheet and look at them. Compare to the prior month and the prior year. Things that should jump out: unusual expenses, accounts you don’t recognize, balances drifting from where they should be. Bookkeeping isn’t about pretty reports — it’s about the questions the reports raise.
When to bring in a professional
If your QuickBooks file already has six months of mess in it, the right answer is usually a one-time cleanup followed by ongoing monthly bookkeeping. We do this work for clients across Houston — full setup, cleanup, and monthly maintenance. See our bookkeeping and Virtual CFO services for details.
To talk through your QuickBooks setup or cleanup, call the office at (832) 983-7080 or reach out through the contact page. Clean books are the foundation of every smart tax decision — and almost every business owner I know wishes they’d set theirs up right from day one.