Cash Application Checklist

Daily cash application workflow run by an AR specialist or staff accountant — capture incoming receipts, match to open invoices, resolve short pays and overpayments, and reconcile to the general ledger before closing out the batch.

6 sections 19 steps Collects data
1

Pre-Application Setup

  1. Pull bank statements and the lockbox file
    • Download the prior business day's bank activity from each operating account and pull the lockbox BAI2 / remittance file. Treasury cutoffs sometimes push wire detail into the next-day file — confirm the date range covers every receipt you intend to apply.

    Collects file
  2. Confirm prior-day batch is fully posted
    • Verify yesterday's cash receipt batch closed cleanly in QuickBooks / NetSuite / Sage Intacct and that the GL deposit cleared to the bank. Starting today's work over an unposted batch causes double-applied payments — a common cleanup hassle at month-end.

  3. Open the unapplied cash GL account
    • Run the unapplied cash / suspense ledger and note any aged items carried from prior days. Anything older than 5 business days should be researched today, not parked again.

2

Capture Incoming Receipts

  1. Tie ACH and wire totals to the bank feed
    • Sum every ACH credit and incoming wire from the bank statement and confirm the total matches the receipts batch you are about to post. Wire fees are typically debited separately — do not net them against the receipt amount; they post to bank-fee expense.

    Collects number
  2. Log lockbox checks against remittance advice
    • For each lockbox check image, capture payer, check number, amount, and any invoice references on the stub. Checks without a stub or memo go to the research queue — do not guess at the customer based on the bank account name alone.

  3. Record credit-card settlement net of processor fees
    • Stripe / QuickBooks Payments / Authorize.net deposit gross receipts minus the processor's fee. Apply the gross amount to customer invoices and post the fee separately to merchant-fee expense, otherwise customer balances will look short by 2-3%.

3

Match Payments to Invoices

  1. Auto-match remittances to open AR
    • Run the receive-payments auto-match routine in the AR module against the day's receipts. Review every match before posting — auto-match will pair a payment with the wrong invoice when amounts coincidentally agree across customers.

  2. Apply unmatched payments to the oldest invoice
    • When the customer is identified but the invoice is not specified, apply oldest-first unless the customer's contract or remittance instructions say otherwise. Split a single payment across multiple invoices line-by-line when the remittance lists them — do not lump-sum apply.

  3. Park unidentified receipts in unapplied cash
    • Wires with no remittance and checks with unreadable stubs go to the unapplied cash GL with a memo: payer name, amount, date received. Unapplied cash is not a parking lot — every item needs a follow-up owner before close of day.

4

Handle Exceptions

  1. Categorize each exception by type
    • Walk every parked or partially-applied receipt and tag the exception. Short pay and overpay each have their own resolution path; unidentified means the payer cannot be matched at all and needs customer outreach.

    Collects list
  2. Email customer for remittance detail
    • For unidentified wires, contact the AP contact at the likely payer with the wire date, amount, and originating bank. Do not apply on a guess — misapplied wires create a downstream short-pay on the actual invoice and a phantom credit on the wrong account.

  3. Process short-pay deduction codes
    • Code the deduction by reason — pricing, shortage, freight, promo, return — and route per the customer's chargeback agreement. Open the residual on the invoice; do not write it off without a credit memo and approval per the deduction-authority matrix.

  4. Issue refund or credit memo for overpayments
    • Confirm with the customer whether to refund or hold as a credit on account. Refunds over the firm's authority threshold need controller approval. Document the customer's instruction in the AR notes — unclaimed credits eventually become escheatable property.

5

Reconcile to the General Ledger

  1. Reconcile daily receipts to the bank feed
    • Total today's applied + unapplied receipts and tie to the bank statement deposit total. Any variance must net to zero before posting — a $0.43 unidentified rounding gap usually means a processor-fee miscoding earlier in the batch.

  2. Tie the AR sub-ledger to GL receivables
    • Run the AR aging total and confirm it equals the GL receivables control account. A break here usually points to a journal entry posted directly to the GL receivables account instead of through the sub-ledger — investigate before close.

  3. Clear suspense in the unapplied cash account
    • Re-open the unapplied cash GL and confirm same-day items have a research owner and a target clear date. Aged unapplied cash is one of the top adjusting-entry sources at month-end.

6

Close-Out and Documentation

  1. File deposit slips and remittance advices
    • Save the bank deposit detail, lockbox images, and emailed remittances to the document management system (SmartVault, ShareFile, TaxDome) under the day's batch folder. Audit trail discipline matters here — auditors will sample receipts during year-end fieldwork.

  2. Lock the daily batch in the AR module
    • Post and close today's receipt batch so it cannot be edited without a reversal. Leaving batches open invites silent edits that break the prior bank reconciliation.

  3. Sign off the daily cash application worksheet
    • The AR specialist signs off the worksheet; the controller or accounting manager reviews exception items and counter-signs at end of day. The signature is the daily key control auditors test for cash receipts segregation of duties.

    Collects signature Collects paragraph

Use this template

Copy it to your account, customize the steps, and run it with your team in minutes.


Sections 6
Steps 19
Category Accounting
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Cash Application Checklist with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.