Payouts - Working Ticket on Scope

[jcannon-majr]

Link to business working doc: DRAFT AX Payouts.docx Updated Aug 27th

---

Added 8/27 , doc and below:

Does Stripe allow us to export out / then we should lean on them for as much as possible

o   Yes they do. The Accounts API endpoint provides detailed information about each or all connected account. Example:

curl https://api.stripe.com/v1/accounts \

-u sk_test_4eC39HqLyjWDarjtT1zdp7dc:

Stripe Requirements @jeremy combined your doc into this scoping ticket

Commerce Onboarding

• Add UI for artists to connect their Stripe accounts to majr
• Redirect to Stripe-hosted onboarding flow
  • co-branded UI
• Implement refresh_url and return_url callbacks

Connected Account Management

• Provide access to the Stripe Dashboard to connected accounts

Refunds (Ship v1.5)

• Add webhook to handle refund notifications from StoreKit
• Add a new transactions status REFUNDED

Adding Funds to Stripe

• Use the API to add funds to balance (once bank account verified)
  • Can also be done manually
• Detect payments from Apple via App Store Connect API
  • Doesn't appear to offer notifications, so we'd have to poll
  • JC: Thinking this will be manual to start. Human-triggered.

Payouts

• Define an automated (or manual) payout schedule (e.g. daily, weekly, monthly)
  • When adding funds to your balance, best practice is to use a manual payout schedule
• Implement system to trigger payouts based on defined schedule
  • Queue them up
  • Set platform default to something like monthly (end of month)
• Track payouts in our system and connect to transactions
• Need table to track variables for commission and percentage structure
  • How does Revenue Reporting calc this today? E.g. suspect hard coded.

Notifications (v1.5)

• Notify artists when a payout is initiated and completed (Does stripe offer sufficient notifs?)
  • Yes, I believe sufficient for v1
• Provide summary of payout details

Auditing

• Implement error handling for failed payouts
• Log all payout transactions for auditing and troubleshooting

Reporting

• Connect transactions to artist payouts
• Connect transactions to payments from Apple

---

Conversation notes:

• What is entirely on our side of the fence that programmatically tracks:
  • Transactions (We do today in Postgres)
  • Apple Commission Rate
  • we need to understand this percentage at transaction level because they will vary
• Would need:
  • Was it paid
  • Status (Pending, Paid, Failed)
  • Payout table
  • Audit table every time we paid an artist
  • Every time we collect from Apple @jamie can we listen for detail, etc.
  • Regular schedule that is repeatable and batch efficiency
• Does Stripe offer 'queued' payouts -> save us time?
  • Yes @jeremy Stripe offers payout timing as a parameter
• 'Store Feature" FEATURE FLAG for this set of feature ('Store')
  • Needs Refinement
  • Pay X dollars for Y period for FLAG = TRUE
• @jeremy note: Manual Payouts API has been enabled. Automatic has now been turned off.
• Leakage: Refund case
  • Apple provides refund notif via ASSN which we need setup an endpoint to listen for
  • Download/get finreports

[jcannon-majr]

Gather artist feedback

[jcannon-majr]

Yep, will do.

[jcannon-majr]

Moved to different team that explicilty doesn't sync to GitHub. Will the ticket persist the connection?

[jcannon-majr]

Seems like it does.

[jcannon-majr]

Still syncing

[jcannon-majr]

which thread syncs to GitHub?

[jcannon-majr]

now mine does!

[jcannon-majr]

Where does this appear? :)