Bank Statement to QuickBooks for Roofing Contractors: Convert PDF Statements to QBO

Convert PDF bank and card statements into a .qbo file for QuickBooks Online or Desktop, built for roofers tracking insurance claim checks and job costs.

Totals reconcile to the original QuickBooks Online and Desktop
Loved by bookkeepers and accountants 50K+ pages converted

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Upload a PDF bank or credit card statement to the converter at the top of this page and get back a .qbo file ready for QuickBooks Online or QuickBooks Desktop (Excel and CSV are also available). Roofing contractors have a specific reason this matters: an insurance-funded reroof isn't paid in one lump sum. The carrier issues a first check, releases a second depreciation check weeks or months later once the job is finished, the homeowner pays a deductible, and on larger claims a mortgage company may hold and release funds in draws. All of that money is payment toward one job, one contract. If you post each check as its own income line, you overstate revenue, understate what's still owed on open jobs, and lose the ability to see whether a given roof actually made money.

Last updated July 2026.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

How an insurance claim actually pays for a roof

Most wind and hail claims are written on a Replacement Cost Value (RCV) policy. The carrier's adjuster sets the RCV, which is what it costs to replace the roof with new materials at today's prices. From that number, the carrier subtracts depreciation, an estimate of how much value the old roof had already lost based on its age and remaining useful life. What's left is Actual Cash Value (ACV), and that's the amount of the first check, minus the homeowner's deductible. The depreciation that got subtracted is called recoverable depreciation, and the carrier holds it back until the work is actually completed and a final invoice or certificate of completion is submitted. Once that paperwork goes in, the carrier releases a second check for the depreciation amount. The homeowner is responsible for the deductible; that's a fixed cost set by their policy, and it's paid to the contractor as part of the total job price, not as a separate favor or discount.

Here's a clean example that ties out. RCV is $18,000. Depreciation is $5,000, so ACV is $13,000. The homeowner's deductible is $1,000, so the first check from the carrier is $12,000 ($13,000 ACV minus the $1,000 deductible). The homeowner separately pays their $1,000 deductible to the contractor. After the roof is finished and the paperwork is submitted, the carrier releases the $5,000 recoverable depreciation check. Add it up: $12,000 plus $1,000 plus $5,000 equals $18,000, the full RCV, and the full contract price of the job. Three deposits, one job.

The job is one contract, not four separate payments

This is the single most common bookkeeping mistake on insurance restoration work. The bank statement shows three or four unrelated-looking deposits over weeks or months: an insurance ACV check, a homeowner payment for the deductible, and later a second insurance deposit for released depreciation. Booked separately, that looks like three jobs or three revenue events. It's one job. Invoice the customer for the full contract amount (the RCV, or RCV plus any approved supplement) when the work is scheduled, then apply each deposit as a partial payment against that single invoice as it arrives. Accounts Receivable is built for exactly this: partial payments against one open invoice, closing out only when the last dollar, usually the released depreciation, comes in.

Supplements: when the carrier approves more scope

Roofs often reveal problems once the old material is off: rotted decking, damaged flashing, code-required upgrades the original estimate didn't include. When the adjuster approves that added scope, it's called a supplement, and it raises the total contract price. The correct handling is to increase the job's invoice or record a change order for the supplement amount, then apply the supplement check to that updated invoice when it arrives. Don't book the supplement check as a new, unrelated deposit; it belongs to the same job and the same customer record, just a larger contract than originally quoted.

When a mortgage company is on the check

On larger claims, or when the homeowner has an active mortgage, the carrier often makes the check payable to both the homeowner and the mortgage lender jointly. The homeowner endorses it over, the lender deposits it into an escrow-type account, and releases funds to the contractor in draws as work is inspected and progresses, rather than all at once. Treat each draw the same way you'd treat any partial payment: apply it against the job's invoice. The portion the mortgage company is still holding is a receivable you're owed, not a loss and not a smaller contract, so keep that balance visible on the books until the final draw clears.

Job costing: know what each roof actually made

Materials bought on account from suppliers like ABC Supply, SRS Distribution, or Beacon Building Products (shingles, underlayment, drip edge, ridge vent) are a direct job cost, not a general supplies expense. The same goes for subcontracted crew labor, dumpster rental, and permit fees. Tag every one of those costs to the specific job, whether you're using QuickBooks classes, projects, or job-linked customers, and compare the total against the contract price once the job closes. That's how you find out whether a reroof actually cleared a healthy margin, or whether a supplement meant to cover rotted decking got eaten by an underpriced original estimate.

Subcontracted crews and 1099 reporting

Most roofing companies use subcontracted install crews rather than employees, and those crews are generally 1099-NEC contractors. For payments made on or after January 1, 2026, the federal reporting threshold is $2,000 per contractor per calendar year, and it's indexed for inflation in later years. Whether a crew is truly an independent contractor or should be treated as an employee comes down to the IRS's control test (who directs how, when, and with what tools the work gets done), and close calls are worth confirming with a CPA rather than guessing. Either way, track what you pay each crew through the year so the totals are ready when 1099 season arrives.

Retail jobs are a different pattern

Not every roof is insurance-funded. Retail jobs, cash customers replacing an aging roof on their own decision rather than after a storm, typically follow a standard deposit-plus-progress or deposit-plus-completion billing structure with no carrier involved and no ACV/depreciation split. Keep retail jobs and insurance jobs distinct in how you record them; mixing the two patterns is how a bookkeeper ends up expecting a second check that was never coming, or wondering why a retail job's single final payment doesn't match the two-check rhythm of an insurance claim.

Card and merchant deposits land net of fees

When a homeowner pays their deductible or a supplement by card, the deposit that hits your bank account is the gross amount minus the payment processor's fee. If you post only the net deposit against the customer's invoice, the invoice never fully closes and the fee never shows up as an expense. Split the transaction: the full invoice amount goes to Accounts Receivable, and the difference between that and the net deposit goes to a merchant fee expense account.

What's really on the bank statement
What appears on the bank statementWhat it actually isWhere it belongs in QuickBooks
First insurance (ACV) checkThe first partial payment on the job's total contractApplied against the job's open invoice / Accounts Receivable
Released depreciation checkThe second partial payment on that same contract, paid after the final invoice is submittedApplied against the same job's invoice, not new income
Homeowner deductible paymentThe homeowner's share of the same total job priceApplied against the same job's invoice
Supplement checkPayment for carrier-approved added scope that raised the contract priceApplied to the updated invoice or change order for that job
Mortgage escrow drawA partial release of insurance funds held by the homeowner's mortgage lenderApplied against the job's invoice; unreleased balance stays as a receivable
ABC Supply / SRS / Beacon material draftA job cost for shingles, underlayment, drip edge, and related materialsCost of goods sold, coded to the specific job
Subcontractor crew paymentLabor cost for that job, usually a 1099 contractorCost of goods sold / subcontractor labor, coded to the job
Dumpster rental chargeA job cost for debris removalCost of goods sold, coded to the job
Permit feeA job cost for the municipal building permitCost of goods sold, coded to the job
Equipment loan draftA payment split between loan principal and interestSplit between the loan liability account and interest expense
Card batch depositThe gross customer payment minus the processor's feeSplit: full invoice amount to Accounts Receivable, fee to a merchant fee expense account
Software subscription chargeAn operating expense, such as estimating or accounting softwareOperating expense, not a job cost
Sales tax remittancePayment of sales tax collected from customers, where materials or labor are taxableReduces the sales tax payable liability
Frequently asked questions

How do I record an insurance claim payment in QuickBooks?

Record the full contract price as one invoice for the job, then apply each check (the first ACV payment, the deductible, any supplement, and the released depreciation) as a separate partial payment against that same invoice, matched to the bank deposit by date and amount. Don't create separate income entries for each check.

Is recoverable depreciation income?

No, it isn't new income by itself. It's the second payment toward the total contract price you already recorded as the job's revenue when the work was invoiced. When the carrier releases it, apply it against the same job's invoice rather than posting it as a fresh sale.

How do I record the homeowner's deductible?

The deductible is the homeowner's portion of the same total job price the insurance company is also paying toward. Record it as a customer payment applied to that job's invoice, alongside the insurance checks, rather than as a separate, smaller job or a discount.

How do I job cost a roofing job in QuickBooks?

Use QuickBooks classes, projects, or job-linked customers to tag materials, subcontractor labor, dumpster fees, and permit costs to each specific roof, then compare the total cost against the job's contract price once it's complete to see the actual gross margin.

How do I import a bank statement into QuickBooks?

Upload the PDF bank or card statement to the converter at the top of this page and download the .qbo file it generates. In QuickBooks Desktop, import it through File, Utilities, Import, Web Connect; in QuickBooks Online, upload the file from the Banking tab.

Are roofing subcontractors 1099 in QuickBooks?

Most subcontracted install crews are 1099-NEC contractors, and for payments made in 2026 or later the federal reporting threshold is $2,000 per contractor per year. QuickBooks can track running totals paid to each subcontractor, though the actual worker classification depends on the IRS control test, which a CPA can confirm on close calls.

Convert your first statement free.

Upload a PDF, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

Insurance restoration billing already involves enough moving pieces between the carrier, the homeowner, and sometimes a mortgage lender, without the bank feed adding a fourth version of the story. Convert your statements with the PDF to QBO converter, then bring them in through importing a bank statement into QuickBooks Online or converting a bank statement for QuickBooks Desktop. If you're comparing tools first, see the full QBO converter overview, and if your roofing company also handles general contracting or larger builds, the bank statement to QuickBooks guide for construction covers retainage and draws in more depth. Bookkeepers managing several roofing clients at once may also want bank statement to QuickBooks for accountants and bulk bank statement conversion for handling multiple companies' statements in one pass.

More bank statements we convert to QuickBooks

Same converter, tuned for the layout each bank uses. Find yours: