Reconcile your NetSuite GL cash account against your bank statement offline. Pre-labeled fields for subsidiary, GL account, and bank account. Download in Excel, Word, or PDF.
Fill in the NetSuite-specific fields below and watch the live preview update. Download the completed statement when you are done.
Pick Excel, Word, or PDF. Each has NetSuite-specific fields for subsidiary, bank account, and GL account pre-labeled.
Fill in your subsidiary name, bank account, GL account number, statement date, and preparer name.
Enter the bank statement ending balance and GL cash balance. Add deposits in transit, outstanding payments, bank fees, and interest.
If both adjusted balances match, save a copy for your records. Compare against NetSuite's built-in reconciliation report.
Grab a blank template in the format that fits your workflow. Every version follows the same two-sided layout with NetSuite fields pre-labeled.
Spreadsheet with formulas. Best for teams that reconcile alongside NetSuite reports.
Pre-formatted document with tables. Best for sign-off copies and controller review.
Print-ready layout. Best for physical sign-off and audit binders.
Stop matching bank data manually. Let Bluecopa auto-reconcile across all your NetSuite subsidiaries and flag exceptions in real time.
NetSuite offers bank reconciliation through its built-in Reconcile Bank Statement page and the Match Bank Data feature. Both approaches compare bank transactions against GL entries to identify and resolve differences.
Upload a CSV bank statement through Match Bank Data, or connect automated bank feeds to pull transactions directly into NetSuite.
Match Bank Data compares imported transactions against NetSuite records using amount, date, and reference. Matched items are flagged for clearing.
Open the Reconcile Bank Statement page to check items that were not auto-matched. These are typically timing differences or unrecorded bank charges.
Post journal entries for bank fees, interest, and corrections. Each entry updates the GL and links to the bank statement period.
Click Reconcile when the adjusted balances match. NetSuite marks the statement as reconciled and locks those transactions from further changes.
Common NetSuite bank reconciliation problems come from mismatched subsidiaries, stale bank feeds, or clearing items in the wrong period.
In NetSuite, go to Transactions > Bank > Reconcile Bank Statement. Select the bank account, enter the statement ending balance, and check off transactions that appear on both the bank statement and NetSuite. Use Match Bank Data for automated matching of imported bank feeds.
Match Bank Data is NetSuite's automated bank reconciliation feature. It imports bank transaction data via bank feeds or CSV and matches it against NetSuite transactions using amount, date, and reference criteria.
Yes. NetSuite supports automated bank feeds through partner integrations that pull transaction data directly from your bank. Alternatively, you can import bank statements as CSV files through the Match Bank Data feature.
Yes. No cost, no account, no watermark. The interactive tool runs in your browser and the downloadable files are yours to keep.
Yes. NetSuite supports multi-subsidiary reconciliation. Each subsidiary has its own bank accounts and GL. Download a separate copy of this template for each subsidiary's bank account.
NetSuite accepts CSV files for bank statement import through Match Bank Data. Bank feed integrations handle the format conversion automatically. QFX/OFX formats are also supported through certain connectors.
Templates work for a handful of accounts. When you manage multiple subsidiaries, handle high transaction volumes, or spend more than a day per month reconciling in NetSuite, automation tools like Bluecopa can auto-match and flag exceptions across all subsidiaries.