You are welcome.
Yes, I do this manually. I have a system where, at the beginning of each month, I download the Detailed Ledger Report for the previous month and add those rows into a “Master” Google Sheet that builds up over time.
If you’re interested in the process:
For me, it is necessary to keep all rows from previous months because I do various operations on this rows to track what we need for our business. For instance, as part of this, I color-code certain cells for future reference, so it’s important that I maintain the historical data of what I’ve already worked on.
However, since the Reconciled and Unreconciled quantities change constantly (as Amazon reconciles older events every day), I need to update these two columns with the latest data, even for previous months.
To do this, in addition to adding the previous month’s data to this “Master Sheet,” I also download the Detailed Ledger Report for all previous months, as far back as possible. I import this csv into a separate sheet within the same google sheet file.
In the master sheet, I use VLOOKUPs to update the Reconciled/Unreconciled columns by matching the Reference IDs with the data in the other sheet. Once everything is updated, I copy and paste the values (to remove the formulas) so I can work with the updated master sheet. Afterward, I delete the extra sheet.
This process is repeated each month.
After that, it’s pretty straightforward. You just filter by the Reason Codes as I mentioned before and color-code the cells for each step (ie. reference IDs that got reimbursed, denied, or are still pending Amazon’s action). So you know what to focus on next month and what’s already been checked.
Thank you! I’ll take it as a compliment

The best thing, as you pointed out, would be to automate more of this and again, in my opinion the tool I mentioned earlier does just that, for a flat fee, which I believe quite convenient.
A word of caution about using service providers (which I’d consider only as a last resort): The fees they charge to recover reimbursements aren’t refunded to you in cases of Reimbursement Reversals , which I am sure you already know is when Amazon claws back money from reimbursements they initially granted but later reversed.
It happens, and for us, it’s about 10% of the initial reimbursements.
There is one provider that credits these reversals back to you, though I’m not sure if I can mention them here, plus I never used any of them.
(since there aren’t many providers in the market, it should be easy to check what each of them offer)
For reference, our Reimbursement Reversals for 2023 reimbursements, have been adding up to $870, out of 10k reimbursed initially.
870 and counting…
If you’re using a service that charges 25% of what they recover (let’s say they recovered that $10,000 for you), they would have charged $2,500, leaving you with $7,500. After the reversals, though, you’d be left with $6,630 ($7,500 minus $870), but their 2500 is already gone and not coming back and more clawbacks could still happen over time.
For reference, our Reimbursement Reversals from 2023 have totaled $870 so far, out of the 10k we initially got back,
$870 and counting.
If you’re using a service that charges 25% of what they recover (let’s say they helped you recover that $10,000), they would’ve charged $2,500, leaving you with $7,500. After the reversals, you’d be down to $6,630 ($7,500 minus $870), but their $2,500 fee is long gone and not coming back.
Plus, more clawbacks could still happen over time.