Most shop owners see their profit and loss statement once a year, when the tax return is due, and few know what it is telling them. In episode 217 of Do It For A Living, host Kevin Dubois sits down with accountant Jerry Cecco of Cecco and Associates to walk through the books of a small performance shop.

Jerry was a car guy before he was an accountant. He got hooked riding in his brother's 1969 Camaro and found accounting in high school. A trip to Sears Point as a spectator in 1996 showed him amateurs could race, and six months later he had a Mustang Cobra on track. Born in Edmonton, he lived in the Bay Area for over 20 years before moving to Texas, and he now drives a C7 Z06 Corvette. He is not a CPA. A CPA can sign off on financial statements that certain institutions require, and Jerry said most shops don't need that or the extra cost.

This article covers cash versus accrual accounting, sales tax on long jobs, how to lay out a shop P&L, where labor belongs, and how to handle inventory and shrinkage.

Cash or accrual

On a cash basis, revenue counts when money clears the bank and expenses count when your payments clear. A $20,000 check in your hand is not revenue until it is deposited.

Many shops start on cash and move to accrual as they grow. Parts and labor go into a car over days or weeks before the job closes, and owners want to see the profit on every invoice. A tech works every day but gets paid on payday, so a cash-basis report puts that labor cost on one day. Accrual matches costs to the work. QuickBooks can report both ways, and the tax return asks which method you use.

Sales tax and long jobs

Under accrual, the date an invoice hits the books is the date of sale, and sales tax is calculated then. In Texas, Jerry said, sales tax is filed monthly and due shortly after the period ends, whether or not the customer has paid.

Kevin described a mistake he sees often. A shop enters a $100,000 build as one invoice in QuickBooks to take a $20,000 deposit, and suddenly owes sales tax on the full $100,000. Jerry's answer is progress billing. If the car will be in the shop for four months, bill about $25,000 a month with the costs for that work. You recover costs as you go, the customer avoids a shock at the end, and the sales tax lines up with what you have collected. Kevin explained that his software works this way. The project lives in the shop system, and a monthly bill gets sliced out and sent to QuickBooks.

Jerry also advised closing an invoice when the customer is there with a card. Close it on the 31st when they pick up on the 5th, and you may owe the tax before you have the money.

When a customer never pays, issue a credit memo, the opposite of an invoice. It reverses the parts, labor and sales tax, and the credit comes off your next sales tax filing. If you delete an invoice you already paid tax on in a closed period, your books no longer match what you filed, which is a problem in an audit.

I almost never recommend deleting invoices.

Laying out the P&L

Jerry builds a chart of accounts backward from the Schedule C on the tax return. Whatever detail you add has to roll up into those lines.

Revenue goes at the top. Split it where the dollars are big. A shop selling $200 used parts doesn't need a custom account for them, but a shop doing $300,000 a month in custom work may want subaccounts. Labor, parts, fabrication, alignments and roll cages can each get a line, and QuickBooks lets you nest subaccounts and collapse them.

Next comes cost of goods or services sold, the parts used on each sale. Sell a part for $100 that cost $50 and the difference is gross profit on parts.

Labor takes more thought. Many shops pay techs for 40 hours no matter what, so wages sit in expenses. Jerry shows owners how to move the billed portion into cost of services. If a tech works 40 hours and bills 25, those 25 hours come out of wage expense and go to cost of services. A $1,000 labor sale for 10 hours then sits against the $30 an hour the tech was paid, and you see the real gross profit on service.

For a shop with a web store, Jerry suggested QuickBooks classes or locations. Tag sales and expenses as online or shop, then run the P&L by class to see whether the web side makes money.

Gross profit, expenses and owner pay

Gross profit pays for your race tires. No profit, no tires.

Gross profit is the profit on each sale. Pay a tech $30 an hour, bill $120, and the difference is yours. Jerry wouldn't give one target margin. It depends on your costs, since rent and health insurance in California run far higher than in Texas, and on what the owner needs to take out, such as $100,000 a year.

Owner pay depends on the entity. In a simple LLC, the bottom line belongs to the owner, and most owners Jerry sees take draws instead of a salary, since a salary can't be given back if the year ends negative. In an S corp or C corp, the owner's salary is a company expense run through payroll. A good net profit is whatever the owner defines as success.

Bank feeds, purchase orders and inventory

Most of Jerry's clients now use QuickBooks Online because bank and card transactions download daily. Rules sort the regulars automatically, so Tire Rack goes to tires and McDonald's to meals. The download only shows vendor, date and amount, so it can't tell you what a purchase was for.

Parts bought for resale belong in inventory, and they become cost of goods sold the day they go on a car.

Purchase orders tie a part to a job before it arrives. When the bill comes, compare it with the PO. If the quote was $200 and the bill says $250, you want to know before you invoice.

Inventory has to be counted or valued at least every December 31st for the tax return. Jerry's tip is to hold off buying parts in late December that won't sell until January. They tie up cash, they have to be counted, and Texas charges a small property tax on inventory.

When prices change on every order, QuickBooks can use first in, first out or a blended average. Blending suits volume items like oil filters. For a one-off carbon fender that costs $100 one time and $300 the next, price the customer from what you paid for that job.

Shrinkage shows up during the count. An aged-out tire bought for $200 three years ago, a missing part, or five quarts of oil on the floor from a forgotten drain plug get written off with a journal entry, a correction with no outside source document behind it.

Reviewing the numbers and fixing mistakes

Jerry suggests watching what moves, such as weekly sales and spending against last month or last quarter. Over several years, Jerry checks how gross profit trends. A rise from 30 to 40 percent can come from charging more, buying for less, or both.

A bookkeeper puts numbers in the right buckets. An accountant or controller reads the trends. If you find a mistake, change it fast when money is involved, at the end of a month, quarter or year so the cutoff is clean. On December 25th, wait for January.

Inventory is the most common problem Jerry finds.

Key takeaways

  • Cash basis is simple to start with. Shops with inventory and payroll usually move to accrual to see real job profit.
  • Progress-bill long jobs so revenue, costs and sales tax line up with the money you collect.
  • Use a credit memo for unpaid invoices. Don't delete an invoice from a closed sales tax period.
  • Move billed labor into cost of services so gross profit on labor reflects what the work cost.
  • Use QuickBooks classes or separate income lines to see whether an online store makes money.
  • Count inventory at least every December 31st and write off shrinkage with a journal entry.

Keeping the shop and the books in sync

Several of Jerry's points depend on what happens in the shop before anything reaches QuickBooks. Kevin described how My Shop Assist holds the whole project, with its time and parts, and sends a monthly invoice to QuickBooks, so a long build doesn't create one giant taxable invoice. Billed hours against clocked hours is the same efficiency number Kevin has covered in earlier episodes. You can see what the software covers on the My Shop Assist features page.

If your books are a mess, start with the shop data that feeds them. Start a free 30-day trial and see how your jobs, labor and parts flow into your accounting.

Related episodes: 216 - How to Set Your Shop Labor Rate and Measure Efficiency and 212 - The Pricing Mistake That Nearly Sank an Off-Road Shop.

Listen on the Do It For A Living podcast site. Jerry Cecco takes questions by email at JerryCecco@gmail.com.