Customer reconciliation, frequently asked questions
Everything you need to know about matching customer receipts and collections with your books using CleverBalance.
General questions
What is customer reconciliation?
Customer reconciliation is the process of matching your books (AR ledger) with customer payments, receipts, or statements to ensure that invoices are correctly settled and all collections are accounted for.
What files do I need to start?
You need customer statement, payment report, or collection data in CSV or Excel format, along with your books or AR ledger in CSV or Excel. You can upload data from any system, and no fixed format is required.
Do both files need to have the same structure?
No. CleverBalance standardizes both datasets internally, so differences in column names, date formats, and reference formats do not affect reconciliation.
Matching & accuracy
How does CleverBalance match receipts with invoices?
CleverBalance uses invoice and reference matching, amount and date logic, rule-based matching for structured cases, and AI-based matching for complex scenarios. This ensures both accuracy and flexibility.
Can it handle partial payments?
Yes. CleverBalance can match one invoice against multiple receipts and multiple partial payments over time. As long as the total amount aligns, the system identifies the match.
Can it handle one payment for multiple invoices?
Yes. Bulk or consolidated payments are automatically matched to multiple invoices when totals match.
What are unapplied receipts, and can this identify them?
Unapplied receipts are payments recorded without being linked to specific invoices. CleverBalance highlights these clearly in the unmatched section so you can allocate them correctly and identify missing invoice references.
How does it handle short or excess payments?
CleverBalance detects short payments where invoice amount is greater than receipt, and excess payments where receipt is greater than invoice. These are surfaced clearly for review and adjustment.
What if invoice or receipt references do not match exactly?
The system can still match transactions using similar or partial references, amount matching, date proximity, and description similarity. AI helps resolve cases where references are inconsistent.
What if there is a delay between invoice and payment?
CleverBalance allows for date differences, helping handle late payments, backdated entries, and cross-period reconciliation.
Does the system ever force incorrect matches?
No. CleverBalance ensures amounts always balance, avoids low-confidence matches, and leaves uncertain cases as unmatched for review.
Output & review
What does the output look like?
You get two clear outputs: matched transactions where invoices and receipts are linked, and unmatched transactions where items need action.
Can I download the results?
Yes. You can download Excel reports with matched transactions and unmatched transactions. These are audit-ready and easy to review.
How do I identify missing receipts?
Invoices present in books but not matched with any receipt appear as unmatched, helping you identify missing collections.
Can I identify overpayments or incorrect entries?
Yes. The system highlights excess payments, duplicate entries, and incorrect postings.
Practical usage
Is this suitable for high-volume collections?
Yes. CleverBalance is built to handle large datasets, high-frequency transactions, and complex AR workflows.
Can accounting firms use this for multiple clients?
Yes. CleverBalance works well for CA and CPA firms managing multiple clients with different formats and reconciliation needs.
How long does reconciliation take?
Typically a few minutes depending on file size. What takes hours in Excel can be completed quickly.
Do I need training to use this?
No. The process is simple: upload, map columns, run, and review. Most users can start immediately.
Is my data secure?
Yes. Your data is securely processed and used only for reconciliation purposes.
Getting started
Can I try this with my own data?
Yes. You can upload your own customer data and books and run reconciliation immediately.
Is there a free trial?
Yes. CleverBalance offers a 14-day free trial with no credit card required.
Still tracking customer payments manually?
Upload your data and see how easily invoices and receipts get matched, with clear visibility into your collections.
No credit card and 14-day free trial