Reconciliation
Match bank payments to invoices, credit notes, and fees across currencies and accounts.
36 articles
Getting started with reconciliation
Core concepts: Understanding how Kolleno matches payments, handles fees, and processes different scenarios
- Reconcile Open Banking PaymentsConfigure Open Banking payments to post directly to your bank account in your ERP for automatic reconciliation.
- 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
- Yapily Open Banking are missing in KollenoContact support when transactions from your Yapily Open Banking connection are missing in Kolleno.
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.
- Bank accounts for different currenciesI use different bank accounts for different currencies – How is this reflected in Kolleno?
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.
- NetSuite payment push retry on different subsidiariesRecover from NetSuite subsidiary mismatches by retrying against the customer's other subsidiaries.
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.
- How to Reconcile DepositsLearn how to match bank transactions against deposit records in Kolleno without posting to NetSuite.
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.