Marketplace settlement reconciliation
Three systems, 438 orders, one month-end close: the bot pulls orders and payouts from two portals, reconciles them against SAP to the cent, and hands finance the commission entry to post.
ExcelSeller portalPayment gateway portalSAP export
- Who
- E-commerce finance executive at a brand that sells on a marketplace
- When
- Every month, first week, before the books close
- Why
- The marketplace pays net of its commission and fees, weeks after delivery. Without this recon nobody sees the overcharged commission, the orders SAP never billed, or the payouts stuck for 60 days.
- By hand
- Three downloads, a tracker carried forward month to month, and hundreds of lookups, all by hand.
3systems: marketplace, payment gateway, SAP
438orders tracked across 4 months
120payouts matched to orders
225SAP open items tied out
22exceptions flagged for follow-up
0.00unexplained difference
What it does
- Seller centre: logs in, exports every order with activity in September (191 orders)
- Payment gateway: logs in, downloads September's payouts (120 lines in 5 weekly batches)
- Makes this month's file from last month's closed reconciliation
- Carries last month forward: each order's status and payments, and August's accrual
- Cleans history: filters closed June orders and deletes them (106 rows)
- Loads the month: pastes orders, payouts and the SAP open items (225)
- Adds the 160 new orders to the order book; 17 formula columns fill themselves
- Reconciles every order into one of 13 categories: settled, short paid, overdue, not billed in SAP...
- Copies the 22 exceptions to a follow-up sheet, sorts and formats them
- Refreshes the pivot and checks: SAP ties to the cent, every payout matched, postings balance
- Lands on the answer: commission expense, the accrual, and three SAP entries ready to post
What the bot hands you
- Commission expense for SeptemberSGD 1,767.90
- Accrue at month-end (commission + fees, reverses day 1)SGD 1,373.06
- Claim back: 3 watch orders charged 15% instead of 8%SGD 38.29
- Bill in SAP: shipped, never billed3 orders, SGD 826.00
- Chase: payouts more than 30 days late12 orders, 3 over 60 days
- SAP balance tied to the order bookSGD 30,718.00, 0.00 unexplained
Screens





Try the demo portals
Pasarly seller centre (demo)TembusuPay merchant portal (demo)
Inside the workbook
- Order Book Every order for 4 months, carried forward, 25 columns, 13 recon categories
- Recon Summary Payout check, SAP tie-out, ageing, commission for the month, checks
- Postings Cash application, credit memos, commission and fee accrual
- Exceptions The follow-up list: short paid, overdue, not billed, price differences
- Status Pivot Order value by recon category and month
Sample files
- Pasarly_Recon_Aug2025.xlsx (input: last month's closed reconciliation (384 orders). The bot starts here)
- FBL5N_SG10_300120_30.09.2025.xlsx (input: SAP open items for the marketplace customer, downloaded by hand)
- Pasarly_Recon_Sep2025_expected.xlsx (expected output: what the workbook looks like after the bot runs)
Get the bot
Coming soon.
How to run it
- Install Operative and the Guerrilla Bots extension
- Operative > Import the .gbw
- Download the three sample files into the bot's working folder
- The two demo portals accept any email and password
- Run, then open Recon Summary: every check should say OK