Bank Statement to QuickBooks for Franchises: Convert Multi-Unit Statements to QBO

A royalty fee is a percentage of gross sales you pay the franchisor, usually pulled by ACH every week or every month. Treat it as an operating expense (a royalty expense account), never as a reduction of your sales. Book the full gross sales your registers rang up, then record the royalty pull separately. If you net the royalty against sales, your top line understates real volume, your royalty cost disappears, and any franchisor audit or lender review will not tie out to your point of sale reports.

Most franchise agreements also require an advertising or brand-fund contribution, again a percentage of sales remitted to a national or regional marketing fund. This is a different obligation from the royalty, so give it its own advertising-fund expense account. Keeping royalty and ad-fund on separate lines lets you confirm each pull matches the percentage in your agreement.

Many franchisors bill a technology or software fee for the required POS system, back-office reporting, or online ordering platform. Book it as its own expense (a technology or software subscription account) rather than lumping it into royalties. When the fee is fixed per location, this line makes it easy to check that you were charged for the right number of open units.

The lump sum you paid to buy into the brand, the initial franchise fee, is not a same-year expense. It is an intangible asset that you capitalize and amortize over time. For US federal tax, a franchise right is a Section 197 intangible and is generally amortized over 15 years, while the book life may instead follow the term stated in your franchise agreement. Renewal fees and transfer fees usually follow similar logic, capitalized and amortized rather than expensed at once. The exact treatment and period depend on your facts, so confirm both with a CPA before you set up the asset and its amortization schedule.

How you handle multiple locations is the single most useful decision in your setup, because it determines whether you can ever see a store-by-store profit and loss. Two structures cover almost everyone.

If all your units run inside one QuickBooks company file, tag every single transaction with a QuickBooks class or location that identifies the unit it belongs to. Sales, royalties, rent, payroll, and vendor bills each carry the store tag. Then a Profit and Loss by Class (or by Location) report gives you a clean column per unit, and you can spot the location that is quietly losing money. This fits owners who want one consolidated set of books and one login. The discipline required is that nothing gets posted without a class.

If each location is its own legal entity, and a separate LLC per store is common for liability reasons, you may prefer a separate company file for each entity and then consolidate the results in a spreadsheet or a reporting tool. Separate files keep each entity's taxes and banking clean and match how your returns are filed. The trade-off is more files to maintain and a manual roll-up for a portfolio view. Match the structure to how your attorney set up the entities, and confirm with your CPA.

Your daily card batch does not hit the bank at face value. The processor keeps its cut and deposits the net. If you record only the deposit, your sales are understated and the fee never appears. Record the gross sales your POS reported, then record the processing fee as its own expense so the two reconcile to the net deposit on the statement.

Sales tax you collect from customers is a liability you hold and later remit to the state, never income. Post it to a sales tax liability account so it does not inflate revenue. When you pay the state, the payment clears that liability.

Gift cards you sell are also a liability, a form of deferred revenue, because you have taken cash but still owe the customer product. Hold the sale in a gift card liability account. Only when the card is redeemed do you move that amount out of the liability and into sales. This keeps you from booking revenue you have not yet earned.

Third-party delivery is the same trap as card processing. DoorDash, Uber Eats, and Grubhub pay you the order value minus their commission, so the deposit is net. Book the gross sale and record the delivery commission as an expense. Only then can you see the true cost of each channel and decide whether that delivery volume is actually profitable for a given unit.

Fixed costs are where per-unit reporting earns its keep. Rent and common area maintenance (CAM) charges, equipment leases for ovens, coolers, or signage, and payroll all belong to a specific store, so class each of them by location. When rent, CAM, leases, and labor all carry the right store tag, your Profit and Loss by Class shows the full cost of running each unit, not just its sales.

If you pay independent contractors such as repair technicians, equipment servicers, or cleaning crews, you may owe them a Form 1099-NEC. For payments made on or after January 1, 2026, the reporting threshold is $2,000, and it is indexed for inflation after that. Track those vendor payments through the year, and confirm who needs a form with your CPA.

How do I record franchise royalty fees in QuickBooks?

Record the royalty as an operating expense, not as a reduction of sales. Book the full gross sales your registers rang, then post the franchisor's ACH pull to a royalty expense account and tag it with the location's class. That way your top line reflects real volume and your royalty cost stays visible for lender reviews and franchisor audits.

How do I track multiple franchise locations in QuickBooks?

Inside one company file, turn on class or location tracking and tag every transaction, sales, royalties, rent, and payroll, with the unit it belongs to. Then run a Profit and Loss by Class to get a column for each store. If your locations are separate legal entities, keep a company file per entity and consolidate the results outside QuickBooks.

Is the initial franchise fee an expense or an asset?

It is an asset, not a same-year expense. The initial franchise fee buys an intangible right, so you capitalize it and amortize it over time. For US federal tax it is a Section 197 intangible amortized over 15 years, while the book life may follow your agreement term. Confirm the treatment and period with a CPA.

Should each franchise location be a separate QuickBooks company?

It depends on your legal structure. If each store is its own LLC or corporation, a separate company file per entity keeps taxes and banking clean and matches how you file. If the units share one legal entity, one file with class tracking per location is simpler and still gives you store-by-store reports. Ask your CPA which fits.

How do I record gift cards in QuickBooks?

Treat a gift card sale as a liability, not income, because you owe the customer product. Post the cash received to a gift card liability account (deferred revenue). When the customer redeems the card, move that amount out of the liability and into your sales income account. This keeps you from recognizing revenue before you have actually earned it.

How do I import a bank statement into QuickBooks?

QuickBooks does not read a PDF directly, so first convert the statement to a .qbo Web Connect file using the converter at the top of this page. In QuickBooks Desktop, go to File > Utilities > Import > Web Connect Files and select the .qbo file. In QuickBooks Online, open Transactions > Bank transactions > Upload from file, then match the account and review each line.