Using Match Bank Data

Before continuing, make sure you’ve completed the following steps:

• Install the Atlar SuiteApp in NetSuite
• Import Bank Details to NetSuite (optional)

Matching bank data in NetSuite

🧩

Note:

Atlar does not perform reconciliation itself—it enables NetSuite’s native matching and reconciliation features by providing the bank data automatically and continuously.

Atlar automatically delivers your bank transactions into NetSuite through the Bank Feeds feature.
This ensures that your reconciliation data is always up to date—no manual uploads or file handling required.

To perform reconciliation, you will use NetSuite’s native Match Bank Data functionality.

This is usually done in 3 steps:

1. Matching transactions in Match Bank Data
2. Reviewing and confirming matches
3. Finalizing the reconciliation

In the sections below we will guide you through each step!

💡

Tip:

Atlar provides the complete, up-to-date transaction data, while NetSuite handles the actual reconciliation process.
This means your existing rules and workflows in NetSuite continue to function as normal—just with fresher data.

Step 1 – Matching Bank Data

1. Go to Transactions > Bank > Match Bank Data.
2. You’ll see two panels:
   • Bank Transactions – the data automatically retrieved by Atlar.
   • NetSuite Transactions – transactions recorded in your ERP.

Run the automatic reconciliation process using NetSuite’s built-in rule-based matching.
This attempts to pair imported bank transactions with existing NetSuite records based on criteria such as date, amount, and reference. You can also create and maintain your own reconciliation rules here.

When a match is found, it will appear under the Review tab after refreshing the page

Step 2 – Review and confirm matches

Under the Review tab, inspect all proposed matches.
From here you can approve or reject each pairing before finalizing reconciliation.

Approved matches are moved to the Reconcile Account Statement page for completion.

Step 3 – Finalize reconciliation

The last step of the reconciliation is done on a different page called Reconcile Account Statement. This is the final step in doing a full reconciliation for NetSuite.

1. Navigate to Transactions > Bank > Reconcile Account Statement.
2. Select your account of choice.
3. Select the submitted matches. ℹ️ Here you can choose to not include all of the reviewed matches.
4. Finalize the reconciliation to complete the process.