NetSuite Bank Reconciliation, Screen by Screen
The bank has closed the month, and Match Bank Data still shows a column of bank lines with nothing beside them. NetSuite reconciles in two places: you match on Match Bank Data, and you reconcile on Reconcile Account Statement. Most of the month-end effort sits in what the rules leave behind on the first page.
Get the bank data in, from a bank connection or an imported statement file.
Match on Match Bank Data: let the rules run, match the rest, then Submit to clear them.
Transactions › Bank › Match Bank DataReconcile the submitted transactions against the statement.
Transactions › Bank › Reconcile Account StatementOne account through a NetSuite month-end
- 1
Make sure the newer pages are on
New accounts have them already. On an older bank account, edit the account record and tick Use Match Bank Data and Reconcile Account Statement Pages. You'll also need a role with the banking permissions.
- 2
Bring in the bank lines
With a bank connection, through the Bank Feeds SuiteApp or a Bank Connectivity Plug-in, data arrives on its own. Without one, you import a statement file. NetSuite's default parsers read BAI2, CAMT.053, CSV, OFX and QFX. QIF isn't supported.
Watch for: Oracle describes manual import as meant for small volumes, and recommends keeping a single import under 10,000 transactions.
- 3
Let the reconciliation rules run
Intelligent Transaction Matching runs your rules as the data is imported. Change a rule? Click Run Reconciliation Rules to try them again. If you use Automated Cash Application, it goes first and creates customer payments from bank lines where it can.
- 4
Match what the rules missed
Match Bank DataBank lines sit on one side, NetSuite transactions on the other. Pair them up, mark transactions with no bank line as cleared, and exclude bank lines that shouldn't count. Then Submit them, which clears them in NetSuite.
- 5
Reconcile against the statement
Reconcile Account StatementReview what you submitted, include or exclude anything that belongs in another period, and finish the reconciliation once it agrees with the statement.
What clears by rule, and what waits for a person
The payout line no rule will catch
A Stripe, PayPal or Shopify payout lands as one deposit covering dozens of orders, minus processing fees, refunds and the odd chargeback. In NetSuite, those orders exist as separate payments, and the fees don't exist at all until somebody enters them. No rule can match a bank line to a total NetSuite has never seen.
Stripe sells its own NetSuite connector, but most businesses take money through more than one channel. n-frames builds the missing piece across PayPal, Shopify and several processors at once. It reads each payout from the processor's own report, creates one NetSuite deposit holding the right customer payments, with fees, refunds and chargebacks on their own lines, and dates it to the payout. The bank line then has an exact partner, and your matching rules clear it like any other. Only payouts whose report doesn't add up get left on Match Bank Data for a person.
That's a SuiteScript job, often running alongside the billing setup that created the invoices in the first place.
NetSuite bank reconciliation FAQ
What's the difference between Reconcile Bank Statement and Match Bank Data in NetSuite?
Reconcile Bank Statement is the older, single page: you type the statement balance and tick transactions until the difference is zero. The newer setup splits that into two. Match Bank Data handles pairing imported bank lines with NetSuite transactions, and Reconcile Account Statement handles the reconciliation itself.
Can NetSuite automatically reconcile bank transactions?
It can match a lot automatically. System rules, your own matching rules and auto-create rules all run when bank data arrives. What's left is anything NetSuite has no exact record for, like a net payout or a deposit nobody's entered. Those need a person, or a script that creates the record first.
What is cash application in NetSuite?
It's deciding which open invoices a customer payment pays off. Reconciliation is a later step: it confirms a bank line against a transaction already in NetSuite. Automated Cash Application can create payments from bank lines where it has enough to go on. Payments covering several invoices, or arriving short, are where it gets slow.
How do I record a bill payment in NetSuite?
Use Transactions > Payables > Pay Bills, pick the vendor and the bills, and save. For a wire or a hand-written check, enter the bill payment directly so it's there for the bank line to match.
Does NetSuite connect directly to my bank for reconciliation?
It can. The Bank Feeds SuiteApp or a Bank Connectivity Plug-in brings transactions in automatically. Not every bank is covered, so plenty of companies still download a BAI2, CAMT.053, CSV, OFX or QFX file and import it.