EN
Bookkeeping

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is the purpose of account reconciliation?
  3. Lesson 2: What preparation is done before sending letters?
  4. Lesson 3: How do you send the letter and track the reply?
  5. Lesson 4: What causes account balance differences?
  6. Lesson 5: How do you analyze a difference?
  7. Lesson 6: How are correcting entries made?
  8. Lesson 7: How do you manage accounts that do not reply?
  9. Lesson 8: How do you set up a period-end reconciliation routine?
  10. What are the most common mistakes in account reconciliation?
  11. How does NetKasam make account reconciliation easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: This period, check the statements of your 10 largest accounts in advance
  14. 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.

Training mapSix steps to resolving account reconciliation differences
  1. 01
    PreparationFix the cut-off date and the statement.
  2. 02
    SendingSend the letters and the online statement.
  3. 03
    ReplySort replies into agreed, different and no reply.
  4. 04
    AnalysisBreak differences down by type.
  5. 05
    CorrectionClose them with a document or a correcting entry.
  6. 06
    Follow-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 reconciliationWith reconciliation
The difference surfaces at the time of paymentThe 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 phoneThe written reply is on record
The receivable is not reliableThe 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.

PreparationControl
Cut-off dateThe same day for all accounts (e.g. last day of the month)
InvoicesAll invoices for the period issued
CollectionsBank and cash collections posted to the accounts
ReturnsReturn 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 Software

Lesson 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.

ChartOf 40 letters, 29 agreed, 7 different, 4 no reply
  • Agreed₺2972.5%
  • Reported a different balance₺717.5%
  • Did not reply₺410%

Prepared with sample values. Reconciliation rate 72.5%.

ReplyCountNext step
Agreed29Archive the reply, close the period
Different7Difference analysis (Lesson 5)
No reply4Reminder, 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 typeExampleSolution
TimingInvoice issued on the last day of the month, other party recorded it the following monthConfirm the invoice reached the other party
ReturnReturn invoice for returned goods exists on the other side, not on oursIssue and record the return invoice
Collection in transitCustomer has paid, payment not yet posted on our sideCheck the bank transaction, post the collection
Recording errorWrong amount or recorded to the wrong accountCorrecting 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.

ChartThe 7 accounts' balance is ₺640,000 on our side and ₺598,000 on the other side: the difference broken down by cause
  1. Our receivable balance₺640,000
  2. Timing difference−₺24,000
  3. Return difference−₺9,000
  4. Collection in transit−₺6,000
  5. Recording error−₺3,000
  6. Other party's balance₺598,000

Prepared with sample values. Total difference ₺42,000.

ChartCauses of difference: more than half is timing
  1. Timing₺24,000
  2. Returns₺9,000
  3. Collection in transit₺6,000
  4. Recording error₺3,000

Prepared with sample values. Timing share 57.1% (24,000 ÷ 42,000).

FormulaFour formulas for measuring reconciliation
  1. Reconciliation rate = Agreed accounts ÷ Letters sent × 100
  2. Difference = Our balance − Other party's balance
  3. Explained difference = Sum of the causes; must equal the difference
  4. 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.

DifferenceRecordingDocument
Return differenceReturn invoice is issued and posted to the accountReturn invoice, return shipment details
Collection in transitCollection entry is madeBank receipt
Recording errorIncorrect entry is cancelled, correct one is enteredInvoice or transaction document
Timing differenceNo entry neededConfirmation 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.

DayStepChannel
Letter + 7ReminderEmail or SMS
Letter + 14Phone callPhone
Letter + 21Second letter, with the statementFormal letter
Period closeRecord the status, move to the risky classInternal 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.

Takeaways from the exampleFour numbers from the sample period
  • 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 endStatements are prepared, letters are sentAccounting
Letter + 7 daysReplies are counted, reminders are sentAccounting
Letter + 14 daysDifferences are analyzed by causeAccounting
Letter + 21 daysCorrections are completed, written notice for non-respondersAccounting
Once a quarterReconciliation rate and difference types are reviewedManagement

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?

  1. Sending letters while records are incomplete. You produce a difference of your own making.
  2. Sending a letter without a statement. The other party cannot find the difference, and the reply is delayed.
  3. Treating no reply as agreement. Silence is not confirmation.
  4. Leaving the difference as a total. A difference that is not broken into causes is not resolved.
  5. Deleting the incorrect entry. The trail is lost; cancellation and re-entry are needed.
  6. Reconciling once a year. Differences pile up.
  7. 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.

  1. Of 50 letters, 38 came back agreed. What is the reconciliation rate?
  2. If our balance is ₺200,000 and the other party's is ₺185,000, what is the difference?
  3. If ₺9,000 of this difference is timing and ₺4,000 is returns, how much unexplained difference remains?
  4. Does a timing difference require a correcting entry?
  5. Why is an account that does not reply not treated as agreed?

Answer key:

  1. 38 ÷ 50 × 100 = %76.
  2. 200.000 − 185.000 = 15.000 ₺.
  3. 15,000 − 9,000 − 4,000 = ₺2,000; this amount continues to be investigated.
  4. No; the recording dates differ, and you confirm the invoice arrived.
  5. 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.

Start FreeFree Bookkeeping Software

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools