Skip to main content
When a payment is collected through Upflow, it is written back to Sage Intacct so your accounting stays aligned with what you collected. This page covers what is written back, how to configure it, how to track the sync status, and how to recover from a failed export. Refund handling is documented in Refund management.

What is written back

In Sage Intacct, the resulting AR Payment posts with State Complete. The Document or check no. field carries the Stripe payment ID, and the Account ID reflects the GL account configured in your settings (for example, an undeposited-funds account). Sage Intacct posted AR Payment showing State Complete, posted to an undeposited-funds account, with the Stripe payment ID in the Document or check no. field

Payment settings

You can select the GL account to which payments are written back in Sage, from your Upflow Settings > Integrations: Upflow payment sync settings showing deposit account mapping per currency
We recommend selecting an undeposited funds account. Payments stay there until the matching bank deposit is recorded, which makes reconciliation with your Stripe payouts much easier.

Map an account per currency

If you collect payments in multiple currencies, you have to map a different GL account to each currency. Note that Sage Intacct’s Undeposited Funds account only accepts payments in your base currency, so payments in any other currency need to use another type of account (typically a bank or clearing account that supports that currency). To configure it, in Settings > Integrations:
  1. Under Payment settings, click Add currency.
  2. Select the currency, then select the GL account payments in that currency should be written back to.
  3. Repeat for each additional currency you collect in.
Once you add or change a mapping, retry any payments that previously failed to export by using Export back to Sage Intacct from the payment’s three-dot menu (see Handling a failed write-back).

Customer advance account

The Customer Advance account section, in Settings > Integrations, sets the Sage Intacct account Upflow uses to record advances. An advance is a payment that isn’t applied to any invoice. When Upflow exports a payment with no linked invoice, it creates an AR Advance in Sage Intacct instead of an AR Payment, and posts it to this account. This applies to payments collected through Upflow and to bank transactions you match to a customer without selecting invoices in cash application. Customer Advance account section in Upflow integration settings, with an account dropdown and a Save button To configure it:
  1. Under Customer Advance account, open the Select an account… dropdown.
  2. Select the GL account you use for customer advances in Sage Intacct. The dropdown lists all your Sage Intacct GL accounts but no bank accounts, because Sage Intacct records an advance against a GL account number.
  3. Click Save.
If no account is selected, the advance export fails with the error Advance could not be exported. Please make sure you have selected a Customer Advance account in the integration settings. Select an account, then retry the export with Export back to Sage Intacct (see Handling a failed write-back). When the advance is later applied to invoices in Upflow, Upflow applies the existing advance to those invoices in Sage Intacct.

Tracking the payment status

A payment carries two distinct statuses:
  • Gateway status — the payment’s current status in Stripe.
  • Sage Intacct status — the export status of the payment from Upflow to Sage Intacct.
Upflow Payments list showing the Gateway status and Sage Intacct status columns side by side, with SUCCEEDED and ERROR states You can identify a payment’s processing status by adding the Gateway status column to:
  • your default payments view, ideally placing it next to the Sage Intacct status column, and saving the view — see here
  • the customer details page → Payments tab (learn more)

Handling a failed write-back

You can identify payments that failed to export to Sage Intacct from your Payments list view, filtered on Sage status contains Error. Hover over the Error status, and/or add the Sage status column to the list (see here), to learn more about the failure reason. Once you’ve updated the required or missing settings, you can retry the export from the payment’s three-dot menu on the Upflow list, by clicking Export back to Sage Intacct. Payment three-dot menu on the Upflow Payments list showing the Export back to Sage Intacct option