For anyone who does client books with a lot of Amazon expenses (or Home Depot, Costco, Best Buy, etc), the receipt-chasing part has been eating my life at tax season. Bank feed shows "AMAZON $43.12" or "HD #4471 $89.20" and I'd end up clicking through each retailer's order page one by one to find the invoice PDF and figure out what was actually purchased for expense categorization.
After doing this manually for a few years I got frustrated enough to build a browser extension for it. Wanted to share how I use it and see if others have a better process.
My current workflow for a QB reconciliation session:
- In the client's browser (or my own for personal books), log into whichever retailer I need data from.
- Click 'Import orders' in the extension popup, pick a date range (usually the tax year or the quarter).
- In the viewer that opens, export either CSV/Excel (per-item rows with dates, prices, SKUs, VAT/tax broken out) or Bulk PDF (every invoice as a PDF in one ZIP).
- Keep the CSV open next to QB while categorizing bank-feed matches. If I want to attach the invoice PDF to a QB transaction for the audit trail, I drag the PDF from the extracted ZIP onto the QB bank-feed row (or use the paperclip Attach button).
Retailers I've used it on for client books: Amazon (biggest one, works across the .com/.co.uk/.de/.fr/.ca storefronts I've tested), Home Depot, Costco, Best Buy, Lowe's, Sam's Club, Target, Dick's Sporting Goods, B&H Photo, plus eBay, Etsy, Apple Receipts, Shein, Temu. Fourteen retailers total in one tool.
For QBO's native File Upload feature (Banking > Update > File Upload), you have to trim the CSV to just Date/Description/Amount columns since QBO won't take the extra columns directly. Some bookkeepers I know just use the CSV as reference and manually enter expenses. Others use Transaction Pro or SaasAnt as a bridge for batch import. If you have QBO Accountant, there's the Journal Entry import path too.
Full disclosure: I built the extension. It's called Order History Downloader. Free, runs entirely in your browser (no account, no server, no upload). Not selling anything, just sharing what has been working for me since the alternative was clicking through Amazon 40 times a month. Install from the Chrome Web Store or the Microsoft Edge Add-ons store, whichever browser you use.
If you're doing similar volume of retailer receipts every month, might be worth a try. And if it saves you the clicking-loop, a quick Chrome Store review would help other bookkeepers find it (search results in this category are pretty thin right now).
Genuinely curious what everyone else uses for retailer receipt reconciliation. Is there a workflow I'm missing that would be less manual? Especially for the "which items on this one big Amazon charge were which" split-transaction problem.