Coolant hoses and a reservoir in an engine bay

Auto Repair Shop QuickBooks CleanupThe parts total missed the file

A single parts number can finish the afternoon and still leave the job, the core, and the shelf uncounted.

See the split

The total is not the job.

An end-of-day parts total is a useful number and a dangerous one. Useful, because the bay can see what moved. Dangerous, because the books can accept it as sales and never meet the repair order that used the parts. A closed ticket is parts plus labor plus, sometimes, work sent out. One bucket cannot say which of those the shop actually earned.

We lay the parts report beside the tickets before anyone renames an income account. If a total has no job under it, the total stays visible and unnamed. Inventing a customer to absorb it creates a sale the bay did not do. The amounts wait in your own file until that month is open with you. This page keeps every dollar off on purpose.

A core has to face its credit.

A core leaves with a charge. It comes back, if it comes back, as a credit. Those two have to face the supplier so a statement can be ticked line by line. A credit dumped into miscellaneous income, or a charge left sitting in a clearing spot, makes the next statement disagree with a file that looks tidy from across the room.

The pair belongs in the open month. Sliding a credit into a period that already left with a return is not a cleanup. It is a change to a filed period, and that is a return question. Until the credit exists, the shelf still thinks the core is out. We would rather see that than pretend the supplier and the shelf already agree.

The shelf moves when the job closes.

Parts on the shelf are an asset until the job that used them closes. They are not an expense on the morning the carton arrived, and they do not wait for a quiet Saturday to become a cost. Cost the carton on the day it arrives and a quiet week looks expensive while a slammed week looks as though the iron cost nothing.

You do not need a perpetual count of every clamp on the first day we open the file. You do need a rule the bay can keep. When the ticket closes, the parts on that ticket leave the asset. A count that will not meet the screen stays on a list with the date. The next delivery either explains it or the list remains, which is why a list exists.

The vendor account rides on the receipt.

The general-ledger account assigned to a vendor usually rides along on the purchase order and on the receipt. One wrong account then stamps every hose, filter, and fluid from that vendor. Changing the vendor once is the repair. Editing a month of receipts one by one is how a second error gets introduced.

Accounts that no longer match how the bay buys are archived, not deleted, so an old ticket can still be read from the name it used. Give a new kind of part an account of its own. A catch-all bucket is where a core, a fluid, and a tool become one number nobody can split later.

Name the total that missed.

Say which parts total had no job under it.

Steven Palmieri, Tax CFO

You will be talking to the Steven Palmieri practice.

Shop pages from here.