Skip to main content

Bank Flow

Complete end-to-end documentation of bank transactions in NetSuite - covering deposits, payments, transfers, and reconciliation.


In This Section

PageDescription
DepositsCustomer payments and bank deposits
PaymentsVendor payments and check runs
ReconciliationBank statement reconciliation

Master Flow Diagram

Bank Transaction Types
─────────────────────────────────────────────────────────────────

┌─────────────────────────────────────────────────────────────────┐
│ Money In │
├─────────────────────────────────────────────────────────────────┤
│ │
│ Customer Undeposited Bank │
│ Payment Funds Account │
│ ┌─────────┐ ┌─────────┐ ┌─────────┐ │
│ │ A/R │ ───▶ │ Holding │ ─── Deposit ▶│ Cash │ │
│ │ ↓ │ │ Account │ │ ↑ │ │
│ └─────────┘ └─────────┘ └─────────┘ │
│ │
└─────────────────────────────────────────────────────────────────┘

┌─────────────────────────────────────────────────────────────────┐
│ Money Out │
├─────────────────────────────────────────────────────────────────┤
│ │
│ Bank Vendor │
│ Account Payment │
│ ┌─────────┐ ┌─────────┐ │
│ │ Cash │ ─── Check/EFT ─────────────────▶│ A/P │ │
│ │ ↓ │ │ ↓ │ │
│ └─────────┘ └─────────┘ │
│ │
└─────────────────────────────────────────────────────────────────┘

┌─────────────────────────────────────────────────────────────────┐
│ Bank Transfer │
├─────────────────────────────────────────────────────────────────┤
│ │
│ Bank A Bank Transfer Bank B │
│ ┌─────────┐ ┌─────────────┐ ┌─────────┐ │
│ │ Cash │ ───▶ │ From → To │ ───────▶│ Cash │ │
│ │ ↓ │ └─────────────┘ │ ↑ │ │
│ └─────────┘ └─────────┘ │
│ │
└─────────────────────────────────────────────────────────────────┘

Banking Basics

Bank Account Types

TypePurposeExamples
CheckingOperating fundsMain operating account
SavingsReserve fundsEmergency fund
PayrollPayroll processingSalary payments
Money MarketShort-term investmentInterest-bearing

Key Transactions

TransactionDirectionGL Impact
Customer PaymentInA/R ↓, Undeposited Funds ↑
DepositInCash ↑, Undeposited Funds ↓
Vendor PaymentOutA/P ↓, Cash ↓
Bank TransferInternalFrom Bank ↓, To Bank ↑
Bank FeesOutExpense ↑, Cash ↓
InterestInCash ↑, Income ↑

The Undeposited Funds Flow

Why Undeposited Funds?
─────────────────────────────────────────────────────────────────

Real World:
You receive 5 checks during the day
At end of day, you take all 5 to the bank
Bank shows ONE deposit for all 5 checks

NetSuite:
Payment 1: $100 → Undeposited Funds
Payment 2: $200 → Undeposited Funds
Payment 3: $150 → Undeposited Funds
Payment 4: $300 → Undeposited Funds
Payment 5: $250 → Undeposited Funds
─────────────────────────────────────
Deposit: $1,000 → Bank Account

This matches your bank statement!

GL Flow Summary

GL Accounts Involved
─────────────────────────────────────────────────────────────────

Balance Sheet:
Bank/Cash Accounts (Assets)
└── Checking, Savings, Petty Cash

Undeposited Funds (Asset)
└── Temporary holding for payments

Accounts Receivable (Asset)
└── Customer balances

Accounts Payable (Liability)
└── Vendor balances

Income Statement:
Bank Fees (Expense)
└── Service charges, wire fees

Interest Income (Revenue)
└── Interest earned

Quick Reference

Transaction Summary

TransactionDebitCredit
Customer PaymentUndeposited FundsA/R
DepositBank AccountUndeposited Funds
Vendor PaymentA/PBank Account
Bank TransferTo BankFrom Bank
Bank FeeExpenseBank Account
Interest IncomeBank AccountIncome

Payment Methods

MethodProcessingClearing
CheckManualDays to clear
ACH/EFTElectronic1-3 days
WireElectronicSame day
Credit CardElectronicBatch dependent

Next Steps