Xero for Restaurants: The 30-Day Fix to Find Hidden Cash

Key takeaways

• Unlock dollar for dollar tax relief by capturing the FICA tip credit and WOTC, owners routinely free up five figures that would otherwise be left unclaimed.
• Avoid IRS mismatch notices by grossing up delivery sales and tying them to platform statements, then reconciling to Form 1099-K totals.
• Cut 5 to 10 hours a week in reconciliation by posting one daily sales summary, using undeposited funds and platform clearing to match real deposits.
• Drop prime cost by 2 to 4 points with weekly inventory counts, a true usage COGS, and labor mapped by function to your P and L.
• Stop cash leaks by isolating sales tax and tips in dedicated accounts, trust funds do not get spent.

Restaurant chart of accounts in Xero that actually works

Most books fail at the restaurant chart of accounts. If you get this wrong, everything else is noise. Build a chart that mirrors your service channels, deposits, and vendor flows.

Revenue by channel and product

• Food sales dine in, takeout, delivery, catering
• Alcohol sales beer, wine, spirits
• Gift card sales as a liability, not revenue
• Discounts and promos as a contra revenue account
• Service charges as operating revenue, not tips

COGS and operating expenses that align to purchasing

• COGS: food, beverage non alcoholic, alcohol, paper and packaging
• Delivery platform commissions in operating expenses, not COGS
• Controllables vs fixed: FOH payroll, BOH payroll, management, payroll taxes and benefits, repairs, utilities, rent and CAM, marketing and delivery platform marketing, merchant fees, software, smallwares and linen, vehicle and delivery

Clearing and control accounts

• Undeposited funds cash and undeposited funds credit cards
• Delivery platform clearing per platform when volume is high
• Gift card liability, sales tax payable per state if needed

Set a written materiality rule on day one. Capitalize only items above your threshold, for example one thousand to two thousand dollars, everything under that is expensed.

POS integration in Xero without a mess

Direct POS pushes clutter your ledger and rarely tie to the bank. The cleaner path is one daily sales summary per location that mirrors the Z read.

• Credit revenue by channel and product on separate lines
• Debit discounts and promos, debit cash over short for drawer differences
• Credit sales tax payable
• Debit tips payable if you collect for payroll distribution
• Debit undeposited funds cash for cash and checks, undeposited funds credit cards for card batches
• Debit delivery platforms clearing for platform orders at gross before commissions

When deposits hit the bank feed, match them to undeposited funds or the platform clearing. Keep the detail in the POS where it belongs, your GL should mirror money movement.

Key insight: One clean daily journal entry provides audit ready sales by channel, and it is the only way your books will ever agree to your bank without heroics.

Delivery platforms and Xero reconciliation the right way

DoorDash, Uber Eats, and Grubhub are third party networks with their own fees, refunds, and tax handling. If you only book the net deposit, your revenue and cost are wrong and your 1099-K will not match.

• Treat each platform as its own sub ledger and map gross sales, discounts, and refunds from the statement
• Record sales tax collected by the platform in your daily entry, then offset it in the platform clearing since the platform usually remits
• Book platform commissions and marketing as operating expenses, not as discounts
• Record driver tips that never pass through your payroll as non cash to the restaurant
• Post deposits to the platform clearing, then reconcile to zero each month, see third party delivery reconciliation

Match platform gross sales to Form 1099-K totals at year end. The IRS set a transitional $5,000 threshold for 2024, which brings many more restaurants into scope, see the IRS announcement on the Form 1099-K reporting threshold.

Bank feeds, bank rules, and clearing accounts that save hours

Use bank feeds to confirm what your GL already knows, not to drive your accounting. A few rules remove friction and errors.

• Match merchant processor deposits to undeposited funds credit cards
• Match platform deposits to the specific platform clearing account
• Create rules for routine vendors like utilities, trash, and subscriptions with correct account and memo
• Separate owner draws and partner distributions from payroll
• Split loan payments between principal and interest with a repeating bill or bank rule
• Require a second pass to review reconciliations monthly before closing

Consider dedicated bank accounts for payroll, sales tax, and tips payable. Visibility and discipline protect cash.

Inventory and COGS in Xero that support menu pricing

Xero is not a restaurant inventory system, you do not need it to be. You need usage based COGS you can compare to sales weekly.

• Use the periodic method, count monthly or every four weeks, and post adjustments to food, beverage, and alcohol cost
• For larger operations, count key items weekly and the rest monthly
• Structure purchasing to match COGS buckets and recode misposted invoices before approval
• Enter credits for returns and shortages so usage is true

Calculate prime cost weekly, COGS plus total labor including taxes and benefits, divided by sales. Full service targets often sit around sixty to sixty five percent, quick service can do better.

Payroll, tips, service charges, and the FICA tip credit in Xero

Tips, service charges, and payroll mapping can make or break labor. The mechanics live in payroll, the proof lives in your GL.

• Treat tips as employee property, record tips payable in the daily sale, then clear it through payroll
• Treat service charges as revenue to the business, if distributed they are wages subject to payroll tax
• Map payroll by function to match the P and L, FOH, BOH, management, payroll taxes and benefits

Track eligible tips and claim the FICA tip credit annually on IRS Form 8846. It reduces income tax dollar for dollar, so do not wait until filing to figure it out.

Work Opportunity Tax Credit in a restaurant hiring process

The Work Opportunity Tax Credit rewards hiring from target groups such as veterans and long term unemployment recipients. Build it into onboarding so you do not miss certifications.

• Use Form 8850 at the job offer stage and submit to your state workforce agency on time
• Track hours and wages for eligible hires in payroll
• Claim the credit on your return after certification, max ranges from two thousand four hundred dollars to nine thousand six hundred dollars per hire

For details and target groups, see the Department of Labor guidance on the Work Opportunity Tax Credit.

Sales tax and marketplace facilitator law without double paying

Platforms often collect and remit sales tax on facilitated orders. Your job is to reflect this correctly so you do not double collect or double remit.

• For platform orders, book the gross sale and an offset for tax collected by the platform so sales tax payable only accumulates for direct channels
• For your POS orders, you collect and remit, record sales tax payable daily and move cash to a dedicated account if that discipline helps
• For catering that ships across states, confirm nexus and taxability, assumptions are expensive
• Each month, agree sales tax payable to filed returns and payments

Gift cards, deposits, and deferred revenue in Xero

Gift cards are not revenue on the day of sale, they are a promise. Treat them as a liability and recognize revenue when redeemed.

• Credit gift card liability on sale, debit the liability on redemption
• Track breakage per state rules and recognize only when earned
• Record event deposits to customer deposits liability, recognize revenue when the event occurs or when forfeited per contract

Multi location and service channel reporting with tracking categories

Use two tracking dimensions, location and channel. Tag every transaction, not just sales.

• Location: Downtown, Northside, Airport
• Channel: Dine in, Takeout, Delivery, Catering

This unlocks labor percent by store, COGS by store, and marketing ROI by channel. Without tags, a channel P and L is just a sales report.

Month end close for restaurants using Xero

Close on a schedule, not when you have time. Consistency is how cash leaks get caught while they are still small.

• Reconcile bank and credit card accounts to zero unreconciled
• Reconcile delivery platform clearing and undeposited funds to zero, investigate anything older than seven days
• Enter inventory counts and usage adjustments
• Review payroll by function against sales for reasonableness
• Amortize prepaids, record depreciation, tie loans to statements
• Scan P and L by vendor and account, fix misclassifications
• Review discounts, voids, comps, and promos as a percent of sales
• Agree sales tax payable to filings, document WOTC certifications

Restaurant KPI reporting that matters inside Xero

You do not need twenty dashboards. You need five reports that explain where the money went.

• P and L by location and channel with prior month and prior year
• Prime cost weekly and monthly
• Menu contribution margin for top sellers
• Labor productivity, sales per labor hour by day part
• Discounts, voids, comps with reasons and manager on duty

Set thresholds that trigger action, then act fast. When spirits cost breaks twenty five percent, investigate pours, spills, and comp policy the same day.

ADA access credit and barrier removal deduction that reduce tax

Two practical incentives apply to many dining rooms and patios. The Disabled Access Credit covers fifty percent of eligible access expenses above two hundred fifty dollars up to ten thousand two hundred fifty dollars of spend, capped at a five thousand dollar credit per year. The Barrier Removal Deduction lets any business deduct up to fifteen thousand dollars per year for qualified costs.

Eligible items include ramps, wider doorways, accessible restrooms, and tactile signage. Time projects before filing, keep detailed invoices that clearly describe the access improvement.

Lease agreements, maintenance, and capitalization policy that prevents surprises

Your lease can quietly add cost. Read percent rent definitions, CAM reconciliations, maintenance responsibilities, and tenant improvement allowances with care.

Adopt a written capitalization policy. Decide what you capitalize and depreciate versus expense. This keeps books consistent and simplifies audit defense.

Contrarian take on Xero and why process beats apps

Xero will not find you a single dollar in credits or reduce prime cost by itself. Software is a ledger, outcomes come from process and weekly review.

If you want a Do It For You partner that hunts credits, runs full stack bookkeeping with anomaly detection, explains the numbers, and files taxes with CPA validation, that is what Korefi.ai was built to own. Owners do not learn new software or chase a bookkeeper, Korefi handles it and is accountable for results.

Thirty day action plan to clean up Xero for a restaurant

Week one setup

• Lock last year
• Rebuild the chart of accounts and tracking categories
• Create clearing and undeposited funds accounts
• Map a daily POS summary template and start posting it every day
• Import vendor list, standardize names and categories

Week two reconciliation

• Reconcile bank and cards for the last two months
• Set bank rules for routine vendors and merchant deposits
• Create platform clearing accounts and reconcile the last sixty days
• Build a simple inventory count sheet and schedule the first count
• Map payroll categories to FOH, BOH, management, and taxes

Week three compliance and credits

• Implement tip handling through payroll, confirm service charge treatment
• Start WOTC pre screening for all new hires
• Document ADA projects and capture invoices
• Reconcile gift card liability to the POS, set a breakage policy where allowed
• Review sales tax handling per channel and platform, correct mapping

Week four close and reporting

• Do a hard month end close with a written tie out pack
• Produce the P and L by location and channel, a prime cost report, and a discounts and comps report
• Confirm 1099-K implications and that your mapping covers gross sales, facilitator collected tax, fees, and refunds
• List open issues with owners and due dates, publish next month’s close calendar

What to watch for that most owners miss

• Net platform deposits that hide fees, they understate revenue and distort cost rates
• Service charges treated like tips, that creates payroll tax exposure
• Gift card liability that never clears, redemptions may be double counted as new sales
• Discounts and comps buried in food cost, move them to contra revenue
• Sales tax double paid when facilitator orders flow into your direct filings

A final word on discipline and dollars

Xero works when it mirrors how money moves, daily sales in, deposits matched, platforms grossed up, payroll mapped by function, inventory counted on a cadence, and credits filed on time. That discipline earns credibility with lenders, landlords, and the IRS.

If you only do three things this week, set up the daily sales entry, reconcile delivery platform clearing, and start tracking the FICA tip credit. The money at stake is real, and the fixes are within reach.

FAQ

How do I set up Xero so my 1099-K from DoorDash and Uber Eats matches?

Post platform orders at gross into a delivery platform clearing account, book platform collected sales tax and refunds, and record commissions and marketing as expenses. Deposit the platform payouts to that clearing account and reconcile it to zero monthly, then tie annual platform gross to your Forms 1099-K.

What is the simplest way to post daily sales from my POS into Xero?

Use one daily sales journal per location that mirrors the Z read, revenue by channel, discounts, sales tax payable, tips payable, undeposited funds for cash and cards, and platform clearing for delivery orders at gross. Match deposits from the bank feed to those undeposited funds and clearing accounts.

Do I treat DoorDash and Uber Eats sales tax as my liability?

Usually the platform collects and remits for facilitated orders, so you record the gross sale and offset the sales tax in the platform clearing. Your sales tax payable should only accumulate for direct POS and catering orders you collect and remit yourself.

How should I map service charges and tips in payroll to avoid tax problems?

Tips are employee property, record a tips payable and clear it through payroll. Service charges are your revenue, if you distribute them they become wages subject to payroll taxes, do not net them against labor outside payroll.

Can my restaurant claim the FICA tip credit and how do I calculate it?

Yes, track charged and cash tips that exceed the amount needed to reach federal minimum wage for the pay period, then compute the employer share of Social Security and Medicare taxes on those excess tips. Claim it on Form 8846 with your income tax return, and maintain payroll level detail to support the numbers.

Do I need a separate system for recipe costing or can Xero handle inventory?

Xero can track periodic inventory and usage well enough for COGS and prime cost, but it is not a recipe or perpetual inventory system. Many operators count key items weekly, post adjustments in Xero, and keep recipe level detail in the POS or a lightweight kitchen tool.

What bank rules should I create first to save time each week?

Start with merchant processor deposits mapped to undeposited funds credit cards, platform payouts to each platform clearing, and fixed vendors like utilities, trash, and software with correct accounts and memos. Add a loan payment rule that splits principal and interest so balances stay accurate.

Who can help me catch credits and keep my clearing accounts clean if I do not have time?

A proactive partner that runs full stack bookkeeping and tax can own daily sales entries, delivery clearing reconciliations, and credit capture. For example, Korefi monitors tip credit eligibility and WOTC screening while keeping platform ledgers tied out, so owners get clean books and dollars back without managing the process.