Bank Statement Troubleshooting and Reconciling Periods
When bank statements are loaded into Valid8, they are checked against reconciliation rules. Statements that do not pass are flagged in yellow, indicating a discrepancy that must be resolved before the period can be marked as reconciled. This article covers how to identify, investigate, and fix reconciliation issues.
Steps
- From the process map, click the Bank Statements tile.
- In the Statements window, click the Statements icon in the upper left-hand corner. Review the Chevrons to see the total number of statements, how many are unassigned, how many are marked to be reconciled, and how many have been reconciled.
- Identify statements flagged in yellow — these indicate a reconciliation issue.
- To review the source data, click the icon in the File column for the statement. This opens a PDF copy of the original statement so you can inspect the data for inaccuracies or redacted information.
- Return to the Statements window and open the Reconcile view for the flagged statement. Read the error message to identify the specific reconciliation issue.
- Common reconciliation errors include:
• Transactions outside the statement's start and end date range
• Account balance variance is not equal to zero
• Date overlap between two statements - Correct the data per the error message. Once the discrepancy is fixed, click the Save icon, then click Reconcile.
- Once reconciled, the statement is locked — transactions can no longer be edited. If further changes are needed, click Unreconcile to reopen the statement, make corrections, then reconcile again.
Tips & Common Questions
- Yellow = action required. Any yellow-flagged statement must be resolved before the engagement analysis is complete.
- The PDF viewer is your first stop for troubleshooting. Opening the source file lets you confirm whether missing data is due to redaction, data entry error, or an incomplete upload.
- Reconciling locks the statement. This is intentional — it protects the integrity of the data. Use Unreconcile carefully and only when necessary.
- Three most common errors: out-of-range transactions, balance variance not equal to zero, and date overlap between statements.