Overview
The Cash Proof workbook is designed to reconcile general ledger activity to bank transactions, helping teams validate that recorded financial activity is supported by actual cash movement.
Each tab in the workbook serves a specific purpose—either summarizing results, supporting the reconciliation, or providing transaction-level detail for investigation.
1. Report Section
Cash Proof Reports
Audit Sight provides two versions of the Cash Proof—Standard and Advanced—to support different levels of complexity. Both reports reconcile general ledger activity to bank transactions but vary in depth and analysis.
Standard Cash Proof
Purpose:
A streamlined, automated reconciliation designed for efficiency and ease of review.
Best for:
Simpler engagements
Single-entity clients
Quick, self-service analysis
👉 See: Standard Cash Proof Overview
👉 See: How to Review the Standard Cash Proof
Advanced Cash Proof
Purpose:
A more detailed reconciliation with enhanced matching and deeper analytical insight.
Best for:
Complex or multi-entity engagements
Higher transaction volume
Situations requiring additional validation
👉 See: Advanced Cash Proof Overview
Key Takeaway
Standard → Efficient, high-level reconciliation
Advanced → Deeper analysis and increased precision
Both reports support the same goal:
Validate that financial activity is supported by cash—and clearly explain any differences.
2. Accounting Reports and Banking Data Analysis
These tabs support the Cash Proof by generating financial records from the general ledger and comparing bank transactions to accounting activity at both a summary and transaction level. This section also highlights potential timing differences between periods.
| Tab Name | Tab Description |
|---|---|
| Balance Sheet | Shows assets, liabilities, and equity for a specific period, calculated from general ledger data. Also includes mappings of accrual accounts reflected as changes in accounts on the Cash Proof. |
| Profit and Loss | Reports financial performance for the period using general ledger activity. |
| Bank Transaction Analysis | High-level comparison of total debits and credits in the general ledger against total cash inflows and outflows per the bank. Helps identify inconsistencies, timing differences, or unusual posting behavior. |
| Matched Transactions | Lists bank transactions that have been matched to debits or credits to cash in the general ledger. |
| Unmatched Transactions | Shows bank transactions or general ledger cash activity that could not be matched, often due to missing data, timing differences, or data inconsistencies. |
| Credits to Cash | Journal entries where credits to cash accounts are matched to positive bank transactions. These are used as reconciling items in the Cash Proof. |
| Debits to Cash | Journal entries where debits to cash accounts are matched to negative bank transactions. These are used as reconciling items in the Cash Proof. |
| Timing Adjustments | Highlights transactions that match but occur in different periods, summarizing potential timing differences (e.g., deposits in transit or outstanding checks). |
👉 See: Understanding Banking Data Sources
👉 See: Chart of Accounts Mapping Overview
3. Revenue and Cash Inflow Reconciling Items
These tabs are automatically generated based on Audit Sight’s analysis of journal entries and bank transactions. They explain differences between recorded revenue and cash inflows.
These differences are often driven by changes in expected accrual accounts (e.g., accounts receivable, deferred revenue, undeposited funds).
| Tab Name | Tab Description |
|---|---|
| Reconciling Items to Cash Revenue | Identifies non-cash revenue journal entries where revenue is recorded without corresponding cash or expected accrual account offsets. |
| Cash Inflows Not Associated With Income | Lists cash inflows that are not tied to revenue activity, such as loans, owner contributions, or other non-operating items. |
| Accrual Account Adjustments | Lists adjustments to accrual accounts that impact revenue but are not directly tied to cash activity. |
👉 See: Understanding Reconciling Items
👉 See: How Bank Transfers Are Treated in Cash Proof
4. Expense and Cash Outflows Reconciling Items
These tabs are automatically generated and explain differences between recorded expenses and cash outflows.
These differences are often driven by changes in expected accrual accounts (e.g., accounts payable, accrued expenses, prepaids, inventory).
| Tab Name | Tab Description |
|---|---|
| Reconciling Items to Cash Expense | Identifies non-cash expense journal entries where expenses are recorded without corresponding cash or expected accrual account offsets. |
| Cash Outflows Not Associated With Expenses | Lists cash outflows not tied to operating expenses, such as debt payments, distributions, or other non-operating activity. |
| Accrual Account Adjustments | Lists adjustments to accrual accounts that impact expenses but are not directly tied to cash activity. |
👉 See: Understanding Reconciling Items
👉 See: How Bank Transfers Are Treated in Cash Proof
5. Underlying Data
These tabs contain the source data used to generate the Cash Proof and support all analysis within the workbook.
These tabs represent the raw inputs and system-derived categorizations that power all matching, reconciling items, and analysis within the Cash Proof.
| Tab Name | Tab Description |
|---|---|
| Journal Entries | Contains all general ledger transactions for the selected period. This forms the foundation of the Cash Proof analysis. |
| Bank Transactions | A complete data dump of all bank transaction detail uploaded into Audit Sight. This represents the independent data source that general ledger activity is compared against during the Cash Proof. |
| Bank Txn Categories | Groups bank transactions into a predefined set of categories based on transaction characteristics. This helps standardize analysis and supports identification of trends or anomalies in cash activity. |
| Bank Txn Classifications | Groups bank transactions by description using machine learning to identify patterns, categorize activity, and highlight potential gaps or inconsistencies. |
👉 See: Accounting and Banking Data
6. Rollforward Tabs
These tabs provide automated account rollforwards for key balance sheet areas. They are system-generated and help explain changes in accounts that commonly drive reconciling items in the Cash Proof.
Each rollforward includes beginning balances, increases, decreases, and the underlying journal entries driving activity—providing full transparency into how balances change over time.
| Tab Name | Tab Description |
|---|---|
| Debt Rollforward | Tracks changes in debt balances, including new borrowings and repayments. Helps identify financing-related cash inflows and outflows. |
| Equity Rollforward | Summarizes equity activity such as owner contributions and distributions. Supports identification of non-operating cash movements. |
| Fixed Assets Rollforward | Details additions, depreciation, and disposals of fixed assets. Helps isolate non-cash expense activity and investing-related cash flows. |
| Sales Tax Rollforward | Tracks accruals and payments related to sales tax. Helps reconcile timing differences between tax expense and cash payments. |
| Intercompany Rollforward | Summarizes activity between related entities. These balances are highlighted for review but typically require user evaluation rather than standard reconciling treatment. |
👉 See: How to Review the Standard Cash Proof
How to Approach a Cash Proof Review
Start with the Cash Proof report
Understand the overall reconciliation and identify any differences.Validate completeness of data
Review Balance Sheet, Profit and Loss, and Bank Transaction Analysis.Review matching results
Use Matched and Unmatched Transactions to evaluate how bank transactions align with the general ledger.Analyze reconciling items
Understand why differences exist (accruals, non-cash activity, missing data, timing).Drill into underlying data
Use Journal Entries and Bank Txn Classifications for detailed investigation.
Important Notes
Cash Proof results are review-dependent and rely on accurate mapping, classification, and completeness of data
Outputs are generated based on system-driven matching and rules-based logic
Reconciling items are expected and help explain how general ledger activity translates to cash movement
Key Takeaway
Each tab in the workbook contributes to answering one core question:
Does general ledger activity align to actual cash movement—and if not, why?
By moving from summary → validation → reconciling items → detail, users can confidently evaluate the completeness and accuracy of the Cash Proof.
