Bookkeeping Headache with Sherwin-Williams Invoices for My Paint Jobs

I've been running my painting biz solo for 8 years and QuickBooks Online has been my go-to for tracking all the Sherwin-Williams paint and supply invoices, but damn it's a pain categorizing the bulk buys against each job's expenses. Just spent $750 on Emerald paint for a big interior repaint and it took me two hours to reconcile it without screwing up my profit margins. Anyone else dealing with this crap and have a better way to automate it? Watched that Idaho Painter video on simple bookkeeping hacks, but he didn't cover integrating supplier receipts like this.