AIWorkDex
Finance Practice

Match customer deposits and isolate accounting exceptions

Link supported deposits to invoices and preserve every unresolved difference for professional review.

Preparation
One period match followed by exception review.
Difficulty
Moderate
Task
Match deposits to invoices
Back to the Task: Match deposits to invoices

Before you start

Get what you need before you start

  • Gather bank deposits, processor payout detail, customer payments, invoices, and fee records.
  • Identify the bookkeeper or accountant who can decide corrections.

Steps

Work through the method

Use the listed inputs and tools. Check the evidence when you need to verify a step.

  1. Trace the deposit to its payment

    For each deposit, locate the processor or customer payment detail and the related invoice. Compare the amount and date.

    Why it matters: A deposit can combine payments or subtract fees before it reaches the bank.

    Input
    Bank, processor, customer payment, and invoice records.
    Output
    A proposed deposit-to-payment-to-invoice link.
    Tools in this stepQuickBooks Online

    Evidence for this step

  2. Separate supported components

    Record partial payments and processing fees separately. Check that the customer balance and deposit total still agree.

    Why it matters: Separate components prevent a net payout from obscuring the underlying receipt.

    Input
    The proposed link and fee or partial-payment detail.
    Output
    A checked match with supported components.
    Tools in this stepQuickBooks Online

    Evidence for this step

  3. Route unresolved items

    Put unmatched receipts, duplicates, refunds, and corrections in one exception list with evidence. Ask the bookkeeper or accountant to decide each treatment.

    Why it matters: An exception list prevents a forced match from hiding uncertainty.

    Input
    All unmatched or ambiguous items.
    Output
    An owned exception list and professional decisions.
    Tools in this stepQuickBooks Online

    Evidence for this step

Success checks

Check the result before you finish

  • Every matched deposit links to a payment and invoice.
  • Fees and partial payments remain separate.
  • A professional owns every unresolved correction.

Failure modes

Watch for these problems

  • A net payout is matched as one invoice payment. Inspect its components.
  • A difference is silently written off. Route it for professional review.
  • A duplicate is deleted without evidence. Preserve the record and decision.

Tools

Choose the tools you need

Sources

Read the sources behind this practice

Check what each source supports and where the advice has limits.