What we do
Tools
Industries
Department
How we workLet's talk →
Home/NetSuite/NetSuite Bank Reconciliation and Unmatched Lines
NetSuite

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.

The order of work

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 Data

Reconcile the submitted transactions against the statement.

Transactions Bank Reconcile Account Statement

One account through a NetSuite month-end

  1. 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. 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. 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. 4

    Match what the rules missed

    Match Bank Data

    Bank 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. 5

    Reconcile against the statement

    Reconcile Account Statement

    Review 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

What's on the bank line What NetSuite already does Where it stalls
A check or bill payment at its exact amount System rules match it, for example on transaction number and amount. Check numbers keyed wrong on either side. A user matching rule can compare the bank's transaction ID with the NetSuite check number.
The same bank fee or interest every month An auto-create rule, made from a one-to-one match, creates the transaction for you next time. Fees that need a tax code or more than one expense line. Auto-create rules don't handle those.
Several deposits combined on one bank line The transaction number and amount rule can match many-to-one when the amounts add up exactly. Anything where the totals never add up exactly, which brings you to the next row.
A card processor payout, net of fees and refunds Nothing. There's no NetSuite record at the payout's amount for a rule to find. This is the line that stays open every month. It needs a deposit built from the payout report first.
A transfer between two subsidiaries Matches on each side once both sides are recorded. The other entity hasn't booked its half yet, so one bank account waits on the other.

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.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.