Reconciling Sales, Payouts, and Form 1099-K

Why is my deposit smaller than my sales report?

A payment deposit is often a net settlement, while a sales report shows customer transactions before deductions. Fees, refunds, sales tax handled by a marketplace, reserves, and timing can all separate the two. For a Canadian business receiving US-dollar payouts, see US-dollar sales and marketplace payouts.

The IRS says Form 1099-K shows gross payment amounts before fees and refunds. It is another view of payment activity, not a bank-deposit total. First identify the report's date basis: an order date, payment date, settlement date, and bank posting date may differ. Compare the same transactions and dates before treating a difference as missing income.

Which records do I need to match each deposit?

Match each bank deposit to a settlement or payout ID, then match that settlement to transaction IDs in the sales records. The IRS requires books that show gross income and supporting documents for sales and deposits.

Keep the original exports and a short worksheet linking each payout ID to its transactions and bank entry. Publication 583 says supporting documents must substantiate book entries and recommends monthly bank reconciliation. A summary without transaction detail may hide a missing refund or a payout that crossed months.

How do I record a payout that nets sales, fees, and refunds?

Record each component in the account it belongs to, then use a payment clearing account to connect the sales records to the bank deposit. The clearing account represents money owed by the processor until it is paid out or otherwise resolved. This is a bookkeeping method for tracing transactions, not an IRS-prescribed journal entry; the IRS allows any recordkeeping system that clearly shows income and expenses.

If the processor charges a fee directly to the bank instead of withholding it from a payout, record that bank charge only once. If a chargeback is still disputed, identify the amount held and do not silently treat it as a completed refund. The IRS recordkeeping guidance calls for entries that can be traced to supporting documents.

Why is recording only the net deposit as sales not enough?

Net deposits conceal gross sales, fees, refunds, tax, and any backup withholding. They also make the books hard to compare with Form 1099-K, which the IRS instructions say is reported before adjustments for fees, refunds, discounts, and other amounts; box 4 shows federal backup withholding.

The same net deposit can result from very different transactions. A low deposit could reflect a refund, a fee, tax withheld by a marketplace, or an unpaid reserve. Those have different places in the books. Record the components from the settlement report, then reconcile the resulting bank amount. For where those book totals go on an income tax return, see Online seller income tax.

Why are sales counted twice when an invoice is paid and the deposit arrives?

Marking an invoice paid should settle that invoice; the later bank deposit should settle the processor clearing balance. If the invoice recorded a sale and receivable, the customer payment clears the receivable into processor clearing, then the deposit moves that balance to the bank. Fees, refunds, and reserves explain any amount still in clearing. Reclassify an imported deposit coded as another sale to a clearing transfer, keeping its bank match.

For cash-method tax books, an invoice need not be the point when income is recognized; actual or constructive receipt may occur at payment. The later bank transfer still is not another sale. Publication 538 explains cash and accrual timing.

Where does sales tax collected by a marketplace or by me go?

Track sales tax separately and distinguish tax imposed on the buyer from tax imposed on the seller. IRS Publication 334 says buyer-imposed tax you collect and remit is not income; record it as a liability until paid. If tax is imposed on you as the seller and charged to the buyer, include that amount in gross receipts and track the tax due separately. Tax a marketplace remits on its own responsibility should not become your unpaid tax liability. A federal IRS explanation says sales tax paid in a reportable card transaction can appear in Form 1099-K gross payments.

State duties differ. In Texas, a seller who accepts a marketplace provider's tax certification in good faith excludes those sales from its Texas sales-tax report, though a Texas seller may still need a permit and returns. The seller still owes a shortfall caused by incorrect or insufficient information it gave the provider; affiliated sellers and providers can owe a shortfall jointly. In California, a registered seller includes facilitated sales in total sales and claims an "other" deduction when the facilitator is responsible for the tax. Keep the marketplace's certification and tax report. See When you must collect sales tax for registration and Filing sales tax returns for return reporting.

Unpaid seller-collected tax can become a personal debt. Under Texas Tax Code §111.016, anyone who collects tax, including a sole proprietor, owes the amount collected; an officer, manager, director, employee, or partner who controls collection or payment and willfully fails to remit it can also be liable. The general assessment limit is 4 years after tax is due; the individual's period can be tolled until 1 year after the business liability becomes final or bankruptcy closes or is dismissed. Under California Revenue and Taxation Code §6829, a responsible officer, member, manager, partner, or other person in control can owe unpaid tax after a business ends if they willfully failed to pay tax that became due while responsible and the business collected or included tax reimbursement in its price. The notice deadline is the earlier of 3 years after CDTFA learns of closure or 8 years after closure; each clock starts at the end of the month after the relevant quarter.

How do I bridge sales and payouts to Form 1099-K?

Compare Form 1099-K with the issuer's gross reportable payments for the form's calendar year, not net deposits or every sales channel. For reporting, the payer makes a settlement payment when it submits the transfer instruction; the transaction date sets its dollar amount. Form 1099-K instructions define these rules. Bridge differences between the issuer's settlement year and the sales records, then apply the business's accounting method when reconciling to its return.

A missing form does not remove sales from the books or return. For third-party network payments, federal reporting generally requires both payments above $20,000 and more than 200 transactions; payment-card transactions have no such threshold.

Start with the issuer's transaction-level gross payments and transfer dates. Then explain differences from your sales report: sales tax included in customer payments, refunds and discounts, cash or other non-card sales, payments belonging to another entity, and transactions outside that issuer or period. Explain the separate bridge from gross payments to settlements and from settlements to bank deposits, including any backup withholding in box 4. Do not post the form itself as sales: the transactions should already appear in the books. The IRS says the form and records help determine the correct income.

What if Form 1099-K is duplicated or has the wrong payee or amount?

Check the issuer, payee name and tax ID, box 1a, and transaction detail before changing the books; two forms may cover different payments. If a form does not belong to the business or truly duplicates another, ask the issuer for a corrected Form 1099-K showing zero. For a wrong payee ID or gross amount, ask for a corrected form with the right information. Keep the original and corrected forms and correspondence. The IRS gives these steps and says it cannot correct a form issued by a payer.

If the business changed entity or tax ID during the year, divide transactions by the entity that earned them and update the payer's records. If the form names an owner but the income belongs on a partnership or corporate return, ask the issuer to correct it. Do not make a false sale or expense merely to force a match. If correction has not arrived by filing time, give the return preparer the transaction bridge and correspondence; the IRS says not to wait indefinitely for a corrected form. For return treatment, see Online seller income tax.

How do reserves, chargebacks, and year-end payouts change the match?

Track held reserves and unsettled disputes separately from fees and completed refunds. An unpaid reserve is still an amount to reconcile with the processor; a chargeback may become a refund, fee, or recoverable dispute depending on what happened. Keep the processor's status and later release or resolution report.

At year-end, compare the transaction date, the date funds became available, the settlement date, and the bank posting date. Under the cash method, Publication 538 includes amounts actually or constructively received, including income received by your authorized agent; substantial restrictions can prevent constructive receipt. Under accrual accounting, income is generally reported when earned, regardless of when the bank receives a payout. A reserve's contractual restrictions and whether the processor is your agent can change the cash-method answer; a bank deposit in the next year alone does not decide it. Carry the unresolved clearing balance into the next period and check it against later payouts.

What should I check before filing, and when should a bookkeeper take over?

Before filing, every material difference should have a source document and a clear account treatment. Publication 583 says the bank, books, and supporting records should reconcile; its electronic-record guidance also calls for records traceable to source documents.

1. Reconcile each settlement to its transaction IDs and bank deposit, including fees, refunds, tax, reserves, and chargebacks.
2. Reconcile the bank monthly and explain deposits still in transit or clearing balances still held.
3. Reconcile each Form 1099-K to the issuer's gross transaction report; document duplicates, wrong payees, and timing differences.
4. Check that invoice payments and imported deposits did not create duplicate sales.
5. Give the return preparer the exports, settlement reports, sales-tax reports, bank statements, Forms 1099-K, and a list of unresolved items.

If payouts span many periods, a clearing balance has no supporting transactions, or prior returns used net deposits as sales, a bookkeeper can rebuild the bridge before the tax return is prepared. For books that are months or years behind, see Catching up on overdue books.

Example

Illustrative US-dollar amounts, with no inventory cost, marketplace-collected tax, or backup withholding. Assume the tax is imposed on the buyer and the seller must collect and remit it. A processor handles $1,000 of sales plus $80 of that tax. It later issues a $100 sales refund plus $8 of tax, deducts a $30 fee, and holds a $50 reserve. The bank receives $892.

The books show $1,000 of gross sales and a separate $100 return, leaving $900 of net sales. They also show $72 of sales-tax payable, a $30 fee expense, $892 in the bank, and a $50 processor receivable; the reserve is not an expense. If the invoice system already recorded the sale, payment and payout clear balances rather than create another sale.

If this payment is reportable and the issuer submits its transfer instruction in the form's calendar year, it contributes $1,080 to Form 1099-K box 1a: $1,000 sale plus $80 tax. The later $108 refund does not reduce that gross payment. Subtract that refund, the $30 fee, and the $50 reserve to reach the $892 bank deposit. Check the issuer's transaction detail before using this bridge for an actual form. IRS instructions define the gross amount, and IRS guidance says it can include sales tax.

Different for you?

• You need to place sales, fees, or inventory costs on a business return: see Online seller income tax.
• You need to file and reconcile state sales-tax returns: see Filing sales tax returns.
• You may need a sales-tax permit or to collect tax on direct sales: see When you must collect sales tax.
• You should have collected or remitted sales tax but did not: see Catching up on uncollected sales tax.
• Several months or years of books are missing: see Catching up on overdue books.
• Your business keeps books in Canadian dollars: see US-dollar sales and marketplace payouts.
• Reserves, disputed payments, or prior-year errors remain unexplained: bring the transaction exports, settlement reports, tax reports, Forms 1099-K, and bank statements to bookkeeping.