Back to library
Claude#businessAgent promptSaves ~60min

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.

rach_maeve4 June 2026
0.0(0)

Fill in the Template

1 / 6 filled

Your Built Prompt

Updates live as you type
Act 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.
Run in

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 comments
Be the first to leave feedback on this prompt.

Related Prompts

More in Business