So I have this tiny design firm in Austin and we are literally drowning in Amazon boxes right now. Everything from toner to those expensive ergonomic chairs everyone wanted. The problem is my accounting is a total disaster. I spend maybe 1500 a month on there and trying to match the invoices to what actually hits the bank account is giving me such bad anxiety because the shipments are always split. I spent like three hours yesterday looking into the Amazon Business Analytics thing but it feels so clunky and hard to use. Then I saw some people talking about just using the QuickBooks direct integration but then a bunch of other people on Reddit said it double counts taxes or misses discounts sometimes so I'm scared to even try it.
My accountant is gonna lose his mind if I dont have this cleaned up by the end of the month since the quarter is wrapping up soon and I honestly just want a way to see everything in one place without having to open every single order detail page manually... it's taking forever.
I just need to keep track of:
Does anyone know a better tool or even just a better way to export this stuff so it actually makes sense for a small business?
I ran into this exact headache last tax season. The automated syncs kept messing up the sales tax, so I stopped trusting them. Now my current setup involves just pulling the monthly reports into a specific spreadsheet template. It is way more reliable than letting a buggy integration touch the books. Better to be safe than spend hours fixing errors later. Just saw a similar question on Smartphone Board that might help you out with your shopping haul.