Reconciliation
Match bank payments to invoices, credit notes, and fees across currencies and accounts.
Getting started with reconciliation
Core concepts: Understanding how Kolleno matches payments, handles fees, and processes different scenarios
Reconcile Open Banking PaymentsThis article explains how to reconcile Open Banking payments with your ERP or accounting platform.
Credit Notes ReconciliationYou can reconcile credit notes with your invoice. It creates a Customer Payment applying the credit note to the invoice in NetSuite.
Reconciliation History OverviewView, filter, and review all past reconciliation activities in your bank accounts
Bank account setup and management
Account configuration: Connect bank accounts, sync transactions, and manage account visibility
Updating Bank Feed MappingSet up the correct bank account mapping in your ERP.
Hide Specific Accounts to all Users in ReconciliationEasily hide confidential or unused bank accounts synced automatically by some banks.
Manual transaction imports
File uploads: Import bank transactions using standard banking file formats
Upload a NACHA file of Bank TransactionsManually import transactions into Kolleno Reconciliation.
Upload a BAI2 CSV file of Bank TransactionsManually import transactions into Kolleno Reconciliation.
Upload an ISO20022 file of Bank TransactionsManually import transactions into Kolleno Reconciliation.
Upload a BAI2 file of Bank TransactionsManually import transactions into Kolleno Reconciliation.
Special reconciliation scenarios
Advanced matching: Handle credit notes, Open Banking payments, and troubleshooting
Manually Retry a Reconciliation SyncHow to manually push a reconciliation match when it did not synchronize correctly with NetSuite.
“Synchronize now” button for bank accountsManually synchronize your bank accounts if and when your bank account outside of Kolleno has changed and you need it to reflect immediately.
Request Additional Fields Mapping for Bank Fee Journal EntriesFix failed bank fee postings in NetSuite by requesting additional field mapping for expense journal entries.
Applying a Payment to an Invoice with Bank FeesLearn how to reconcile payments that are slightly less than the invoice amount due to bank fees.
How To Reconcile
Learn how to reconcile using Kolleno
How Kolleno Reconciles Bank Fees in NetSuiteAuto NetSuite bank fee reconciliation: Kolleno posts journal entries, no manual work.
How suggested matches are determinedLearn how Kolleno suggests invoice matches when applying a payment.
How to record overpayments?Learn how to record and reconcile customer payments that exceed the invoice amount.
How Kolleno Handles Customer Payments for Invoices in Different CurrenciesKolleno automates NetSuite’s multi-step FX payment reconciliation, eliminating manual entries.
How Kolleno Handles Customer Overpayment Write-Offs in NetSuiteKolleno automates NetSuite write-offs for small customer overpayments, ensuring clean A/R.
How to Match a Single Payment to a Single InvoiceMatching a single payment to a single invoice is the simplest type of reconciliation. To do this, follow the steps below:
How to Match One Payment to Multiple Invoices Using RemittanceLearn how to apply a single payment to multiple invoices using remittance advice for faster reconciliation.
How to Apply a Partial Payment Against an Invoice BalanceLearn how to record partial customer payments and track outstanding invoice balances in Kolleno.
How to Match a New Payment with an Invoice and a Pre-Existing PaymentLearn how to apply both new and pre-existing payments to fully clear an invoice in Kolleno.
How to Allocate a Payment Across Multiple Customers’ InvoicesLearn how to split one payment across invoices from different customers in Kolleno.
How to Match a Payment to an Invoice and a Credit NoteLearn how to apply a payment and a credit note together to fully reconcile an invoice in Kolleno.
How to exclude non-matching transactions from your reconciliation view?Hide transactions not meant for matching from your bank feed data view using tags and filters.
Updating the Payment Memo when matching payments in Kolleno (NetSuite)Adjust what appears in the Payment Memo field sent to NetSuite when matching payments in Kolleno.
How Invoices Are Automatically Suggested When a Remittance Is Received via EmailUnderstand how Kolleno automatically processes remittance files from customer emails and uses them to suggest invoice matches during reconciliation.
How to View Full Payment Source Data in Bank ReconciliationAccess complete backend payment metadata for full transparency when matching bank transactions to invoices.
SFTP Reconciliation
SFTP Reconciliation
Connecting Unsupported Banks to KollenoSome banks are not available for direct connection in Kolleno. In these cases, automated statement imports are still possible using SFTP.
How Automatic Bank Statement Imports Work With SFTPIf your bank provides statements via SFTP, Kolleno can securely retrieve and process them automatically without manual uploads.
Setting Up Your Bank’s SFTP Connection in KollenoIf your bank provides statements via SFTP, Kolleno can use this connection to automatically import and process statements without manual uploads.
Bulk Create SFTP Reconciliation AccountsKolleno provides a way for bulk creating SFTP and manual upload reconciliation accounts via CSV.