Be aware that the cash tracking report and the financial summary reports don’t always tie out. There are issues with some returns not being in one report but are in the other.
Topic summary
Need a consolidated report to track cash added/removed across many Shopify POS tills (cash drawers per terminal); current process requires drilling into each till daily for 30+ tills, which is time-consuming. Users view this as an accounting necessity and request Shopify prioritize it.
Existing reports often don’t tie out. Cash Tracking and Finance Summary can disagree; some returns appear in one report but not the other. Partial refunds (refunds for part of an order) are a major source of mismatches.
Additional reconciliation gaps involve refunds/exchanges/gift card credits and “Draft Orders” (manually created orders), which show as a sales channel but aren’t included in the All Channels filter.
Workarounds shared:
- Filter for “Unknown” transaction type to identify partial refunds.
- Review Draft Orders separately.
- Post unreconciled differences to a clearing account temporarily.
- Consider third-party POS reporting apps (no specific solution identified).
Status: Unresolved. No official Shopify fix or a dedicated per-till cash movement report. Open needs: consolidated cash/credit refund reporting and consistent tie-outs across Shopify reports.
2 Likes