Money automation · Runs every week
Match store payouts to accounting deposits.
Matched payments, differences, and entries that may need correcting. Run this automation in Fieldwork chat, or schedule it to email you a report when something needs attention.
Match store payouts to accounting deposits — Sep 14
Automation run • Sep 14
Match store payouts to accounting deposits
Output
Three payouts need review. Accounting deposits are $4,700 below store payouts at Harbor & Pine for August 15 through September 13, 2026.
Amounts are USD. Difference means deposit minus net payout. Matching uses payout references, amounts, and dates.
| Payout | Net payout | Deposit | Difference |
|---|---|---|---|
| Aug 28 | $4,200 | $4,200 | $0 |
| Sep 2 | $1,950 | $0 | -$1,950 |
| Sep 8 | $3,150 | $3,200 | +$50 |
| Sep 11 | $2,800 | $0 | -$2,800 |
| Total | $12,100 | $7,400 | -$4,700 |
Zero means no matching deposit was found, not confirmed nonreceipt.
- August 28 matches exactly.
- September 2 may be missing an entry. Check the bank statement before adding a $1,950 deposit.
- September 8 likely omits a $50 processing fee. If confirmed, record the fee and reduce the deposit by $50.
- September 11 may still be settling after Friday. Confirm arrival before making a correction.
No refund-related differences or duplicate deposits were identified. Settlement timing remains unconfirmed. No accounting entries were changed.
Automation steps. The agent follows these 3 steps each time it runs, using your connected store and accounting.
- 1
Match my store's payouts from the last 30 days to deposits in my accounting system.
- 2
Show matches and differences.
- 3
Explain likely causes of differences, such as fees, refunds, timing, or missing entries, and list entries that need correcting.
Adjust the automation in Chat
Run this automation and tell the agent what to do differently. Ask it to schedule that version if you want the changes in future runs.
- Allow three business days for settlement.
- Show only unmatched payouts.
- Group differences by payment provider.
Fieldwork emails the scheduled report. Each email links to the full run as a conversation in Fieldwork. The automation asks the agent to keep a log in your knowledge base and read it before each run to check what has changed.
Adjustable schedule
Choose how often it runs at setup, from hourly to monthly. Ask in Fieldwork chat for a custom schedule and timezone.
Only useful reports
When nothing needs attention, the run skips the email. When there are findings, you get a report with a link to the full conversation.
Read-only access
The agent reads your store and accounting without changing the source. It can keep notes and a run log in your Fieldwork knowledge base.
This automation reads your store and accounting. Connect Shopify, BigCommerce, or WooCommerce for your store and Xero, Business Central, or QuickBooks for your accounting to Fieldwork.
More automations for money.
Questions about this automation.
- What do I connect?
- Connect both your store and accounting system. Run in chat or activate weekly checks.
- Will it correct entries?
- It reports proposed corrections without changing entries. No messages or mailbox drafts are created.
- Can I change the checks?
- Ask in chat to adjust the date range or matching tolerance and schedule that version.
- Where does the report arrive?
- Scheduled reports arrive by email with access to the full conversation. Nothing needing attention means no email or push notification.
Security first
Your data stays yours. Your data is never used to train any AI model - not ours, not a provider's. Fieldwork is GDPR compliant and certifying against SOC 2 and ISO 27001, with encryption in transit and at rest, and org-level access controls throughout.
Try Fieldwork
$50 / user / mo introductory pricing. AI quota included.
- ✓Down from $99 / user / mo
- ✓All platform features
- ✓Early access, no card required