SgtBatten The issue is multiple items in the order often result in multiple outflows, but the user recorded them as a single outflow (exactly as you recommend). The actual outflows are not always known immediately, so the desire is to avoid having to edit transactions just because Amazon charges when things ship.

dakinemaui Seems a minor issue.  You can click "view your recent order", and immediately Amazon will show how many it was split into.  I do that by reflex as soon as the purchase screen completes. 

Saish Dawg 3rd party merchants often ship/charge separately from what that transaction list shows. In my experience, even the Amazon fulfillment doesn't agree 100%.

And it is a minor issue, but one I can easily sidestep. So I do.

dakinemaui Yes, a few times a single item in a single order was billed up to three times (still adding up to the total), which was mysterious.  Though, the simple click on the order to review works for me enough of the time to treat anything else as a true exception.  But point taken, and fair enough.

I don’t know how to link to my old post but this is what I posted a while back. Not sure if it helps with your question. 
 

Amazon Order History Report!!!

•  
• MXMOM
•  
•  
• mxmom
•  
• 4 mths ago 
•  

This was posted over on the Facebook YNAB Fans group by someone (not me) but I have seen alot of people having problems with the Amazon order reconciliation so I thought I would post this here in case it didn't make it here or if you are not on that FB group. Again, not my discovery. Credit to another person (whose name I won't share because it is a private group). 

If the person who posted this on FB is also on here, please come and claim credit for this.   

__________________________________________________________________________________________________ 

As many of you know reconciling Amazon order to YNAB is a pain due to the way Amazon bills on delivery. We will put in an order into YNAB for say, $55.93 and Amazon will bill it as 3 separate orders and we then have to crawl through the orders page to find it. 

Well I just discovered this link: 

https://www.amazon.com/gp/help/customer/display.html…

I will build an order report for Excel and you can search by amount!! Very helpful for us and thought we would share.

MXMOM I believe Amazon has taken away access to this report. 😒

Vibrant Dang, why do they do that? On a related note, we have a weird Amazon charge on our card this week.  The payee says Amazon Channels and shows a recurring charge.  I have combed through all things Amazon (order, Prime, etc) and can't figure it out.  

Sep. 8, 2020

MXMOM Look under My Subscriptions - it sounds like it's adding a premium channel on to your Prime Video. (HBO, etc.)

Vibrant yes, thats what I thought but I didn't see it.  I am going on the website today.  Sometimes all the info doesn't show up on the app.  

Edited to add - just got off chat. Sure enough it was a charge for SuperChannel.  Cancelled it. Hubby doesn't recall ordering and we share the prime video with the kids so maybe one of them ordered it for something.  Amazing how they just click "order" and then assume some magical money fairy takes care of it.

Vibrant slightly more annoying but it looks like it’s still somewhat possible: https://www.amazon.com/gp/privacycentral/dsar/preview.html

Periwinkle Flute I have definitely seen changes in those Order Details/Invoice amounts from what the values are immediately following checkout. The final result that hits my CC can be very different, especially with 3rd party merchants. That's why this is such a popular topic:

• Recording transactions immediately allows you to easily categorize but you run the chance the actual transactions do not agree with the checkout invoice(s), mandating correcting things after the dust has settled.
• Waiting to record transactions until after things have actually posted to the CC leaves your categories overstated and misleading for upcoming spending decisions. 

dakinemaui Order Details and Invoice are completely different things. The Order Details just shows all the things you bought and the total cost so, yes, if there are 3rd party items or things ship at different times this will not match the actual charge amounts on the CC.

The amounts at the bottom right of the Invoice show the actual amounts charged to the CC and the date of each charge and will EXACTLY match what appears on the CC. This info does not appear at the time of the order being made (so will not change since it's not there). One the item ships and the card is actually charged is when these amounts will appear.

It's not uncommon at work for one order to be split into 5 or more charges on the debit card and the Invoice ALWAYS has the breakdown of the charges for that order.

Periwinkle Flute 

Periwinkle Flute I think your advice works to somewhat ease the symptoms, but it doesn't seem to address the underlying problem. No one wants to go in after the fact, pull up their order history, pull up order #277, dig into the Invoice, look for the transaction amount, NOT find that amount, close the invoice, back out to order #278, dig into that Invoice, etc. etc. until they finally find that magic number. They can then switch back to YNAB and correctly categorize the new transaction. They'll also need to go edit the original transaction and remove that item's category and amount.

Yes, I agree that the Invoices have the information that can be used to figure out the multiple outflows (eventually). However, don't you think that avoiding multiple outflows entirely is a better solution?

dakinemaui of course. I was just trying to explain a fool proof way to find out what the charges were for if it does happen.

It happens to me about  once a year (around Christmas when I'm buying a lot of stuff at once). Even when it does happen it takes maybe 20 seconds to open 4 or 5 invoices in order to find the mystery amount(s) and another 5 seconds to make sure the separate charges equals the total amount I entered in YNAB. In my photo example if I had entered the $30.67 as one transaction I don't go back and change it to make it 2. I just clear the 2 CC charges against my 1 YNAB charge and everything is reconciled!

9001 Nice job! It worked!  I ran the code past my teenaged programmer first and he said it's all good as far as not doing anything naughty :).  He lives on Github....  Appreciate the open-source work, thanks!

9001 Can't seem to get it to work on Chrome for me, the tab is just blank when it opens. A quick Google suggested they've disabled javascript running when opening a new tab, but TBH I'm way out of my depth here. Is there a workaround to this?

Cyan Storm Thank you! This is exactly the kind of thing I was looking for - just a quick breakdown of the actual charges. Way easier for me than the other options (I use my phone to order and don't always enter them immediately, so inevitably importing flags up some missed ones)

Cyan Storm That's a great tip. I also found that you can export your transactions and look it up that way but it's more cumbersome.

To do it, go to Amazon’s website and then select “Account & Lists” from the top right. You have to click on it. From there select “Download order reports” under the “Ordering and shopping preferences” section of the menu.

Superbone I’ve had this happen to me also. What I figured out is that Amazon gives you a choice when you return something......you can have the credit applied to your original payment or credited to your gift card. It’s in the small print when you’re entering the return.

KnitPurlKnit Yeah, I remember selecting that in the past. I must have been in hurry that day and overlooked it. I’m sure it defaults to a gift card credit.

Superbone Yeah, they really want you to take that gift card so you can't do something foolish, like spend the money somewhere other than Amazon.

Matthew They're looking to take over the world, that's for sure. They've got their hooks in me. I can tell you that.