Overview
The Trial Balance Only (TB-only) Cash Proof supports engagements where monthly trial balances and banking data are available, but detailed general ledger activity is not.
Cash Proof Advanced uses this data to:
- Calculate changes in key balance sheet accounts.
- Identify non-cash and non-operating activity.
- Organize banking transactions into groups and categories.
- Automatically create eligible banking-only reconciling items.
- Highlight unusual banking activity for further investigation.
Important: Without detailed general ledger activity, the workpaper may still contain material variances that require investigation and supplemental procedures. Automatically created items provide a starting point for your team’s review.
How the TB-Only Cash Proof Works
The workflow identifies reconciling activity using three sources:
- Changes in key balance sheet accounts.
- Non-cash revenue and expense activity identified through account mappings.
- Banking transactions, including transfers, sweeps, and eligible financing, equity, and investment activity.
1. Changes in Key Balance Sheet Accounts
The workpaper calculates changes in mapped balance sheet accounts to help explain differences between banking activity and reported revenue and expenses.
Revenue-Related Balance Sheet Changes
| Account | Fully Qualified Category (FQC) |
|---|---|
| Cash → Undeposited Funds | asset:current:undepositedFunds |
| Accounts Receivable | asset:current:accountsReceivable |
| Accounts Receivable → Allowance for Doubtful Accounts | asset:current:accountsReceivable:allowanceForDoubtfulAccounts |
| Other → Billings in Excess of Cost | liability:current:other:billingsInExcessOfCost |
| Other → Customer Deposits | liability:current:other:customerDeposits |
| Other → Deferred Revenue | liability:current:other:deferredRevenue |
Expense-Related Balance Sheet Changes
| Account | Fully Qualified Category (FQC) |
|---|---|
| Cash → Non-Bank Account | asset:current:cashNonBankAccounts |
| Inventory | asset:current:inventory |
| Prepaid Expenses | asset:current:prepaidExpenses |
| Accounts Payable | liability:current:accountsPayable |
| Credit Card Payable | liability:current:creditCardPayable |
| Payroll Liabilities | liability:current:payrollLiability |
| Tax | liability:current:tax |
| Other | liability:current:other |
| Other → Accrued | liability:current:other:accrued |
| Tax (Noncurrent) | liability:noncurrent:tax |
2. Non-Cash Revenue and Expense Activity
The workpaper uses Fully Qualified Categories (FQCs) to identify adjustments for non-cash and non-operating activity.
Revenue Activity
| Category | Fully Qualified Category (FQC) |
|---|---|
| Non-Operating Income | income:nonOperating |
Expense Activity
| Category | Fully Qualified Category (FQC) |
|---|---|
| Depreciation | asset:nonCurrent:fixed:accumulatedDepreciation |
| Amortization | expense:operating:amortization |
| Bad Debt Expense | expense:operating:badDebt |
| Gain or Loss on Fixed Assets | expense:nonOperating:gainLossOnFixedAsset |
| Other Non-Operating Expense | expense:nonOperating |
These adjustments help distinguish operating cash activity from non-cash accounting adjustments and non-operating activity.
3. Organization of Banking Data
The TB-only workflow organizes banking transactions into groups and categories to support automatic creation and manual review of banking-only reconciling items.
Each bank transaction is assigned:
- A Group, representing a keyword or pattern unique to the client’s banking activity.
- A Category, identifying the type of banking activity.
Groups and categories help your team identify trends, investigate unusual transactions, analyze recurring activity, and review or create banking-only reconciling items.
4. Automatic Banking-Only Reconciling Items
For TB-only entities, Cash Proof Advanced automatically creates banking-only reconciling items from eligible banking transactions. Your team starts with organized items to review, reducing the need to build each item manually.
Which transactions are included?
| Banking activity | When items are created automatically |
|---|---|
| Bank transfers and sweeps | Always |
| Loan proceeds and loan payments | When the trial balance shows debt |
| Owner contributions and distributions | When owner’s equity changed during the period |
| Investment proceeds | When the trial balance shows investments |
| Intercompany and related-party activity | Not created automatically; your team must review this activity |
Transactions are grouped by their AI Category. Correcting a transaction’s category moves it to the appropriate item the next time the workpaper refreshes.
Reviewing automatically created items
Automatically created items appear on the Banking Recon Items tab. A sparkle icon identifies automatically included transactions. Hover over the icon to see why a transaction was included.
Review the items and make any necessary changes. You can:
- Rename reconciling items.
- Add or remove transactions.
- Delete reconciling items.
- Create additional reconciling items.
Your manual changes are preserved when the workpaper refreshes.
Understanding “Recorded in GL”
Banking-only reconciling items for TB-only entities are marked Recorded in GL by default.
Because detailed general ledger activity is unavailable, Audit Sight cannot verify whether each banking transaction was recorded in the books. The default setting is not confirmation that the transaction was recorded.
If you determine that a transaction was not recorded, click its Recorded in GL tag to change the setting.
Bank Transfer Matching
Bank transactions identified as transfers are automatically matched to offsetting transactions. This helps identify internal fund movement, treasury sweeps, and bank-to-bank transfers.
Review this activity alongside the automatically created banking-only reconciling items.
Unusual Banking Patterns
The TB-only workflow also highlights activity that may warrant further investigation, including:
- Large unexplained inflows or outflows.
- Unusual transfer behavior.
- Potential non-operating transactions.
- Significant fluctuations in banking activity.
Use these insights to direct additional audit or diligence procedures.
Reviewing Your Initial TB-Only Cash Proof
The initial workpaper combines trial balance adjustments with organized banking activity and automatically created banking-only reconciling items.
Your team should review these items, investigate remaining variances, and add supporting procedures as needed. Common supplemental procedures include:
Bank Reconciliations
Use monthly bank reconciliations, client-prepared reconciliation schedules, and supporting documentation to investigate timing differences and other reconciling activity.
Key Account Rollforwards
Rollforwards can help explain activity in accounts such as:
- Debt.
- Fixed assets.
- Equity.
- Deferred revenue.
- Accrued liabilities.
Investigation of Banking Activity
Review large transaction groups, sweep accounts, treasury activity, non-operating transactions, and unusual cash movements. Intercompany and related-party activity requires manual review.
Important Limitations
Without detailed general ledger activity, the TB-only Cash Proof cannot:
- Map individual journal entries.
- Build transaction-level reconciling items from individual journal entries.
- Roll forward accounting reconciling items.
- Directly match individual GL debits and credits to banking transactions.
- Verify whether each banking transaction was recorded in the books.
Banking-only reconciling items can still be created automatically from banking data, subject to the conditions described above.
The TB-only workflow accelerates preparation and helps focus investigation. Your team remains responsible for reviewing reconciling items, resolving unexplained variances, and performing any additional procedures needed.
FAQs
Can I use TB-only entities in the same workpaper as standard entities?
Yes. A single workpaper can include entities with full general ledger detail and TB-only entities. Audit Sight applies the appropriate logic to each entity.
Does the TB-only Cash Proof create reconciling items for me?
Yes. Cash Proof Advanced automatically creates banking-only reconciling items for transfers and sweeps, as well as eligible loan, owner contribution and distribution, and investment proceeds activity when the trial balance meets the conditions described above.
Intercompany and related-party activity is not included automatically and requires manual review.
Can I change automatically created reconciling items?
Yes. You can rename items, add or remove transactions, delete items, and create your own. Your manual changes are preserved when the workpaper refreshes.
Why are banking-only items marked “Recorded in GL”?
This is the default setting for TB-only entities. Without detailed general ledger activity, Audit Sight cannot verify whether each transaction was recorded. Review the setting and change the transaction’s tag if you determine that it was not recorded.
What should I expect the variance to be?
The remaining variance depends on the accounting records, account mappings, and whether reconciling activity can be explained using the trial balances and banking data.
Material variances may remain and require additional investigation or supporting schedules.
Why use Cash Proof Advanced for TB-only engagements?
Cash Proof Advanced provides enhanced logic to organize banking data, identify transfers and sweeps, separate non-cash activity, automatically create eligible banking-only reconciling items, and highlight unusual banking patterns.
How do I upload the data?
See the existing TB-only upload article for upload instructions and formatting requirements.
Uploading Monthly Trial Balances (Trial Balance–Only Upload Option)