Make sure every Stripe payout reached Sage Intacct

**Objective:** Match each Stripe payout arriving between {date-from} and {date-to} (if blank, today) to the Sage Intacct deposit that recorded it, and report payouts with no deposit, deposits with no payout, and failed payouts. Intacct bank account: {bank-account} (if blank, work it out in Step 1).

**Step 1: Establish the Intacct bank account**

If a bank account was given, confirm it with `intacct-get-checking-account` and `bank-account-id`. Otherwise call `intacct-get-checking-account` and keep the active accounts. If exactly one remains, use it. If more than one remains, list them (`bank-account-id`, `bank-name`, `currency`), ask which one Stripe pays out to, and stop.

**Step 2: Read the Stripe payouts**

Call `stripe-get-payout` with `arrival-date.from`, `arrival-date.to` and `max-records` 500. Keep payouts whose `status` is paid or in_transit for matching. Set aside payouts whose `status` is failed or canceled for Step 5.

**Step 3: Read the Intacct deposits**

Call `intacct-get-deposit` with `bank-account` set to the account from Step 1, `deposit-date.from` 2 days before the start date, and `deposit-date.to` 5 days after the end date.

**Step 4: Match**

A payout matches a deposit when the Stripe `amount` equals the Intacct `total-transaction-amount` to within 0.01, the currencies are the same, and the `deposit-date` falls between 2 days before and 5 days after the `arrival-date`. When two payouts have the same amount, pair each with the deposit closest in date.

For each payout still unmatched:

* call `intacct-get-other-receipt` with `bank-account`, and with `total-base-amount.min` and `total-base-amount.max` both set to the payout amount, in case it was recorded as an other receipt;
* check whether one unmatched deposit equals the sum of two or three unmatched payouts, in case several payouts were deposited together, and report those as a combined match.

**Step 5: Report**

* **Matched:** `payout-id`, `arrival-date`, amount, `deposit-id`, `deposit-date`, days apart, and whether the deposit is `cleared`
* **Stripe payouts with no Intacct record:** `payout-id`, `arrival-date`, amount, `status`
* **Intacct deposits with no payout:** `deposit-id`, `deposit-date`, amount, `description`. Say that these may be deposits from other sources.
* **Failed or canceled payouts:** `payout-id`, amount, `failure-message`. Flag any that matches an Intacct deposit, because that deposit records money that never arrived.

End with the total of paid payouts, the total of matched deposits, and the difference.

**Rules & Guidelines:**

* Tools named stripe-... are on the stripe server; tools named intacct-... are on the intacct server. Both servers must be connected. If a tool from one of them is unavailable, say which server is not connected and stop.
* Read only. Do not call `intacct-create-journal-entry` or any other Intacct create or update tool.
* A Stripe payout is net of fees and refunds, so it will not equal the charges for the period. Match payouts to deposits only.
* Pass `company` to Intacct tools only when the user names an Intacct company.

**Validation:**

* If Stripe returns no payouts in the window, say so and stop.
* If the bank account has no deposits in the window, say the account may be the wrong one and stop, instead of reporting every payout as missing.
* If the Stripe amounts are consistently 100 times the Intacct amounts, divide the Stripe amounts by 100, say that you did, and continue.