Analysis / Revenue reconciliation
Reconcile marketplace settlements with orders
Use Proforma to reconcile marketplace settlements with orders. Produce order-to-settlement bridge and unmatched settlement queue from your business data.
Finance lead · Revenue operations manager
Bring this question into Chat
Your starting prompt.
Reconcile marketplace orders with settlements and bank payouts for [period]. Trace gross sales through returns, commissions, taxes, reserves and other identified adjustments. Show a settlement bridge and flag orders absent from settlements or payouts that do not match deposits. Keep unsupported deductions separate from expected fees, preserve order and settlement IDs, and calculate all totals within each currency.
Copy this starting point, then replace the placeholders with your own inputs.
Method and review
Keep the assumptions visible.
Agree on identifiers, currency, periods and account mappings before comparing totals. Keep unmatched records and timing differences visible instead of forcing a match.
For this task, check
Marketplace tax collection and reserve policies affect the expected payout amount.
This starting prompt has no published worked example yet. Begin with a small sample and check the calculations before relying on the result.
Before you begin
- Uploaded exports or permitted Data covering the listed inputs
Work with permitted files or queryable data. Verify the result against the original records.
Take the next step
Make it your investigation.
Copy the prompt above, create or open your Workspace, and paste it into Chat. Add the inputs you have permission to use and adapt the assumptions with your agent.
Start exploringYour prompt is carried by copy and paste. Signing up does not submit it or start this work automatically.
Or start with your own agent
The setup prompt includes this public task. Your agent will help you connect when needed and use the access you approve.