QuickBooks Cleanup Checklist for Ohio Contractors and Trades

Mae
Author: Mae
Updated: November 16, 2026

The QuickBooks file of a busy contractor usually tells the same story. It was set up in a hurry, the bank feed has been auto-accepting transactions for two years, there are four versions of “Materials” in the chart of accounts, every job is lumped together, and the balance sheet shows a negative loan balance nobody can explain. The business is probably fine. The file is not, and until it is, you cannot see which jobs made money, you cannot price the next bid with confidence, and your tax return is built on guesses. I am Josh Katz, a CPA in Beachwood, and this is the cleanup sequence I use for Cleveland area contractors, electricians, plumbers, HVAC companies, landscapers, and remodelers. Work through it in order; each step makes the next one easier.

Related reading: cash vs accrual accounting for small business and bookkeeping mistakes that cost small businesses money.

1. Lock the past, set a cutoff

Before you touch anything, decide which year you are cleaning. If the 2024 return has been filed, close the books at December 31, 2024 and set a closing date password in QuickBooks so nothing moves behind it. Every fix you make for 2025 and 2026 then stays in the years that are still open. Changing a filed year means an amended return, and that is a separate decision.

2. Rebuild the chart of accounts around jobs, not bank categories

The default QuickBooks chart is built for an office, not a job site. A trades business needs cost of goods sold split into at least four lines: materials, subcontractors, direct labor (field wages and their payroll taxes), and equipment and job costs (rentals, permits, dump fees, fuel for job trucks). Overhead stays below the line: office wages, insurance, vehicles not tied to jobs, software, advertising. Merge the duplicates. “Materials,” “Material,” “Supplies,” and “Home Depot” are one account.
The payoff is gross margin by job type. Most trades in this market should see 35 to 50 percent gross margin after direct costs; if your cleaned-up file shows 20 percent, the problem is pricing or labor efficiency, not bookkeeping, and you now know which.

3. Turn on projects or classes, then tag the last year of job costs

QuickBooks Online Plus and Advanced include Projects. Create one per job above a few thousand dollars and assign the materials, sub invoices, and labor hours to it. For smaller repeat work, a class per service line (service calls, installs, remodels) is enough. Going back and tagging a full year is tedious, which is why most owners never do it, but a year of tagged jobs is the only way to find out that the kitchen remodels you love are the lowest-margin thing you do.

4. Reconcile every account, every month, back to the cutoff

Open the reconciliation screen for each bank account, credit card, line of credit, and equipment loan, and reconcile month by month to the statement. The bank feed is not a reconciliation; it matches what the bank sent, not what is true. The usual finds: duplicate transactions from a feed that was reconnected, deposits recorded twice (once from the invoice, once from the feed), and transfers between accounts recorded as income on one side and expense on the other. Fix those and the profit figure often moves by five figures.

5. Clean undeposited funds and accounts receivable

Two balances that are almost always wrong in a contractor file. Undeposited Funds builds up when customer payments are received in QuickBooks but never matched to the bank deposit; the money is in the bank, the file just does not know it. Clear it by matching each payment to its deposit. Then run the open invoices report. Anything over 90 days is either a collections problem or an invoice that was paid and never recorded. Write off what is truly gone so receivables reflect money you will actually collect, and so you stop paying tax on income that never arrived if you are on accrual basis.

6. Separate owner money from company money

Trucks, tools, and materials bought on a personal card, and personal purchases on the company card, are universal in this industry. Every one of them gets recorded as either an owner contribution or an owner draw, not as an expense or income. If the owner draw account is enormous, that is a sign the owner is underpaid on payroll (an S corp issue) or that personal spending is running through the business, which is the first thing an auditor looks for in a cash-heavy trade.

7. Fix the loan and equipment balances

Pull the year-end statement for every truck loan, equipment loan, and line of credit and make the QuickBooks balance match. Loan payments are usually recorded entirely as an expense when they are mostly principal, which overstates expenses and leaves the loan balance frozen at the original amount. Split each payment into principal and interest. Then make sure the truck or the excavator itself is on the balance sheet as a fixed asset, with depreciation recorded at year end, so the tax return and the books agree.

8. Sales tax: the Ohio contractor rules

Ohio treats contractors differently from retailers, and most QuickBooks files get it wrong one way or the other. In general, a contractor who installs materials into real property is the consumer of those materials and pays sales tax when buying them; the customer is not charged tax on the installed job. But some work is treated as a taxable sale of tangible personal property, carpet and certain fixtures being the classic examples, and some customers (exempt organizations, resale) can give you an exemption certificate. Your file needs a clear rule per service line, the exemption certificates on hand, and the use tax tracked on anything bought tax-free from out of state. If you charged tax you should not have, or did not charge tax you should have, this is the step where it surfaces, and it is better that you find it than the Department of Taxation.

9. Subcontractors, 1099s, and workers’ comp

Create a vendor record for every sub with their W-9 attached and the 1099 box checked, so January is a two-click job instead of a scramble. Then check the subs against Ohio’s workers’ comp rules: the Bureau of Workers’ Compensation can hold a general contractor responsible for an uninsured sub’s injured worker, so keep a current BWC certificate on file for each. If a “sub” works only for you, on your schedule, with your tools, the cleanup is the moment to talk about whether they are really an employee; I laid out the test in 1099 vs W-2.

10. Municipal tax by job location

A Cleveland area contractor works in a dozen cities a year, and Ohio municipal income tax follows the work. If your crew spends more than 20 days in a city, that city can tax the wages earned there, and your net profit is apportioned by where the work was done. Tag jobs by city in the project name or a custom field so your year-end RITA and CCA returns can be built from the file rather than from memory. The rules and the rate table are in my RITA and CCA guide.

11. Check the Ohio CAT line

Contractors cross the Ohio Commercial Activity Tax threshold earlier than most businesses because material costs pass through gross receipts. The exclusion is $6 million of taxable gross receipts; a general contractor doing $7 million of revenue with $4 million of materials owes CAT on the amount over the exclusion even if net profit is small. The clean file gives you the gross receipts figure to check against. Details in the Ohio CAT guide.

12. Set the monthly routine so you never do this again

The cleanup is a project; staying clean is a habit. Once a month: reconcile every account, match every customer payment to its deposit, tag every job cost, record the owner draws, and read the profit and loss by job. It takes a few hours a month for a typical crew of five to ten, which is why most contractors hand it to someone. My monthly bookkeeping for trades starts at $350 a month, flat, and includes job-level reporting and the sales tax and municipal tracking above. Catch-up for the prior year is quoted as a one-time project; I described how that works in Catching Up on Two Years of Books.

The checklist, in one place

  • Set a closing date after the last filed year
  • Rebuild the chart of accounts: materials, subs, direct labor, job costs, then overhead
  • Turn on Projects or classes and tag a year of job costs
  • Reconcile every bank, card, and loan account, month by month
  • Clear Undeposited Funds and write off dead receivables
  • Record personal and business crossovers as contributions and draws
  • Split loan payments into principal and interest; put equipment on the balance sheet
  • Apply the Ohio contractor sales tax rules per service line; file exemption certificates
  • W-9 and BWC certificate for every sub; 1099 flag on the vendor
  • Tag jobs by city for RITA and CCA apportionment
  • Compare gross receipts to the $6 million CAT exclusion
  • Monthly close, every month

Frequently asked questions

How long does a QuickBooks cleanup take for a contractor? One year of a five-to-ten person trades business, with two bank accounts and a couple of cards, usually takes two to four weeks. Two years roughly doubles it. The job tagging is what takes the time.
Should I switch from QuickBooks Desktop to Online? For most trades, yes, mainly because the field crew can enter receipts and hours from a phone and the bank feeds are more reliable. Intuit has been phasing out Desktop for new customers, and the migration is cleanest right after a cleanup.
Do I need job costing if I only do small service calls? Use classes by service line instead of a project per call. You still want to know whether service calls or installs carry the business.
Josh Katz, CPA, 3401 Enterprise Pkwy, Suite 340-387, Beachwood, OH 44122. Call (216) 249-6013 for a free consultation.

Want these books kept for you?

Monthly bookkeeping for Cleveland small businesses starts at $350, flat, with a CPA doing the work.

Bookkeeping services in Cleveland →  |  Call (216) 249-6013