
Loading...
Quick answer: To organise online purchase history for taxes, export every platform you shop on (Amazon, Walmart, Temu, eBay, Best Buy, Home Depot, and the rest) into a single CSV with order ID, date, item, amount, platform, and Schedule C category. Do it quarterly, tag business purchases at the time of purchase, and you will cut tax prep from days to hours.
It is mid-March and you are staring at the Amazon “Your Orders” page. The list keeps going: printer ink, a birthday gift, a desk mat, dog food, a USB-C hub, a webcam. Somewhere in last year's orders are your deductions, and your job is to pick them out one by one and build a record your accountant will accept.
If that sounds familiar, this guide is for you. With the right system, the job shrinks from days to a couple of hours, and you will likely find deductions you missed last time.
When the IRS looks at a business deduction, it expects to see three things: what you bought, when you bought it, and why it was for your business. A credit card statement that reads “$847 Amazon.com” answers none of those questions. It tells the IRS you spent money at Amazon. It does not tell them whether that $847 was a standing desk for your home office (deductible) or a PlayStation for your living room (not deductible).
That distinction matters more than almost anyone realises until they are mid-audit. The IRS standard for documentation is item-level detail: the name of the thing you bought, the amount, the date, and ideally a short note on the business purpose. Credit card and bank statements do not carry that detail. Your order confirmation emails do, but they are scattered across thousands of inbox messages. The platforms themselves have the data, but most of them make it surprisingly hard to get out.
The result: legitimate deductions go unclaimed, not because you didn't buy the things, but because you can't prove it in a form the IRS will accept. Organised records are about claiming money you already earned.
There are really only four ways to pull this data together, and each comes with a cost.
Manual screenshots. You screenshot each order and paste it into a document. It works for the first fifteen orders. For a full year across several stores, it is hours of clicking and a pile of images nobody wants to read.
Downloading from each store. Most stores don't offer this, and the ones that do limit it. Amazon lets you request a data archive from your account settings, but it can take a while to arrive and comes as a zip of technical files, not a spreadsheet.
Typing a spreadsheet by hand. You copy each purchase from order emails into Excel or Google Sheets. It produces a file your accountant can use, but it is the slowest method, and mistakes creep in as you get tired.
Using an export tool. A browser extension reads the order history page you are already signed in to and saves every item, date, and amount to a spreadsheet. Hours become minutes. Pick one that never asks for your store passwords.
Here is an honest map of what each major platform lets you do natively, and where the gaps are.
Amazon. Go to Account then Orders to see your history. Amazon shut down its Order History Report CSV in 2023. What remains is the “Request My Data” option in your account settings, which returns a data archive rather than a usable spreadsheet. The orders page itself has no CSV button.
Walmart. Your order history sits at walmart.com/orders under Purchase History. There is no CSV export at all. You can filter by year and open individual orders, but to get a spreadsheet you are copy-pasting or using a third-party tool.
Temu. Purchases live under Your Orders in the app or on the web. There is no native download. The list does not even show annual totals, which means for tax prep you are scrolling month by month and adding in your head.
eBay. The Purchase History page has limited download options, and pulling a full tax year usually means stitching several date ranges together, or using an export tool.
Best Buy. Your order history page shows past orders, but there is no export button. You see them one at a time.
Home Depot. Online and in-store receipts live under Purchase History at homedepot.com/myaccount/purchase-history once you sign in. Again, no CSV.
The short version: most stores make it much harder than it should be to get your own purchase data out.
No export button? Skip the copy and paste.
Export Amazon, Walmart, Temu, and more to one spreadsheet. Last 30 days free.
A purchase record that holds up for taxes has a consistent shape. Every row should carry the same fields so that when your accountant or tax software reads the file, there is no ambiguity.
Here is what a single row should look like:
| Order ID | Date | Item | Amount | Platform | Category |
|---|---|---|---|---|---|
| 114-3884291-7442618 | 2025-03-12 | Brother HL-L2350DW Laser Printer | $119.99 | Amazon | Office Expenses |
The Order ID is your proof-of-purchase identifier. If the IRS ever asks, you can pull up that exact order and show the full invoice. Without it, you are relying on memory. The Date anchors the expense to the correct tax year and matters for categories with timing rules, such as Section 179 or home office depreciation. The Item name is what makes the expense defensible: “Brother laser printer” is obviously office equipment, whereas “Amazon.com purchase” could be anything. The Amount is what you actually deduct. The Platform tells you where to go to retrieve the original invoice if needed. The Category is the Schedule C line your accountant will put this on, and tagging it now saves you a painful reclassification later.
Those six fields are the minimum. Add a seventh column for Business Purpose if you want to be airtight: “printer for client proposal reports” takes five seconds to type and makes the deduction essentially bulletproof.
Once you have a clean export, the next job is sorting purchases into Schedule C categories. You do not need to memorise all 20 lines. Knowing the five or six that actually apply to your business will cover more than 90% of what you buy online.
Office Expenses (Line 18) covers most of what you buy on Amazon that is consumable or small-ticket: printer ink, paper, pens, desk organisers, small equipment. Supplies (Line 22) is a related category that overlaps with Office Expenses; the practical rule is to pick one or the other and stay consistent across the year. Equipment that lasts more than a year (standing desks, monitors, laptops, printers over a few hundred dollars) typically goes in Assets or under Section 179 rather than Office Expenses because it is depreciable.
Other Expenses (Line 27a) is where your software and SaaS subscriptions usually land: design tools, accounting software, cloud storage, project management, anything that lives in a browser. Utilities (Line 25) covers your business-use percentage of internet and phone. Travel (Line 24a) picks up luggage, travel adapters, and travel gear, though not meals. Meals (Line 24b) is its own beast and not usually a big online-order line, but client lunches ordered through a delivery platform belong here at 50%.
The trap most people fall into is trying to be too precise. Pick categories that are defensible and be consistent. If you tag a desk lamp as Office Expenses in January and Supplies in August, your Schedule C looks sloppy. Pick a lane and stay in it. If you have hundreds of rows to sort, the Purchase Categorizer puts each item on a Schedule C line for you to review.
The people who breeze through March are the ones who stopped treating tax prep as an annual event. Three specific habits make the difference.
Export quarterly, not annually. Four small exports are far less painful than one big one, and they protect you if a store stops showing older orders. Put 30 minutes on your calendar for the first Saturday of April, July, October, and January.
Tag business purchases when you buy them. A label in your email, a note on your phone, a tag in your banking app: whatever fits your habits. Five seconds now saves minutes of remembering later.
Keep a running category total. Once a quarter, sum your export by Schedule C category and write the totals down. By year end you already know roughly what your deductions look like, and you'll spot overspending along the way.
Export each store you shop at into one spreadsheet with order ID, date, item, amount, and store, then add a Schedule C category column and a business purpose column. Retyping a year of orders from email receipts can take a full weekend; working from exports usually takes an evening.
Amazon's old Order History Report CSV is gone. You can request a data archive from your account settings, but it isn't a tax-ready spreadsheet. For a clean file with every item, date, and amount, most people use a Chrome extension that exports from the orders page they are already signed in to.
No. The IRS expects to see what was purchased, when, the amount, and the business purpose. A line that reads 'Amazon.com $847' does not show any of that. You need the underlying order detail, which is why organising your purchase history matters.
Most online purchases for a self-employed business fall into a few Schedule C lines: Office Expenses (18), Supplies (22), Utilities (25), Travel (24a), and Other Expenses (27a) for software. Large equipment that lasts more than a year generally belongs in Assets or under Section 179 rather than in Office Expenses.
Quarterly. Four short sessions across the year are less painful than one marathon in March, and they protect you if a store stops showing older orders.
Every item, date, and amount from the stores you shop at, ready to sort for Schedule C.
Export my ordersFree for your last 30 days of orders. See current plans. Want a rough number first? Try the Tax Deduction Estimator.