Reconciliation Exceptions and Returned Items

Overview
Reconciliation exceptions and returned items sit at the intersection of cash management, internal control, and fraud prevention. On the AFP Certified Treasury Professional (CTP) exam, this topic appears within the Corporate Liquidity Management domain because every unresolved exception or returned item distorts the cash position, weakens the liquidity forecast, and can expose the company to loss. This guide explains why the topic matters, what the key terms mean, how the processes actually work in practice, and how to attack exam questions on the subject.

1. Why This Topic Is Important

Accurate cash position. Treasury makes daily funding, borrowing, and investing decisions based on the cash position. If the ledger says a deposit cleared but the bank actually returned it, treasury may be overdrawn or may invest cash it does not have. Reconciliation exceptions are the mechanism for catching these differences before they become costly.

Fraud detection. Check fraud, altered payees, duplicate ACH debits, and unauthorized corporate debits are typically discovered through reconciliation. Under UCC Article 4-406, a company that fails to examine its statements and report unauthorized items promptly may lose the right to recover from its bank. The exam frequently tests this duty of care.

Internal control and audit. Timely, independent reconciliation is one of the most basic control activities auditors test. Segregation of duties between those who initiate payments, those who handle cash receipts, and those who reconcile is a classic exam point.

Cost and working capital. Returned deposited items mean the company extended credit it did not intend to extend. Each return carries bank fees, collection effort, and potential bad debt. Returned outgoing payments (for example, payroll ACH credits to closed accounts) create employee or vendor service issues and rework.

Regulatory compliance. Nacha Operating Rules, Regulation CC, and UCC Articles 3 and 4 all impose deadlines and responsibilities around returns. Missing a deadline can shift the loss to the company.

2. What It Is: Key Definitions

Bank reconciliation is the process of comparing the bank's record of account activity (statement or electronic reporting file such as BAI2 or ISO 20022 camt.053) with the company's general ledger cash account and explaining every difference.

Reconciliation exception is any item that does not match between the bank record and the company record. Exceptions fall into two broad categories:
- Timing differences are legitimate items that will clear on their own. Examples: outstanding checks (issued by the company but not yet presented to the bank) and deposits in transit (recorded by the company but not yet credited by the bank).
- Errors and unrecorded items require investigation or an adjusting entry. Examples: bank service charges, interest earned, NSF items charged back, encoding errors (the MICR amount differs from the written amount), duplicate postings, transposition errors in the ledger, checks paid for the wrong amount, and unauthorized or fraudulent items.

Returned item is a payment that the paying bank or receiving bank sends back unpaid or undeliverable. From the company's perspective there are two directions:
- Returned deposited items (collections side): a customer check or ACH debit the company deposited is returned, and the bank charges the amount back to the company's account.
- Returned disbursements (payments side): a payment the company sent, such as an ACH credit, is returned because the receiver's account is closed or invalid, or a check the company issued is dishonored (for example, because a stop payment was placed or positive pay flagged it).

Common check return reasons: NSF (non-sufficient funds), uncollected funds, account closed, stop payment, refer to maker, stale-dated (older than six months under UCC 4-404, which a bank may but need not pay), post-dated, missing or irregular endorsement, unauthorized signature, altered item, counterfeit item.

Common ACH return reason codes (Nacha):
- R01 Insufficient funds
- R02 Account closed
- R03 No account or unable to locate account
- R04 Invalid account number
- R05 Unauthorized debit to a consumer account using a corporate SEC code
- R07 Authorization revoked by customer
- R08 Payment stopped
- R09 Uncollected funds
- R10 Customer advises originator is not known or not authorized to debit
- R16 Account frozen
- R20 Non-transaction account
- R29 Corporate customer advises not authorized

Notification of Change (NOC) is not a return but is closely related: the receiving bank accepts the entry but tells the originator to correct information (for example, C01 incorrect account number, C02 incorrect routing number, C03 both). Under Nacha rules the originator must make the change within six banking days of receipt or before the next entry, whichever is later.

3. How It Works: Processes and Timelines

The reconciliation process
1. Obtain the bank record (prior-day BAI2 file, statement, or camt.053).
2. Match transactions automatically using an account reconciliation program (ARP) or treasury system. Matching keys include check number, amount, date, and reference.
3. Isolate unmatched items as exceptions.
4. Classify each exception: timing difference, bank error, company error, unrecorded bank item, or potential fraud.
5. Investigate and resolve. Timing differences simply carry forward. Company errors and unrecorded bank items require journal entries to the book balance. Bank errors require a claim to the bank and an adjustment on the bank side of the reconciliation.
6. Document, review, and sign off. Aged outstanding items should be escalated; long-outstanding checks eventually become subject to state unclaimed property (escheatment) laws.

Adjusting the bank balance versus the book balance
This distinction is heavily tested. Adjust the bank balance for: deposits in transit (add), outstanding checks (subtract), bank errors (add or subtract as appropriate). Adjust the book balance for: bank service charges (subtract), NSF or returned items charged back (subtract), interest earned (add), notes collected by the bank (add), company recording errors (add or subtract). After adjustments, the two balances must be equal.

Worked example
Bank statement balance: 500,000. Book balance: 487,300. Deposits in transit: 40,000. Outstanding checks: 55,000. Bank service charge not yet recorded: 300. Customer check returned NSF: 2,500. Interest credited by bank: 500. A check written for 1,800 was recorded in the ledger as 1,000 (an 800 understatement of disbursements).
Adjusted bank balance: 500,000 + 40,000 - 55,000 = 485,000.
Adjusted book balance: 487,300 - 300 - 2,500 + 500 - 800 = 484,200.
The balances do not agree, so an 800 difference remains and must be investigated. (In this case, check the arithmetic on the error: if the ledger showed 1,000 and the check was 1,800, the book is overstated by 800, so the subtraction is correct; the residual indicates another unidentified item, perhaps a duplicate deposit posting.) The exam may give you a set of items and ask for the adjusted balance, or ask which single item explains a difference; always work both sides.

Bank account reconciliation services
Banks offer tools that reduce manual exception handling:
- Full reconciliation: the company sends an issue file; the bank matches paid checks and reports outstanding and exception items.
- Partial reconciliation: the bank provides a paid-item file; the company does the matching.
- Deposit reconciliation: deposits from multiple locations are identified by location code so each site's deposits can be verified.
- Positive pay: the bank compares presented checks to the issue file and reports mismatches (exceptions) for a pay or return decision, usually by a mid-day deadline. If the company misses the deadline, the default decision (typically return, sometimes pay) applies. Payee positive pay adds payee name matching. Reverse positive pay shifts the matching burden to the company, which reviews all presented items.
- ACH debit blocks and filters: block all ACH debits or allow only authorized originators and limits, preventing unauthorized debits from posting in the first place.

Returned deposited item workflow
1. The paying bank dishonors the check or ACH debit and returns it through the clearing system.
2. The depository bank charges back the company's account, debits a return fee, and sends a return notice or includes the item in the information reporting file.
3. Treasury adjusts the cash position and the book balance; accounts receivable reopens the customer's invoice.
4. Collection options: re-present the paper check (banks typically allow one re-presentment), convert the returned check to an RCK (re-presented check) ACH entry under Nacha rules (eligible for consumer checks under 2,500, re-presented no more than two times after the original return), contact the customer, hold shipments, revise credit terms, or refer to a collection agency.

Key legal and rule-based timelines
- Check returns, Regulation CC and UCC 4-302: the paying bank must decide to pay or return by its midnight deadline, generally midnight of the banking day following the banking day of presentment. For returned checks of 5,000 or more, the paying bank must provide notice of nonpayment to the depositary bank by 2:00 p.m. local time on the second business day after presentment.
- ACH returns, Nacha: most returns (R01, R02, R03, R04, R09, R29) must be transmitted by the RDFI so they are available to the ODFI by the opening of business on the second banking day after settlement. Consumer unauthorized returns (R05, R07, R10) may be returned within 60 calendar days of settlement. Corporate unauthorized returns (R29) are limited to the two-banking-day window, which is why companies must monitor their accounts daily and use debit blocks and filters.
- Customer duty to examine statements, UCC 4-406: the customer must examine statements with reasonable promptness and report unauthorized signatures or alterations. If the same wrongdoer commits repeated forgeries, the customer is barred from claiming items paid after 30 days from when the first statement was made available if the customer failed to report. There is an absolute one-year bar regardless of bank negligence. Many deposit agreements shorten the reporting period further (often 30 or 60 days), and the exam may reference the contractual period.
- Stale-dated checks, UCC 4-404: a bank is not obligated to pay a check more than six months old but may do so in good faith.
- Wire transfers: wires are final when accepted by the beneficiary bank. There is no return mechanism; a mistaken wire requires a recall request and the beneficiary's cooperation, which is why wires are classified as high-risk for payment errors.

Returned disbursement workflow
For ACH credits returned R02, R03, or R04, the originator receives the funds back, must obtain corrected information from the payee, and re-originate. NOCs must be applied within six banking days. For checks, a positive pay exception leads to a pay or return decision; a returned company check (for example, due to a closed account after a bank change) must be reissued and the vendor contacted.

4. Controls and Best Practices the Exam Expects You to Know
- Reconcile high-volume accounts daily, not monthly, using prior-day reporting.
- Segregate duties: the reconciler should not have check-signing, wire-release, or cash-receipt authority.
- Use positive pay with payee match and set the default decision to return.
- Use ACH debit blocks on disbursement-only and concentration accounts, and filters on accounts that legitimately receive debits.
- Age outstanding checks and deposits in transit; investigate anything over 30 days.
- Maintain a returned-item log with reason codes and resolution status; analyze trends by customer to tighten credit policy.
- Review deposit agreement terms for the statement review window and positive pay decision deadlines.
- Reduce exceptions at the source: electronic payments with remittance data, lockbox with data capture, and standardized reference fields all improve auto-match rates.

5. Exam Tips: Answering Questions on Reconciliation Exceptions and Returned Items

Tip 1: Identify which side of the reconciliation the item affects. The single most common question style gives you an item and asks whether it adjusts the bank balance or the book balance. Rule of thumb: if the bank does not know about it yet, adjust the bank balance (outstanding checks, deposits in transit). If the company does not know about it yet, adjust the book balance (fees, interest, returned items, bank collections). Errors are adjusted on the side that made the error.

Tip 2: Distinguish timing differences from exceptions requiring action. If the question asks which item requires an adjusting journal entry, eliminate outstanding checks and deposits in transit immediately; they are timing differences, not errors.

Tip 3: Know the return codes by category, not by memorizing every number. Group them: funds problems (R01, R09), account problems (R02, R03, R04, R16, R20), authorization problems (R05, R07, R10, R29), stop payment (R08). If a question describes a scenario, map it to the category first, then to the code.

Tip 4: Memorize the headline deadlines. Two banking days for standard ACH returns and corporate unauthorized returns. Sixty calendar days for consumer unauthorized returns. Six banking days to act on a NOC. Midnight deadline for check returns. 2:00 p.m. second business day for large-dollar (5,000 or more) return notice. Six months for stale-dated checks. One-year absolute bar under UCC 4-406. If an answer choice contains a deadline, check it against this list before anything else.

Tip 5: Consumer versus corporate matters. Several questions hinge on whether the debited account belongs to a consumer or a business. Consumers get 60 days to dispute unauthorized ACH debits; corporations get two banking days. This asymmetry is why the exam stresses daily reconciliation and debit blocks for corporate accounts.

Tip 6: Read positive pay questions for the default decision and the deadline. If a company misses the decision deadline, the bank applies the default. Questions may ask what happens to an exception that was not decisioned, or which service would have prevented an altered-payee loss (answer: payee positive pay).

Tip 7: For returned deposited items, think about both cash and receivables. The correct answer often involves two consequences: the bank charges back the account (reducing available balance and requiring a book entry) and the receivable is reopened. Answer choices that address only one dimension are usually incomplete.

Tip 8: Control questions test segregation of duties and timeliness. If a scenario describes the same person preparing checks and reconciling the account, the weakness is lack of segregation of duties. If a fraud went undetected for months, the weakness is infrequent reconciliation and the consequence under UCC 4-406 is that the company may bear the loss.

Tip 9: Wires are different. If a question asks which payment type cannot be returned or has no return mechanism, the answer is a wire transfer; recovery depends on the beneficiary's consent.

Tip 10: Use process of elimination on calculation questions. Compute the adjusted bank balance first because it typically involves only two or three items. Then adjust the book balance. If your result matches an answer choice, you are done; if not, re-check the sign on each book adjustment (fees and returns reduce, interest and collections increase).

Tip 11: Watch for words such as best, most effective, and primary. When several controls are plausible, the exam wants the one that prevents the problem rather than detects it. Positive pay and debit blocks are preventive; reconciliation is detective. A question asking for the best way to prevent unauthorized ACH debits wants debit blocks or filters, not daily reconciliation.

Tip 12: Connect the topic to liquidity. Questions in the liquidity management domain may frame a reconciliation issue in terms of cash positioning or forecasting. Remember that unreconciled exceptions and unexpected returns create variance between forecast and actual cash, which can lead to overdrafts, unnecessary borrowing, or idle balances. The correct answer often links the control to improved cash position accuracy.

6. Quick Review Summary
- Reconciliation compares bank records to book records; exceptions are the differences.
- Timing differences (outstanding checks, deposits in transit) adjust the bank side; unrecorded bank items and company errors adjust the book side.
- Returned items flow in two directions: returned deposits (charged back to the company) and returned disbursements (funds come back, payment must be reissued).
- Know the ACH return codes by category and the key timelines: 2 banking days, 60 calendar days, 6 banking days for NOCs, midnight deadline, 2:00 p.m. large-dollar notice, 6 months stale-dated, 1 year UCC 4-406.
- Preventive tools: positive pay, payee positive pay, ACH debit blocks and filters. Detective tools: daily reconciliation, ARP services, aged exception reports.
- Controls: segregation of duties, daily reconciliation, documented exception resolution, escheatment tracking.
- On the exam, classify the item, identify the side it affects, check deadlines, and prefer preventive controls when asked for the best solution.