Reconciliation
Match bank payments to invoices, credit notes, and fees across currencies and accounts.
Credit Notes ReconciliationYou can reconcile credit notes with your invoice. It creates a Customer Payment applying the credit note to the invoice in 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.
Updating Bank Feed MappingSet up the correct bank account mapping in your ERP.
Reconcile Open Banking PaymentsThis article explains how to reconcile Open Banking payments with your ERP or accounting platform.
How Kolleno Reconciles Bank Fees in NetSuiteAuto NetSuite bank fee reconciliation: Kolleno posts journal entries, no manual work.
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:
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 suggested matches are determinedLearn how Kolleno suggests invoice matches when applying a payment.
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 record overpayments?Learn how to record and reconcile customer payments that exceed the invoice amount.
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.
Upload an ISO20022 file of Bank TransactionsManually import transactions into Kolleno Reconciliation.
Reconciliation History OverviewView, filter, and review all past reconciliation activities in your bank accounts
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.
Hide Specific Accounts to all Users in ReconciliationEasily hide confidential or unused bank accounts synced automatically by some banks.
Upload a BAI2 CSV file of Bank TransactionsManually import transactions into Kolleno Reconciliation.
Request Additional Fields Mapping for Bank Fee Journal EntriesFix failed bank fee postings in NetSuite by requesting additional field mapping for expense journal entries.
Upload a NACHA file of Bank TransactionsManually import transactions into Kolleno Reconciliation.