Caet — CRM Diary Upload

Everything attempted on this date at the Recurring location only — the same filter as Transactions → All locations: Recurring → All types: Payments in the Square Dashboard. You get two separate files, and they are not the same shape. Payments in = recurring payments taken that day (date, amount, C-number). Declines = invoices due that day still unpaid (date, C-number, 0, Declined). Keep them apart — only the payments file reduces balances. Both split automatically at 100 rows, because the CRM dashboard rejects anything longer. On a Monday, generate Friday, Saturday and Sunday separately.

Payments in

Recurring payments that went through on this date. This is the file that reduces balances.

Rows

Value

$0.00

Files

Missing C-number

Date	Amount	Customer Reference

Declines

Invoices due on this date that are still unpaid — not card attempts that bounced. Four columns: date, customer reference, 0, Declined. The balance column is a literal zero, which is what the import expects. Rows with no C-number are held back, never shipped blank. Take the XLSX if you are working in Excel — the balance stays a real number there rather than whatever Excel guesses from a CSV.

Rows

Invoiced value

$0.00

context only — the file writes 0

Files

Held back, no C-number

Date	Customer Reference	Balance	Tag

All Cities —

Cities

Payments in

Value in

$0.00

Declines

Value declined

$0.00

Missing C-number

City	In	Value	Payments file	Declined	Value	Declines file

Choose a city and payment date, then click Generate Report.

Pulls live from Square. Takes ~30s for a typical day. Yesterday is generated automatically every morning for all six cities.

Caet — CRM Diary Upload

Payments in

Declines

All Cities —

Past Reports