Bank Statement to QuickBooks for Cleaning Companies: Convert PDF Statements to QBO

Convert PDF bank and card statements into .qbo files for QuickBooks so maid service card batches, commercial net-30 deposits, and 1099 crew pay post clean.

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

Residential maid services, commercial janitorial contractors, and the bookkeepers who keep their books can turn PDF bank and credit card statements into .qbo Web Connect files for QuickBooks Online and Desktop. Upload a statement to the converter at the top of this page and it parses every line, so weekly card batches from recurring maid clients, single net-30 deposits from office contracts, crew payouts, and the monthly janitorial supply bill land with real dates and amounts. You also get Excel and CSV copies, which help when you split a card batch into gross revenue and processing fees or allocate one lump crew payment across several subcontractors. It also reaches back further than a bank feed, which usually stops around 90 days.

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].

Two revenue models sit on one bank statement

A cleaning company usually runs two very different books of business through one checking account, and they hit the statement in opposite ways. Recurring residential work (weekly or biweekly maid service) is almost always auto-billed to a card through scheduling software like Jobber, ZenMaid, Launch27, Automaid, or Housecall Pro. Those charges do not deposit one by one. The processor bundles a day or a week of them and remits a single net batch after its fee comes out, so the deposit that hits checking is smaller than what your clients were charged. Book that net number as revenue and income runs low every month. Split it instead into gross service income and a merchant processing fee expense so the two pieces reconcile back to the batch.

Commercial janitorial contracts behave nothing like that. You invoice an office park or a medical building on net-30 terms, do the work in June, and the payment shows up as one ACH or a mailed check weeks later. That money is accounts receivable at the time you cleaned, and the later deposit clears the receivable rather than creating fresh income. Book both the invoice and the deposit as revenue and you double count the same job.

Subcontracted cleaners versus W-2 employees

How you pay the people doing the cleaning drives both your books and your audit exposure. A genuine independent contractor gets a Form 1099-NEC if you pay them 2,000 dollars or more in a year (the threshold rose from 600 dollars for payments made on or after January 1, 2026), and their pay goes to a contract labor or subcontractor expense account with no withholding. A cleaner you schedule, train, and supply is an employee who belongs on payroll with a W-2, wages, and payroll taxes. Misclassification is the industry's biggest audit risk: the IRS weighs behavioral control, financial control, and the permanency of the relationship, and a house cleaner you dispatch on your schedule with your products usually fails the contractor test. Lose that audit and you owe back payroll taxes and penalties.

There is a bookkeeping trap even when the workers are legitimately 1099. If you pay a crew with one lump weekly ACH, that single bank line has to be split by contractor so each person's total is right at year end, otherwise you cannot produce accurate 1099-NEC forms in January. Converting the statement so every payout keeps its date and amount makes the split easier to reconstruct. See how to handle multiple clients in an accountant workflow if you keep books for several cleaning companies.

Tips routed through your card processor

When a residential client adds a tip on the card, that money runs through your processor and lands in your deposit, but it is not your revenue: it belongs to the cleaner who earned it. Until you pay it out, a tip is a liability you are holding, so book it to a tips payable account rather than to service income, and disbursing it to the cleaner clears the liability. Treat tips as income and you overstate revenue and pay tax on money that was never yours to keep.

Supplies and chemicals versus equipment

A single card charge at a janitorial supply house or a big box store often mixes two different things. Consumables (microfiber cloths, disinfectant, floor finish, trash liners, gloves) are supplies expense, used up on the job within the period. But a floor buffer, a carpet extractor, or a commercial backpack vacuum is a fixed asset with a useful life of years, so it goes on the balance sheet and depreciates rather than hitting one month as an expense. When a supply run and an extractor land on the same statement line, split the charge so the asset is capitalized and only the consumables are expensed.

Company vans versus mileage reimbursement

Vehicles get recorded two ways depending on who owns the car. A company van is a business asset, and its gas, insurance, repairs, and loan payments run through the company's vehicle expense and loan accounts. When a cleaner drives their own car between houses and you reimburse them for mileage, that is not a vehicle expense: it is a reimbursement, usually paid at the IRS standard mileage rate, and it goes to a mileage or travel reimbursement account. Mixing the two overstates what the company spends operating its own fleet.

Insurance, bonding, workers comp, and license fees

Cleaning companies carry more insurance than most trades because clients demand it before letting a crew into their building. General liability, a janitorial or surety bond (which protects the client if a job is not completed or something is stolen), and workers compensation are each their own expense account, not one lumped insurance line. Workers comp deserves attention: premiums are estimated up front against expected payroll, then the carrier audits actual payroll at the end of the term. That audit produces either a refund check or an additional bill, and each posts against the workers comp expense, not to miscellaneous income or a new cost. Janitorial license and permit fees round out the group as their own line.

Client deposits, franchise fees, and onboarding costs

Commercial clients sometimes hand you a key or lockbox deposit so your crew can get in after hours. That cash is refundable, so it is a liability you are holding, not revenue, until the contract ends and you return it. If the operator runs a cleaning franchise (a common model here), the initial franchise fee and the ongoing royalty each get their own expense account rather than disappearing into overhead. Uniforms, employee background checks (standard for anyone entering a client's home), and training get their own accounts too. Finally, if you want per-account profitability on commercial contracts, match each statement line to the right customer or job so an office building's revenue and its share of labor and supplies land together. Without that tagging you cannot tell which contracts make money.

Mapping cleaning company transactions to QuickBooks

Here is how common statement lines map to QuickBooks treatment as you review the import.

What appears on the cleaning company's bank statementWhat it actually isWhere it belongs in QuickBooks
Weekly card batch from maid clients (net of fees)Gross service income minus the processor's cutSplit: service income (gross) plus merchant fee expense
ACH or check from a commercial janitorial contractPayment on a net-30 invoiceClears accounts receivable, not new income
Lump weekly ACH to the cleaning crewPay owed to several subcontractorsSplit by contractor to contract labor (1099-NEC)
Tip added on a client's cardMoney owed to the cleanerTips payable (liability) until paid out
Charge at a janitorial supply house or big box storeConsumables, sometimes plus equipmentSplit: supplies expense and fixed asset if gear is included
Floor buffer, extractor, or backpack vacuumLong-lived equipmentFixed asset, then depreciation
Mileage paid to a cleaner using their own carReimbursement, not a company vehicle costMileage or travel reimbursement expense
Bond, general liability, or workers comp premiumRequired insurance coverageSeparate insurance and bond expense accounts
Workers comp audit refund or additional billTrue-up against actual payrollPosts against workers comp expense
Key or lockbox deposit from a commercial clientRefundable cash you are holdingCustomer deposit liability
Franchise fee or monthly royaltyCost of running under the brandDedicated franchise fee and royalty expense
How to convert your statements
  1. Upload your PDF bank and credit card statements to the converter at the top of this page, several accounts at once if you like. It accepts PDF and image files.
  2. The tool parses each statement, reconciles the running balance, and keeps the date, description, and amount for every line, including card batches and crew payouts.
  3. Download a .qbo file per statement, plus Excel and CSV copies for splitting batches and allocating crew pay.
  4. Import into QuickBooks. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file.

QuickBooks Online manual upload accepts .csv, .txt, .qbo, .qfx, and .ofx files, up to 1,000 transactions or 350 KB per file, so split a long statement past that limit. For one statement, use the PDF to QBO converter or the QBO converter page. When the card side is your main headache, see convert a credit card statement to QuickBooks, and for each platform, import a bank statement into QuickBooks Online or convert a bank statement to QuickBooks Desktop. Crews that also do trade work can compare the HVAC and plumbing contractor guide.

Frequently asked questions

Which QuickBooks is best for a cleaning business?

QuickBooks Online suits most cleaning companies because it works from any device, connects to field software, and lets a bookkeeper log in remotely. Solo cleaners can start on a lower tier; a company running payroll for a W-2 crew usually needs a plan with payroll. QuickBooks Desktop still works if you prefer a local file. Both import .qbo statements the same way.

What chart of accounts should a cleaning company use?

Set up separate income accounts for residential and commercial work, then expense accounts for cleaning supplies, contract labor or payroll, insurance, bonding, and workers comp, license and permit fees, vehicle costs, and mileage reimbursement. Add a tips payable liability, a customer deposit liability, and a fixed asset account for equipment like buffers and extractors. Keep franchise fees separate if you run under a brand.

How do I record credit card payments from cleaning clients in QuickBooks?

Record the gross amount clients were charged as service income, then post the processor's fee to a merchant fees expense, so the net deposit matches your bank statement. Card payments arrive as batches, not one charge at a time, so split each batch rather than booking the net figure as revenue. Tips inside the batch go to a tips payable liability, not income.

Should cleaners be 1099 or W-2?

Most house cleaners you schedule, train, and equip are W-2 employees under IRS rules, not 1099 contractors. The IRS weighs behavioral control, financial control, and how permanent the relationship is, and a cleaner working your routes on your terms usually fails the contractor test. Misclassification is the industry's top audit risk and can mean back payroll taxes and penalties, so review each worker carefully.

Does Jobber sync with QuickBooks?

Yes. Jobber offers a one-way sync to QuickBooks Online that can push clients, invoices, payments, tips, and payouts, with Jobber acting as the source of truth. It does not sync your bank or credit card statements, though. To reconcile the actual deposits and card batches that hit checking, convert those PDF statements to .qbo and import them alongside whatever the app sends over.

How do I import a bank statement into QuickBooks?

Convert the PDF statement to a .qbo Web Connect file, then import it. In QuickBooks Desktop, go to File, then Utilities, then Import, then Web Connect Files. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file. Manual uploads carry no 90-day limit like bank feeds do, so you can bring in older periods for taxes.

Convert your first statement free.

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