> ## 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.

# Online payments sync for NetSuite

> Automate import and reconciliation of Upflow online payments into NetSuite in real time, with full Autopay support for end-to-end collection automation.

When you [process online payments via Upflow](/en-us/payments/accept-online-payments/onboarding-and-setup), we can automatically import and reconcile them in real-time into your NetSuite instance so your accounting is always up-to-date. This functionality works in synergy with [Autopay](/en-us/payments/collect-online-payments/collecting-automatically-with-autopay) for complete, end-to-end online payment collection automation 💯

👉 This functionality is available with *Upflow Payments*. Reach out to your customer success manager to see it in action!

# Functional overview

## Basic flow

Our online payments sync for NetSuite works in parallel of the underlying physical money flow (from your customer's bank account to yours) in 2 simple steps:

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102437137.jpg?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=83444dba84aa1a5fc822b8c354e19f99" alt="Two-step flow diagram: payment imported to NetSuite as a customer payment, then deposit recorded once funds settle to the bank account" width="640" data-path="images/45602102437137.jpg" />

| **Step 1**                                                                                                                                                                                            | **Step 2**                                                                                                                                                                    |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| You receive a payment from a customer via their portal for one or multiple invoices. It is immediately imported into NetSuite as a customer payment and linked to the corresponding sales invoice(s). | Payments collected are deposited in daily batches to your bank account. Successful deposits are immediately recorded into NetSuite alongside all known payments-related fees. |

## NetSuite GL accounts & analytics

To ensure money movements and associated operations are properly reflected in your NetSuite instance/accounting, you can configure which General Ledger accounts and header-level classifications should be used for each component [from your "Payment sync" section here](https://app.upflow.io/organization/-/settings/payments-by-upflow).

Where applicable, you also have the option to specify the corresponding **Department**, **Class** & **Location** to seamlessly integrate with your analytical accounting workflows in NetSuite.

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102442001.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=c9816ee5c17b97686a44ea107aafe6f7" width="320" alt="Department, Class and Location selectors in the Upflow NetSuite payment sync settings" data-path="images/45602102442001.png" />

(Optional) You can also create **a dedicated payment method in NetSuite** (e.g. "UPFLOW") to easily identify and track online payments received by your platform(s). *Otherwise, you'll need to at least ensure that the Refund Method field is set as optional in your Customer Refund preferred form.*

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102443793.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=7620f5b0e5278c4586fad0580ba2ae38" width="320" alt="Payment methods selector for Payments and Refunds when syncing data to NetSuite" data-path="images/45602102443793.png" />

### Payments

GL account: Undeposited Funds. You cannot modify this.

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602091005201.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=a2c55f3cf41d1f1b472493ce16864e71" alt="" width="320" data-path="images/45602091005201.png" />

Undeposited Funds is the NetSuite standard for representing money collected but not yet deposited to your bank account. It enables proper recording and reconciliation of deposits at the end of the chain with the standard Deposit object, as well as leverage other useful NetSuite built-in functionality and workflows like FX loss/gains accounting (more details below).

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602091010065.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=bac15af57bfc21d9c6967c66041e0b4a" alt="" width="640" data-path="images/45602091010065.png" />

⬆️ *Customer payment record in NetSuite, applied to related invoice(s).*

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102457617.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=14fb09c595bf61d66a64f2017e945f33" alt="" width="640" data-path="images/45602102457617.png" />

⬆️ *Customer payment GL impacts, on the AR and Undeposited Funds accounts.*

### Deposits

GL accounts: specified by you. Must be an account of type "Bank".

Select the GL account corresponding to the bank account where you receive payouts from your Upflow payment account, which you set up through Stripe Express. You can add up to one bank account for each currency [if multi-currency is supported for your organization](/en-us/payments/process-online-payments/fx-and-multi-currency-settlement):

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102461457.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=5d47ba081ecfb01b1d503008b10f1495" alt="" width="320" data-path="images/45602102461457.png" />

 Successful deposits are imported and automatically reconciled to payments contained within and related other objects (more details below):

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102463761.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=f18ae2f32dc838c983fd8c934393ad29" alt="" width="640" data-path="images/45602102463761.png" />

⬆️ *The successful deposit is posted to the specified GL account, and automatically reconciled against previously imported payments.*

<img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602091019281.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=dce56a82a95018d595e732ea24534f3d" alt="" width="640" data-path="images/45602091019281.png" />

⬆️ *Previously imported payments automatically transition from "undeposited" to "deposited".*

### Processing & surcharges

GL accounts: specified by you.

Select the GL account to record the payment processing fees charged by Upflow (typically, an expense account), and if applicable the one for the card fees you pass on to customers when they pay:

| Processing ("gateway") fees GL account                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | "Convenience" fees GL account                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602102487057.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=ec92bb3e6d81784ecc80504536c1b841" width="320" alt="Processing fees GL account selector" data-path="images/45602102487057.png" /> | <img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602091024273.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=8d0bee059c069680e3a3091f316597d1" width="421" alt="Convenience fees GL account selector" data-path="images/45602091024273.png" /> |

Both are posted and automatically reconciled with successful deposits, in different tabs:

| Processing fees recorded under the "Cash Back" tab                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Impact of processing fees in the specified GL account register                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602091026961.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=e98af90d365039d7f800077746609024" width="640" alt="Processing fees in the NetSuite deposit Cash Back tab" data-path="images/45602091026961.png" /> | <img src="https://mintcdn.com/upflow-04dc27cd/3QoMbpqs_CUoAT6_/images/45602091031313.png?fit=max&auto=format&n=3QoMbpqs_CUoAT6_&q=85&s=f4ec68dcaaadec087116ac67dba176b7" width="640" alt="Processing fees impact on the NetSuite GL account register" data-path="images/45602091031313.png" /> |

## Failed payments

Our integration records failed payments as a pair of a customer payment + a refund in NetSuite. This is to ensure consistent behavior across failures as some of them may be asynchronous, typically for unsuccessful direct debits.
