Monthly multi-channel sales reconciliation agent
A multi-channel reconciliation workflow: per-channel summary, fee categorisation, GST treatment, the discrepancy list, and the journal entries for the bookkeeper.
Fill in the Template
1 / 6 filledYour Built Prompt
Updates live as you typeAct as my reconciliation agent. I sell across multiple channels (Shopify, Etsy, Amazon, Faire, marketplace, in-store) and I need to reconcile last month so the books match what actually landed in the bank.
Sales channels active: {{channels}}
Bank deposits for the month (paste totals + dates): {{deposits}}
Payment processor reports (Stripe, PayPal, Klarna, Afterpay totals): {{processor_totals}}
Refunds + chargebacks this month: {{refunds}}
Marketplace fees + ad fees pulled out before payout: {{fees}}
GST registered (yes / no): Yes - registered
Walk me through:
1. Per-channel summary - gross sales, fees, refunds, net payout, expected vs actual landing in the bank. Flag any mismatch over $20.
2. Fee categorisation - separate transaction fees, marketplace fees, ad fees, shipping label costs. These code differently in the books.
3. GST treatment (if registered) - which sales had GST collected, which were marketplace-handled (GST collected by Amazon AU / eBay AU), which need a manual GST line.
4. Discrepancy report - the 3-5 items I need to investigate before close (a refund that did not match, a payout that is short, a fee that looks high).
5. Journal-entry list for my bookkeeper - the entries to post for the month, by channel.
AU English. Numbers first, then a one-sentence note. Do not guess on unknowns - flag and stop.Fill in the required fields above to copy or run this prompt.
This prompt produces general information, not financial or tax advice. Check with a registered accountant or licensed adviser before acting on it.
Tags
Community Feedback
0 commentsRelated Prompts
More in BusinessProduct Delivery Agent
A deployable AI agent that drafts PRDs, synthesises customer feedback, plans the roadmap, and writes release notes. Configure once, run per feature.
Hiring Funnel Agent
A deployable AI agent that runs your hiring funnel — JDs, candidate triage, interview kits, offer letters, candidate comms. Configure once, run per role.
Monthly Bookkeeping Agent
A deployable AI agent that runs your monthly close, BAS prep, and cash flow updates — AU-tax compliant. Configure once, run every month.
Write a sales-to-CSM handoff
Drafts a structured sales-to-CSM handoff document so customers don't repeat themselves.