NetSuite bank reconciliation and what to add when native matching stops
NetSuite bank reconciliation means importing a bank statement or feed, letting NetSuite propose matches against the cash account, and reconciling until the cleared balance equals the statement. It works for lines that are one bank row and one ledger transaction. It stops at processor payouts, combined customer payments and intercompany transfers. For those you add a SuiteApp or a matching tool. Reconciles starts at $888 a year and reads exported files, so no SuiteApp project is needed.
What native NetSuite bank reconciliation covers and where it stops
NetSuite imports bank statements or bank feeds and offers matching rules that pair statement lines with transactions by amount, date and reference. Rules can also create entries for recurring items such as bank fees. NetSuite documents the feature in NetSuite Help, and our NetSuite reconciliation page shows a month matched end to end.
That handles the clean lines. The rest comes in four shapes.
- Processor payouts. Stripe, PayPal, Adyen and marketplace payouts equal many sales minus fees and refunds, so the deposit matches no single transaction.
- Combined customer payments. One wire settles eight invoices, or a customer short pays and the credit memo is missing.
- Timing. A deposit booked on the 30th clears on the 2nd and straddles the month end.
- Subsidiaries. Each bank account is reconciled separately, and the same exception repeats in every entity.
At 40 lines a month a controller fixes these by hand. At 4,000 the work is finding which sales are inside which deposit, not clicking the match button.
NetSuite bank reconciliation options compared
| Option | Best for | What it does | Where it stops | Typical cost |
|---|---|---|---|---|
| Native bank reconciliation and matching rules | One to one lines in one or two entities | Imports statements, proposes and creates entries | Does not explain payouts or split combined payments | Included with NetSuite |
| SuiteApp such as ZoneReconcile | Teams that want matching inside NetSuite | Reconciliation workflow on NetSuite data | Needs install, admin time and a quote, see our [ZoneReconcile pricing guide](/blog/zonereconcile-pricing) | Quote based |
| Close platforms such as FloQast or BlackLine | Controllers who need a full close workflow | Reconciliation plus checklists and sign off | Priced as a suite, see [FloQast pricing](/blog/floqast-pricing) | Annual contract |
| Reconciles | Payout batches, split remittances, many subsidiaries | Matches bank, processor and ledger exports and exports journal entries | Works on exported files, not inside NetSuite screens | From $888 a year |
| Spreadsheet and a bookkeeper | Under a few dozen lines | Manual checking | Does not scale, errors slip through | Time |
Third party prices come from their public pages or quotes at the time of writing, so confirm before you buy. For the wider shortlist see the roundup of the best bank reconciliation software.
One Adyen payout in NetSuite, matched to sales and fees
Say $18,742.60 reaches the bank on the 9th. NetSuite holds 64 customer payments for the week totaling $19,310.00. The $567.40 difference is $541.15 of processing fees and $26.25 of refunds on two orders.
NetSuite shows the $18,742.60 statement line and proposes nothing, because no single transaction has that amount. You search for the 64 payments, select them, and still have a $567.40 gap to explain and book. A matching tool starts from the Adyen settlement report instead. It adds the 64 payments, applies the fees and refunds, lands on $18,742.60 and marks the deposit as one to many with the gap itemized, ready to export as a journal entry for NetSuite's CSV import. If one order had been captured twice the sales total would be higher and the match would fall out as an exception naming the duplicate. See Adyen reconciliation for the file layout.
How Reconciles works with NetSuite
Reconciles reads your bank statements, your processor reports and a saved search export from NetSuite, all as CSV or XLSX. It matches them, shows every match with a reason, and sends what it cannot tie to an exceptions queue. On Growth and Scale, workspaces cover several subsidiaries and bank accounts, and approved journal entries export for import back into NetSuite. For intercompany balances, see intercompany reconciliation software, and for a group with many entities, multi-entity account reconciliation.
How to decide whether native NetSuite matching is enough
1. Count the lines that do not match one to one. If nearly every bank line is one transaction, native rules are enough.
2. List processors and subsidiaries. Past two or three of each, one tool that matches them all saves more than another SuiteApp.
3. Decide whether you need a workflow or proof. Close platforms manage tasks. A matching tool proves the cash arrived.
4. Time one month. Upload last month's statement and payout reports and see how many lines tie out on their own before you pay.
NetSuite bank reconciliation questions
How do you do bank reconciliation in NetSuite?
Import the bank statement, let NetSuite propose matches against cash account transactions, accept or fix them, then reconcile the account so the cleared balance equals the statement balance. Unmatched lines such as net payouts and fees need manual work or a matching tool beside NetSuite.
Can NetSuite automate bank reconciliation?
Partly. NetSuite imports statements or bank feeds and applies matching rules to one to one lines, and it can create entries for rule based items such as fees. It does not explain a payout that covers many sales, so those lines stay manual.
What is the best NetSuite bank reconciliation software?
It depends on the gap. NetSuite's own matching suits clean one to one lines. A SuiteApp such as ZoneReconcile fits teams that want everything inside NetSuite. A matching tool such as Reconciles fits payout batches and many subsidiaries, from $888 a year, with no SuiteApp project.
Does NetSuite bank reconciliation work across subsidiaries?
Each bank account reconciles on its own, so every subsidiary repeats the work. Intercompany transfers have to agree on both sides before consolidation, and NetSuite leaves that comparison to you or to a separate tool.