Toast Portal vs API Category Totals Showing Differences in Last Week Report

[ToastJim]

We are experiencing an issue where the Toast API is off from the Portal when comparing net sales within individual locations in categories like say 'Food' or 'Wine in the 'last week' period.  The net sales data differs by a few dollars and up but it's usually off by around $10-50 and only for one or 2 locations out of 20.  We run the API a few times per day the latest about 15 hours after the 'last week' is done and each time it's a little closer.  Then it's just off from there in a few locations for different categories.  So Store X might have $25,050 K in 'Food' in the portal the API shows  $25,075 (as example).  Is this a known issue where data is just off sometimes or takes several days to settle?   Thanks in advance for anyone that can share any info it would be appreciated.

[achilles]

Have you looked at Refunds/Voids?

[Rob · Accepted solution]

Thanks for reaching out! Small mismatches like that are expected sometimes and usually come from timing/processing and reporting-definition differences. We see this pattern a lot (API numbers that creep toward the portal totals over 24–72hrs) and there are a few common, explainable causes and quick checks you can run.

• Look for a “Data Delay” notification on the Sales Summary for the affected locations/dates. If present, that explains the mismatch.

• Pull the Orders Report or Payments Report for the same period; they use a different (more live) data stream and often show transactions missed by the Sales Summary while it’s reprocessing. This gives you the most up-to-date cash/transaction picture.

• Check for uncategorized items or recent reclassifications in the Menu/Item detail for the affected location(s). Reclassifying items can move dollars between categories.

• Look for refunds/voids/adjustments that landed after the end of the week (or that were processed later). Those will change category totals.

• If suspecting a sync block, force a POS resync on the tablets at that location (Passcode screen → three dots → Resync All Data). That can clear a stuck upload.