To track 1099 income from bank deposits, list every deposit from a client or platform in one sheet, grouped by payer. When the 1099 forms arrive early in the year, compare each payer's total with the form. Explain any difference, and report the deposits from payers who never sent a form.
Which bank deposits belong on a 1099 income sheet?
A 1099 income sheet holds the deposits that are payment for your work or sales: client transfers, checks from customers and payouts from platforms. It leaves out money that is not income, such as transfers between your own accounts, loan proceeds, refunds of purchases and gifts from family.
Sorting a year of deposits takes one pass with four labels. Every credit on the statement gets exactly one:
- Income. A client paid you, a platform paid out your earnings, or a customer paid by check.
- Transfer. Money moved from your savings, another checking account or a card overpayment. It was already yours.
- Refund. A store or service returned money you spent. It reduces an expense; it is not income.
- Other. A loan, a gift, an insurance payout or anything you need to ask about.
Only the first label goes into the totals. The other three stay in the sheet, labeled, so you can show later why a credit was left out. That matters if anyone ever compares your total deposits with your reported income. Unexplained deposits look like unreported income until you show otherwise.
The IRS is direct about the scope. Its page on managing taxes for gig work says you must report all income, even if you do not receive a Form 1099 from the business that paid you. So the sheet tracks income, not forms. Forms are just a cross-check.
Setting up the 1099 income sheet by payer
The 1099 income sheet needs two tabs. The first, Deposits, holds every credit row from your statements with a label and a payer name. The second, Payers, lists each payer once with a formula total, the amount on their 1099 and the difference. Everything else is optional.
The Deposits tab uses these columns:
| Column | Example content | Filled by |
|---|---|---|
| Date | 2026-03-06 | Statement |
| Description | ACH CREDIT BRIGHTLINE STUDIO PAYMT | Statement |
| Amount | 1,800.00 | Statement |
| Account | Checking 4417 | You |
| Label | Income | You |
| Payer | Brightline Studio | You |
| Note | Invoice 2026-014 | You, optional |
Bank descriptions are messy, so the Payer column is where you clean them up. "BRIGHTLINE STUDIO PAYMT", "BRIGHTLINE STUDIO LLC" and "BRIGHTLINE ST" are one payer. Typing the clean name once per row is tedious. A short lookup table of description fragments and payer names, with a formula to match them, does it for you after the first month.
The Payers tab has one row per payer. Column B sums the Deposits tab with =SUMIFS(Deposits!C:C, Deposits!F:F, A2, Deposits!E:E, "Income"). Column C is where you type the amount from the 1099 when it arrives. Column D is =B2-C2. A zero in column D means the payer and you agree.
Add a row at the bottom for "No form expected". Payers who paid you too little to trigger a form still belong in the total income figure, so they need a home.
Matching payer deposits to each 1099 form
Each payer's deposit total should come close to the amount on their 1099, but an exact match is less common than you would think. Differences come from three sources: timing at year end, fees taken before payout, and the form reporting a gross figure while your bank received a net one.
Work through the gaps in this order:
- Timing. A client may record a payment on December 30 that lands in your account on January 3. The payer counts it in one year and your statement shows it in the next. Check the first week of January and the last week of December.
- Platform fees. A marketplace may report the full sale on its form while depositing the sale minus its fees. The difference is the fee total, which is an expense you can deduct, not missing income.
- Refunds and chargebacks. If a customer was refunded, the gross figure on the form may still include the original sale.
- Wrong account. Some payers pay into a second account or onto a card. If a payer's deposits look short, check every account you own before you assume the form is wrong.
Write the reason next to each difference. "Fees $412, per platform annual report" is a full explanation. A difference with no note is a question your preparer will ask, and answering it at their hourly rate is expensive.
If the form is simply wrong, such as a payment counted twice or a payment that went to someone else, ask the payer for a corrected form. Keep your sheet and the statement rows as your evidence.
What if a 1099 never arrives for a payer?
You report the money anyway. A missing 1099 changes nothing about what you owe; the deposits on your statement are the record. Forms are often missing for a simple reason: the payer paid you less than the amount that requires one, or sent it to an old address.
The thresholds explain most missing forms. Under the IRS instructions for Forms 1099-MISC and 1099-NEC, the threshold for reporting nonemployee compensation increased to $2,000 for tax years beginning after 2025. A client who paid you $1,500 during 2026 owes you no form. The same instructions set January 31 as the date payers must furnish the statement to you.
Payment apps and marketplaces follow a separate rule. The IRS page on understanding your Form 1099-K says a platform must send one when your payments for goods or services exceed $20,000 in more than 200 transactions. It also notes that you may receive one below that threshold. Most small sellers will not get a 1099-K at all.
So a typical freelancer's sheet has a few payers with forms and several without. Both kinds go into the income total. Mark the "no form" payers with a note such as "below threshold" so nobody wonders later whether a form went missing.
By mid-February, chase any payer whose total is over the threshold and whose form has not arrived. Many payers also post forms in an online portal.
Worked example: three payers and a year of 1099 deposits
This worked example reconciles a made-up designer's 2026 deposits against the forms received. Every name and amount is invented. It shows one exact match, one timing gap and one platform fee gap, and how each difference gets a note that a preparer can read in seconds.
| Payer | Deposits labeled Income | Amount on form | Difference | Explanation |
|---|---|---|---|---|
| Brightline Studio (1099-NEC) | $21,600.00 | $21,600.00 | $0.00 | Matches |
| Harbor & Pine Co. (1099-NEC) | $8,400.00 | $10,200.00 | -$1,800.00 | Invoice paid Dec 30, deposited Jan 4, 2027 |
| Online marketplace (1099-K) | $22,950.00 | $25,500.00 | -$2,550.00 | Platform fees, per annual report |
| Two small clients (no form) | $1,750.00 | none | n/a | Each below the $2,000 threshold |
| Total income from deposits | $54,700.00 |
Two judgment calls hide in this table. First, the Harbor & Pine payment: the designer received it in January, so on a cash basis it is 2027 income, even though the client's form says 2026. Your preparer decides how to handle a mismatch like this, but they need to know it exists. Second, the marketplace: the gross sales figure is income and the $2,550 in fees is an expense. Reporting only the net deposits would understate both lines.
The total row is the deposit figure, built from the bank so every dollar traces to a statement row. It is not the gross receipts figure for the return: with the marketplace reported at its gross $25,500 and the $2,550 in fees as an expense, gross receipts come to $57,250.
1099 deposit trap: refunds and duplicate deposits counted as income
The most common way to overstate 1099 income is to count a credit that is not income. A refund from a store, a reversed card charge or a payment that appears twice all look like money in. If they land in the Income label, you pay tax on money you never earned.
Two patterns cause most of the trouble:
- Reversals. A card company refunds a double charge, and the credit sits among client payments. If you were charged twice and later refunded, that pair should net to zero in your expenses, not add to your income. Checking whether a purchase was charged twice explains how to tell a pending hold from a real duplicate.
- Duplicate imports. When you paste statement rows into the sheet each month, overlapping date ranges paste some rows twice. Before each paste, compare the first date of the new file with the last date already in the sheet.
Run one check before you file. Total every credit on every statement for the year. Subtract the transfers, refunds and other labels. The result must equal your income total. If it does not, a row is mislabeled or missing.
Feeding the 1099 deposit total into quarterly payments
The deposit sheet does double duty during the year. Each quarter, its running income total is the starting point for an estimated tax payment. Subtract expenses for the same months and you have the profit figure that the quarterly calculation needs, without waiting for forms that arrive the next January.
Add a Quarter column to the Deposits tab with a formula based on the date, and the Payers tab can show income per quarter as well as for the year. The arithmetic that turns a quarter's profit into a payment, including the safe-harbor amounts, is in calculating quarterly estimated taxes from your deposits.
The expense side works the same way: tag the outgoing rows from the same statements by category. A ready layout for that half of the job is the tax deduction tracker spreadsheet you fill from statements. Keep the two tabs in one file so the income and the costs come from the same rows.
The weak link is usually getting the rows out of a PDF statement in the first place. CheapBankConvert is being built for that one step: a statement in, CSV or Excel rows out, paid once per document, with the first 2 pages previewed free. It is not open yet, and you can get started to be emailed when it is.