Who this is for
- Online stores and shops that sell through a store platform or a point-of-sale system
- Owners choosing between one entry per order and one entry per payout or per day
- Sole proprietors, partnerships and corporations with US sales
Not covered here
- Amazon, Stripe and restaurant point-of-sale entries in detail
- Which states require you to collect sales tax
- Choosing cash or accrual accounting or an inventory method
- Sales outside the US
Do you have to enter every Shopify or POS order in your accounting software?
Federal tax rules do not require an entry for every order. They ask for a result, not a posting style. A business must keep permanent books or records, including inventories, sufficient to establish gross income, deductions and credits, and the IRS says that, except in a few cases, the law does not require any special kind of records beyond a system that clearly shows income and expenses. One entry per order, per payout or per day can each meet that test. The answer is the same in QuickBooks, Xero or any other accounting software: the rule is about your records, not the software.
A summary entry works only if all three hold:
- It breaks out gross sales, discounts, shipping, refunds, fees and sales tax, not just the net deposit.
- It ties to the platform report and to the bank deposit.
- The order-level detail stays retrievable, in the software or in saved platform exports.
A case stops being simple when stock is tracked by item, sales run through several channels, sales tax is owed in many states, wholesale customers carry balances, or an app that syncs the store into your accounting software (a connector) has already posted sales and deposits. Gather these before choosing: the platform's sales report and payout report for a recent month, the matching bank statements, the connector's settings, and any Form 1099-K you received.
The usual fit:
| Your shop | Usual fit |
|---|---|
| Stock tracked by item, wholesale invoices, or the software produces your sales tax return | One entry per order |
| High volume, simple catalog, everyone pays at checkout | One entry per payout (online) or per day (point of sale) |
| Either, with a connector already running | One source posts; the bank feed only matches |
If several of these apply, or past months may already be double counted, settle the method before posting more months. The last section, Different for you?, shows where each case goes.
What do the IRS record rules require, and where do the order details have to live?
The books must show gross income, and supporting documents must back the entries. The order details do not have to sit inside the accounting software, but they must be retrievable.
Publication 583 lists the documents that support gross receipts: cash register tapes, bank deposit slips, receipt books, invoices and credit card charge slips. For an online store, the platform's order export and payout report can serve the same purpose. The regulation requires records to be available for inspection and kept as long as their contents may matter to any tax law; see how long to keep business records. For software records, the publication says a recordkeeping system should include a summary of business transactions, ordinarily made in the books, and that computerized records must reconcile with the books and return and give enough detail to identify the underlying source documents. A payout entry that carries its payout ID and sits beside the saved platform exports is set up to meet that test.
The IRS can ask for the software file itself. Its electronic records FAQ says examiners request the accounting-software backup in most cases where software is used, and that a broad audit, such as one verifying gross income, will likely include that request. The examiner can then drill down from reports to the underlying data.
So with summary entries, save the platform's order export, sales report and payout report for each period yourself. Do not rely on the platform as the only copy.
What must a daily or payout summary entry break out?
A summary entry must show each component of the money, so the books still state gross income, refunds, fees and sales tax. Posting only the net deposit as sales hides all four. A common layout, though the IRS does not require this exact one:
| Line on the entry | Comes from | Goes in the books as |
|---|---|---|
| Gross sales | Platform sales report, by sale date | Sales (income) |
| Discounts | Sales report | Netted against sales |
| Shipping charged | Sales report | Its own income line |
| Sales tax collected | Platform tax report | Sales tax payable (a liability); not income if imposed on the buyer |
| Refunds and returns | Sales or payout report | Returns and allowances, reducing sales |
| Processor fees | Payout or activity report | Expense |
| Chargebacks, adjustments, reserves | Payout report | Their own lines, not sales |
| Federal backup withholding | Payout report; Form 1099-K box 4 | Its own line: tax withheld for you, not a fee or a reduction of sales |
| Net payout | Bank statement | Clears the platform clearing account (a holding account for money not yet paid out) |
Publication 334 subtracts returns and allowances from gross receipts to get net receipts. It says sales taxes imposed on the buyer, which you must collect and pay over, are not income, but a sales tax imposed on you as the seller goes in gross receipts. Which one applies depends on the state.
Your platform's own reports are the usual source for these lines; Shopify's Finance summary report and payouts documentation are an example. Report names differ by platform, so match each line to your platform's own report.
When does one entry per order make sense?
One entry per order makes sense when the books need information that a batch total cannot carry.
| Situation | Why per order helps |
|---|---|
| Stock tracked by item in the software | Cost of goods sold and stock levels move with each sale; a payout summary has no item lines |
| Wholesale or invoiced customers | Each customer's balance, terms and payment need their own invoice |
| The software must produce the sales tax return | Tax has to be split by state and local jurisdiction, order by order |
| Very low order volume | A few orders a week cost little to post and need no batch tie-out |
When selling merchandise is an income-producing factor, a business must generally take inventories into account at the start and end of the year, unless it is a small business taxpayer (average annual gross receipts of $32,000,000 or less for the three prior tax years, and not a tax shelter). With summary entries, stock and cost of goods sold may have to come from a count or an item report instead of from each sale. For that count and the small-business exception, see cost of goods sold on Schedule C and inventory or supplies for small sellers.
More entries mean more review time; what that does to a bookkeeper's fee is in what an ecommerce bookkeeper does and costs.
When does one entry per payout or per day make sense?
One entry per payout or per day is enough when the books only need totals: high order volume, a simple catalog, customers who pay at checkout so no one owes you a balance, and tax figures taken from the platform's tax report.
- Online sales: one entry per payout. Each payout ties to one bank deposit, which keeps the match short.
- Point of sale: one entry per day. Publication 334 says to make sure records balance with actual cash and credit receipts at the end of each business day. The sample system in Publication 583 keeps a daily summary of cash receipts taken from the register tape and rolls it into a monthly summary. Tips, gift cards and cash need lines of their own; see recording daily POS sales.
A payout covers several days of sales. Keep each sale's date in the saved sales report, and split a payout that crosses a month or year end so each period carries its own sales. Dating a whole payout by the payout date can put sales in the wrong period.
Why do a connector and a bank feed count sales twice?
A connector (the app that posts your store's sales) and a bank feed (the automatic download of bank transactions) double count when both record the same money as income. The connector posts the sales. The bank feed then offers the deposit as a new transaction, and if it is added instead of matched to the payout entry, the same sales appear twice. Fees double count the same way when the connector books them as an expense and a second entry books them again.
One source should post the sales and fees. The other should only confirm the deposit. Two clean setups:
- Connector posts, bank feed matches. The connector posts sales, refunds and fees to a platform clearing account. The bank-feed deposit is matched to the payout and clears the account.
- You post, bank feed matches. The connector posts nothing. You post one summary entry per payout or day, and the bank-feed deposit is matched to it.
Check your connector's own settings for what it posts (sales, refunds, fees, payouts) and under which dates. Settings differ by connector, and this page cannot tell you what yours does. To test for a double count, compare a month's income in the books with the platform's gross sales for the same dates; income near twice the platform figure points to one. See duplicate income in accounting software for the cleanup.
How do you prove a summary entry ties to the platform report and the bank deposit?
Compare four numbers: the sales on the entry, the payout on the entry, the bank deposit and the clearing account balance. If all four agree, the summary holds up.
| Check | Compare | Source |
|---|---|---|
| Sales | Entry's gross sales, discounts, shipping, tax and refunds | Platform sales report for the same dates |
| Payout | Entry's fees, refunds, adjustments and net payout | Payout or payments activity report |
| Bank | Net payout equals the deposit amount | Bank statement line and date |
| Clearing account | Balance once the deposit posts | Books: zero, or only the days not yet paid out |
Put the payout ID or bank reference in the entry memo, and save both exports with that month's bank statement. If you take payments through more than one processor, each pays out separately; keep a clearing account for each. Publication 334 advises balancing records to actual receipts at the end of each business day; a payout tie-out applies the same check to each batch. A leftover difference is usually a refund, fee, hold or timing item; see Shopify payouts and bank deposits, reconciling sales and payouts and the Undeposited Funds balance.
How do refunds and sales tax work when a payout covers many days?
A payout is a settlement date, not a sale date. Post sales by the day they were made, and let the payout clear the platform balance. That keeps the books tied to the platform report. The tax year the income falls in depends on your accounting method, covered under Year-end below.
Refunds. A refund reduces sales when it is issued, even if the sale was last month, and it shows up as a deduction inside a later payout. Publication 334 treats credits for returned merchandise and other allowances as deductions from gross sales. Record the refund in the period it is issued and leave the closed month alone. For an accrual-method business, tax timing can differ: a refund generally counts when paid, and credit toward future purchases when applied to a later sale (26 CFR 1.461-4(g)(3)). A business that has adopted the recurring item exception can count some refunds paid within 8½ months after year end, or by the return's filing date if earlier, in the earlier year. Show a preparer any refund that crosses year end; see recording refunds.
Sales tax. On your own store, the payout includes the tax collected; if a marketplace collects and remits the tax itself, it does not. Tax imposed on the buyer goes to a payable account, not to sales, as the table shows; tax imposed on you as the seller stays in gross receipts, with the tax due tracked separately. The entries are in recording sales tax collected and paid, and which states to collect in is in Shopify sales tax by state.
Year-end. A payout that spans December 31 holds sales from two years. Which year each sale's income belongs to depends on your accounting method and facts, so keep sales through December 31 on their own line and run the platform's sales report by sale date for the year. Orders paid before they ship, such as preorders, can fall under the advance payment rules, which let a business that qualifies elect to postpone part of that income a year; the election is made on the return, or by a method change (26 CFR 1.451-8(g)). Keep these orders on their own line too. For the methods, see cash or accrual for a small business. A payout that straddles year-end on a return not yet filed is worth showing to bookkeeping help.
How do your books tie to Form 1099-K under either method?
Form 1099-K reports the gross payments a processor settled to you in the calendar year, before fees and refunds, so it will not equal payouts or net sales under either method. The regulation treats a payment as settled when the processor submits the instruction to transfer the funds to you, and sets each transaction's dollar amount on its transaction date. A sale made on the last day of the year can therefore appear on the next year's form. The same regulation defines the gross amount without regard to adjustments for discounts, fees, refunds or other amounts. Its own example reports the full sale even though the processor paid out less after a fee. The form instructions add shipping to that list and give month-by-month amounts in boxes 5a through 5l. Publication 334 warns that the form may include items that are not receipts, such as sales tax.
| Your books | Form 1099-K |
|---|---|
| Sales plus shipping and sales tax collected, as the buyer was charged on the sale date, for orders paid through that processor | Box 1a for payments settled in the form's year, and boxes 5a through 5l by month |
| Refunds and fees, kept as separate lines | Not subtracted by the form |
| Backup withholding, kept as its own line | Box 4, federal income tax withheld |
| Orders paid by another gateway, by cash or on a marketplace | Not on this form; may be on another issuer's Form 1099-K or on none |
Card payments are reported with no minimum. The instructions apply a reporting threshold, a total above $20,000 and more than 200 transactions, only to third party network transactions (payment apps and marketplaces), not to card payments.
A processor can withhold federal tax (backup withholding) when a payee has not given a taxpayer ID in the manner required, and shows it in box 4 (instructions). It is tax already paid, not a fee: claim it as federal income tax withheld on the return for the year received. A partnership or S corporation cannot claim it itself; its partners or shareholders do (IRS Topic 307, Backup withholding).
Either method can support the comparison if gross sales, refunds, fees and tax stay on separate lines. Per-order entries make tracing easier; per-payout or per-day entries rely on the saved detail behind each one. Run the platform's sales report by sale date and its payout report, which shows the transfer dates, for the whole year and for each month. Keep both with the books and bridge the year-end sales that settled in the next year. For a 1099-K that still will not tie, see reconciling sales and payouts.
Can you switch methods mid-year without redoing the books?
Often, but not always. A change in the treatment of a material item, meaning an item that involves the proper time to include income or take a deduction, is a change in accounting method, and it generally needs IRS approval on Form 3115. Publication 334 also says that changing the method of accounting for inventory means filing Form 3115. Moving from per-order to per-payout entries, with sales still dated by sale date, changes the detail and not the timing. If you track stock by item, settle how cost of goods sold will be figured before you drop per-order entries.
If only the level of detail changes, to switch without redoing earlier months:
- Pick a cut-off on a month start, after the prior month is reconciled and ties to the platform report.
- Leave earlier entries as they are, once you have confirmed they do not double count.
- Turn off whichever source stops posting at the cut-off, so only one source records the new months.
- Check that the clearing account is zero at the cut-off, or equals the days not yet paid out. For the one payout that spans the cut-off, post the earlier days under the old method and the later days under the new one, using the platform's sales report by date.
- Note the date and the reason in the file, and keep the exports.
Redo earlier months only if they double count or do not tie to the platform reports. If the switch would also change the date income is counted (deposit date versus sale date), that may change which period the return picks it up in. Settle that with a CPA before year-end.
Example
These examples are illustrative; all amounts are in US dollars.
A store with 400 orders a month
A Shopify store posts one entry per payout. Over the payout period, sales are US$40,000, refunds US$300 and processor fees US$1,200, so the deposit is US$38,500 (40,000 − 300 − 1,200). The entry credits sales US$40,000, debits returns US$300 and fees US$1,200, and debits the clearing account US$38,500. The bank-feed deposit is matched to that clearing balance. Sales tax is left out to keep the numbers simple. Tax imposed on the buyer and collected in the payout would raise the deposit and be posted to a payable account, not to sales.
A boutique selling online and in store
A boutique tracks cost by item. Five units of a product that cost US$20 each sell for US$50 each. Posted per order, the sale shows US$250 of sales, US$100 of cost of goods sold, and stock down by five. A payout summary would show the US$250 with no item, so stock and cost would need a count or an item report.
A connector and a bank feed both post
A connector books US$12,000 of sales. With no fees or refunds, the deposit for those same sales is also US$12,000, and the bank feed books it as new income. Income shows US$24,000 until one side is removed.
Different for you?
- The connector and bank feed have counted sales twice for months: start with duplicate income in accounting software. If those months are closed, or a return already used the doubled income, what to correct and how to tie the totals back to the platform reports and Form 1099-K is worth taking to bookkeeping help.
- Order volume is too high to post by hand, or stock by item, several channels and sales tax in many states all sit in one set of books: the choice between per order and per payout affects inventory, sales tax and the return. Settle it with bookkeeping help, including how to repair past months and how the totals tie to Form 1099-K.
- Your Form 1099-K still does not tie after the comparison: see Shopify payouts and bank deposits and reconciling sales and payouts; numbers that will not reconcile are worth taking to bookkeeping help.
- You also sell on Amazon, take payments through Stripe, or run a shop or restaurant on a point-of-sale system: see Amazon settlement reports, Stripe payouts and recording daily POS sales.
- You are not sure which states to collect sales tax in: see Shopify sales tax by state.
- Your books are months behind and a return is due: see catching up on overdue books, then bookkeeping help.
- You want to know what a bookkeeper would handle and charge: see ecommerce bookkeeper cost and scope.
Figures on this page
| Figure | Value | Source |
|---|---|---|
| Small-business inventory gross-receipts test Average annual gross receipts for the three prior tax years under section 448(c); other conditions apply to the inventory-method exception. | $32,000,000 Tax year 2026 | IRS: Internal Revenue Bulletin 2025-45 Checked |
| Federal Form 1099-K marketplace payment threshold Marketplace or payment-app payments must exceed this amount and exceed 200 transactions before federal third-party network reporting is required; payment-card transactions have no such threshold. | $20,000 | IRS: Understanding your Form 1099-K Checked |
Primary sources
- IRS: Publication 583, Starting a Business and Keeping Records
- IRS: Recordkeeping for small business
- IRS: Use of electronic accounting software records, frequently asked questions
- IRS: Publication 334, Tax Guide for Small Business
- 26 CFR 1.6001-1, Records
- 26 CFR 1.6050W-1, Information reporting for payments made in settlement of payment card and third party network transactions
- 26 CFR 1.446-1, General rule for methods of accounting
- IRS: Instructions for Form 1099-K
- IRS: Topic no. 307, Backup withholding
- 26 CFR 1.461-4, General rules for taxable year of deduction (rebates and refunds)
- 26 CFR 1.461-5, Recurring item exception
- 26 CFR 1.451-8, Advance payments for goods, services, and other items
- Shopify Help Center: Getting paid with Shopify Payments (vendor documentation)
- Shopify Help Center: Finance summary report (vendor documentation)
About this guide
Published by Cloud Accounting under standing professional approval. This version has no separately recorded personal review. It explains general rules for the tax year shown. It is not advice for your situation.
Changes
- : First published.