Upload & Compare

Upload the Google purchase export and the Zoho sales export. Every Zoho line is matched to Purchase by domain + SKU, then flagged as Notify now, Overdue or OK. Purchase changes once a month; Zoho changes daily and always compares against the Purchase data already saved on the server.
Purchase file (Google export) — monthly
.xlsx with Domain name, Subscription, Quantity, Start/End date, Order name, Customer ID. Upload once a month — leave empty to use what's already on the server.
Load a Purchase file to enable
Zoho sales export(s) — daily
Add one or more Zoho .xlsx files — they're merged into one and compared against the Purchase data on the server. You can also drag files onto this card.
Load a Zoho file to enable
Uses data/Purchase data.xlsx + data/Invoice.xlsx as they are right now — no upload needed
Daily 9 AM e-mail
Checking server…
Backfill a past month's Purchase prices
Save an OLD Purchase file's rates into history — which month(s) it covers is read from its own Start/End dates, never touches this month's live data above.