Portland Restaurant and Café Bookkeeping: Reconcile POS Sales to Cash

Close by sales channel, not just by bank account

A restaurant may receive money from counter service, table service, online ordering, delivery platforms, catering, and gift cards. Even when all funds reach one bank account, each channel has its own fees, settlement dates, refunds, and reports. Build a monthly channel list and assign one person to obtain each statement.

Choose a consistent close period for the point-of-sale system and preserve the source reports. If a late-night service period crosses midnight, document how the report dates are selected. The objective is not to force every system to show the same daily total; it is to explain the differences so nothing disappears between the POS and the ledger.

Work through the settlement before recording the payout

Consider a fictional restaurant whose card report shows US$10,000 of food and beverage sales, US$300 of customer refunds, and US$1,700 of voluntary employee tips collected on cards. If the processor deducts US$300 of fees and settles all of that activity together, the bank receives US$11,100: 10,000 minus 300 plus 1,700 minus 300.

That US$11,100 deposit is not a clean measure of restaurant sales or profit. Keep the US$9,700 of sales after refunds, the employee-tip amount, and processor costs separately visible. This is bookkeeping arithmetic for the stated facts; other charges, sales channels, timing differences, tax rules, and tip arrangements can change the actual entry.

If the payout differs, investigate unsettled transactions, chargebacks, reserves, or an earlier fee adjustment. Attach the explanation to that month’s reconciliation. Avoid recording the difference as miscellaneous income or expense solely to make the bank balance match.

Reconcile delivery and ordering platforms individually

For each platform, retain the transaction statement and agreement. Identify customer order value, restaurant-funded promotions, platform-funded promotions, commissions, advertising, refunds, dispute adjustments, and the resulting payout. The account names should reflect the actual agreement and the preparer’s treatment; a platform’s dashboard label does not settle every accounting question.

Use one clearing balance per channel when practical, then review balances that remain outstanding after the expected settlement period. Check whether a refunded order also appears in the POS refund report. The same reversal should not be counted twice because two systems describe it.

When Form 1099-K arrives, reconcile it with the underlying merchant records. IRS guidance says its gross payment amount is not adjusted for items such as processor fees and refunds. The form is a reporting document to review alongside the books, not an instruction to add the same sales a second time.

• IRS: What to Do with Form 1099-K

Distinguish employee tips from mandatory charges

The IRS distinguishes voluntary tips from employer-imposed service charges. Distributed service charges are wages rather than tips for federal reporting purposes. Keep the POS configuration, receipts, and payroll mapping clear enough to trace a collected amount through to the worker payment or the business’s records.

Maintain the tip reports and payout reconciliation without assuming that the amount shown on one terminal captures all cash or shared tips. If the policy changes, record the effective date and give the payroll provider the updated policy before processing the affected pay period.

Oregon BOLI says tips cannot offset the required minimum wage. Review lawful tip-pool participation and the compensation process with qualified help; a spreadsheet distributing cash does not itself establish compliance. This guide does not assume that every restaurant is subject to the same federal information-return rules.

• IRS: Tip Recordkeeping and Reporting
• Oregon BOLI: Minimum Wage and Tips

Keep cash, gift cards, and deposits from obscuring the picture

A daily cash sheet should show the opening float, cash sales, cash refunds, authorized payouts, cash retained, and bank deposit. Have someone review unexplained overages or shortages rather than repeatedly hiding them inside sales. The owner needs to know whether the difference is a process error, timing issue, or something requiring investigation.

Track gift cards and customer deposits through sale, redemption, refund, and outstanding balance. A gift-card redemption can settle an existing customer balance without bringing new cash into the restaurant that day. Keep the terms and activity schedule for the preparer to determine the applicable accounting and tax treatment.

Catering deposits deserve the same attention. Store the event agreement, cancellation terms, invoices, and payment applications together. An event moving into another month should not leave an unexplained balance in the books.

Review food costs and labor using consistent records

Code supplier invoices consistently and record returns or credits. Keep food, beverages, packaging, and other meaningful categories visible without creating a category for every ingredient. Use a repeatable inventory-count process and record spoilage or unusual waste so purchases can be understood in the context of stock changes.

For labor, retain approved time records, payroll reports, and correction details. Oregon requires records of daily hours for non-exempt employees and itemized earnings statements. Compare payroll activity with the restaurant’s operating pattern and investigate missing or inconsistent data before trying to evaluate staffing costs.

Use these records for management decisions without pretending that one ratio proves the business is healthy. A sales promotion can raise order volume while increasing packaging, delivery, and labor costs. A useful monthly report makes those relationships visible.

• Oregon BOLI: Paid Time and Time Records

Keep operating licenses and tax scope on the handoff list

Oregon’s Department of Agriculture directs restaurants and mobile food operators to local county health departments for food-service licensing. Preserve the relevant license and inspection documents in the operating file, with a person responsible for changes and renewals. Those documents are distinct from a tax account or a reconciled general ledger.

For the accountant handoff, supply the final POS reports, channel reconciliations, merchant forms, payroll and tip schedules, supplier balances, inventory records, gift-card balances, and event deposits. Identify any business-location or entity changes. Ask explicitly which local returns, payroll work, and bookkeeping cleanup are included in the engagement.

• Oregon Department of Agriculture: Food Safety Licenses