Skip to content
itsorted.online
Accounting guide

POS Sales Into Xero: Daily Summaries vs Every Transaction

Every POS system in Singapore can send sales to Xero, but they don't all do it the same way. Some post one invoice per shift, some a daily summary, some every single sale. The choice affects how easy your bank reconciliation is, how cluttered your Xero file becomes and whether stock in Xero means anything. This guide explains the options, how to split cash, NETS, card and PayNow so each matches its own bank deposit, and when per-transaction syncing is worth it. It covers the software side; agree account and GST treatment with your accountant.

By IT Sorted teamReviewed 7 min readHow we write guides
in

Key takeaways

  • Xero's own POS integration guide recommends summarising sales by payment type.
  • StoreHub creates one Xero invoice per closed shift per register, with returns as credit notes.
  • Map each payment method (cash, NETS, card, PayNow) to its own bank or clearing account.
  • A payment method left unmapped in StoreHub pauses the Xero sync until you map it.
  • Track stock in the POS; tracked inventory in Xero works better with per-item data.
In this guide · 7 sections
  1. 01Three ways a POS can post sales to Xero
  2. 02What popular POS systems do
  3. 03Split every summary by payment method
  4. 04Inventory: where stock should live
  5. 05Setting it up: step by step
  6. 06Do it yourself or get help?
  7. 07Frequently asked questions

Short answer

For most shops and F&B outlets, send a daily or per-shift summary to Xero, split by payment method, with each method posted to its own clearing account that you match to the bank deposit. Sync every transaction only if you need customer-level invoices or Xero must track stock. Keep stock in the POS.

Three ways a POS can post sales to Xero

Check which method your POS's Xero integration uses before you connect it. The Xero App Store's point of sale category notes that every POS app's integration can be different.

MethodWhat appears in XeroGood forDownside
Daily summaryOne invoice or journal per day, per outletMost retail and F&BNo customer or item detail in Xero
Per-shift or per-register summaryOne invoice per closed shift on each registerOutlets with several registers and shiftsMore entries to match against bank deposits
Every transactionOne invoice per saleBusinesses invoicing named customers (B2B, trade counters)Thousands of entries; harder reconciliation

Xero's developer guide on integrating a POS system with Xero describes summarising sales for each payment type, so daily figures are clearly labelled for cross-checking against the POS, and says this approach aligns well with bank reconciliation.

Split every summary by payment method

A summary that posts all sales as one lump can't be matched to the bank, because cash, NETS, cards and PayNow arrive at different times, in different amounts and with different fees.

Payment methodHow it usually reaches youMap it to
CashBanked by you, often not dailyA cash on hand or undeposited cash account
NETSSettled by NETS or your acquiring bankNETS clearing account
Cards (Visa, Mastercard, Amex)Settled by your card terminal provider, minus feesCard clearing account (one per provider)
PayNow / SGQROften straight to the bank, sometimes via a providerBank account, or a clearing account if a provider settles it
Vouchers and gift cardsNo money on the day; prepaid earlierGift card liability account

StoreHub's mapping article shows the pattern: for each payment type, pick a matching Xero bank or current asset account, map tax codes and accounts, and check every payment method, tax code and product is mapped, because an unmapped one pauses the Xero sync. Xero's POS guide also says gift cards and vouchers should be tracked as a current liability.

Inventory: where stock should live

Stock is where summary syncing and Xero can clash. Xero's tracked inventory counts quantities and records cost of goods sold as items are traded, which needs item-level sales data.

Keep stock in the POS

  • POS already knows every item sold
  • Works with daily or shift summaries
  • Variants, modifiers and recipes handled by the POS
  • Post a cost of sales journal monthly from the POS stock report

Track stock in Xero

  • Needs item lines for every product synced
  • Every product must match between POS and Xero
  • Unmatched products can stop the sync
  • Breaks down with modifiers, bundles and recipes

For most shops and F&B outlets, the POS is the stock system and Xero holds the financial totals. If you also sell online from the same stock, our guide to omnichannel POS and inventory covers keeping one stock count.

Setting it up: step by step

These steps apply to most POS integrations.

  1. Agree the chart of accounts with your accountant

    Sales accounts (for example food and beverage, or product categories), discounts, gift card liability, rounding, and a clearing account per payment method.

  2. Choose summary level

    Daily or per-shift summary for most outlets; per-transaction only if you invoice named customers or Xero must track stock.

  3. Map payment methods, tax codes and outlets

    Each payment type to its account, each POS tax code to the right Xero GST rate, and each outlet to a tracking category if you have several.

  4. Run one week in parallel

    Compare the POS end-of-day report with what reached Xero, for every day and payment method.

  5. Reconcile deposits to clearing accounts

    Match each NETS, card and PayNow deposit to its clearing account; record fees as expenses.

  6. Review clearing balances monthly

    A balance that grows means missing deposits, unrecorded fees or refunds not synced.

Do it yourself or get help?

If your POS has a native Xero integration and you have one outlet, follow its setup guide, map every payment method, and run a week in parallel. The work is in the mapping; most problems come from one unmapped payment type or a wrong tax code.

Our Sales & Payout Sync (S$490) connects up to 3 sales channels, such as your POS, online store and a marketplace, to Xero, QuickBooks or Zoho Books, posts each day's sales and payouts as summaries with fees and refunds split out, agrees the account and tax mapping with your accountant, and checks one month of payouts against your bank. It doesn't include bookkeeping, and connector fees, if any, are paid by you.

Frequently asked questions

For most shops and F&B outlets, a daily or per-shift summary split by payment method is better. It keeps Xero tidy, matches how money reaches your bank and is what Xero's own POS integration guide describes. Send every transaction only if you invoice named customers through the POS or need Xero to track item-level stock.

StoreHub's help centre says that when you close a shift, sales, payments and inventory are sent to Xero as one invoice per closed shift on each register, with an item breakdown and payment methods. Returns go to Xero as credit notes. Every payment method, tax code and product must be mapped, or the sync pauses until you map it.

Map each payment method to its own account. Use a clearing account for NETS and each card provider, and the bank account or a clearing account for PayNow, depending on how it settles. When the deposit arrives, match it to the clearing account and record any fee as an expense, so sales stay at the full amount.

Yes. Xero Central says the Shopify integration by Xero imports a daily summary of Shopify sales and refunds as invoices or bills, and Shopify POS sales are part of the same store. Check the payment gateway mapping so in-store card, cash and online payments each go to the right account.

Usually in the POS. It already records every item, variant and modifier sold. Xero's tracked inventory needs item-level sales data and matching products in both systems, which doesn't fit daily summaries. Many businesses keep stock in the POS and post a periodic cost of sales journal to Xero from the POS stock report.

Rather have it done for you?

Fixed price, set up in your own accounts.

Order online, get a written scope, and keep full ownership of everything we set up. Questions first? Ask us in writing.