When you process online payments via Upflow, 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 for complete, end-to-end online payment collection automation 💯
👉 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:
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.
Where applicable, you also have the option to specify the corresponding Department, Class & Location to seamlessly integrate with your analytical accounting workflows in NetSuite ✨ | |
You should 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. |
Payments
GL account: Undeposited Funds. You cannot modify this.
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).
⬆️ Customer payment record in NetSuite, applied to related invoice(s).
⬆️ 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 setup up through Stripe Express. You can add up to one bank account for each currency if multi-currency is supported for your organization:
Successful deposits are imported and automatically reconciled to payments contained within and related other objects (more details below):
⬆️ The successful deposit is posted to the specified GL account, and automatically reconciled against previously imported payments.
⬆️ Previously imported payments automatically transition from "undeposited" to "deposited".
Processing & convenience fees
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, or "gateway" fees GL account. | "Convenience" fees GL account. |
Both are posted and automatically reconciled with successful deposits, in different tabs:
Processing fees are recorded under the "Cash Back" tab. | Impact of processing fees in the specified GL account register. |
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.