General Information
Do you have a video guide of the Cash Proof Module?
Yes. You can watch a step by step here of the Advanced Cash Proof.
And here for the Standard Cash Proof.
What is the Cash Proof Module?
The Cash Proof module is designed to automate the reconciliation of how GAAP (i.e., Reported) Revenue or Expense balances are reconciled to Cash Inflows and Cash Outflows per the bank. This module is typically used in transaction advisory engagements and audit engagements.
How Does It Work?
Audit Sight has built a rules-based engine that analyzes each journal entry recorded by the company to identify unusual transactions in the revenue and expense cycle. Additionally, the solution matches transactions between the bank and ledger to identify reconciling items, timing differences, and potentially unrecorded transactions. For each reconciling item, a tab is generated to document the identified item.
What Data Required to Run Cash Proof?
To run the Cash Proof module, you need to provide both Accounting Data and Banking Data.
Accounting Data:
General Ledger Report: The module needs detailed transactional data from your accounting system.
Comparative Trial Balance: This includes the balances from the prior period for comparison to the current period.
Note: Some general ledgers include starting and ending balances. If this is included, a trial balance is not needed.
The comparative trial balance is used to perform a completeness check over the accounting data.
Banking Data:
Bank Statements: You can upload PDF versions of your client’s bank statements.
Banking Transactions Listing: Alternatively, you can provide an Excel or CSV file that lists individual bank transactions.
QuickBooks Online is available for direct accounting connections. QuickBooks Desktop data can be provided through a backup (QBB) upload, and other accounting systems through supported exports. Upload banking data separately using PDF statements or supported Excel or CSV transaction files. Confirm that both accounting and banking data cover the required accounts and period before running the Cash Proof.
General FAQs
Can I run a Cash Proof over Revenue or Expenses?
Yes, a Cash Proof can be run over revenue, expenses, or both.
What are expected accrual accounts?
Expected accrual accounts are used to convert GAAP financials to cash. To calculate the reconciling items, the month-over-month change from the balance sheet is used.
For a Revenue Cash Proof, the expected accrual accounts are Accounts Receivable, Undeposited Funds, and Deferred Revenue.
For an Expense Cash Proof, the expected accrual accounts are Inventory, Prepaid Expenses, Accounts Payable, and Accrued Liabilities.
How do I know if I have complete data?
Audit Sight runs a completeness test over the accounting population by comparing the total activity in the general ledger to the balance provided. Any accounts that do not roll indicate that the detail is incomplete. Audit Sight also reviews the date ranges on uploaded bank statements to identify any potential gaps.
What reports are generated in the Cash Proof?
The cash proof workbook generates several reports, including:
Financial reports such as the Balance Sheet, Income Statement, and Chart of Accounts.
Bank account to GL account matching analysis including monthly activity summaries, listings of matched and unmatched transactions, and a listing of bank transactions.
High-level summary of all unique JE combinations for revenue, accrual accounts, expense accounts, and cash.
Every journal entry for the period and how it relates to the cash proof (i.e. reconciling items, accrual accounts, etc.).
Key Account Rollforwards for the following accounts Fixed Assets, Owner’s Equity, Debt, Sales Tax, and Intercompany.
What if I want to change the mapping of the chart of accounts?
Mapping of the chart of accounts can be altered at any time. Log in to Audit Sight, select your client or engagement, and navigate to the mapping header. Once the mapping is updated, a new Standard Cash Proof will be generated and ready for you to download in a matter of minutes. But if using the Advanced Cash Proof, a new one will need to be requested, no additional fees are incurred when changing the mapping of the chart of accounts.
What is the Audit Sight clearing account?
The Audit Sight clearing account is a processing account used to balance derived journal entries, including entries split across dates. It does not correct the client’s underlying books. Review its activity, the source records, and any effect on the Cash Proof before concluding.
What is the Audit Sight historical variance account?
This processing account represents an imbalance in the beginning trial balance supplied. Investigate the source balances and resolve missing or inconsistent data. Adding a balancing account does not establish that the underlying records are accurate.
Banking Data-Related Questions
How does Audit Sight handle foreign currencies?
Currently, the Audit Sight Cash Proof must be in a single currency (i.e., the currency in the bank statements must match the currency in the accounting data). For PDF bank statement conversion, we support any bank statement in USD and generally support most English-written statements. It’s a best practice to upload a single statement to ensure it can be processed. For non-English statements, we recommend obtaining a listing of transactions in Excel or CSV format for upload into the software.
What can I do if I only have banking data?
If you only have banking data (e.g., PDF bank statements or Excel listings of banking transactions), you can still use Audit Sight to start your Cash Proof. Once the transactions or statements are uploaded, they will be sorted into cash inflows and outflows. Additionally, using our machine learning algorithm, the transactions will be grouped based on the bank transaction description. These groups can help identify non-revenue and non-expense banking transactions.
What can I do if I only have the trial balance and banking data?
Use the Trial Balance Only Cash Proof. Cash Proof Advanced uses monthly balance changes, account mappings, and banking activity to create eligible reconciling items. Without GL detail it cannot directly match individual banking transactions to journal entries or verify whether each transaction was recorded. Review generated items and investigate remaining differences.
How does Audit Sight handle monthly timing differences (i.e., outstanding checks and deposits in transit)?
Cash Proof Advanced applies configurable matching rules and identifies potential deposits in transit and outstanding checks for review. Matching windows depend on the rule; they are not limited to a universal 30-day window. Review unmatched items and adjust rules or timing classifications when supported by the records.
See Matching Rules and Timing Differences.
What happens if I can't provide all bank statements or I can only get statements from a certain account?
When no banking data is available for a certain account, a standard reconciling item is created called "Bank Stmt not provided." This reconciling item can appear in multiple places depending on how the debits and credits are recorded for the company. If a specific month is missing, this will appear as a reconciling item called "Missing Bank Statement."
Other
What is the typical threshold for investigation?
For the Advanced Cash Proof, 1% threshold over the entire period is used in the cash proof for further investigation. If the cash proof variance exceeds 1%, the Audit Sight team will review it as part of our internal quality control. Monthly variances over 1% are often caused by timing differences.
Can I run interim testing with the Cash Proof module?
Yes! The Cash Proof module is perfect for interim testing. It helps streamline the process by reconciling cash balances at key points during the audit, allowing you to address issues before year-end.
Pricing, refreshes, and entity scope
Your firm’s agreement defines included products, usage, refresh terms, and any conversion or additional service fees. Confirm the applicable terms with your Audit Sight contact when expanding the period or scope.
Choose entity structure based on the analysis required. Combining entities can reduce visibility into individual accounts and transactions. Preserve bank-to-GL mappings and evaluate intercompany activity and any required eliminations.
What if I need help troubleshooting an issue with Cash Proof?
If you encounter any issues or need assistance, our support team is here to help. You can contact your account manager directly or reach us through our support portal or via email at support@auditsight.com.