Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.upflow.io/llms.txt

Use this file to discover all available pages before exploring further.

When you collect online payments through Payments by Upflow (PBU), Stripe batches successful payments into payouts that are wired to your bank account. To keep your books in sync, the deposit that lands in your bank needs to be reflected in your accounting system, applied against the right customer payments and net of any processing fees. For accounting integrations where Upflow does not create the bank deposit automatically, you reconcile the payout manually using a CSV export from Upflow. This page describes the principle and the data in the export. For the concrete steps in your accounting system, see the relevant integration article.
This article applies to merchants using Payments by Upflow (PBU). If you collect payments through a Stripe standard account connected to Upflow, payouts are managed by Stripe directly — reconcile them with Stripe’s own reports.

​
When does manual reconciliation apply?

It depends on the integration:
  • Automated payout sync — the integration creates the bank deposit in your accounting system, automatically matched to the payments it contains. No manual step required. This is the case for our NetSuite integration (see Online payments sync for NetSuite).
  • Manual reconciliation — the integration writes back individual payments but does not create the bank deposit, so you record the deposit yourself based on the Upflow payout export. This is the case for QuickBooks Online (see QuickBooks - Payout reconciliation).

​
The Upflow payout export

In Upflow, the Payouts tab (next to Payments) lists every payout, with its arrival date, amount, status, and the count of payments it contains. Click the download icon at the top right of the list to export the CSV. Upflow Payouts list view with the export download icon at the top right The export contains one row per Upflow transaction included in your payouts. The columns most useful for accounting reconciliation are:
  • payout_arrival_date and payout_amount — the date and total of the bank deposit you’ll record in your accounting system.
  • transaction_upflow_id — the Upflow payment identifier. When an integration writes back payments individually (as QuickBooks Online does), this matches the corresponding payment record in your accounting system, so you can find each payment unambiguously.
  • transaction_converted_total_amount — the transaction’s contribution to the payout in the payout currency (what actually lands in the bank).
  • transaction_processing_fees and transaction_net_amount — fees withheld by Upflow and the net amount deposited.
  • customer_name — the customer the payment is applied to.
Sample export: upflow-payout-sample.csv — one payout, four transactions, full set of columns.

​
High-level reconciliation flow

  1. Export the payout from Upflow as described above, and identify the payout you want to reconcile (one row in the Payouts list, multiple transaction rows in the CSV).
  2. In your accounting system, record a deposit on the bank account where the payout arrived, dated to the payout’s arrival date, for the payout amount. Apply that deposit against the individual payments listed in the CSV so they’re cleared from any “undeposited” / clearing account, and post any processing fees to the relevant expense account.
  3. Match the deposit against your bank feed when the corresponding bank transaction appears.
The exact mechanics depend on your accounting system.