Bank Statement to QuickBooks for Interior Designers: Convert PDF Statements to QBO

Convert PDF bank and card statements into a .qbo file for QuickBooks Online or Desktop, built for interior designers handling retainers and FF&E resale.

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 it hands back a .qbo file you can import straight into QuickBooks Online or QuickBooks Desktop, plus an Excel or CSV copy so you can eyeball every line before it touches your books. That part is mechanical. The harder part is what happens after the file lands, because a design firm's bank statement is not one kind of money moving through one kind of account. In a single week you might see a client retainer you have not earned yet, a 50 percent deposit you paid a trade vendor to place a custom sofa order (an asset, not an expense), FF&E you buy at trade price and resell at retail (product income with a real cost behind it), and design fees you actually billed for your time. Dump all of that into generic "income" and "expense" categories and your margins on furniture, your cash position, and your liability for client funds all go blurry at once.

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

Client retainers and deposits are a liability, not income

When a client wires you a retainer or writes a deposit check before you have designed a single room, that money is not yours yet. It sits on your books as unearned revenue (a liability), and you recognize it as income in two separate pieces as the underlying obligations are satisfied: the design-fee portion as you actually perform the work, and the product portion when the furniture or fixtures are delivered to the client. Say a client sends a $10,000 retainer against a project with an estimated $4,000 in design fees and $6,000 in furniture. You book the full $10,000 to a client retainers liability account when it hits the bank. As you bill design-fee hours or milestones, you move the matching amount out of the liability and into design-fee income. When the sofa and side tables ship and are accepted, you move the product portion out of the liability and into product income, with the trade cost recognized as cost of goods sold at the same time. Until goods are delivered or hours are worked, the cash is still the client's, not yours, and your balance sheet should say so.

Trade purchasing: are you a principal or an agent?

Most designers buy fabric, lighting, rugs, and case goods from trade-only vendors at a net or wholesale price, then resell those same pieces to the client at a retail markup. How you report that markup on your books, and on your income statement, depends on a specific question under current revenue-recognition guidance (ASC 606): do you control the item before it reaches the client, or are you merely arranging a purchase on the client's behalf for a fee?

If you take title to the goods, carry the risk if they arrive damaged or the client rejects them, and set your own resale price, you are acting as a principal. That means you report the full retail price as product income and the trade cost as cost of goods sold, so your revenue shows the gross sale and your gross margin shows the spread. If instead you are simply placing an order in the client's name, never take on inventory risk, and are paid a fixed fee or commission for arranging it, you look more like an agent, and you would report only your margin or commission as income, not the full retail price. This distinction can change your reported revenue by a large multiple without changing your actual profit at all, which is exactly why it matters for loan applications, valuations, and comparing year over year. It is a facts-and-circumstances call that your CPA should make and document, not something to guess at from a bank feed.

Vendor deposits you pay: an asset, not an expense

Trade vendors routinely require 50 percent (or more) down before they will cut fabric or build a custom piece. When that deposit leaves your account, it is not an expense on the day you pay it. It is a prepaid deposit, an asset sitting on your balance sheet (some firms track it as job-specific work in process), because you have not yet received the goods and the client has not yet been billed for that item. The cost only moves to cost of goods sold when the item is delivered and you recognize the matching sale. Coding vendor deposits straight to an expense account the moment they clear the bank understates your assets, overstates your expenses in the deposit month, and then leaves a mystery when the final invoice comes in with no offsetting cost to match against it.

Keep design fees, product sales, and pass-throughs in separate accounts

Set up at least three income accounts: design-fee income (hourly, flat-fee, or per-room), product income (the retail side of FF&E you resell), and reimbursable expenses (costs you pass through to the client). These behave differently and blending them hides where your money actually comes from. Design fees are close to pure margin once you cover your own time. Product income carries a real cost of goods sold, so its margin depends entirely on your markup and freight. Reimbursables billed at exact cost are a wash on your income statement, a pass-through with no margin, while reimbursables marked up even slightly do carry margin and belong closer to product income than to a zero-margin pass-through account. A firm that lumps all three together can look highly profitable on total revenue while actually losing money on the furniture side, or the reverse.

Freight, white-glove delivery, and inbound shipping

Inbound freight on an item you are reselling, the charge to get a chair from the manufacturer's dock to your warehouse or the client's home, is part of that item's cost, not a standalone shipping expense. Roll it into cost of goods sold alongside the trade price so your product margin reflects the real, landed cost of the piece. White-glove delivery and receiving fees you bill separately to the client, on the other hand, can sit in their own income line if you are marking them up, or flow through as a reimbursable pass-through if you are billing them at cost.

Installers and workroom labor: 1099 contractors and the new threshold

Upholsterers, workrooms, installers, and other subcontracted labor you bring onto a project are usually 1099 contractors rather than employees, and classification follows the IRS's control test: who directs how, when, and with what tools the work gets done, not just how the invoice is worded. For payments made on or after January 1, 2026, a business only needs to issue a Form 1099-NEC to a contractor once payments to that contractor reach $2,000 in the calendar year, and that threshold is indexed for inflation in future years. That is a real change from the reporting rule most designers grew up with, so update your bookkeeping checklist and your vendor W-9 collection process accordingly. Close calls on employee versus contractor status are worth a CPA's sign-off before you build a habit around them.

Sales tax on resold FF&E is state-specific

Because you are reselling tangible goods, most states let you buy FF&E from trade vendors tax-free using a resale certificate, then require you to collect sales tax from your client as the retailer when you sell the piece at retail. Holding that certificate is a two-way obligation: it exempts your wholesale purchase, but it also puts the burden on you to charge and remit tax on the resale, and using it to buy anything not genuinely intended for resale is a compliance problem waiting to surface in an audit. Rules on what is taxable (goods versus pure design-fee services), registration, and filing frequency vary by state, and some states tax design services differently depending on whether they are bundled with a sale of goods. Confirm your state's specific treatment with a CPA or your state's revenue department rather than assuming it matches a colleague's state.

What your bank statement shows, and where it actually belongs
What appears on the bank statementWhat it actually isWhere it belongs in QuickBooks
Client deposit or retainer ACHUnearned revenue you have not yet worked off or delivered goods forClient retainers liability account, split to income as earned
50 percent vendor deposit draft (outgoing)Prepaid deposit on custom FF&E, not yet deliveredDeposits paid / job WIP asset account
Trade vendor final paymentRemaining balance due on delivery of ordered goodsClears the deposit asset, remainder to cost of goods sold
White-glove delivery charge (outgoing)Receiving and installation cost tied to a specific itemCost of goods sold or a marked-up delivery income line if billed to client
Inbound freight chargeLanded cost of the item you are resellingCost of goods sold, rolled into item cost
Installer or workroom paymentSubcontracted labor, typically a 1099-NEC contractorContract labor expense, tracked against $2,000 reporting threshold
Design-fee deposit from clientPrepayment against hours or a flat fee not yet performedClient retainers liability, moved to design-fee income as earned
Card batch deposit (net of processor fees)Blended client payments minus merchant feesGross to the correct income accounts, fees to a merchant fees expense account
Showroom or sample purchaseA business supply or COGS item depending on intended useSupplies expense, or cost of goods sold if resold to a client
Software subscription (design or accounting tools)An operating expenseSoftware or dues and subscriptions expense
Sales tax remittanceTax collected from clients, now being paid to the stateClears the sales tax payable liability account
Reimbursable expense billed to clientA pass-through cost, at cost or marked upReimbursable income account (at cost) or product/service income (if marked up)
Frequently asked questions

How do I record a client deposit in QuickBooks?

Record it as a credit to a client retainers or unearned revenue liability account, not as income, the day it clears the bank. Then move the design-fee portion to design-fee income as you perform the work and the product portion to product income once the related goods are delivered, so you never report revenue you have not actually earned.

Do interior designers report the full retail price of furniture as revenue?

Only if you are acting as a principal under ASC 606, meaning you took control of the goods, carried the delivery and acceptance risk, and set the resale price. If you were purely arranging the purchase for a fixed fee with no inventory risk, you report only your commission or markup, not the full retail price. This is a facts-based determination a CPA should confirm.

Are vendor deposits an expense in QuickBooks?

No, a deposit you pay a trade vendor to place a custom order is a prepaid asset, not an expense, because you have not yet received the goods. It converts to cost of goods sold only when the item is delivered and you recognize the matching sale to your client.

How do I import a bank statement into QuickBooks?

Convert your first statement free.

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

Related guides

Upload the PDF statement to a converter that outputs a .qbo file, then use QuickBooks Online's file upload or QuickBooks Desktop's Web Connect import to bring the transactions in for categorization. See the guide to importing a bank statement into QuickBooks Online or the Desktop conversion walkthrough for the exact steps in each product.

Should design fees and product sales be separate income accounts?

Yes, because they carry very different margins and mixing them hides which side of your business is actually profitable. Design fees are close to pure margin on your time, while product income has a real cost of goods sold behind it, so separate accounts let you see the true markup on furniture versus the value of your design hours.

Do interior designers charge sales tax on furniture?

In most states, yes: designers buy trade goods tax-free on a resale certificate and then collect sales tax from the client on the retail sale, acting as the retailer of record. Exact rules on what is taxable and how design services are treated vary by state, so confirm your state's specific requirements with a CPA before you set up your tax settings.

Ready to get a month of retainers, trade deposits, and FF&E resale off a PDF and into your books correctly? Upload your statement to the PDF to QBO converter at the top of this page, choose QuickBooks Online or Desktop, and download a clean .qbo file (or Excel/CSV to review first) in minutes. If you manage several client entities at once, the bulk bank statement to QuickBooks tool handles multiple statements in one pass, and if you are a bookkeeper or CPA supporting design firms, the accountant-focused workflow and the general QBO converter page cover the broader setup.

More bank statements we convert to QuickBooks

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