How are you all doing your accounting?

Hey all. I run a multichannel brand but most of my sales are Amazon (around 13k units/yr in volume). I also sell on Woocommerce and ebay. I use quickbooks for my accounting and its like 80% automated- it does an awesome job with any expenses paid by credit card or bank transfer, and it’s pretty good at revenue (captures payments net of cc fees/referral fees).

Where I just can’t get get automated is COGS. I tried Quickbooks built-in inventory system but it’s just not made for e-commerce- can’t even handle multiple inventory locations or multiple sales channels. I use a 3PL and they have perfect reports, and Woo, Amazon, and eBay all do good reports too. But tying it all together has still been manual. It’s not a crazy workload- vlookups and whatnot keep my excel file updated through the month then at the end of the month it takes me around 3-4 hours to compute COGS. But it just feels like the solution should be out there.

I looked into an inventory management system but it’s just overkill and priced that way. It’s hard to justify paying $150-$200/mo to save myself 3-4 hours. Plus it still doesn’t solve the rest of the automation failures of quickbooks, the biggest one being to gross up Amazon sales for the referral fees (another manual thing I do during my monthly accounting process, but it’s only a 10-20 minute affair).

It just all feels so… solvable. Anyone use any magic bullet systems that do it all for them? I’d hate to pay a human to do this since it’s all data that is readily available.

This isn’t promotion or lead generation- I have nothing to sell just want to know if the solution exists!