Bank Statement to QuickBooks for Construction: Convert PDF Statements to QBO

A construction business rarely runs on one account. You have operating checking, a fuel or fleet card, a supplier card at the lumberyard, a materials card at the big-box store, and often an equipment loan or a line of credit for cash flow between draws. Bank feeds usually reach back only about 90 days, and they frequently skip loan accounts, closed cards, and supplier store cards entirely. Those are exactly the accounts loaded with job costs. Wait until March to connect them and most of last year's material and equipment spend never made it into the books.

QuickBooks will not read a PDF directly, so when your bank or lender only hands you PDF statements, you need to convert them into a format QuickBooks accepts. Manual uploads carry no date limit, so you can bring in a full prior year or an account the feed never touched and still reconcile it. You can convert a bank statement to QuickBooks in a few minutes with the tool above, then start assigning costs to jobs.

The point of construction bookkeeping is knowing whether a job made money. Job costing means every dollar of cost gets attached to the job that caused it, so you can compare actual spend against the estimate while the work is still moving. Once your converted transactions are in QuickBooks, tag each line to a job. In QuickBooks Online Plus and Advanced, the Projects feature holds a job's income, costs, and time in one place and gives an estimate versus actual view. On a lower plan, classes and the customer/sub-customer structure do a similar job. On QuickBooks Desktop and Enterprise Contractor, the customer:job list plus items give the most granular breakdown of any QuickBooks product.

Split your cost accounts the way a contractor thinks: materials, labor, subcontractor, and equipment. Keep true overhead (office rent, general insurance, software) out of the job cost accounts so it does not distort a job's margin. Decide your categories once and tag the same way every month.

Here is how the transactions you actually see on a contractor's statement line up with QuickBooks treatment. Tag the job on every cost line as you review the converted statement.

Committed costs and change orders sit alongside this. A signed subcontract or approved change order is money you have promised but not yet paid, so track it against the estimate before the check clears. When the payment hits the statement and imports, it moves from committed to actual.

Retainage (also called retention) is the slice a general contractor or owner holds back on each billing, usually 5 to 10 percent, until the job is done and accepted. Most contractors track it with a separate Retainage Receivable account set up as an other current asset, plus a retainage item on the invoice that codes the withheld amount as a negative line. On a $10,000 progress billing with 10 percent retention, code -$1,000 to the retainage item, so the invoice collects $9,000 now and the $1,000 sits in Retainage Receivable. When the job releases it, bill the retainage and apply the payment. Keeping it out of regular accounts receivable stops it from looking like money that is merely late.

If you pay a subcontractor or non-corporate vendor $600 or more in a year for work, you owe them a 1099-NEC. Get a W-9 before the first check so you have the name, address, and TIN. In QuickBooks, set the vendor up with Track payments for 1099 checked, and map your subcontractor cost account to Box 1, Nonemployee Compensation. One catch that matters on converted statements: the IRS excludes card, debit, and third-party app payments from 1099 reporting because the processor reports those, so only checks and ACH transfers should feed the 1099 total. Good reason to keep subcontractor card charges separate from checks at import.

1. Upload your PDF bank and credit card statements to the converter at the top of this page. You can drop in several accounts at once, including the supplier and fuel cards. It accepts PDF and image files.
2. The tool OCRs and parses each statement, then reconciles the running balance, keeping the date, description, and amount for every line.
3. Download a .qbo file per statement, plus Excel and CSV copies for your job cost tracking.
4. Import into QuickBooks. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 lines per file. Each file must be in English and 350 KB or less, so split a long statement if it runs past those limits. For a walkthrough, see how to import a bank statement into QuickBooks Online, or go straight to the PDF to QBO converter. Shops closing out a full year across many cards can save time with bulk bank statement to QuickBooks conversion, and firms handling several builders may prefer the bank statement conversion for accountants workflow.

Can QuickBooks do job costing?

Yes. QuickBooks Online Plus and Advanced handle job costing through the Projects feature, which groups a job's income, costs, and labor and shows estimate versus actual. QuickBooks Desktop and Enterprise Contractor go deeper with the customer:job list and items. On lower QBO plans, classes give you a lighter version of the same tracking.

How do I track job costs in QuickBooks?

Tag every cost to a job as you enter or import it. Use Projects or the customer:job field so materials, subcontractor payments, equipment, and permits attach to the right job. Convert PDF statements first so each supplier and card charge imports with its date and amount, then assign the job before you reconcile and run a job profitability report.

How do I record retainage in QuickBooks?

Set up a Retainage Receivable account as an other current asset and a retainage item on your invoices. Code the withheld amount as a negative line on each progress billing, which moves it out of accounts receivable into Retainage Receivable. When the job releases the retention, bill it separately and apply the payment you receive.

Is QuickBooks good for construction?

Yes, for the books and job costing it works well for most contractors. QuickBooks Desktop Enterprise Contractor has the strongest job costing, while QuickBooks Online Projects covers cloud tracking. It is not full construction management software, so it will not run scheduling or bid estimating, but for cost tracking, 1099s, and taxes it fits most shops.

How do I track subcontractor payments in QuickBooks?

Set each subcontractor up as a vendor with Track payments for 1099 checked, collect a W-9 first, and post their payments to a subcontractor cost account. Tag the job on each payment for job costing. Remember that only checks and ACH count toward the 1099-NEC, since card and app payments are reported by the processor instead.

Can I import old bank statements into QuickBooks for taxes?

Yes. Manual uploads have no date limit, unlike bank feeds that reach back only about 90 days. Convert older PDF statements into .qbo files and upload them, which is how most contractors backfill a prior tax year or a supplier card the feed never connected to. Import them account by account and reconcile each month.