• North America
    • United Kingdom
    • Europe
  • Product
    • AP AutomationEnd-to-end, global payables solution designed for growing companies
    • Global PaymentsScalable mass payment solutions for the gig, ad tech, freelance, and marketplace economies
    • ProcurementComplete control and visibility over corporate spend
    • ExpensesMobile ready integrated expenses and global reimbursements
    • Product OverviewComprehensive payables technology to help your business streamline, simplify, and evolve
    • Integrations
      • Oracle NetSuite
      • Sage Intacct
      • QuickBooks
      • Microsoft Dynamics
      • Xero
      • View All
  • Solutions
    • Industries
      • Advertising Technology
      • Affiliate & Influencer Networks
      • Business Services
      • Ecommerce & Retail
      • Healthcare
      • Marketplace & Gig Economy
      • Software & Technology
      • Non-profits
      • View All
    • Services
      • Money Services Business
      • Currency Management
      • FX Hedging
      • Implementation
      • Supplier Enablement Program
  • Resources
    • Learn
      • Customer Stories
      • FinTalk Blog
      • FAQs
      • Guides
    • Connect
      • Newsroom
      • Partners
      • Events
  • Company
    • About
    • Careers
    • Accolades
    • Contact Us
    • Support
  • Login
  • Get Started
Get Started

NetSuite Bank Integration: How to Prepare Bank Deposits & Do Bank Reconciliation in NetSuite


We've paired this article with a comprehensive guide to handling accounts payable and global mass payments when using NetSuite. Get your free copy of The Last Mile of NetSuite: Payables Transformation Strategies!
Get the FREE guide
Home / NetSuite Hub / NetSuite Bank Integration

In a new era of banking, NetSuite has launched banking as a service to increase operational efficiency and cost savings. It’s a unique open banking approach to help NetSuite customers streamline financial services and improve bank relationships. This new banking solution is called NetSuite Banking as a Service. The solution makes the platform one of the leading fintech providers in the current tech climate.

Preparing Bank Deposits in NetSuite

In NetSuite, a business can record deposits to its bank accounts to capture customer payments and other monies received. This allows you to accurately track income by recording funds deposited. 

Usually, organizations post customer payments (cash, check, credit) to the “Undeposited Funds” ledger account rather than a specific bank account. This process is a painful path that creates a time lag between the amount shown on your books for an account and the actual bank balance. When you record a deposit in NetSuite, it moves funds out of the “Undeposited Funds” account to the ledger account for that bank account. This helps to accurately reflect the proper balances in real-time.

For a deposit, you can add funds, select payments received for existing transactions, or add monies not related to transactions. If an organization records customer payments directly to a bank account (rather than to “Undeposited Funds”), there is no need to create deposits for those amounts. To record deposits to your bank accounts, go to:

  • Transactions > Bank > Make Deposits 

Then follow these steps:

In the “Primary Information” section

  1. Select the custom form for the deposit.
  2. Choose the bank account. This displays the currency and exchange rate.
  3. The “Amount” field shows the total amount of payments, other deposits, and cashback selected.
  4. Accept the date or enter a new one.
  5. Select a posting period. (optional to also enter a memo).
  6. Check the “To Be Printed” box

In the “Classification” section

  1. Choose a department, class, and location for the deposit.
  2. On the “Deposits” subtab, enter the items for the deposit.
  3. On the “Other Deposits” subtab, enter anything not received as payments recorded to the “Undeposited Funds” account.
  4. On the Cash Back subtab, enter the amount of cash you received from the deposit, account number, classification, and memo and then click “Add.”

There is also a “Communications” tab where you can attach files and notes for the transaction. Once all data is entered, click “Save.”

All deposits can be saved and edited in the “Deposits” list. You can also delete a recorded deposit from the list.

How Do I Do a Bank Reconciliation in NetSuite?

There is no need for an excel or CSV file when you import account statements into NetSuite. You can match and reconcile transactions without them. The matching rules are on the “Confirm Transaction Matches” page. This section displays side-by-side lists of imported “Statement Transactions” and NetSuite General Ledger Transactions. You can then filter and select one or more from each list to choose the correct matches. 

The professional services from the original reconciliation pages are still available. Through the old tool, you can reconcile bank statements, enter transactions, hold reconciliations, and delete them. The new reconciliation features come with many enhancements. Not only are there improvements to intelligent matching, there is an account reconciliation portlet to work from. 

This new portlet provides advanced capabilities to meet customer expectations for treasury management. Additional benefits include:

  • Customers can now view a daily snapshot of total cash balances. This can be done across all Cash and Credit Card accounts.
  • It is easy to determine when each account was last reconciled.
  • You can view when the last statement was uploaded to the account. This includes any statement balances and outstanding items to match and clear.

Improvements to Intelligent Transaction Matching have also streamlined the system to increase revenue for consumers. Some new benefits to the matching program include:

  • It allows for faster automatic bank account reconciliations. This greatly reduces monthly processing times.
  • You can now apply rules to specific accounts (the previous version only allowed global rules).
  • An organization can deactivate default rules if required (or as an alternative to deleting them).
  • Additional transaction types help to increase granularity for creating matching conditions.

The Benefits of NetSuite Banking as a Service

Bank integration for NetSuite was the next logical step for such an intelligent service. Customers benefit from a variety of applications like embedded payments, deposits, lending, and reconciliations as part of their ERP. With direct access to financial services, users can interact with financial institutions in 8 different ways:

  • Remittance
  • Receivables
  • Payment
  • Account reconciliation
  • Working capital
  • Cash forecasting
  • Bank transfers
  • FX management

The ERP system offers a variety of revenue streams to elevate the customer experience in real-time. By consolidating these data centers, you improve customer relationships and create greater peace of mind. Benefits to NetSuite bank integrations include:

Writing Checks

When you need to pay an expense or record a non-check transaction, NetSuite business processes enable you to use the “Write Check” feature to issue a check.

Journal Entry

To create a transaction that will change the balance in a general ledger account, the Oracle NetSuite global business unit allows you to create a journal entry.

Moving Funds

You can shift funds from one account to another. You can also make transfers to non-bank accounts.

Credit Cards

With the NetSuite banking business model, a customer can add company credit lines, charges, pay the credit card bill, and then reconcile the entire statement. All within a single solution provider.

Account Mapping

The ERP solution allows you to create and save a record for a financial institution. You can then add multiple Format Profiles to it. Format Profiles allow a business to set up a bank transaction code for statement file formats to be imported.  

Online Banking

For an e-commerce, omni-channel commerce, or any business that uses online banking, NetSuite enables you to download transaction data from your bank or credit card company. You can then import the statement into the account. You can also automate your file uploads with the “Bank Connectivity” plug-in. 

NetSuite is an incredibly capable system that consolidates a variety of operational tasks into a simple dashboard. They consistently innovate to exceed consumer needs and will continue to do so for years to come.

About the Author

Brianna Blaney

Brianna Blaney began her career as a fintech writer in Boston for a major media corporation, later progressing to digital media marketing with platforms in San Francisco.
She has worked as a financial writer for Tipalti for 7+years, keeping a close eye on shifting trends and reporting on the ever-evolving landscape of financial automation.
She prides herself on reverse-engineering the logistics of successful content and implementing techniques centered around people (not campaigns).
In her spare time, she loves to cook and take care of her pet squirrel, Marshmallow.


RELATED ARTICLES

How to Set Up NetSuite Multi Currency: Features & Add-OnsHow to Set Up a NetSuite Invoice Approval WorkflowThe Best AP Automation Solution for Netsuite Ultimate Guide to Integration with NetSuite NetSuite vs QuickBooks: Comparison Guide 2023 Ultimate Guide to NetSuite Modules (with Complete List) NetSuite + Tipalti Enhances Your Payables Process The Complete Guide to NetSuite's Sandbox System NetSuite Bank Integration: Bank Deposits & Reconciliation Guide NetSuite Document Management with NetSuite's File Cabinet, Box, & DocuPeakHow to Import Transactions Data Into NetSuite

Footer

Solutions

  • Accounts Payable Automation
  • Global Partner Payments
  • Procurement
  • Expenses

Capabilities

  • Overview
  • Supplier Management
  • Invoice Management
  • PO Matching
  • Self-Billing Module
  • Payment Reconciliation
  • Global Payments
  • Fraud Detection
  • Tax and VAT Compliance

Why Tipalti

  • Why Tipalti
  • Customer Stories
  • Invoice-Based Workflow
  • Performance-Based Workflow
  • Benefits by Role
  • Benefits by Industry
  • Compare Tipalti

Technology

  • The Tipalti Platform
  • Multi-Entity Architecture
  • Financial Controls
  • Payment API
  • Secure Cloud
  • Money Services Business
  • Pi Payables Intelligence

Resources

  • The FinTalk Blog
  • What is AP Automation?
  • Compare Payment Methods
  • Future of Finance
  • Destination IPO
  • Payments Across Borders
  • The Total Guide to ERP Integration
  • Cost Per Invoice Calculator
  • Payment Error Calculator

Company

  • About Tipalti
  • Careers
  • Partnerships
  • Events
  • Press
  • In The News
  • Media Kit
  • Support
  • FAQs
  • North America
    • United Kingdom
    • Europe
Contact Us
LinkedIn Instagram Facebook Twitter YouTube
We Handled It.
Legal Agreements
|
Cookies Declaration
|
Privacy Policy
|
Payer / Sender Rights
|
Customer Assistance Policy
© 2010–2023 Tipalti Inc.