Reconciling a 1099 total against the deposits in your account

The form in front of you reports 92,400.00. You add up every deposit from that payer across twelve months of bank statements and get 87,833.50. The gap is 4,566.50, and the payer's support queue is not going to explain it to you this week.

The difference is usually not an error. When the payer is a platform that settles by transfer and deducts its charge before remitting, several mechanical differences apply at once, and each one moves money between the form and your account by an amount you can pin down. The work in front of you is to build a schedule that names each of them and closes, rather than to hunt for a mistake that is probably not there.

Make the difference exact before anything else

Round numbers are useless here. Convert every statement for the year, verify each one, filter the credit rows to that payer and total them to the cent. In the example above the deposit total is 87,833.50 against a reported 92,400.00, so the difference to explain is exactly 4,566.50.

Two things about the filtering step deserve attention, because both silently understate the deposit total. Payers change their transfer descriptor when they switch processor, so the second half of the year can arrive under a different string. And a payer that batches several invoices into one settlement gives you fewer deposits than invoices, which makes a count-based sanity check confusing until you know that is happening. Widen the filter to the amount range and the settlement day of the week before you accept a total.

Where the gap comes from

Timing across the year boundary

Your account records a payment on the day it clears. The payer records it on whatever date its own process fixes, and that date is not the same across forms or across payers. Some report on the date a payment was issued or approved; payment-card and third-party network reporting works from the date a transaction settled through the network, which is a different event again. Find out which basis your payer used before you assume an item is timing, because that answer decides which side of the boundary it falls on. The example here uses a payer that reports on the date it issued the transfer.

On that basis, a gross 7,150.00 was issued on 29 December and reached the account on 3 January. It counts toward the reported figure for the year just closed and toward next year's deposits. Running the other way, a gross 5,900.00 was issued on 28 December of the prior year and landed on 4 January of this one, so it sits inside this year's deposits and was reported on the prior year's form. Both figures are stated gross, the way the payer reported them. What actually arrived in the account was smaller, for the reason in the next section.

Fees netted at source

A platform that takes its charge before remitting sends you the net, and nothing in your bank statement records the deduction. The money never travelled, so the account only ever sees the smaller figure that arrived. The charge lives in the platform's settlement report, and that report is the only place you can source it from.

The rate is the easy part. The basis is where a bridging schedule usually goes wrong. A percentage charge is taken out of each settlement as it leaves, so it applies to the gross amounts that actually settled into the account during the year, not to the total printed on the form. Those two populations differ by exactly the timing and holdback items. Take the percentage of the reported figure and you have quietly mixed a net adjustment into a schedule of gross ones, and the residue that leaves is the kind of small difference people round away rather than explain.

So the fee comes last. Move the reported figure onto the settlements the platform actually charged, then take the percentage of that. Here the gross settled during the year is 90,550.00, and three percent of it is 2,716.50.

Holdbacks and reserves

A platform holding a rolling reserve counts the amount when you earned it and releases the cash later. Here, a gross 1,500.00 was still held at 31 December, and a gross 900.00 of the prior year's reserve was released and settled in February. Both behave like the timing items: earned in one period, settled in another, and both stated gross, on the same basis as the reported figure they adjust.

Write it as one bridging schedule

Every explanation above becomes a line. Keep the gross adjustments together, subtotal them, and only then take the fee off, so that no line in the schedule is measured on a different basis from the one above it.

In prose: 92,400.00 less 7,150.00 gives 85,250.00; plus 5,900.00 gives 91,150.00; less 1,500.00 gives 89,650.00; plus 900.00 gives 90,550.00, which is the gross that settled during the year. Three percent of 90,550.00 is 2,716.50, and 90,550.00 less 2,716.50 is 87,833.50, the deposit total. The same items rebuild the gap directly: 7,150.00 less 5,900.00 plus 1,500.00 less 900.00 plus 2,716.50 is 4,566.50.

Test it at the level of the individual deposit as well, because a schedule can balance without being coherent. The 5,900.00 issued in the prior December arrived on 4 January as 5,723.00 once the three percent came off. The released reserve arrived in February as 873.00. The 7,150.00 issued on 29 December will appear in next year's statements as 6,935.50. Every settlement is charged once, at the same rate, and the fee line in the schedule is the sum of those charges rather than a percentage of a number the platform never touched.

A note saying the difference is timing leaves whoever reads it next to redo the whole exercise. A schedule gives every item an amount and a source document, so the figure can be checked without reopening twelve statements.

Getting a deposit total you can defend

1. 1

   Convert every statement for the year

   Convert all twelve statement documents for the account the payer settles into, including any month you think is uneventful.
2. 2

   Verify each statement row by row

   Opening balance plus credits less debits must equal the printed closing balance on every file, and each row's recalculated balance must equal the balance printed beside it. The second test is the one that finds a misread deposit; the first can close over a pair of errors that cancel.
3. 3

   Check the months join, then check the calendar

   The closing balance of each month must equal the opening balance of the next, and a break means something between them is unaccounted for. A clean join is strong evidence the statements you hold run into each other rather than proof the set is complete, so read the period dates as well and confirm they run end to end with no gap.
4. 4

   Isolate the payer's credits

   Filter the credit rows by descriptor, then widen by amount range and settlement day to catch deposits the descriptor missed.
5. 5

   Bridge to the reported figure

   List the gross timing and holdback items with their amounts and sources, subtotal to the gross that settled, then apply the fee to that subtotal and confirm the schedule closes on the deposit total exactly.

Steps two and three are the ones people skip, and they are the ones that decide whether the total means anything. The continuity and calendar checks across month boundaries are set out in more detail in converting a full year of bank statements at once, and the per-statement checks in how to verify a converted bank statement.

Convert·Into rebuilds each statement's running balance from its printed opening figure and flags the rows where the recalculated figure and the printed one part company. A bridging exercise leans on that harder than most statement work does. The total you are bridging to is a sum of individual credit rows, so a single misread amount shifts it without disturbing anything else you would think to check, and the difference then refuses to explain itself no matter how carefully you work the settlement report.

What the balance check settles, and what it leaves open

Two different checks get called the balance check, and a bridging exercise depends on which one you actually ran. Confirming that a statement's opening figure plus its credits less its debits equals its printed closing figure tests one number. That number can be right while the rows underneath it are not: a credit read 500.00 high against a debit read 500.00 high on the same statement leaves the closing balance exactly where it belongs, and so does a deposit dropped in April alongside a deposit of the same value duplicated in September. Both cases move the figure you are bridging to and leave the closing balance sitting exactly where the bank printed it.

Recalculating every row's balance from the opening figure and comparing it against the balance printed beside it is the version that survives contact with a reconciliation. It puts a misread amount on a named row, and neither cancelling pair gets past it: the 500.00 credit breaks the recalculated chain at its own row, and the dropped deposit throws every row between April and the duplicate off by the same amount.

What it leaves open is the part a bridging schedule leans on hardest. The arithmetic never reads a date or a description, so a deposit dated 3 January instead of 31 December, or one whose descriptor was garbled badly enough that your payer filter skipped it, sits inside a chain that closes perfectly. It cannot tell you which payer a credit came from or which period it belongs to. A row for 0.00 satisfies it either way. And where a statement prints no running balance column, there is no chain to recalculate at all, which is worth knowing before you promise anyone a verified total. Read the date and description columns yourself on the rows that carry your bridging items.

When the bridge still will not close

If the schedule leaves a residue after the three usual items, work through the settlement report rather than the statements. Chargebacks and refunds netted against a later payout, a payment routed to an account you did not include, and a second entity of yours being paid under the same tax identifier all produce differences that no amount of statement work will surface, because the evidence is on the payer's side.

Whatever you end up with, the reported figure, the explained items and the deposit total are inputs to a filing decision, not the decision itself. Hand the schedule and the verified statements to your own tax preparer and let them determine what gets reported. If the year also has to be rebuilt from scratch because no books were kept, filing from bank statements alone covers the sequence, and mixed personal and business use is dealt with in separating business from personal transactions.