# 1099 PDF to Excel: Collect Every Form in One Sheet

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Tax time on a budget
- Canonical: https://cheapbankconvert.com/blog/1099-pdf-to-excel

> Turn each 1099 PDF to Excel in one sheet: type the few boxes that matter, check them against deposits, and skip paying to convert forms.
Moving each 1099 PDF to Excel takes a few minutes by hand: one row per form, with the payer, the form type, the box that holds the money and the amount. Typing beats converting, because a form has only a handful of numbers. The sheet then lets you check every form against the deposits on your bank statements.

## Which 1099 boxes belong in the Excel sheet?

A 1099 sheet needs only the boxes that carry money you report, plus enough detail to find the form again. For most people that is one or two boxes per form. Use columns for payer name, payer tax ID, form type, box, amount, any federal tax withheld and the file name of the PDF.

The form type tells you which box to read. A 1099-NEC reports pay for work done as a non-employee; the IRS [instructions for Forms 1099-MISC and 1099-NEC](https://www.irs.gov/instructions/i1099mec) say box 1a of the current form holds nonemployee compensation of $2,000 or more; forms for earlier years call it box 1. A 1099-INT reports bank interest. A 1099-MISC can hold rents, royalties and other income. A 1099-K reports card and payment-app payments.

Withholding is the box people skip. If a payer withheld federal tax, that amount is a credit on your return, and leaving it out of the sheet means paying it twice.

## Should you convert a 1099 PDF or type it?

Typing a 1099 is almost always faster than converting it. A converter is built for documents with dozens or hundreds of rows, like a bank statement. A 1099 has a few boxes laid out as a form, not a table, so converted output comes back as scattered cells you must sort out by hand anyway.

Five forms take about ten minutes to type, and you read each number as you go, which is a check in itself. Paying to convert them saves nothing.

The bank statements are a different case. To check the 1099s you need a year of deposits as rows, and those are long tables. CheapBankConvert, not yet open, is built for that side of the job: one fee per statement, nothing renewing, and a two-page free preview. See [the CheapBankConvert homepage](/) for the early prices.

## Matching each 1099 row to bank deposits

Matching means adding up the deposits from each payer for the year and putting the total next to the 1099 amount. Filter the deposit rows by the payer's name, sum them, and enter the result in a "deposits" column. A "difference" column of 1099 amount minus deposits shows which forms need a closer look.

The table below is a worked example. The payers and amounts are made up for illustration.

| Payer (example) | Form | Box | 1099 amount | Matched deposits | Difference |
| --- | --- | --- | ---: | ---: | ---: |
| Brightline Studio LLC | 1099-NEC | 1a | 8,400.00 | 8,400.00 | 0.00 |
| Harbor Apps Inc | 1099-NEC | 1a | 5,250.00 | 4,500.00 | 750.00 |
| Payment platform | 1099-K | Gross | 3,912.00 | 3,610.00 | 302.00 |
| First Valley Bank | 1099-INT | Interest | 118.42 | 118.42 | 0.00 |

Use `=SUMIFS(Deposits!C:C, Deposits!B:B, "*Harbor*")` to total one payer's deposits from a deposits tab, where column B holds descriptions and column C holds amounts. The asterisks let the match work when the bank adds reference numbers to the name.

If you rent out property, add the rent you collected to the same sheet. Rent often arrives with no 1099, and [rental property expense tracking from bank statements](/blog/rental-property-expense-tracking) shows how to keep the income and costs per property.

## Why a 1099 total rarely equals your bank deposits?

A 1099 total and your deposits differ for ordinary reasons: timing, fees and gross reporting. A client may have mailed a December check that you deposited in January. A payment platform may report the gross amount it processed, while your bank received that amount minus its fees. A single deposit may combine two payers.

Read each difference before you change anything. In the example, Harbor Apps paid $750 by check on December 30 and the deposit cleared on January 3, so the form is right. The platform gap of $302 is fees, which are a business expense you can support with the platform's report and the bank rows; [using a bank statement as proof of expense](/blog/bank-statement-as-proof-of-expense) explains what that pairing shows.

Report what the forms and your records support, not the deposit total. Deposits that come from no 1099 at all, such as cash jobs or small clients, are still income.

## Missing or wrong 1099 forms in the sheet

A missing 1099 does not remove the income, and a wrong one should be fixed by the payer. The IRS instructions say payers must furnish the forms to recipients by January 31. If a known client has not sent one by mid-February, ask for it, and report the income from your deposits either way.

For a wrong amount, write to the payer with your deposit total and the dates, and ask for a corrected form. The deposit rows from your statements are the evidence. Keep the email and the matched rows together.

A deposit list helps in a dispute too. If a client claims they paid you more, or never paid at all, the same filtered rows show each payment by date, and they can serve as evidence; [bank statements for small claims court](/blog/bank-statements-for-small-claims-court) covers how to present them. Save the finished sheet with the PDFs, named with the tax year.