A clean IdealSync playbook · by Dorian Gorski
Monthly cash and true COGS close
Payouts, landed cost, true margin per SKU, returns, and a 90 day cash forecast. 8 tasks, 3 departments, 3 automations.
Make this fit my business →Preview freely. Sign in to save your own version. No private client information appears in this template.
- T1 · Finance
Pull the month's payout and fee reports
Amazon settlement reports, payout statements, advertising invoices
After: Flow start - T2 · Supply Chain
Update landed cost per SKU
Supplier invoices, freight invoices, duty and customs charges, units received
After: Flow start - T3 · Finance
Reconcile payouts against the bank
Bank statements, settlement totals, reserve balance
After: T1 - T4 · Finance
Recalculate true margin per SKU
Landed cost per SKU, fees per unit, ad spend per SKU, returns rate
After: T2, T3 - T5 · Finance
Flag SKUs below the margin floor
Margin floor per category, true margin per SKU
After: T4 - T6 · Operations
Review returns and reimbursements
Returns report with reason codes, reimbursement report, lost and damaged units
After: T1 - T7 · Finance
Update the 90 day cash forecast
Open purchase orders, supplier payment terms, forecast units, fixed costs
After: T4, T6 - T8 · Finance
Agree the actions with the team
Margin flags, cash forecast, returns findings
After: T5, T7
Why we build it this way
Make every handoff explicit.
Name the required input, responsible role and approval before wiring an automation.
Capture the result and use it to improve the next run.
Design guidance from the IdealSync method. Adapt and validate it for your operation.The next run should teach you something
Confirm the data. Give the response an owner. Do the work. Record the result. Improve the next run.
Save my starting blueprint →