How Do You Find and Close Account Reconciliation Differences? Training on Letters and Statements, Difference Types, Difference Analysis, Correcting Entries and Unresponsive Accounts
How do you find and close account reconciliation differences? Letters, statements, difference types, difference analysis and correcting entries: a hands-on 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is the purpose of account reconciliation?
- Lesson 2: What preparation is done before sending letters?
- Lesson 3: How do you send the letter and track the reply?
- Lesson 4: What causes account balance differences?
- Lesson 5: How do you analyze a difference?
- Lesson 6: How are correcting entries made?
- Lesson 7: How do you manage accounts that do not reply?
- Lesson 8: How do you set up a period-end reconciliation routine?
- What are the most common mistakes in account reconciliation?
- How does NetKasam make account reconciliation easier?
- Mini quiz: Test what you have learned
- Conclusion: This period, check the statements of your 10 largest accounts in advance
- Frequently Asked Questions About Account Reconciliation Differences
At month end you sent balance letters to your 40 largest customers. About thirty said "we agree", a few reported a different balance, and a few did not reply at all. The differences of those reporting a different balance total ₺42,000, and nobody knows where it came from: one says "your invoice never reached us", another "you didn't deduct the return", another "we made the payment". Sending the letter is only the first half of reconciliation; the real work is finding the difference and closing it. If this is not done systematically, the same argument reopens every period.
This article is not a lecture but an 8-lesson hands-on training. We will answer the question how do you find and close account reconciliation differences with numbers, using a sample period with 40 letters: the purpose of reconciliation, preparation before the letters, tracking replies, difference types, difference analysis, correcting entries, managing accounts that do not reply, and the period-end routine. At the end there is a mini quiz and an answer key. For the general definition of reconciliation, see the article what is account reconciliation and how is it done; here we tackle the hard part of the practice, resolving differences.
What will you be able to do by the end of this training?
In short: Before the reconciliation letter you will fix the cut-off date, track replies, separate differences by type, make correcting entries with documents and manage accounts that do not reply systematically.
- 01PreparationFix the cut-off date and the statement.
- 02SendingSend the letters and the online statement.
- 03ReplySort replies into agreed, different and no reply.
- 04AnalysisBreak differences down by type.
- 05CorrectionClose them with a document or a correcting entry.
- 06Follow-upCall the non-responders in turn.
The 8 lessons of the training: (1) the purpose of reconciliation, (2) preparation, (3) letters and reply tracking, (4) difference types, (5) difference analysis, (6) correcting entries, (7) accounts that do not reply, (8) period-end routine.
Lesson 1: What is the purpose of account reconciliation?
In short: Reconciliation documents that the balance comes out the same on both sides. If it does not, the difference is found before the payment and dispute stage.
| Without reconciliation | With reconciliation |
|---|---|
| The difference surfaces at the time of payment | The difference is found at period end |
| The customer says "I never saw the invoice" | Missing documents are sent on time |
| The balance argument drags on over the phone | The written reply is on record |
| The receivable is not reliable | The receivable is confirmed |
For an e-commerce seller, accounts are not only corporate customers: the dealers you sell to wholesale, your suppliers and the companies you get shipping or services from are also account records. Reconciliation is verifying these mutual balances. For the basics of current accounts, see the article how to track current accounts and the customer and supplier account tracking page. Sample business: a wholesaler that sells on credit terms to dealers and corporate customers and reconciles with its 40 largest accounts at month end.
Lesson 2: What preparation is done before sending letters?
In short: First make sure your records are complete as of month end: no unissued invoices, unentered collections or unprocessed returns should remain. A letter sent with incomplete records produces a difference of your own making.
| Preparation | Control |
|---|---|
| Cut-off date | The same day for all accounts (e.g. last day of the month) |
| Invoices | All invoices for the period issued |
| Collections | Bank and cash collections posted to the accounts |
| Returns | Return invoices issued |
| Which accounts? | Those with a balance above a set amount |
For complete records, see the articles how to do the month-end close and, for matching bank transactions, how to do a bank reconciliation. If there are many accounts to reconcile, start with those with the highest balances; in the example, the 40 accounts represent most of the total receivables.
Do an internal check before the letter too: if you both sell to and buy from the same company (companies that are both customer and supplier), assess the two balances separately and state clearly in the letter which balance you are confirming. In NetKasam, customer and supplier balances appear separately, but the other party may be recording both as a single company. With accounts like these that you trade with in both directions, part of the difference comes from how the two sides net their balances; attaching the statement to the letter prevents this confusion.
Product pageFree Bookkeeping SoftwareLesson 3: How do you send the letter and track the reply?
In short: In NetKasam you send a reconciliation letter from the account statement with one click and wait for the other party's reply. With the online statement you can share account transactions with your customer or supplier.
- Agreed₺2972.5%
- Reported a different balance₺717.5%
- Did not reply₺410%
Prepared with sample values. Reconciliation rate 72.5%.
| Reply | Count | Next step |
|---|---|---|
| Agreed | 29 | Archive the reply, close the period |
| Different | 7 | Difference analysis (Lesson 5) |
| No reply | 4 | Reminder, phone call (Lesson 7) |
State the reply period in the letter; some businesses use a phrase like "if no reply is received within 10 days, it is deemed agreed"; consult your certified public accountant (mali müşavir) about its legal effect. Sharing the online statement when you send the letter makes it easier for the other party to find the difference themselves; the statement shows invoice and collection transactions one by one.
Lesson 4: What causes account balance differences?
In short: Most differences come from four causes: timing, returns, collections in transit and recording errors. Knowing the cause also determines the solution.
| Difference type | Example | Solution |
|---|---|---|
| Timing | Invoice issued on the last day of the month, other party recorded it the following month | Confirm the invoice reached the other party |
| Return | Return invoice for returned goods exists on the other side, not on ours | Issue and record the return invoice |
| Collection in transit | Customer has paid, payment not yet posted on our side | Check the bank transaction, post the collection |
| Recording error | Wrong amount or recorded to the wrong account | Correcting entry, with its document |
For resolving return differences, see the article how to issue a return invoice, and for invoice timing, within how many days must an invoice be issued. In the example, our receivable balance is higher than the other party's records; differences can also go the other way and are resolved with the same method.
Lesson 5: How do you analyze a difference?
In short: Drill the difference down to individual transactions and break it into causes. The analysis is not finished until the amounts of the causes add up to the total difference.
- Our receivable balance₺640,000
- Timing difference−₺24,000
- Return difference−₺9,000
- Collection in transit−₺6,000
- Recording error−₺3,000
- Other party's balance₺598,000
Prepared with sample values. Total difference ₺42,000.
- Timing₺24,000
- Returns₺9,000
- Collection in transit₺6,000
- Recording error₺3,000
Prepared with sample values. Timing share 57.1% (24,000 ÷ 42,000).
- Reconciliation rate = Agreed accounts ÷ Letters sent × 100
- Difference = Our balance − Other party's balance
- Explained difference = Sum of the causes; must equal the difference
- Timing share = Timing difference ÷ Total difference × 100
Prepared with sample values.
A timing difference does not mean the balance is wrong; it only shows that the recording dates differ, and it closes with confirmation that the invoice reached the other party. Return, collection and error differences, however, require corrections in your own records. So although the total difference is ₺42,000, the real correction burden is ₺18,000 (9,000 + 6,000 + 3,000); the remaining ₺24,000 closes with document confirmation.
Lesson 6: How are correcting entries made?
In short: Instead of deleting an incorrect entry, cancel it and enter the correct one. A return invoice for returns, a collection entry for payments and a correcting entry for errors are made together with the document.
| Difference | Recording | Document |
|---|---|---|
| Return difference | Return invoice is issued and posted to the account | Return invoice, return shipment details |
| Collection in transit | Collection entry is made | Bank receipt |
| Recording error | Incorrect entry is cancelled, correct one is entered | Invoice or transaction document |
| Timing difference | No entry needed | Confirmation showing the invoice arrived |
In NetKasam, all transactions of a cancelled or deleted expense voucher are updated with a reversing entry; apply the same principle to incorrect account entries: cancel instead of deleting and re-enter the correct one, so balances stay consistent and the trail stays visible. You can store documents, contracts and correspondence related to account transactions on the account card with digital document management; this way the reconciliation reply is also archived with the related account. For accounts that use cheques and promissory notes, see the article how to track cheques and promissory notes.
Lesson 7: How do you manage accounts that do not reply?
In short: An account with no reply is not an agreed account. Proceed in order with a reminder, a phone call and a second letter; if it stays inconclusive, archive the written notice.
| Day | Step | Channel |
|---|---|---|
| Letter + 7 | Reminder | Email or SMS |
| Letter + 14 | Phone call | Phone |
| Letter + 21 | Second letter, with the statement | Formal letter |
| Period close | Record the status, move to the risky class | Internal record |
In NetKasam, automatic reminders for payments approaching or past due and template-based balance reminders by bulk SMS are available. If an account with no reply also carries payment risk, review its risk limit; for the method, see the article how to set a customer risk limit. For overdue receivables, the article how to track receivables is a useful complement.
- 72.5%reconciliation rate (29 / 40)
- ₺42,000total difference across 7 accounts
- 57.1%difference due to timing
- ₺18,000difference requiring correction
Keep a log for accounts that do not reply: on which date and through which channel they were contacted, whom you spoke with and what was said. This small diary documents the "letter sent, reminded, spoken to" chain if a dispute arises later. If the same account fails to reply two periods in a row, it is usually not a reconciliation problem but a relationship or payment problem; at that point the matter should be handled together with sales and management, and limit and payment terms should be renegotiated.
Lesson 8: How do you set up a period-end reconciliation routine?
In short: Reconcile not once a year but at month or quarter end. Small differences are resolved while they are small.
| When? | What to do? | Who? |
|---|---|---|
| Period end | Statements are prepared, letters are sent | Accounting |
| Letter + 7 days | Replies are counted, reminders are sent | Accounting |
| Letter + 14 days | Differences are analyzed by cause | Accounting |
| Letter + 21 days | Corrections are completed, written notice for non-responders | Accounting |
| Once a quarter | Reconciliation rate and difference types are reviewed | Management |
Write down the reconciliation rate every period: 72.5% in the example. If the rate is rising, your recording discipline is settling in; if it is falling, look for the reason in the difference types (if there are many timing differences, issue invoices earlier). You can use the reports screen to save reports and export them to Excel. For mutual balances on the supplier side, see the article how to plan supplier payments.
Recommended readingHow to Do the Month-End Close?What are the most common mistakes in account reconciliation?
- Sending letters while records are incomplete. You produce a difference of your own making.
- Sending a letter without a statement. The other party cannot find the difference, and the reply is delayed.
- Treating no reply as agreement. Silence is not confirmation.
- Leaving the difference as a total. A difference that is not broken into causes is not resolved.
- Deleting the incorrect entry. The trail is lost; cancellation and re-entry are needed.
- Reconciling once a year. Differences pile up.
- Not archiving the reply. There is no evidence at the next dispute.
How does NetKasam make account reconciliation easier?
- One-click reconciliation letter. Sent from the account statement; the other party's reply is awaited (customer and supplier account tracking).
- Online statement. Account transactions are shared with the customer or supplier.
- Reminders. Automatic reminders for payments approaching or past due, and balance reminders by bulk SMS.
- Reversing entry. When an expense voucher is cancelled or deleted, all transactions of the operation are updated with a reversing entry (expense management).
- Digital document management. Contracts and documents are stored together with the account.
- Customers and suppliers in one place. Balances appear separately; there is no limit on the number of accounts.
- Bookkeeping is free. Current account tracking is free in every plan; for details, see the pricing page.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- Of 50 letters, 38 came back agreed. What is the reconciliation rate?
- If our balance is ₺200,000 and the other party's is ₺185,000, what is the difference?
- If ₺9,000 of this difference is timing and ₺4,000 is returns, how much unexplained difference remains?
- Does a timing difference require a correcting entry?
- Why is an account that does not reply not treated as agreed?
Answer key:
- 38 ÷ 50 × 100 = %76.
- 200.000 − 185.000 = 15.000 ₺.
- 15,000 − 9,000 − 4,000 = ₺2,000; this amount continues to be investigated.
- No; the recording dates differ, and you confirm the invoice arrived.
- Silence is not confirmation; agreement on the balance has not been obtained in writing.
Frequently Asked Questions About Account Reconciliation Differences
How do you find an account reconciliation difference?
The difference between our balance and the other party's balance is broken down, by comparing statement transactions, into causes such as timing, returns, collections in transit and recording errors.
How do I send a reconciliation letter in NetKasam?
You send a reconciliation letter from the account statement with one click and wait for the other party's reply.
Can I share account transactions with the customer?
Yes. With the online statement, you can share account transactions with your customer or supplier.
What is a timing difference?
It is the same transaction being recorded in different periods on the two sides; for example, the invoice is issued at month end and the other party enters it the following month. It closes once delivery of the invoice is confirmed.
Can I treat an account that does not reply as reconciled?
No; silence is not confirmation. Follow up with a reminder, a phone call and a second letter; for legal consequences, consult your certified public accountant (mali müşavir).
How often should reconciliation be done?
For accounts with large balances, at month or quarter end; with reconciliation once a year, differences pile up.
How do you correct an incorrect account entry?
Instead of being deleted, the incorrect entry is cancelled and the correct one is entered with a document; in NetKasam, the transaction of a cancelled voucher is updated with a reversing entry.
Are there reminders for overdue payments?
Yes. Automatic reminders for payments approaching or past due, and balance reminders by bulk SMS, are available.
Conclusion: This period, check the statements of your 10 largest accounts in advance
Most reconciliation differences can be prevented before the letter is sent. This period, review the statements of the ten accounts with the highest balances yourself before the letter: are there unissued invoices, unposted collections or forgotten returns? When you send the letter with this clean statement, your reconciliation rate rises, differences shrink and the remaining differences close quickly according to their cause. If the same type of difference shows up again next period, look for the source in the process: for example, if timing differences always occur with the same accounts, try sending those customers their invoices before month end.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.