Quick answer
Your point-of-sale system already holds the numbers you need to plan cash and borrow well. Pull monthly sales for the last two years, sales by day and hour, average transaction value, product or service mix, refunds and voids, and payment-type splits. Compare them with your bank statements and GST returns, then use them to map seasonal gaps and show a lender how your business trades.
Key points
- Monthly sales over two years reveal your real seasonal pattern.
- Day-and-hour reports show where rosters and opening hours can change.
- Average sale and product mix show how to lift takings without more customers.
- POS data should reconcile with bank statements and GST returns.
- Lenders find POS reports a useful complement to bank statements.
Behind most café counters and shop tills sits a small goldmine that rarely gets opened: the reporting section of the point-of-sale system. It knows how many flat whites you sold last July, what time Saturday trade peaks, which product lines carry the shop, and how this December compared with the last two.
Most owners only look at the daily total. But a handful of POS reports, pulled once a month, can transform how you plan cash — and how a lender sees your business when you ask for funding.
Why does POS data matter for cash planning?
Cash flow planning, as business.govt.nz describes it, is about forecasting the money coming in and going out so you can see shortfalls before they happen. For a main-street business, the “money coming in” side is mostly sales — and your POS system holds a detailed history of exactly that.
Bank statements show the money landing. POS reports show why it landed: which days, which hours, which products, which customers. That detail is what turns a rough guess into a forecast.
The six reports worth pulling
1. Monthly sales for the last two years. This is the foundation. Two years lets you see whether a quiet month is seasonal (it happened last year too) or a genuine change. Use it to set the season pattern in the cash gap estimator.
2. Sales by day of week and hour. Shows when you’re busy and when you’re paying staff to wait. It’s the basis for smarter rosters and opening hours — and for spotting a weekday drop if nearby offices empty.
3. Average transaction value. If you can lift the average sale, you can lift takings without needing more customers. Watch how it moves through the year and after price changes.
4. Product or service mix. Which lines sell, which carry the margin, and which tie up stock. For retailers, this is how you decide what to reorder for next season. For cafés, it shows whether food or coffee drives the business.
5. Refunds, voids and discounts. Unusual patterns can point to process problems, staff errors or something worth looking into. Lenders and buyers sometimes ask about them.
6. Payment type split. Card, eftpos, cash, online, gift cards and accounts. This matters because cash takings don’t always show clearly in bank statements, and online platform payouts can arrive on a different schedule.
How do POS reports line up with your other numbers?
Your POS figures should broadly match two other sources:
| Source | What it shows | Why differences happen |
|---|---|---|
| POS reports | Sales recorded at the till | Includes cash and items later refunded |
| Bank statements | Money received | Settlement timing, fees, tips, platform payouts |
| GST returns | Sales declared to Inland Revenue | Accounting basis and filing period |
Small differences are normal. Large ones are worth understanding — preferably with your accountant — before you apply for funding or try to sell the business. A buyer doing due diligence will cross-check exactly these three sources, as our guide to buying an existing café explains.
Using POS data to plan the year
Stock. Last year’s product mix and sell-through tell you how much to order for the next season, and when. See seasonal stock funding.
Staff. Day-and-hour reports show when to add or trim shifts, and when to start the summer team.
GST. Business.govt.nz says GST is 15% of your sales. Using your monthly sales history, you can estimate each GST payment ahead of time. If you file 2-monthly, Inland Revenue’s filing schedule means the GST on your busiest months follows shortly after — often as trade quietens.
Gaps. Put your monthly sales into the cash gap estimator with your fixed costs and lump sums. The months that dip below zero are where a plan — or funding — is needed.
Mapping a gap already? Start a 60-second enquiry and talk it through — there’s no credit check to ask.
Using POS data when you borrow
Bank statements are still the core document most lenders ask for. But POS reports strengthen your story by showing:
- Seasonality — “July is always our quietest month, and here are two years proving it”
- Resilience — average sale holding up even when customer numbers dip
- Purpose — “this range sold through 80% last Christmas, so we want to order more”
- Recovery — weekly sales climbing back after roadworks or weather
Bring a simple one-page summary: monthly sales for two years, your top products or services, and a sentence explaining any unusual months. It makes the first conversation far more productive.
An illustrative example
Illustrative only. A bookshop owner wanted funding for a bigger Christmas order. Their bank statements showed a strong December but didn’t explain why. Their POS reports did: two years of monthly sales showing a consistent November–December peak, a product mix report showing which categories sold through, and a payment split showing a growing share of gift-card sales redeemed in January.
The owner used those reports to size the order, plan the GST payment that would follow, and explain the request in one page. The conversation took twenty minutes instead of two hours.
Setting your POS up to report well
Reports are only as good as the data behind them. A few set-up choices make a big difference:
- Use clear product categories. Group items the way you think about your business — coffee, food, retail, services — so the mix report means something.
- Record discounts and staff meals properly rather than voiding sales, so margins aren’t hidden.
- Link your POS to your accounting software where possible, so sales flow through without re-keying.
- Keep payment types separate. Card, cash, online, account and gift card sales each behave differently for cash flow.
- Train staff to use the same buttons for the same things, every time.
If your POS has been set up badly for years, it’s still worth fixing now. In twelve months you’ll have a clean year to compare against.
A monthly 20-minute numbers routine
Once a month, sit down with a coffee and work through the same short list:
- Total sales for the month, against the same month last year
- Average sale, and whether it’s moving up or down
- Best and worst sellers — anything to reorder, drop or reprice?
- Busiest and quietest hours — do your rosters still match?
- Next three months of bills — GST, tax, levies, insurance, rent reviews
- Update the cash gap estimator if anything has changed
Twenty minutes a month won’t make you an accountant, but it will make you the owner who sees a cash gap coming in time to do something about it.
What if your POS can’t produce these reports?
Older or very basic systems sometimes can’t. In that case, export whatever sales data you can into a spreadsheet each month, and use your bank statements and GST returns to fill the gaps. If you’re due for an upgrade anyway, choose a system with good reporting and accounting integration — it will repay the effort many times over.
Sharing your numbers with your accountant
Your accountant sees your business once or twice a year through the annual accounts. Send them your monthly POS summary as well, and they can spot problems — margins slipping, a product line losing money, tax estimates that need updating — months earlier. Many accountants would far rather have a short monthly email than a shoebox of surprises at year end. It also means that when you ask for funding, your accountant already knows the story behind the numbers and can support it.
Let your numbers do the talking
If your POS reports point to a gap — a season to stock for, a quiet stretch to bridge, a tax bill to plan — start your 60-second enquiry. Asking doesn’t involve a credit check, your enquiry stays with one team rather than going to a list of lenders, and a person who understands main-street trade will phone you. The more accurate your numbers on the form, the better we can match you first time.
Frequently asked questions
Do lenders accept POS reports instead of bank statements?
Usually not instead of — bank statements remain the core document. But POS reports add detail lenders find useful, such as seasonality, average sales and product mix, and they help explain your story.
My POS and bank deposits don't match. Is that a problem?
Small differences are normal — card settlement timing, tips, refunds and fees. Large or unexplained gaps are worth investigating with your accountant before you apply for funding.
Which POS report matters most for cash planning?
Monthly sales for at least the last two years. It shows your true seasonal pattern, which is the starting point for planning stock, staff and tax.
How often should I look at my POS reports?
A quick weekly look at sales against the same week last year, and a deeper monthly review, is a good rhythm for most main-street businesses.