Hacker News new | ask | show | jobs
by sanjeetsuhag 859 days ago
My biggest gripe with my Firefly workflow is how difficult it is to automatically handle Amazon orders. I’ve setup rules to automatically organize/label the various types of transactions that I export from banks to CSVs, but having to break down Amazon orders is a tedious nightmare. If anyone has any ideas for how to automate this, please share. One idea is to have Puppeteer just open the order page and get the invoice, but that doesn’t seem to secure to me, even if it’s on machine.
2 comments
neilv 859 days ago
For Amazon orders in GnuCash, I've been idly thinking about making a browser plugin that scrapes the Amazon order page, since that's less likely to be cut off than a standalone scraper is.

How I'm currently manually doing Amazon orders in GnuCash is I go to the register for account "Liabilities > Credit Cards > Chase-CC-1234", and add a transation with description, say, "2024-02-16 Amazon order 113-1234567890-987654 (bobs red mill, soy curls, yaktrax)", with a split for each item and for each payment method used (credit card, CC rewards, gift balance).

I keep the order date in the transaction description so that the GnuCash date can be the date that the CC is charged. If Amazon splits the shipment and does multiple CC charges (potentially on very different dates), so that GnuCash reflects those dates, I'm currently duplicating the transaction in GnuCash, and then editing the splits in the original and the duplicate to match the CC charges and what they're for. And each transaction description gets a "#1", "#2", etc. added after the Amazon order number.

One upside of the manual process is that the work is negative feedback for spending money. :)

link
h05sz487b 859 days ago
For Amazon I sometimes have items grouped differently in the order overview on Amazon itself then in the credit card charge. That makes it quite tedious to actually find out what charge goes where.
link
zrail 859 days ago
Amazon's transaction engine is bananas. I've seen it split an order for multiple items across two unequal card transactions. Try reconciling that without parsing every single invoice page.
link
ibash 859 days ago
Amazon has a data export here: https://www.amazon.com/gp/privacycentral/dsar/preview.html

It’s fairly detailed. One issue is that matching refunds to line items can be ambiguous.

I have a side project that does a best effort match, when I get around to completing it I’ll publish it. If you build it before me please share :)

link