Cash Application Checklist
Pre-Application Setup
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.
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.
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.
Capture Incoming Receipts
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.
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.
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%.
Match Payments to Invoices
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.
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.
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.
Handle Exceptions
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.
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.
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.
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.
Reconcile to the General Ledger
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.
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.
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.
Close-Out and Documentation
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.
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.
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.
Use this template in Manifestly
- Monthly Close Process
- Budgeting and Forecasting Checklist
- Monthly Bookkeeping and Accounting Close
- Financial Statement Audit Checklist
- Business Succession Planning
- Expense Reporting and Reimbursement Checklist
- Bank Reconciliation Checklist
- Risk Management Checklist
- Fixed Assets Management Checklist
- Client Onboarding Checklist
- Accounts Receivable Checklist
- Cash Flow Analysis Checklist
- Consulting and Advisory Services Checklist
- Accounts Payable Checklist
- Tax Planning Checklist
- Account Reconciliation Checklist
- Audit Preparation Checklist
- Financial Reporting Checklist
- Business Valuation Checklist
- Payroll Processing Checklist
- Internal Controls Review Checklist
- New Business Structuring Checklist
- Chart of Accounts Maintenance Checklist
- Debt Management Checklist
- Journal Entry Checklist
- Lease Accounting Checklist
- Investment Reconciliation Checklist
- Regulatory Compliance Checklist
- Credit and Collections Checklist
- Loan Covenant Compliance Checklist
- Individual Tax Return Preparation Checklist
- Business Tax Compliance Checklist
- Cash Flow Management Checklist
- New Employee Onboarding Checklist (Accounting Department)
- New Client Onboarding Checklist
- Financial Analysis Checklist
- Employee Termination Checklist (Accounting Department)
- Employee Expense Policy Compliance Checklist
- Cost Accounting Checklist
- Accounting Policy Update Cycle
- Inventory Accounting Close Checklist
- Quarterly Budget Review Checklist
- Quarterly Internal Control Review Checklist
- Client Engagement Letter Renewal
- End-of-Month Sales and Revenue Reporting
- Capital Expenditure (CapEx) Approval Checklist
- Grant Accounting Checklist
- Performance Review Checklist (Accounting Staff)
- Accounting Software Migration Checklist
- Financial Statement Preparation Checklist
- Yearly Accounting Department Goals Setting
- Quarterly Financial Reporting Checklist
- Vendor Contract Negotiation Checklist
- Chart of Accounts Review Checklist
- Fixed Assets Audit Checklist
- Accounting Standards Update Adoption Checklist
- Sales Tax Reporting Checklist
- Merger and Acquisition Due Diligence Checklist
- Monthly Management Reports Checklist
- Financial Risk Assessment Checklist
- Firm Insurance Renewal Checklist
- Payroll Services Checklist
- Accounts Payable Ledger Checklist
- Collections Management Checklist
- Quarterly Payroll Tax Compliance Checklist
- AP Payment Processing Checklist
- Vendor Setup and Maintenance Checklist
- Employee Expense Reimbursement Checklist
- Monthly Accounting Close Checklist
- Annual Financial Statements Checklist
- Accounting Department Workflow Optimization
- Accounts Payable Aging Report Checklist
- Payroll Tax Filing Checklist
- Corporate Tax Return Preparation Checklist
- Internal Audit Preparation Checklist
- Internal Control Procedures Checklist
- External Audit Preparation Checklist
- Daily Bookkeeping Checklist
- Customer Credit Approval Checklist
- Accounts Receivable Aging Report Checklist
- Budget Variance Analysis Checklist
- Financial Audit Checklist
- Cost-Benefit Analysis Checklist
- Weekly Bookkeeping Checklist
- Client Engagement Closeout Checklist
- Corporate Tax Preparation Checklist
- Year-End Bookkeeping Checklist
- Billing Process Checklist
- Risk Assessment Checklist
- Cash Flow Analysis Checklist
- Legal Entity Management Checklist
- Monthly Financial Review Checklist
- M&A Due Diligence Checklist
- Post-Merger Audit Checklist
- Profitability Analysis Checklist
- Acquisition Integration Checklist
- Year-End Tax Planning Checklist
- Segregation of Duties Assessment
- Fraud Prevention Checklist
- Cash Management Checklist
- Financial Project Planning Checklist
- System Access Control Checklist
- SOX Compliance Checklist
- Financial Ratio Analysis Checklist
- Accounting Software Implementation Checklist
- Monthly Bookkeeping Close Checklist
- Tax Audit Documentation Checklist
- Contract Review Checklist
- Project Cost Control Checklist
- Deal Closure Checklist
- Engagement Risk Management Checklist
- Year-End Accounting Checklist
- Quarterly Bookkeeping Checklist
- Staff Offboarding Checklist
- Engagement Budgeting Checklist
- Monthly Financial Reporting Checklist
- Monthly Financial Close Checklist
- New Vendor Onboarding Checklist
- Annual Budget Preparation Checklist
- New Employee Onboarding Checklist
- Month-End Close Checklist
Ready to take control of your recurring tasks?
Start Free 14-Day TrialUse Slack? Sign up with one click
