Why the form and your bank never agree
The single most common tax-season surprise for anyone paid through platforms or processors is a 1099 showing an amount considerably larger than what reached the bank. It is usually not an error, and understanding why is most of the work.
Information returns generally report gross activity. What lands in your account is net: after the platform's commission, after processing fees, after refunds and chargebacks, after any holdback or reserve. The gap between the two can be substantial, and in some businesses it is enormous.
Reconciliation is the exercise of explaining that gap deliberately, line by line, so you can either agree with the form or say precisely why it is wrong. It needs one thing you may not have yet: a complete, sortable record of what you actually received.
What happens if you skip it
Two failure modes, both expensive. If you report only what you banked while the form reports gross, the numbers disagree with what the authority already holds, and correspondence follows. If you report the gross figure without capturing the fees and refunds that explain it, you pay tax on income you never received.
There is a third, quieter case: the same income reported twice. It happens more often than people expect — a marketplace and a payment processor both reporting the same transactions, or a payer issuing a form for payments a platform also reported.
All three are found by the same exercise, and none are found by looking at the form alone.
Step 1 — Build your own number first
Do not start from the form. Start from your records, so the comparison is genuinely independent.
Extract every account that received money in the year — business checking, any personal account used, and each payment processor. Convert the statements into one table with date, description, signed amount and balance, and check each one against its own closing balance so you know the record is complete before you compare anything against it.
Then filter to deposits from the payer in question. That total is your number: what that payer's money actually delivered to your accounts during the year.
Step 2 — Get the gross side from the processor
Your bank shows net payouts, so the fee and refund detail has to come from the platform or processor's own report. Every serious platform provides one — a settlement or payout report listing gross sales, commission, processing fees, refunds, chargebacks and adjustments per payout.
That report is the bridge between the two numbers. Without it you can see that a gap exists but not what it consists of, and "there is a gap" is not an answer anybody accepts.
If the report only exists as a PDF, convert it the same way as a statement so it can be totalled and matched rather than read.
Step 3 — Build the bridge, line by line
The reconciliation itself is a short table that starts at the form's figure and ends at your banked total, with each difference named. If every line is explained, the form is consistent with your records even though the numbers differ.
Work in that direction — from the form down to the bank — because it forces you to account for every reduction rather than reverse-engineering a number that happens to work.
| Line | Why it differs | Where the figure comes from |
|---|---|---|
| Amount on the form | Gross activity reported | The 1099 itself |
| Less platform commission | Deducted before payout | Platform settlement report |
| Less processing fees | Per-transaction charges | Processor report |
| Less refunds and chargebacks | Returned to customers | Processor report |
| Less holdbacks or reserves | Withheld, released later | Processor report |
| Timing differences | Late-December activity paid in January | Compare period boundaries |
| Equals net payouts | What the bank should show | Your extracted statements |
The timing difference nobody expects
A payout initiated in late December frequently lands in January. Whether it belongs to the old year or the new depends on the reporting basis, and a mismatch here can look like a large discrepancy while being entirely mechanical.
Check both ends of the year deliberately: the last payouts of December and the first of January, on both the form's side and yours. In most disputed reconciliations that turn out to be nothing, this is the explanation.
The same applies to a platform that reports on transaction date while your bank necessarily shows settlement date. The difference is real and it is not an error on either side.
Finding income reported twice
This is the case worth actively hunting, because it costs you money rather than merely time. If a marketplace processes payments and a processor settles them, both may issue a form covering the same underlying sales.
The test is straightforward once your data is in one place: total the forms you received, compare against your independently-built income figure, and look at whether any deposits could be attributed to two payers.
If you find genuine double reporting, that is a conversation with the payer — and having a complete, reconciled record of what you actually received is the entire basis of it.
Contractor payments: a different shape of check
A 1099-NEC from a single client is usually simpler: no fee stack, no refunds, so the form and your deposits should be close. The differences that do appear are typically timing — a December invoice paid in January — or a payment made net of an expense reimbursement.
The check is quick with extracted data: filter deposits by that client for the year and compare. When it disagrees, it is usually possible to point at the specific invoice that crossed the year boundary.
If you are on the other side and paying contractors, the same dataset shows what you paid each of them — see the payer view below.
The payer's side of the same exercise
If you pay subcontractors, someone has to determine what you paid each of them during the year. A categorised year of bank data answers that directly: filter by payee, total by year, and you have the figure whoever prepares your forms needs.
Watch for payments made through multiple routes — some by transfer, some by card, some through a processor. A contractor paid three ways is the one most likely to be under- or over-stated.
To be explicit: FlowParse does not issue, e-file or transmit any information return. It produces the payment record; issuing the forms is your accountant's job or your filing provider's.
Getting the numbers off the form
If you have a stack of 1099s, the data on them can be extracted too rather than retyped — payer, TIN, box amounts, year — into a schedule you can total and compare. That is a different job from this page: see 1099 to Excel.
The distinction is worth keeping straight. 1099 to Excel reads the form. This page checks the form against reality. Most people doing serious reconciliation end up wanting both.
What to do when the form is genuinely incorrect
Sometimes the form really is wrong: a payment attributed to you that was not yours, an amount including transactions that were reversed, a duplicate issued after a correction.
The process is the same everywhere: contact the payer with a specific, evidenced discrepancy and request a corrected form. "This looks too high" gets nowhere; "your figure includes these four refunded transactions totalling this amount, here are the dates" gets a correction.
Which is the whole argument for doing the reconciliation properly: the output is not just a number, it is the evidence for a conversation.
What to keep afterwards
Keep the reconciliation itself, not just the conclusion. A one-page bridge from the form to your banked total, with the supporting extracts attached, answers in seconds a question that would otherwise take a day to reconstruct.
Keep it with the source documents: the form, the processor reports, and the statements. Retention rules apply to those originals rather than to your spreadsheet, and an extraction tool is not an archive — FlowParse deletes the original file immediately after processing.
If you consolidated several accounts, keep the source-file reference on every row so any figure in the reconciliation can be traced back to the document that produced it.
Why January is the wrong time to start
Reconciling in tax season means doing twelve months of investigation in the week you have least capacity, on transactions nobody remembers.
Quarterly is dramatically easier: three months of payouts against three months of processor reports, while the detail is still fresh and while any error in a form-relevant total can still be raised with the payer before the form is issued.
It is the same data either way. The only difference is whether you look at it four times calmly or once under pressure.
Who needs this most
Marketplace and platform sellers
Where reported gross and banked net differ by the whole fee stack.
Anyone paid by several processors
The group most exposed to the same income being reported twice.
Freelancers with many clients
Multiple 1099-NECs to check against deposits, with year-boundary timing.
Bookkeepers and preparers
Doing this for a dozen clients in the same few weeks.
Why completeness decides this exercise
A reconciliation built on an incomplete deposit list produces a difference that cannot be explained, and hours are then spent hunting for a cause that does not exist.
That is why every statement is checked against its own opening and closing balance before anything is compared, and why the sequence check across months matters as much: a missing statement period is indistinguishable from missing income until you look for it.
See extraction accuracy for what that proves — and what it does not: it proves the extraction faithfully contains what the statement said, not that the statement or the form is right.
Sensitive documents, handled carefully
Tax forms and statements carry identifiers you do not want loose. Uploads run over TLS, processing is in EU data centres, the original file is deleted immediately after extraction, extracted data is stored encrypted and nothing is used to train models — details on the security page.
Three shapes of payer, three shapes of gap
Not every mismatch has the same cause, and knowing which kind of payer you are dealing with tells you where to look before you start.
A marketplace that collects from the customer and pays you a residue reports the largest gross figure and produces the widest gap, because commission, promoted-listing fees, shipping labels and refunds all sit between the sale and your payout. A pure payment processor sits closer: the gap is mostly the per-transaction fee and refunds. A single business client paying invoices has almost no gap at all, and any difference is usually timing.
The practical use of this is triage. If a marketplace form is 30% above your deposits, that is normal and needs a fee breakdown. If a client's 1099-NEC is 30% above what they paid you, something is actually wrong and needs a conversation.
| Payer type | Typical gap | Where the explanation lives |
|---|---|---|
| Marketplace | Large — full fee stack | Settlement report per payout |
| Payment processor | Moderate — fees and refunds | Processor fee report |
| Business client | Small — timing only | Your invoices and their payment dates |
| Multiple routes | Unpredictable | All of the above, matched by deposit |
Holdbacks, reserves and money you have not received yet
Some processors hold a percentage of takings as a rolling reserve, releasing it weeks later. Marketplaces do the same around refund-heavy periods, and new accounts are often held longer.
That money is typically inside the reported gross figure and is not yet in your bank, which produces a gap that is neither a fee nor an error — it is simply timing on a longer clock. It also unwinds later, so a reserve released in January belongs to activity from the previous year.
Track it explicitly rather than letting it blur into the fee line. A reserve you cannot see is the difference that makes an otherwise clean reconciliation refuse to close, and it is the one people spend the longest hunting.
A worked example: one seller, two forms
A seller trades on a marketplace and also takes direct payments through a processor. Two forms arrive. The marketplace figure is far above what was banked; the processor figure is modestly above.
Extracting the year gives the banked total per payer in minutes. The marketplace settlement report then explains its gap almost entirely: commission, promoted listings, shipping labels, refunds and a small rolling reserve. Every line has a number, and the bridge closes to within a rounding difference.
The processor is stranger. Its form is higher than the payouts by more than its fees, and the extra turns out to be a handful of transactions that were refunded in the new year — reported as gross activity in the old one. Not an error, but worth writing down, because the same amount reappears as a negative in the following year.
The output is two one-page bridges and a note. Total time: under two hours, most of it looking things up rather than adding things up — and the seller now knows their real net income for both channels.
What to hand your accountant
Three things: every form you received, the reconciliation bridge for each, and the extracted deposit data behind it. That is enough for them to report correctly and to advise on any figure that is genuinely disputed.
What is not useful is the forms alone. An accountant who receives only the paperwork has to either take the numbers at face value or ask you to do exactly this exercise, later, under more time pressure.
If they prepare the return from your books, make sure the fee and refund lines exist in those books as costs. Reporting gross income without the offsetting costs is the expensive version of getting this right.
The boundary, stated plainly
FlowParse turns documents into data. It does not compute your tax, decide what is deductible, apply a rate, issue a form or file anything with any tax authority. Those are decisions about your circumstances and the law where you live, and they belong to you and your accountant.
It is also worth being precise about what a bank statement proves. It proves a payment happened: this amount left this account on this date, to this counterparty. It does not prove what was bought, whether the cost was for the business, or how much tax was inside it. For anything where the tax authority wants to see the nature of the expense — a VAT or sales-tax claim above all — the invoice or receipt is the evidence and the statement is the corroboration.
What that leaves is still the slowest part of the job: getting a year of transactions out of PDFs, complete, correctly signed, in one sortable place. That is what this page is about.
The fastest way to start
Convert one quarter of the account that receives payouts, and total the deposits from the payer in question. Compare that against a quarter of the processor's report. If those two agree once the fees and refunds are named, the annual version is the same exercise with more rows.
Then decide the cadence. Doing this quarterly is the difference between a reconciliation and an investigation.
Build your own number before you accept the form
Convert the accounts that received payouts, prove the record is complete, and reconcile the 1099 line by line — with evidence you can send to the payer.
