Amazon.com Business Banking Integration for QBO – Look What I Found!

By Alicia Katz Pollock
June 10, 2021

If you’re anything like me, you just spent the last year comfort-shopping on amazon.com. Not only did I buy a stack of funny t-shirts and almost anything that had Baby Yoda on it, but I also invested heavily in my business, buying the equipment I needed to take me in new directions this year, like better mics and lighting equipment, and my beloved standing desk.

I have an Amazon for Business account, because I love all the perks like free shipping, progressive discounts on my office supplies, and 5% cash back when I use my AmEx card. 

But the issue for me as a business owner is that because I’m a frequent shopper, my QuickBooks Online banking feed is full of Amazon charges, and it’s been time-consuming to have to log into amazon.com or scan my email to figure out which charge is for what.

So you can imagine my enthusiastic “Look What I Found!” when I noticed a new tab in QBO’s Banking Center, App Transactions. There are TWO new integrations there, one for Amazon Business, and a second one for Square (I’ll talk about that one in the future – just know that it operates exactly like Connect to PayPal, bringing in your Square sales receipts and deducting the fees).

When I connected Amazon for Business by entering my Amazon username and password, and then an OTC (one-time code), I was delighted to discover a list of all my recent Amazon purchases. 

Each transaction shows the payment method, and when you click on it, the actual product description. That’s so huge that I’m going to repeat it again: IT TELLS YOU WHAT YOU BOUGHT! Click on the order number or the link in the memo to open a receipt. You can update the expense category, and add the Payee if you want to be more specific than just saying “Amazon.com.”

The list showed all my orders, not just my business purchases, but it’s easy to Exclude all those that were paid using personal bank accounts that aren’t in my QBO. I don’t even have to muck around with Owner’s Draw unless I accidentally paid with my business card!

After you code the transactions, they move to the Reviewed tab so you can access them later. When the charges appear in the Banking Feed, they’ll Match your Amazon entry. The reverse is also true – if the transaction is already in your QBO, the Amazon for Business integration will update it, adding a new row detailing the purchase (it’s not elegant, but it works).