Consolidate weekly Stripe revenue and separate growth from FX

Every Monday at 7am, consolidate last week's Stripe revenue into my home currency and explain what currency movement did to the number. Treat my home currency as USD unless I have told you otherwise, and treat the reporting window as the seven full days ending the previous Sunday.

Use the Stripe List Balance Transactions operation to pull every transaction that settled inside that seven day window, across every currency I charge in. Page through the whole result set instead of stopping at the first page, and keep each transaction's currency, settlement date, gross amount, fee and net amount. Stripe returns amounts in the smallest currency unit, so divide by 100 for normal decimal currencies and handle zero decimal currencies such as JPY and KRW correctly rather than dividing them. If I ask for gross charge volume instead of settled activity, use List Charges in place of List Balance Transactions.

Use the Open Exchange Rates Get Historical Rates operation to convert each transaction at the rate on its own settlement date. Do not apply one week end rate to the whole period, because that makes both the currency effect and the growth number wrong. Loop the historical call once per distinct settlement date in the window and reuse that result for every transaction on the same date, since each dated call counts against my monthly request quota. Also call Get Latest Rates once for today's comparison rate. Open Exchange Rates is a read only API and free plans are USD base only, so request USD as the base and derive any cross rate you need by dividing the two USD quotes. Do not use the Convert Amount operation or the Get Time-Series operation, since those require higher plans than mine.

Write a short report that breaks revenue down by currency, showing both the native amount and the converted home currency amount for each, and then gives the consolidated home currency total. Separate genuine growth from pure FX effect: restate last week's currency mix at the prior week's rates, report the difference between that restated total and the actual converted total as the FX effect, and treat the remainder as real growth. State plainly which direction currency movement pushed the headline number.

Append the weekly totals as a row to my finance tracking sheet with the Google Sheets Append Values operation. The row should carry the week ending date, the per currency native totals, the consolidated home currency total, the constant currency total and the FX effect, so the tab builds a week over week history I can chart later.

Then post the written summary to Slack with the Send a Message operation, calling out any currency where the FX effect alone exceeded 1 percent of that currency's revenue. Lead with the consolidated total and the growth versus FX split, and keep the message short enough to read on a phone.

If a settlement date has no published rate yet, fall back to the most recent earlier date that does and note the substitution in the report.