PDF Bank Statement to QuickBooks for Franchise Owners: Convert Multi-Location Statements to QBO

Run three locations and you have three bank accounts, three card processors, and three stacks of PDF statements every month, plus a royalty and ad fund sweep the franchisor pulls out of each one. PDFQBO converts every statement into a QuickBooks QBO file so each location's deposits, fee sweeps, and expenses reach your books with their exact dates and amounts, ready to tag by location.

Quick answer

To get a franchise location's bank statement into QuickBooks, convert the PDF to a QBO file first. Upload each location's operating account, merchant payout, or card statement to PDFQBO, review the POS deposits, royalty sweeps, and ad fund debits it reads, and download a QBO (Web Connect) file. Then import that file into QuickBooks Online or Desktop, code each line, and assign it to that location's class so you can see one store's profit and loss and the whole group's at the same time.

One account per location Royalty and ad fund sweeps QuickBooks Online and Desktop

Last updated July 2026

Convert a location's statement to QBO

Upload an operating, merchant, or card PDF and download a QBO file for QuickBooks.

No credit card required to try your first statement.

Every location

One workflow per store

QBO + IIF

Online and Desktop

Batch upload

A year of statements at once

Auto delete

Files removed after use

How to convert franchise bank statements to QuickBooks

Four steps take you from a folder of PDFs to QBO files QuickBooks accepts, however many locations you operate.

Gather each location's PDFs

Download the monthly statement from every store's operating account, the payout statement from the POS or card processor, and any location credit card. Multi-unit operators usually have more accounts than a bank feed will comfortably handle.

Upload to the converter

Drag the statements into the tool above. Upload one store's month or every store's quarter in a single session. Each file converts on its own, so you always know which location a downloaded QBO file belongs to.

Review the transactions

PDFQBO reads the date, description, and amount on each line and keeps deposits and withdrawals on the correct side. Check the table, confirm the POS deposits and franchisor sweeps, then export a QBO or IIF file per account.

Import and tag by location

Upload each QBO file to the matching bank account in QuickBooks Online, or import the Web Connect or IIF file in Desktop. Then code each line and assign the location's class or location tag so store-level reports actually work.

Why franchise books are hard to get into QuickBooks

Every location is another stack of statements

A single store means an operating account, a merchant payout account, and a card. Five stores means fifteen accounts and fifteen PDFs a month, and bank feeds break, disconnect, or simply never existed for the older accounts. Converting the statements gives you a workflow that scales the same way whether you run one unit or twenty: download the PDF, convert it, import it, tag it. Nothing depends on a feed staying connected, and adding a store means adding a file rather than rebuilding your process.

Royalty and ad fund sweeps are not just expenses

Most franchisors pull an ongoing royalty as a percentage of gross sales and, on top of it, a national or regional advertising fund contribution, commonly around 1 to 3 percent of sales. They usually leave the bank as automatic ACH debits, weekly or monthly. Those belong in their own general ledger accounts, not lumped into a catch-all fees line, both because they are large deductible expenses and because you should be reconciling them against the franchisor's royalty statement and your own POS gross sales. Converting the statement gets every sweep in with its exact date and amount, which is the only way to catch the month you were overbilled.

The initial franchise fee is amortized, not expensed

The lump sum you paid to buy the franchise is generally treated as a Section 197 intangible and written off over 15 years, unlike the ongoing royalty and ad fund payments, which are deductible in the year you pay them. Both leave the bank account looking like an ordinary payment to the franchisor. Getting them into QuickBooks as separate dated lines from the converted statement is what lets your accountant capitalize the one and expense the other instead of guessing at year-end.

Store-level profit is the whole point

A consolidated profit and loss tells you the group made money. It does not tell you that store three has been losing money for two quarters while store one carries it. QuickBooks handles this with class or location tracking, but the tags only work if every transaction is actually in QuickBooks and correctly attributed. Converting each location's statements separately keeps that attribution clean from the start, so the per-store report you hand your lender or your franchisor is real.

Built for multi-unit books

One tool for every account at every location, so a whole group's month goes into QuickBooks in one session.

Every location in one pass

Upload all your stores' statements together and get a separate QBO file back for each account. Import each one into its matching QuickBooks bank account so nothing gets crossed between locations.

Franchisor sweeps captured

Royalty and ad fund ACH debits are just lines on a statement until they are in QuickBooks. Converting gets each one in dated and exact, so you can reconcile them against the franchisor's royalty statement and your POS gross sales.

POS payouts net of fees

Card batches arrive net of the processor's cut, so the bank shows less than the store rang up. Converting the payout statement lets you split gross sales from fees and tie the net back to the deposit.

No dependence on bank feeds

Feeds disconnect, banks change platforms, and history rarely backfills past a few months. A PDF statement always exists, and converting it gives you a path into QuickBooks that never breaks in the middle of a close.

Catch up a whole group

Took over a store mid-year, or fell behind across the group? Upload a quarter or a year of statements from every location together and convert them in one session, with each file tracked on its own.

Reads any bank's layout

Stores in different states often bank in different places. A national bank, a regional bank, a credit union, or a processor each format a statement their own way, and PDFQBO finds the transaction rows on all of them.

Who uses it in franchising

Anyone keeping a franchised or multi-location business's books in QuickBooks from PDF statements.

Multi-unit franchisees

Three, five, or fifteen stores, each with its own accounts. Converting every statement each month is the fastest way to get all of them into QuickBooks and see a real profit and loss per store, not just for the group.

Single-unit owners buying in

A new franchisee inherits an opening balance, a fee schedule, and a statement history that predates the bank feed. Converting those first months puts the whole story in QuickBooks so the initial fee, royalties, and buildout costs are coded right from day one.

Restaurant and retail brands

POS deposits net of fees, food or inventory cost, and a royalty on gross sales define the margin. Converting the statements gets every deposit and sweep in so store-level margin is measurable instead of estimated.

Bookkeepers with franchise clients

Every client hands you a different pile of PDFs and a different franchisor's fee structure. One converter for every account and every bank gives you a repeatable close, however many locations a client operates.

Common franchise categories once the transactions are in

Once each location's statements are converted and imported, you code the transactions and tag them to a class or location. These are the accounts a franchise owner leans on most, and getting every transaction into QuickBooks is what makes store-level reporting and your tax return trustworthy.

• Royalty expense for the ongoing percentage of gross sales the franchisor sweeps, in its own account rather than a generic fees line.
• Advertising fund contributions for the national or regional marketing fee, kept separate from your own local marketing spend.
• Franchise fee (intangible asset) for the initial fee paid to buy in, capitalized and amortized rather than expensed in year one.
• Merchant and processing fees for the cut the card processor takes out of each POS batch before it reaches the bank.
• Cost of goods sold for food, product, or supplies bought from the franchisor's approved vendors, tracked per location.
• Rent, payroll, and location overhead tagged to the store that incurred them so one location's losses never hide inside the group total.

For a step-by-step on coding the imported lines, see the guide on categorizing bank transactions in QuickBooks. For handling several accounts at once, see importing multiple bank accounts, and for the buildout, recording depreciation.

Frequently asked questions

How do I get a franchise bank statement into QuickBooks?

Convert the PDF statement to a QBO file, then import it into that location's bank account. Upload the operating, merchant, or card statement to PDFQBO, review the POS deposits, royalty sweeps, and expenses it reads, and download a QBO (Web Connect) file. In QuickBooks Online you upload it from the Banking screen; in Desktop you import the Web Connect or IIF file. Then code each line and tag it to the store's class.

How do I record franchise royalty fees in QuickBooks?

Record the ongoing royalty as a deductible operating expense in its own account, dated to the day the franchisor swept it from the bank. Do not bury it in a general fees or dues account, because it is usually one of the largest line items you have and you need it reconcilable against the franchisor's royalty statement. Converting the bank statement gets each sweep into QuickBooks with the exact amount actually taken.

Is the initial franchise fee an expense or an asset?

The initial franchise fee is generally an intangible asset amortized over 15 years, not an expense you deduct in the year you paid it, while ongoing royalty and advertising fund payments are deductible when paid. Both come out of the same bank account, so the statement alone will not tell them apart. Getting them into QuickBooks as separate dated lines lets your accountant treat each one correctly. Confirm your specific facts with your CPA.

How do I track multiple franchise locations in QuickBooks?

Use class or location tracking so every transaction carries the store it belongs to, then run a profit and loss by class to see each unit separately. QuickBooks Online with location tracking, or Advanced for larger groups, handles this well. The tags only work if every transaction is actually imported, so converting each location's PDF statements is what makes store-level reporting possible.

Should each franchise location have its own bank account?

Most multi-unit operators keep a separate operating account per location, because it makes royalty sweeps, POS deposits, and store expenses trace cleanly to one unit and reconcile without guesswork. The trade-off is more statements to process every month. Converting the PDFs is what keeps that manageable: each account produces its own QBO file that imports into its own QuickBooks register.

Why does my royalty payment not match my POS sales?

Differences usually come from timing, from revenue the agreement excludes from the royalty base, or from a POS reporting error. To find out which, you need both numbers side by side: the actual sweep from the bank and the gross sales from the POS. Converting the bank statement gets the real amounts into QuickBooks, so you can compare them month by month instead of trusting the franchisor's figure by default.

Get every location's statements into QuickBooks

Upload each store's operating, merchant, or card PDF, review the deposits and franchisor sweeps, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.

Convert a statement View pricing