Skip to content
All Acquire guides

Manual evidence template

Bank-period coverage grid

Download editable Markdown template

Use one grid for each entity, currency and review year. Rename the month columns for your actual period. Copy it into your own document or spreadsheet, or download the editable Markdown. No signup is needed. It records coverage manually; it does not calculate revenue or certify completeness.

Record the scope

Record the scope
FieldYour entry
Legal entityTo enter
Review start/endTo enter as YYYY-MM-DD
CurrencyTo confirm
Account inventory source/versionTo enter
Pack version/cut-offTo enter
Person checking coverageTo assign

Account-by-month grid

The headings below describe an example July–June year; enter the actual year in the scope and rename if required. Each row is a blank template, not a supplied account.

Account-by-month grid
Account aliasJulAugSepOctNovDecJanFebMarAprMayJun
Account A: to identifyUUUUUUUUUUUU
Account B: to identifyUUUUUUUUUUUU

U = unchecked; S = statement covers the whole month; P = partial coverage; M = no statement supplied for the required dates; N = not applicable, with evidence and reason. Use text as well as any colours you add. S does not mean transactions have been classified or professionally approved.

Keep exact dates and references alongside the grid

Keep exact dates and references alongside the grid
Account aliasLegal holderPurposeStatement reference/versionCoverage startCoverage endMissing startMissing endOverlap/page issueOpening/closing evidenceNext requestChecked by/date
To enterTo confirmTo confirmTo enterTo enterTo enterIf missingIf missingTo checkIf relevantTo enterPending

Check the dates and page sequence in the actual source, not the filename. For a mid-month gap, mark P and record the exact missing dates. Overlapping exports can repeat transactions; do not count them twice. Do not infer a nil month from an empty or absent file.

If an account is said to have opened late or closed early, retain the evidence before using N. “Not supplied” does not mean “does not exist”. A complete grid for known accounts does not prove that the inventory itself is complete.

Neutral request text

“Please provide complete statements for [account alias] covering [start] to [end]. If the account did not operate throughout that period, please provide opening/closing-date evidence. Please confirm the complete account inventory for [entity] during [period].”

Use an authorised private sharing channel. Keep sensitive identifiers and actual statements out of public links. Read the missing-statements guide for Harbour Lane's clearly labelled synthetic example and the limits of a partial-year comparison.

Bank-period coverage grid | Dealensics