About monthlyBook

Drop the month's exports from your shop: Shopify orders, Square transactions and item sales, Meta Ads and Google Ads reports. Each file is recognised by its columns and you get one table by week or by month: orders, sales, shipping, tax, tips, refunds, Square fees, ad spend, ad spend per sale and what's left after refunds, fees and ads. The usual traps of merging these by hand are handled: Shopify's one row per item counts each order once, Square's items file doesn't add its tax a second time, an order placed late in the evening stays on the day the store saw it, and a file downloaded twice is counted once. Download Excel (with daily, item and check sheets) or CSV. The files are read in your browser and never uploaded.

Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.

Built on open-source libraries: Papa Parse, ExcelJS.