Reconcile 1099-K With Bank Deposits: Step by Step

TL;DR A Form 1099-K reports gross payment amounts processed for you, before fees, refunds and chargebacks, while your bank statements show the net amounts actually deposited. They will almost never match directly. To reconcile, convert your bank statements to a spreadsheet, total the deposits from each payment processor by month, then add back fees, refunds and chargebacks, and adjust for payouts that crossed month or year boundaries. Compare the result with the monthly amounts on the 1099-K. Keep the workbook as support for your tax preparer. This is general information, not tax advice.

Disclaimer: This article explains a general record-keeping method. It isn't tax advice. Reporting rules and thresholds for Form 1099-K have changed in recent years and may change again. Check current IRS guidance and talk to a qualified tax professional about your situation.

If you sell through a payment processor, an online marketplace or a payment app, you may receive a Form 1099-K at the start of the year. Many people open it, compare the total with what hit their bank account, and find that the form shows a noticeably larger number. That's normal, and it's not a reason to panic, but it is a reason to understand and document the difference.

This guide explains why the numbers differ and walks through a reconciliation in Excel using your bank statements and the processor's reports.

What a 1099-K reports

Form 1099-K is issued by payment settlement entities: card processors and third-party settlement organizations, which include many payment platforms and marketplaces. It reports the gross amount of reportable payment transactions processed for you during the calendar year.

Key features:

• Gross, not net. The total is before processing fees, refunds, chargebacks, shipping costs or other deductions.
• Calendar year. It covers transactions in the year, based on the processor's records.
• Monthly breakdown. The form includes boxes for each month's gross amount, which is extremely useful for reconciling.
• One form per processor. If you use several, you may receive several forms.

The form doesn't tell you what's taxable. It reports what was processed. Your taxable income is worked out from your actual sales, expenses and other factors, which is why your records matter.

Why deposits don't match

Here are the usual reasons the 1099-K total is higher than the deposits you see on your statements.

Processing fees. The processor keeps its fee and deposits the rest. If you sold 1,000.00 and paid 30.00 in fees, the 1099-K includes 1,000.00 and your bank shows 970.00.

Refunds. If a customer was refunded, the original sale may still be in the gross total while the refund reduced your payout.

Chargebacks and disputes. Similar to refunds: the original sale counts in gross, the reversal reduces what you received.

Sales tax and shipping. If you collected these as part of a payment, they may be included in gross amounts even though they're not your income in the usual sense. How they're treated depends on your situation.

Timing. A sale on 30 December might be paid out in early January. It's in this year's 1099-K but next year's bank deposit. The reverse happens at the start of the year.

Balances held on the platform. If you left money in the platform account, spent it from there or moved it to a different account, it won't appear as a deposit in the bank you're looking at.

Payouts to multiple accounts. Some people change their payout account during the year, or split payouts.

Non-sales payments. Depending on the platform and how payments were marked, personal transfers, reimbursements or shared expenses sometimes end up in reportable totals. These need to be identified and documented.

Every one of these is a legitimate, explainable difference. The reconciliation is about quantifying them.

What you need

1. The 1099-K forms from each processor.
2. The processor's own reports. Most processors provide downloadable summaries or transaction reports showing gross sales, fees, refunds and payouts. These are the most direct link between the form and your bank.
3. Bank statements for every account that received payouts, for the full year plus a month or two either side to catch timing differences.
4. A spreadsheet.

If your bank statements are PDFs, convert them first. SheetStatement extracts each transaction with its date, description and amount, checks each statement balances, and exports Excel or CSV. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover a full year of statements.

Step 1: Isolate the processor deposits

Combine all bank statements into one table. Then identify the deposits that came from each processor. Payout descriptions usually include the processor's name and often the word "payout" or "transfer".

Add a Source column:

=IFS(ISNUMBER(SEARCH("PROCESSOR A", C2)), "Processor A",
     ISNUMBER(SEARCH("PROCESSOR B", C2)), "Processor B",
     TRUE, "")

Replace the search terms with the text that appears in your statements. Filter for each source and scan the descriptions to make sure nothing is misclassified.

Add a Month column with =TEXT(A2, "yyyy-mm").

Step 2: Total deposits by month

For each processor, build a month grid:

=SUMIFS(Tx[Amount], Tx[Source], "Processor A", Tx[Month], A2)

This is the net cash you received.

Step 3: Bring in the processor's figures

From the processor's monthly reports, record for each month:

• Gross sales (should match the 1099-K monthly box, or be close).
• Fees.
• Refunds.
• Chargebacks or disputes.
• Payouts (the total the processor says it sent to your bank).
• Any other adjustments.

Put these alongside your bank totals:

Step 4: Build the reconciliation

Work from gross down to what landed in the bank:

Gross per 1099-K
− Fees
− Refunds
− Chargebacks
± Other adjustments
= Net activity for the month
± Change in balance held on the platform
= Payouts for the month
± Payouts in transit at month start/end
= Bank deposits

In Excel, a Difference column at the end:

=ROUND(BankDeposits - (Gross - Fees - Refunds - Chargebacks + Adjustments - BalanceChange + TimingAdjustment), 2)

Each month should come to zero or a small, explained amount.

The two-step check

It's often clearer to split the reconciliation into two parts:

1. Gross to payouts, using the processor's own report. This tells you whether the 1099-K gross is consistent with the processor's records.
2. Payouts to bank deposits, using your bank statements. This tells you whether every payout actually arrived.

If step 1 balances and step 2 doesn't, the problem is between the processor and your bank: a payout to a different account, a payout in transit, or a misclassified deposit. If step 1 doesn't balance, look at the processor's report or ask the processor.

Step 5: Handle timing at year boundaries

Payouts typically take a few days. Sales in the last days of December are often deposited in January. Sales in the last days of the previous December may have been deposited in this January.

To handle this:

1. Include January of the following year in your bank data.
2. Identify payouts in early January that relate to December sales, using the processor's payout report.
3. Treat them as December payouts in your reconciliation, with a note.
4. Do the reverse for early-January deposits that relate to the previous December.

A short Timing table documents it:

Step 6: Identify non-sales payments

If any of the 1099-K amount is from payments that weren't sales, such as a friend repaying you for a shared expense or money moved between your own accounts through a platform, list them separately with evidence: the date, the amount, who it was from and what it was for. Your tax preparer will advise how to handle them. This is the area where documentation matters most.

Step 7: Summarize the year

Build a one-page summary for your preparer:

Plus the monthly reconciliation, the timing table, the list of non-sales payments, and the bank statements and processor reports as backup.

A worked example

A small online shop uses one card processor and receives a 1099-K showing a gross total much higher than its deposits.

1. Bank data. Fourteen months of statements (December through the following January) are converted and combined. Every statement balances.
2. Deposits. Processor payouts are tagged by a search on the description and totaled by month.
3. Processor report. Monthly gross, fees, refunds and payouts are downloaded.
4. Step 1 check. For every month, gross minus fees and refunds equals the processor's payouts. The 1099-K monthly boxes match the processor's gross.
5. Step 2 check. Eleven months tie exactly. In two months, payouts and deposits differ by the same amount in opposite directions: a payout sent on the last day of one month arrived on the first day of the next. In December, a payout is in transit at year-end and arrives in January.
6. Summary. The total difference between the 1099-K and deposits is fully explained by fees, refunds and timing.

The shop's preparer gets a clear, documented bridge between the form and the books instead of an unexplained gap.

Marketplaces, payment apps and card processors

The reconciliation method is the same for every kind of payment platform, but the details you'll need to account for differ.

Card processors that you use directly, for example on your own website or a card reader in a shop, usually deposit sales minus fees on a regular schedule. Their reports typically show gross sales, fees, refunds, disputes and payouts clearly, which makes step 1 straightforward.

Online marketplaces often deduct more than processing fees: selling fees, listing fees, shipping labels bought through the platform, advertising, and sometimes sales tax collected on your behalf. All of these sit between the gross amount and your payout. Download the marketplace's monthly statements or transaction reports and give each kind of deduction its own column.

Payment apps can mix business and personal activity in one account. If you use the same app for customer payments and for splitting dinner with friends, expect to spend most of your time identifying which payments are which. Going forward, a separate business profile or account where the app offers one makes this much easier.

Whatever the platform, the principle doesn't change: every difference between gross and deposits should fall into a named column with a source document behind it.

When payouts go to more than one account

Payouts sometimes land in different places during the year. You might have changed banks, added a business account part-way through, or had the platform pay some funds to a debit card. In that case:

1. List every payout destination from the processor's payout report or settings history.
2. Convert statements for each destination account for the relevant months.
3. Tag deposits by source in every account and total them together by month.

If the processor's payout report shows a payout you can't find in any bank statement, check whether it went to an account you've forgotten, was returned, or is still pending. A payout that can't be traced is the one thing your reconciliation can't explain, so it's worth chasing.

Common mistakes

Comparing the 1099-K to bank deposits only. Without the processor's reports, you can't separate fees and refunds from missing payouts. Use both.

Using transaction downloads instead of statements. Downloads can miss older months or include pending items. Statements give you complete, balanced months.

Double counting transfers. If you moved money from the platform to savings and then to checking, count the deposit once, at the first bank account it reached.

Ignoring refunds issued from the bank. If you refunded a customer directly from your bank account rather than through the platform, the platform's gross won't show the reduction. List these refunds separately.

Leaving it until tax season. Reports may be harder to download months later. Monthly reconciliation avoids that.

Tips that save time

• Reconcile monthly, not annually. A month is easy to check; a year of unreconciled payouts is not. Our month-end close checklist includes this step.
• Record sales gross in your books. If you book the processor's payouts as income, your books will show net figures and won't match the 1099-K. Recording gross sales with fees as an expense keeps them aligned. Our guide to reconciling Stripe payouts shows the pattern.
• Keep personal and business payments separate. Using a separate account or profile for business makes the whole exercise far simpler.
• Save the processor reports every month. Platforms don't always keep reports available forever.

See also our checklist on bank statements for tax preparation for the rest of the documents preparers commonly ask for.

Build the reconciliation

Upload your bank statements to SheetStatement, confirm each balances, and download Excel or CSV to start the reconciliation. The free plan covers 3 pages a month.

FAQ

Why is my 1099-K higher than my bank deposits?

Because the form reports gross payments before fees, refunds, chargebacks and other deductions, and because of timing differences around year-end. Your bank shows net payouts.

Do I report the 1099-K amount as income?

That's a tax question for your preparer. The 1099-K is a starting point; your actual income depends on your sales, refunds, expenses and other factors. Keep a reconciliation that explains the difference.

What if I received a 1099-K for personal payments?

Document each payment: who it was from, what it was for and why it isn't income. Ask a tax professional how to handle it in your return.

How do I find which deposits came from the processor?

Search the bank statement descriptions for the processor's name or payout wording, tag them with a Source column, and total by month.

What if a month doesn't reconcile?

Split it into gross-to-payouts (using the processor's report) and payouts-to-deposits (using bank statements). The step that doesn't balance tells you where to look.

Do I need statements from the following January?

Yes, usually. Payouts for late-December sales often arrive in January, so you need that month to complete the reconciliation.

Can I do this if I use several processors?

Yes. Tag deposits by processor and reconcile each against its own 1099-K and reports separately.

What if the 1099-K monthly amounts don't match the processor's reports?

Check that you're looking at the same account and the same basis, gross rather than net. If they still don't match, contact the processor; the form is based on its records, and only it can explain or correct them.

Is this tax advice?

No. It's general information about record keeping. Rules and thresholds for Form 1099-K have changed; check current IRS guidance and consult a tax professional.