Record merchant account timestamps

[alanna]

User story

As a host admin (and their accountants) we need accurate information about transaction times, so that we can accurately do month and year end close processes, and track difference between when transactions are recorded on OC, in merchant accounts (Stripe, Paypal, Wise), and the bank account.

Best solution for this problem

Add to the OC data whatever timestamps are available through merchant account APIs relating to steps in their processing of funds, and show these as columns in the CSV exports.

MVP

Record them in the database and export via metabase maybe?

Metrics

Accurate accounting across transitions between months and years.

P2 low frequency, high impact

[BenJam]

FYI we have the created_at (seconds since epoch) date from stripe for card payments.

[BenJam]

Recording the merchant id seems like the safer option to me, and it's what we've done with transactions exported in the report.

as far as I can see we have this for inbound transactions through Stripe and Paypal and the merchant ids appear for these transactions. I'll leave it to @znarf or @Betree but perhaps this is basically a case of similarly recording the merchant_id for transactions that are made through Wise?

[alanna]

We already record the merchant ID, Scott needs the timestamps too. To learn more about why can you please ask him directly?

[alanna]

Just emphasising again that OCF's auditor and accountant say we need this, especially in the export data

[iamronen]

adding this to the "financial systems" working group thread.