Every sale landed in QuickBooks blank, for one accountant to code by hand.

What was going wrong

Apparel Redefined prints and embroiders clothing in Chicago. Sales closes deals in Zoho, their sales system, and each closed deal becomes an invoice in QuickBooks.

Those invoices arrived blank. Every line was marked as a general service, with no product and no sales channel. Someone had to open each one and code it by hand, and the rules for how to code it lived in one head: their accountant's.

The owners also wanted to see which kinds of work make money: screen print, embroidery, and the rest. Blank invoices could not tell them. Almost none of the revenue carried the kind of work on it.

Two quieter problems sat underneath. When a deal was closed twice, the order got made twice, six times in fourteen months. And when the handoff to the order system failed, it failed without telling anyone.

What I found

A rep knows what each line is when they write the quote, and the order system already held it. But the link from Zoho to QuickBooks carried no product and no channel, never updated when a quote changed, and treated every close as a brand new deal.

Asking the accountant to go faster would not fix it, and neither would another review step. The fix was to capture the answer where it is first known: on the quote line, when the rep writes it.

Finance had just rebuilt their accounts so each kind of work has its own income line, and each sales channel is tagged. That gave the invoices somewhere to go. That part was their work, not mine.

I also counted where the money is. Deals that run through Zoho are a small share of the orders, but a much bigger share of the revenue, because they are the larger jobs.

What changed

Reps now tag what each quote line is, once. When the deal closes, the invoice is built and coded: the right income line, the right channel. If a tag is missing, the system holds the invoice instead of guessing, and an email says what is missing.

When a quote changes, the invoice follows it. A deal closed twice no longer makes two orders. A failure sends an email instead of vanishing, and the deal in Zoho shows whether its invoice went through. It shipped in pieces, on top of a link another vendor built before me.

In the three weeks after the last fix, 48 of 67 deals were invoiced and coded the moment they closed. Before, it was none. That is about 74 invoices a month the accountant no longer builds. She puts a hand-built one at 10 to 20 minutes, so that is 12 to 25 hours a month, or 150 to 300 hours a year. I stand behind the low end.

The bigger change is harder to count. How to code an invoice used to live in one person's head, and now it lives in the system. When something is missing, a hold email says exactly what to finish, so nobody has to walk the floor to find out.

What I checked before I believed it

First, whether invoices go out faster. They do, from about two weeks after a job finished to a day or two. But that started in April, months before any of this shipped, from changes on the accounting side. My work did not cause it, so I do not claim it.

Second, whether accounting touches each invoice less. Not yet. A Zoho invoice that has been sent and paid is still edited about four times, the same as before. Two of those are just sending it and marking it paid. The other two are probably card fees, due dates, or shipping, and that is worth asking accounting about.

Third, what the hours really are. They are building time removed, not all accounting time. Accounting still reviews and sends every invoice, and I have not timed how long that takes on one the system built. Until I do, the true saving is lower than the table by whatever review costs. No one was let go and no bill got smaller, so I left it in hours and did not turn it into dollars.

Fourth, the double orders. There have been none since the fix. But they only happened about once every two months, so five weeks without one proves very little. The cause is gone. The count will take most of a year to show it.

One thing did not last. I also had reps add the supplier's order number to garment lines, so the dock could match boxes faster. It went from about 1 line in 70 to 1 in 4 within a month. Then, the week of July 20, it fell to almost none, with no change on our side. Nobody noticed, because nothing was watching. A check that says when a field stops getting filled in is the next thing worth building.

The other piece left is the rest of the business. Orders that do not come through Zoho are most of them by count, and every one of them is still coded by hand. That is where most of the hand work still sits.