Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

My POS cannot give me the reports or the links to other systems I need

Short answer

When the till's reports do not answer your questions, the usual route is to pull its data through its API or export and report from your own copy. The risks are incomplete data, orders that change after export, refunds, tax and time zones. Define the question and the numbers that must match first.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • I export to a spreadsheet every week and rebuild the same report.
  • My accountant asks for figures the till cannot produce.
  • I cannot see sales by supplier, staff member, hour or margin.
  • Totals in my own sheet differ from the till's.
  • My POS data has to reach my accounting or stock system.

Why does this happen?

  1. Built-in reports are general

    The standard reports answer common questions. A margin per supplier, sales per staff hour or a weekly comparison across shops usually needs data the report does not combine.

  2. Exports are snapshots

    A file taken today does not include a refund made tomorrow. Reports built on exports disagree with the live system unless recent days are re-read.

  3. Orders hold the full sale, payments hold the money

    In Square's model a payment is linked to an order that itemises the sale, taxes, discounts and service charges. A report that reads only payments misses discounts and items, and one that reads only orders misses how they were paid.

  4. Integration events repeat and arrive late

    When a link receives notifications from the till, the same one can arrive more than once, and an update can arrive out of order. A link that does not guard against it double-counts.

  5. Different definitions of a day and of tax

    A report by calendar day, by closing time or by time zone gives different totals. Tax-inclusive and tax-exclusive figures also differ.

What can I do about it today?

  1. Write the three questions you want answeredFor example: which items make the most profit, which hours need staff, what to reorder.
  2. Choose a week and take figures from the tillGross sales, refunds, tax and tips for one closed week. These become the numbers any new report must match.
  3. Ask what your accountant needs in what formatA list of fields and a date range avoids rebuilding later.
  4. Check what export options your till hasLook at the till's own help for exports and for API access before paying for any add-on.
  5. Do not give out your till loginIf someone needs access, add them as a user with limited permissions, never share your own password.

When should I bring someone in?

  • The data has to flow automatically to accounting, stock or a dashboard.
  • You have several shops or more than one till system.
  • Your numbers do not agree and nobody can say which is right.

How do I handle it?

  1. Agree the questions and the check figuresEach report starts with the question and a closed week whose totals are known.
  2. Read orders and payments togetherSales, discounts, tax, refunds and tenders are loaded and matched to each other.
  3. Keep a copy in a database I can queryData is stored with the original identifiers, so a re-read of recent days replaces rather than duplicates.
  4. Build the report and prove itIt must match the check week to the cent before it is trusted.
  5. Connect it onwardAccounting or stock links are added with logging and a daily comparison that shows differences.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Do I need an API to get better reports?

Not always. Regular exports can be enough. An API helps when the data has to arrive automatically and stay current.

Why do my totals differ from the till?

Common reasons: refunds after the export, tax rules, tips, time zones or a different end of day.

Is it safe to give a developer access?

Use a limited user or the provider's access tokens that can be revoked, never your personal password.

Can this feed my accounting software?

Often yes. The summarised daily figures are posted, and a check shows differences.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

For your developer: the technical fixes

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.