# Cash Lead Schedule: Layout and Tie-Outs

- Author: PreciseBankFlow (https://www.precisebankflow.com)
- Published: 2025-12-29
- Updated: 2025-12-29
- Category: Bank statements in an audit
- Canonical: https://www.precisebankflow.com/blog/cash-lead-schedule

> How to prepare a cash lead schedule: every bank account, prior and current balances, adjustments, references to the reconciliations and the trial balance.
A cash lead schedule is the top workpaper for cash in an audit file. It lists every bank and cash account on one page, with the prior-year audited balance, the current unadjusted balance from the trial balance, any adjustments and the final figure. Each row carries a reference to the reconciliation and confirmation that support it.

## What goes on a cash lead schedule?

A cash lead schedule needs one row per general ledger cash account and a fixed set of columns: account name and number, prior-year final balance, current-year unadjusted balance, proposed adjustments, reclassifications, final balance and a workpaper reference. A total row agrees to the cash line on the balance sheet.

Each column has a job. The prior-year column comes from last year's audited file, which lets a reviewer see movement at a glance. The unadjusted column is copied from the client's trial balance as delivered, before any audit entries, so the starting point is never in doubt. Adjustments and reclassifications sit in separate columns because they mean different things: an adjustment changes total cash, while a reclassification only moves it between lines, such as an overdraft moved to liabilities.

The reference column is what turns a list of numbers into a lead. It points to the reconciliation, the confirmation reply and any further testing for that account. A reviewer should be able to start on the lead, follow a reference and land on the evidence without asking where it is.

Add a short header too: client name, period end, preparer, reviewer and dates. Many firms also add a tickmark legend at the foot, so each mark on the page has one stated meaning.

## Cash lead schedule layout, worked for four accounts

The schedule below is a worked example for a small company at December 31. The account names, numbers, references and adjustment are invented for illustration and do not come from any real client.

| Account | Prior year final | Current unadjusted | Adjustments | Reclass | Current final | Ref |
| --- | --- | --- | --- | --- | --- | --- |
| 1010 Operating checking | 212,450.18 | 186,904.77 | (1,250.00) AJE-3 | | 185,654.77 | C-1 |
| 1020 Payroll checking | 8,000.00 | 7,612.40 | | | 7,612.40 | C-2 |
| 1030 Money market | 150,000.00 | 175,322.06 | | | 175,322.06 | C-3 |
| 1040 Processor clearing | 14,275.93 | 22,108.55 | | | 22,108.55 | C-4 |
| Total cash | 384,726.11 | 391,947.78 | (1,250.00) | | 390,697.78 | TB |

In this example, AJE-3 books a bank fee the client missed. The adjustment column carries the entry number so the reviewer can find its support in the adjustments summary.

Row 1040 is a processor clearing account, which holds sales a card or ecommerce processor has collected but not yet paid out. It belongs on the cash lead only if the client's chart of accounts treats it as cash. Testing it means matching payouts to deposits, as set out in [reconciling Shopify payouts to orders](/blog/reconcile-shopify-payouts).

## Tying the cash lead schedule to the trial balance and the reconciliations

Tying out a cash lead schedule means proving three agreements: the unadjusted column agrees to the client's trial balance, each unadjusted balance agrees to the book side of that account's reconciliation, and the final total agrees to the balance sheet. Mark each agreement with a tickmark and a reference.

Work through the tie-outs in a fixed order:

1. Foot every column and cross-foot every row. A schedule that does not add is not a lead.
2. Agree each current unadjusted balance to the trial balance, line by line.
3. Agree each balance to the book balance on the reconciliation the reference points to.
4. Agree the bank side of each reconciliation to the confirmation reply.
5. Agree the prior-year column to last year's final lead, not to last year's draft.
6. Agree the total final balance to the cash line on the draft financial statements.

Steps 3 and 4 are where the lead hands over to the detailed work. Testing what sits between the bank and the book balance is covered in the program of [audit procedures for bank reconciliation](/blog/audit-procedures-for-bank-reconciliation#what-does-a-bank-reconciliation-audit-program-sample-include). The lead only shows that the numbers you tested are the numbers in the accounts.

Agreement runs in both directions. Tracing from the trial balance to the lead proves nothing is missing from the lead, and vouching from the lead back to the trial balance proves nothing on it is invented. [Vouching and tracing, and which assertion each direction tests](/blog/vouching-and-tracing) explains why direction matters.

## How should adjustments and reclassifications show on a cash lead schedule?

Adjustments and reclassifications show on a cash lead schedule as separate columns, each entry labelled with its number from the adjustments summary. Proposed entries the client has not yet accepted stay in the adjustments column, marked as proposed. An overdraft is reclassified to liabilities, and restricted cash is moved to its own line.

Keep the columns honest. An adjustment that changes cash should have a matching entry somewhere else in the file, such as an expense or a receivable. A reclassification nets to zero across the balance sheet. If a reclassification column on the cash lead does not net to zero with its other side, one half was missed.

Overdrafts are the common case. A negative balance at one bank is usually shown as a liability unless the client has a right of offset with a positive balance at the same bank. Put the reclassification on the lead so the cash total is right, and reference the memo that explains the decision.

## Cash lead schedule gaps: the account that is missing from the list

A cash lead schedule can foot, tie and still be wrong if an account is missing from it. The schedule only lists what the client recorded. Before testing any row, compare the lead to sources the client did not prepare: the bank confirmation replies, last year's lead and the bank fees charged on each statement.

A closed account should appear with a zero balance and a note on when it closed, rather than vanish. An account opened during the year should appear with its opening deposit traced. Interest or fee lines on a statement that refer to a different account number are a clue that another account exists.

When an account is large in transaction count but small in balance, such as a payroll account funded to zero each cycle, the lead understates its risk. Those accounts often need transaction testing rather than balance testing, and choosing which lines to test is covered in [audit sampling of bank transactions](/blog/audit-sampling-bank-transactions).

The lead is only as good as the statements behind each reference. [PreciseBankFlow](/) foots each statement and flags gaps and duplicates in the lines, so the balances you copy onto the lead rest on statements already checked for completeness.