End-of-Day Cash Drawer & Vault Balance Reconciliation Report

1. Branch Location & Cashier Profile

Provide accurate branch and employee identification details for audit trail purposes. All fields marked mandatory must be completed before submission.


Branch Code

Branch Name

Branch Full Address

Reporting Date

Shift End Time


Employee ID Number

Employee Full Legal Name

Job Role/Position

Shift Type

Cash Drawer/Vault Identifier

Immediate Supervisor Name

Supervisor Employee ID

Was a proper handover completed from previous shift?


Has this specific drawer/vault location experienced variances in the past 30 days?


2. Variance Amount & Denomination Breakdown

Document the exact variance amount and provide a complete breakdown by denomination. Calculate variance percentage relative to total drawer/vault balance. All currency values must be entered with standard decimal notation.


Variance Type Classification

Total Variance Amount

Is the variance within the institution's acceptable threshold limit?


Variance as Percentage of Expected Balance (%)

Total Expected Balance per System/Log

Total Actual Counted Balance


Denomination Breakdown - Bills

Denomination

Expected Count

Actual Count

Variance Count

Value per Unit

Total Variance Value

100
500
498
-2
$100.00
-$200.00
50
800
800
0
$50.00
$0.00
20
1200
1195
-5
$20.00
-$100.00
10
600
610
10
$10.00
$100.00
5
400
398
-2
$5.00
-$10.00
1
500
505
5
$1.00
$5.00
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00

Denomination Breakdown - Coins

Coin Type

Expected Count

Actual Count

Variance Count

Value per Unit

Total Variance Value

1.00
200
200
0
$1.00
$0.00
0.50
150
148
-2
$0.50
-$1.00
0.25
300
304
4
$0.25
$1.00
0.10
250
250
0
$0.10
$0.00
0.05
200
195
-5
$0.05
-$0.25
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00
 
 
 
0
 
$0.00

Does this variance involve foreign currency or non-standard denominations?


Total Transaction Volume Processed During Shift

Total Number of Transactions Processed

Peak Hour Transaction Count (Highest 60-min period)

3. Audit Steps & Reconciliation Log

Document all audit and reconciliation procedures performed to identify root cause. Include timestamps, personnel involved, and outcomes of each step. Follow-up questions will appear based on your responses.


Was an immediate physical recount performed?


Was a witness present during the recount/audit process?


Was system-level reconciliation attempted using core banking platform?


Which manual audit procedures were completed? (Select all that apply)

Were any system errors or technical issues encountered during the shift?


Were any cash handling equipment malfunctions identified (e.g., bill counter, coin sorter)?


What is the current reconciliation status?

Does this variance require escalation beyond branch level?


Timestamp when variance was first discovered

Time duration spent on initial investigation (hh:mm)

Detailed chronological log of all audit steps performed, including timestamps and responsible personnel:

4. Security Camera & Transaction Review Findings

Record all security-related investigations including camera footage review, transaction monitoring, and any suspicious activity identification. This section is critical for fraud detection and loss prevention.


Has security camera footage been reviewed for the shift period?


List specific camera IDs and timestamps reviewed (e.g., CAM-04: 14:30-15:45):

Total number of security cameras reviewed

Were customer-facing cash transactions reviewed in detail?


Were high-value transactions (above institutional threshold) specifically reviewed?


Was any suspicious behavior or potential fraud indicators observed?


Were any procedural violations by staff identified?


Are there indicators of potential external theft or robbery attempt?


Has all relevant evidence been preserved and secured?


Evidence storage location/reference number

Has law enforcement or internal security been notified?


Security Officer on Duty (Name & ID)

Overall Security Risk Rating for this incident (1=Low Risk, 5=Critical Risk)

5. Branch Audit & Compliance Sign-Off

Final review and compliance verification by branch management. Ensure all required approvals, notifications, and corrective action plans are documented before final submission.


Has the Branch Manager reviewed and verified all reconciliation findings?


Branch Manager Full Name

Branch Manager Employee ID

Has the Regional/Area Manager been notified of this variance?


Has the institutional compliance checklist been completed for this incident?


Compliance Items Verified (Select all that apply):

Are corrective actions required to prevent recurrence?


Is additional training or coaching required for involved personnel?


Branch Manager Digital Signature - Verifying accuracy of reported information

Branch Manager Sign-Off Timestamp

Does this incident require Internal Audit Department review?


Final Resolution Status

Estimated Final Resolution Date

Final Documentation Storage Location/Reference

Additional Comments, Observations, or Recommendations:

Attach supporting documents (e.g., transaction logs, recount sheets, system screenshots)

Choose a file or drop it here
 
How would you like to be the architect of this form template, designing it to meet your specific demands? Edit this Bank Cash Reconciliation & Variance Reporting Form
Spreadsheet power in your forms: Zapof.
This form is protected by Google reCAPTCHA. Privacy - Terms.
 
Built using Zapof