
What is a good way to track Amazon?
So, I have always wondered if there is a good way to track Amazon orders? You know, you order a bunch of things and spend $175. You enter that expense. Then the ten things you ordered ship at different times. Amazon then charges you for each of the shipments when they ship. You import your bank transactions and they won't match your $175.00 entry. Has anyone come up with a good way to track this so it is easier to match up?
Thanks
-
I don't import transactions, so the situation you describe doesn't occur for me, although I do receive individual charges for items that are shipped separately. It's really a pain to track. I turn my original $175 transaction into a split (if it wasn't already) and separate out each segment of their "delayed billing" that you describe, as the appear. Way too much work, IMHO, but I can't think of a better way.
Reply -
I do a split at the time of purchase (and add a note against each split item to state product the cost relates to):
Then if they do come in bit by bit across my bank account I add the line item as a new item in my account (again with a note to say what the product was) and mark that as cleared:
...and then edit the original split transaction and delete the individual line item which came in separately (note the minus symbol beside each split item). At the time of doing this I need to edit the total amount of that original outflow amount in order to allow that to save correctly:
This then allows me to clear the remaining items if they come in to my bank as one transaction, else repeat until all are split out into individual transactions and cleared.
Reply -
I'll put in the original amount and then fix it. It is actually usually easy to fix if you know the trick... After a short time after the order got to amazon and go to your order history and then click the 'view invoice' link that his hidden to the top right of the order it breaks down the order per charge on the card correctly 99% of the time.
Where this process doesn't work for me is during Christmas and my Birthday when my wife orders me presents and I'm not allowed to look at the orders/invoices.
Reply -
I'm sorry to say I just wait for the transactions to download and then go back to the Amazon orders history to match it up. It's certainly not the most efficient use of my time, but I found that trying to anticipate the breakdown and then inevitably having to go back and fix it anyway was just more work.
Reply -
I make a paper list from the Amazon order in columns, each column represents a category. Then I add them up on a calculator. Then I get the bank statement and add them up. If the two lists don't tally I make a guess at which category the missing few pounds (it isn't much) goes into.
It is a tedious PITA, but I can't think of a better way.
To be honest, although boring, it doesn't really take very long. Maybe 10 minutes. <shrug>
Reply -
Something I saw on Reddit: Don't bundle items. If you order things as you need them, instead of making big purchases all at once, this situation will fix itself.
But, like others have said, this the easiest thing (for those on Direct Import):
1) Manually enter in the ENTIRE transaction
2) Split accordingly in YNAB
3) If/when Amazon divides the transaction into smaller orders and they post to your Amazon Visa card (the ONLY car you should be using on Amazon [5% cash back!]) delete your manual entry. Boom.
Reply -
I've really been struggling with this lately. I buy so many of my essential needs from Amazon that it gets very confusing.
I've tried 2 methods: only ordering 1 thing at a time. Put it in my shopping cart, go to check out and buy it. Do the same with the next item. Then you get all separate transactions and know exactly what it's for when the transaction clears. My hesitation in continuing this is that it's wasteful and I don't want to receive 6 separate boxes at one time.
The only other method I've used that sort of works is to enter the entire amount of the transaction as soon as I order it. Then as each transaction imports, I clear each one of those until the total adds up to what the original amount was. Then I delete the initial transaction that I manually entered when I completed the order. This too though is a PITA.
Neither is perfect and if someone has discovered something better, please pass it along!
Reply -
I spent a frustrating amount of my evening last night trying to reconcile my Amazon purchases instead of working on my sewing project. I managed to figure it out, but I definitely! want to streamline that process if I can. Based on what I learned in this thread, I'm going to record the transaction, split it according to the orders (putting the order# in the memo) as listed in the order confirmation email and hope it all matches the next time I reconcile.
My struggle last night was down to Amazon originally giving me one order with 3 items totaling one number, later splitting it because one of the items shipped later, thus changing the original split and having unrecognizable entries in YNAB. Ugh. I think I had YNAB, Amazon, 3 calculator windows and both the credit card statement and the running register open at once trying to get everything to work.
Reply -
I usually just wait for the transactions to come through the credit card since I know what categories they will come out of and about how much in each rather than deal with entering then fixing later. I often have to change the imported entries anyway since YNAB always selects the last used category for the payee.
Maybe not the best method, but I always have both YNAB and my Amazon Orders page open near each other so it works for me. *shrug*
Reply -
I enter the initial transaction (assuming all the same category), and then as each shipment clears the bank, i will approve each transaction and go reduce the original transaction I entered by that amount. This way, the ledger is always accurate. The problem with leaving the original transaction unedited is that now your budget is incorrect. Just as an illustration:
I spend $100 at Amazon and put in a transaction for $100.
They split that into 3 shipments, one for $25, one for $60, and one for $15. Let's say they each clear the bank on different days (so the maximum annoyance 😃).
On day 1, I approve the $25 transaction and reduce my original transaction of $100 by the same amount (so it's now $75). Then $60 get's approved on day two and I reduce the original transaction again (so it's now $15). Then, when the last shipment clears the bank, the amounts match (both $15), so the transactions link and I approve.
This method makes sure that your budget is always accurate, that you know how much is left to clear from that order, and you get the last transaction to link for free since the amounts will match.
Hope this helps!
Reply -
If I order many items at once from Amazon, I usually see how much it's going to be, then buy myself an Amazon gift card for the amount. I then log the purchase of the gift card in YNAB as a single purchase (you can still split this between multiple budget categories if necessary) and the Amazon order is placed using the funds on my Amazon gift card. That way, if Amazon splits it out, YNAB is not affected.
Reply -
I seriously just spent two hours trying to follow my credit card statement with my Amazon account. It's such a pain! After that I had to go back and try to match what I had posted to YNAB to the split charges on my card. I think I am going to try splitting my orders from Amazon into my budgeted categories and try making smaller orders more often. I've been out of town so didn't get this done in a timely manner and really don't want to have to do this again. Amazon is such a pain it mentally makes me check myself before I place an order and ask "Do I really want this?" . Gives me an extra incentive to stick to the budget.
Reply