{"id":10682,"date":"2025-02-21T17:21:04","date_gmt":"2025-02-21T11:51:04","guid":{"rendered":"https:\/\/helpcenter.nexterp.in\/helpcenter\/?p=10682"},"modified":"2026-02-06T12:59:09","modified_gmt":"2026-02-06T07:29:09","slug":"how-can-i-reconcile-differences-between-the-fee-collection-report-and-the-settlement-report","status":"publish","type":"post","link":"https:\/\/helpcenter.nexterp.in\/helpcenter\/how-can-i-reconcile-differences-between-the-fee-collection-report-and-the-settlement-report\/","title":{"rendered":"How can I reconcile differences between the fee collection report and the settlement report?"},"content":{"rendered":"\n

Reconciliation ensures the accuracy and consistency<\/strong> of financial records, particularly between the Fee Collection Report<\/strong> and the Settlement Report<\/strong>. Below is a step-by-step guide to conducting an effective reconciliation.<\/p>\n\n\n\n

Part 1: Understanding the Reports<\/strong><\/h2>\n\n\n\n

1\ufe0f\u20e3 Fee Collection Report<\/strong><\/h3>\n\n\n\n

Overview<\/strong><\/h4>\n\n\n\n

The Fee Collection Report provides receipt-wise collection details<\/strong> for all active collections under Normal Collection<\/strong> in NextOS.<\/p>\n\n\n\n

It includes key details such as:
\u2705 Receipt No.<\/strong>
\u2705 Collection & Payment Date<\/strong>
\u2705 Payment Mode & Instrument Details<\/strong>
\u2705 Payment Status<\/strong>
\u2705 Fine & Concession<\/strong>
\u2705 Fee Type-wise Breakup<\/strong>
\u2705 Total Collected Amount<\/strong><\/strong><\/p>\n\n\n\n

How to Download<\/strong><\/h4>\n\n\n\n

\ud83d\udccc Navigate to:<\/strong> Finance -> Fee -> Fee Reports -> 1.1 Fee Collection Report<\/strong>
\ud83d\udccc Generate the Report<\/strong>
\ud83d\udccc Export as PDF or Excel<\/strong><\/p>\n\n\n\n

\ud83d\udcd6 For a detailed guide, refer to:<\/em>
[Fee Collection Report Overview<\/a>]<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

2\ufe0f\u20e3 Settlement Report<\/strong><\/h3>\n\n\n\n

Overview<\/strong><\/h4>\n\n\n\n

The Settlement Report provides details of successful and refunded online payments<\/strong>.<\/p>\n\n\n\n

\ud83d\udccc Note:<\/strong> Settlements occur T+2 days<\/strong> after a successful payment.<\/p>\n\n\n\n

How to Download<\/strong><\/h4>\n\n\n\n

\ud83d\udccc Navigate to:<\/strong> Finance -> Payment Gateway -> Payment Gateway Reports -> Settlement Report<\/strong><\/p>\n\n\n\n

\ud83d\udcd6 For a detailed guide, refer to:<\/em>
[Settlement Report Overview<\/a> ]<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Part 2: Reconciling the Reports<\/strong><\/h2>\n\n\n\n

1\ufe0f\u20e3 Match Receipt IDs<\/strong><\/h3>\n\n\n\n

\u2714\ufe0f Use the Receipt ID<\/strong> from the Fee Collection Report<\/strong> to locate the corresponding payment in the Settlement Report<\/strong>.
\u2714\ufe0f Ensure each receipt ID has a matching entry in the Settlement Report<\/strong>.<\/p>\n\n\n\n

2\ufe0f\u20e3 Verify Payment Status<\/strong><\/h3>\n\n\n\n

\u2714\ufe0f Ensure each transaction in the Settlement Report<\/strong> is marked as Settled<\/strong>.
\u2714\ufe0f If a payment is still Pending<\/strong>, check with the Payment Gateway Provider<\/strong> for the reason.<\/p>\n\n\n\n

3\ufe0f\u20e3 Account for Settlement Delays<\/strong><\/h3>\n\n\n\n

\u2714\ufe0f Online payments usually take 2-3 days<\/strong> to settle.
\u2714\ufe0f Confirm that the settlement period<\/strong> matches the transaction date in the Fee Collection Report<\/strong>.<\/p>\n\n\n\n

Part 3: Resolving Discrepancies<\/strong><\/h2>\n\n\n\n

1\ufe0f\u20e3 Unmatched Transactions<\/strong><\/h3>\n\n\n\n

\ud83d\udd38 If a transaction appears in the Fee Collection Report<\/strong> but is missing from the Settlement Report<\/strong>, check if:
\u2705 The transaction failed<\/strong> or was reversed<\/strong>.
\u2705 Contact Support<\/strong> for further clarification.<\/p>\n\n\n\n

2\ufe0f\u20e3 Duplicate Entries<\/strong><\/h3>\n\n\n\n

\ud83d\udd38 Ensure no transactions are recorded twice<\/strong> in either report.<\/p>\n\n\n\n

3\ufe0f\u20e3 Partial Settlements<\/strong><\/h3>\n\n\n\n

\ud83d\udd38 If only part of a payment is settled, investigate the remaining amount with the payment gateway provider<\/strong>.<\/p>\n\n\n\n

4\ufe0f\u20e3 Offline Payments<\/strong><\/h3>\n\n\n\n

\ud83d\udd38 Exclude offline payments<\/strong> from reconciliation, as they do not go through the payment gateway<\/strong>.<\/p>\n\n\n\n

Part 4: Real-Life Example<\/strong><\/h2>\n\n\n\n

\ud83d\udccc Scenario:<\/strong><\/h3>\n\n\n\n

A parent<\/strong> paid Rs. 5,000<\/strong> via the NLP app<\/strong> for a student\u2019s fees.<\/p>\n\n\n\n