To reconcile Amazon and Home Depot purchases from a bank statement on Mac, convert the statement PDF into a spreadsheet, filter the description column for merchant patterns — AMZN Mktp, HD, HOME DEPOT — and match each row to its order confirmation or store receipt. The hard parts aren't the conversion; they're the split charges, partial refunds, and marketplace seller variants that don't line up with the order history one-for-one. This guide walks through each failure mode with a merchant description cheat sheet you can paste straight into Excel or Numbers.
Why retailer reconciliation breaks
Contractors, property managers, and small-business owners hit the same wall every month: one order on Amazon or Home Depot appears as three or four charges on the bank statement, often on different days, sometimes with different descriptors. A $642 Home Depot trip becomes a $412 card swipe and a $230 delivery fee three days later. An Amazon order with two items that ship separately is two charges. Returns drop a credit that doesn't obviously match anything.
The retailer's order history says one thing. The bank statement says another. The gap between them is where bookkeeping errors live — doubled expenses, missed returns, miscategorized charges. Getting the statement into a spreadsheet is the first step to closing the gap.
Step 1 — Convert the statement to a filterable table
Open Bank Statement PDF Converter on your Mac and drop the month's PDF onto the import area. Smart detection finds the transaction rows, transactions-only mode strips the balance summaries and marketing copy, and a single export drops a clean XLSX onto your disk. The Excel conversion guide covers the import details; the rest of this guide assumes you've got the rows in front of you.
If you run multi-month reconciliation — a quarter at a time, say — batch-convert the folder in one pass and use an Account plus Month column to keep things filterable. The month-end reconciliation guide has the batch mechanics.
Step 2 — Filter by merchant pattern
Bank descriptions are ugly strings. They're all-caps, abbreviated, sometimes truncated, and they vary by card network. The trick is pattern-matching the consistent pieces. In Excel: apply Data > AutoFilter to the Description column and type AMZN into the filter box. Every Amazon charge pops out. Switch the filter to HOME DEPOT or HD and you've got the Home Depot rows. Paste each subset into its own tab for matching.
Merchant description cheat sheet
| Retailer | Description patterns on statement | Notes |
|---|---|---|
| Amazon (fulfilled) | AMAZON.COM*XY1Z2, AMZN DIGITAL, Amazon.com | Direct fulfillment; search order ID fragment in Amazon history |
| Amazon Marketplace | AMZN Mktp US*1A2B3, AMZN MKTPLACE PMTS | Third-party seller; order ID fragment after the asterisk |
| Amazon Prime / Subscribe | PRIME VIDEO, AMZN PRIME, Amazon Web Services | Recurring; group as a separate subscription category |
| Home Depot — store | HD 0123 HOME DEPOT, THE HOME DEPOT #0456 | Store number follows HD; cross-check to receipt |
| Home Depot — online | HOMEDEPOT.COM, HOME DEPOT ONLINE | Delivery fees often post a few days after the order |
| Lowe's | LOWES #01234, LOWES.COM | Pattern mirrors Home Depot's store-number format |
| Costco | COSTCO WHSE #0123, COSTCO.COM, COSTCO GAS | Gas charges are a separate pattern — split for Line 9 if vehicle |
| Walmart | WAL-MART #0123, WALMART.COM, WM SUPERCENTER | Grocery vs. general merchandise is not split in the descriptor |
| Target | TARGET 00012345, TARGET.COM, TGT *TARGET | Target debit card (RedCard) may appear as TGT* |
| Best Buy | BEST BUY #0123, BESTBUY.COM, BESTBUYCOM888 | Marketplace charges not distinguished from first-party |
The descriptors vary slightly by card network (Visa vs. Mastercard vs. Amex) and by bank. Use the patterns as starting points; your own statements will have minor variants you can add to the cheat sheet once and reuse monthly.
Step 3 — Deal with split charges
Amazon bills per shipment. An order with three items fulfilled from three warehouses produces three charges — often on three different days, rarely summing cleanly to the order total because of taxes and shipping allocation. Home Depot splits delivery fees from the merchandise charge. Best Buy sometimes pre-authorizes the full amount and then releases a partial capture.
In your spreadsheet, add two columns: Order reference and Expected total. Paste the order ID from your Amazon or Home Depot history into Order reference and the order subtotal into Expected total. Then group charges by reference and SUMIF the actual amounts. If the sums match expected, you're reconciled. If they don't, you're either missing a shipment or looking at a pending authorization that hasn't posted.
A split charge that doesn't reconcile is almost always a missing row, not a wrong amount. Scroll the next month's statement before you assume fraud.
Step 4 — Match partial refunds
Returns produce a credit line on your statement, usually with a similar descriptor to the original charge. The refund amount is often less than the original — return shipping, restocking fees, or you only returned one of two items — so exact-amount matching fails.
The technique: filter by merchant, sort by date ascending, and scan for negative (credit) amounts. Insert a Refund column next to Amount. For each credit, identify the original purchase by date proximity and order ID, then enter the refund amount negative-signed in the purchase's Refund column. The Net column becomes Amount plus Refund — that's what you book to the expense category and what your Schedule C deduction is based on.
For the tax-season implications of partial refunds — how netting affects your Car & truck or Supplies totals — see the tax-season organization guide.
Step 5 — Separate first-party from marketplace
For Amazon specifically, the AMZN Mktp prefix is load-bearing. It means the charge was fulfilled by a third-party seller, not Amazon itself. Returns policies differ. Warranty coverage differs. For business purchases, the tax receipt may come from the seller, not Amazon. Tag marketplace charges separately so you don't apply Amazon's refund flow to a seller that doesn't honor it.
Best Buy Marketplace, Walmart Marketplace, and Target Plus have the same seller-dispatched dynamic but don't flag it on the statement descriptor. You usually have to open the order on the retailer site to confirm — but once confirmed, add a Seller column to your spreadsheet so next month's reconciliation is faster.
Step 6 — Export and archive
Save the reconciled spreadsheet with a clear filename — 2025-10-retail-recon.xlsx — and keep it alongside the source PDFs. If you're handing work to a bookkeeper, the Chase-to-Excel guide and the general PDF-to-Excel workflow cover the column structure bookkeepers prefer.
Reconciliation checklist
- Statement PDF converted with transactions-only mode
- Description column filtered by each retailer pattern from the cheat sheet
- Split charges grouped by Order reference and summed to Expected total
- Partial refunds entered in a Refund column, netted in Net
- Marketplace vs. first-party tagged per Amazon / Best Buy / Walmart / Target row
- Reconciled file saved with the month's PDFs
Get the Mac app
Bank Statement PDF Converter runs natively on macOS 13.5+. Smart transaction detection, side-by-side review, and every export format your workflow needs — XLSX, CSV, TSV, Markdown, XML, TXT. Files stay on your device while you browse and review. Download from the Mac App Store.
FAQ
How do I reconcile Amazon and Home Depot purchases from a bank statement? +
Convert the bank statement PDF to a spreadsheet on Mac, filter the description column for merchant patterns like AMZN Mktp and HOME DEPOT, then match each row to its order confirmation or receipt. Split charges and partial refunds get their own columns for netting against the original order.
Why does one Amazon order appear as multiple charges on my statement? +
Amazon bills per shipment, not per order. An order containing three items that ship separately will appear as three smaller charges on your bank statement, often on three different days. Matching them requires summing the child charges back to the order total.
How do I handle partial refunds from retailers? +
Find the refund credit on the statement, match it by date and amount to the specific return, and net it against the original purchase in a Refund column. The running difference — purchase minus refund — is the cost basis you book to the expense category.
What does AMZN Mktp US mean on a bank statement? +
AMZN Mktp US is Amazon's descriptor for third-party marketplace sellers. Charges with this prefix are not fulfilled by Amazon directly. The trailing alphanumeric code is the order-ID fragment, which you can search in your Amazon order history to find the original purchase.
Do I need a separate app for each retailer? +
No. Bank Statement PDF Converter extracts every row from the bank PDF regardless of merchant. One conversion gives you every retailer in one spreadsheet — Amazon, Home Depot, Costco, Walmart, Target, Lowe's, Best Buy, and any other — which you then filter by description pattern.