A single-command automation pipeline for downloading EPOS Now sales data, transforming it for QuickBooks Online, uploading Sales Receipts, archiving files and reconciling totals.
Sales, inventory and reconciliation lived across EPOS exports, QuickBooks Online, spreadsheets and Slack follow-ups. Daily and month-end work required manual downloads, transformation, upload checks and repeated review to confirm that QuickBooks matched EPOS.
OIAT built a Python orchestration flow around the real operating sequence: log into EPOS Now HQ with Playwright, download BookKeeping CSVs, transform sales rows into QuickBooks-ready receipts, handle spillover dates, check for duplicates locally and through QBO queries, then notify operators in Slack.
The finished workflow runs as a single command. It downloads, transforms, uploads, archives and reconciles automatically. Processed files move into dated archive folders, QuickBooks Sales Receipts are deduplicated, token refresh is handled, and reconciliation compares EPOS totals against QBO totals for confidence after upload.
Send the current process, tools involved and desired outcome. We'll shape the first useful build.