Before running a cash proof workpaper in Audit Sight, users should review the Validation and Completeness results to ensure the underlying accounting and banking data is accurate and properly mapped. Performing these checks helps prevent reconciliation issues and unexpected variances in the workpaper output.

The checks differ slightly depending on whether you are running a revenue-only cash proof or a revenue and expense cash proof.

Revenue-Only Cash Proof: What to Validate First

Before proceeding with requesting a workpaper, confirm the following:

Account Activity

• Income accounts roll across the testing period.
• Cash accounts roll across the testing period.
• Change-in accounts roll, including:
  • Accounts Receivable
  • Undeposited Funds
  • Deferred Revenue
  • Other revenue-related change-in accounts

Chart of Accounts Mapping

• Applicable income, cash, and change-in accounts are mapped appropriately in COA Mapping.
• Bank accounts are mapped to the appropriate cash accounts in the Chart of Accounts.

Banking Data Completeness

• Banking data is complete for any bank account where revenue deposits occur.
• Ensure all relevant bank accounts are connected or uploaded into Audit Sight.

Revenue and Expense Cash Proof: Additional Checks

If the workpaper includes both revenue and expenses, perform the same checks listed above plus the following:

Expense Activity

• Expense accounts roll across the testing period.

Additional Change-in Accounts

Confirm the following accounts roll appropriately:

• Accounts Payable
• Accrued Liabilities
• Prepaid Expenses
• Other expense-related change-in accounts

Banking Data Completeness

• Banking data should be complete for any bank account where expenses are paid.

Best Practices When Uploading the AUS Template

If accounting data is uploaded using the Audit Sight template, consider the following best practices:

Check for Opening or Closing Entries

• Review whether there are opening or closing journal entries in the first or last month of the dataset.
• These entries can cause unusual spikes or distortions in income or expense activity in those periods.

Confirm Banking Data Direction

• Verify that banking data is formatted correctly:
  • Deposits should appear as positive values
  • Checks and withdrawals should appear as negative values

Incorrect sign conventions can cause reconciliation mismatches in the cash proof.