Overview
When banks charge processing fees on customer payments, Kolleno automatically creates the necessary NetSuite journal entries to properly account for these fees, eliminating manual reconciliation work.
This solution is based on NetSuite SuiteAnswer ID 23089.
The Problem
Customer pays $100 invoice → Bank deposits $90 (after $10 fee) → Your books need to reflect both the full payment and the bank charge.
Prerequisites
Configure your General Ledger Mapping with:
Bank Ledger Category: Your bank asset account
in Kolleno: Bank Ledger
Accounts Receivable Category: Your bank asset account
in Kolleno: Accounts Receivable
Expense Category: Your bank fees expense account
in Kolleno: Processing Fees
Automatic Process (With Kolleno)
When Kolleno detects a bank fee, it creates a NetSuite journal entry:
Step A – Bank Fee Journal Entry
Journal Entry
Debit: Expense Account – $10.00 (linked to customer)
Credit: Accounts Receivable Account – $10.00 (linked to customer)
Step B – Customer Payment Application
Customer Payment
Debit: Bank Ledger Account – $90.00 (actual deposit applied to invoices)
Debit: Expense Account – $10.00 (covers the bank fee)
Credit: Accounts Receivable – $100 (clears the invoice)
This balances (debits = credits) and shows the real flow: customer’s invoice cleared for $100, with $90 hitting cash and $10 hitting fees.
Manual NetSuite Process (Without Kolleno)
Step A- Create Journal Entry
Navigate to Transactions > Financial > Make Journal Entries
Entry should be:
Debit Bank Service Charge (Expense account) 10.00; select Customer linked to this Journal in Name column.
Credit Accounts Receivable 10.00; select Customer linked to this Journal in Name column
Step B - Accept Customer Payment
Navigate to Transactions > Customers > Accept Customer Payments
Mark the Apply checkbox for the Invoice(s)/Journal(s) to be paid under the Apply tab > Invoices subtab
Mark the Journal Entry with the debited Expense account under Apply tab > Credits sub tab
Save the Payment
GL Impact will be:
Debit Undeposited Funds / Bank Account 90.00
Credit Accounts Receivable 90.00