Dealership Daily Deposit and Bank Reconciliation Sheet

Daily reconciliation form for dealership office managers to compare cashier receipts, parts, service, and sales deposits, and credit-card batches against bank records.

Reconciliation Details

• Reconciliation Date
  Select the business date being reconciled.
• Prepared By
  Name of the office manager or accounting staff member completing this form.
• Dealership Location
  Enter the dealership or store location for this reconciliation.
• Bank Name
  Enter the bank used for daily deposits.
• Deposit Reference Number
  Optional deposit slip or reference number for traceability.

Deposit Totals by Department

• Cashier Receipts Total
  Total cashier receipts included in the daily deposit.
• Parts Deposit Total
  Total parts department deposit amount.
• Service Deposit Total
  Total service department deposit amount.
• Sales Deposit Total
  Total sales department deposit amount.
• Other Deposit Total
  Any other deposit amount not captured above.

Credit Card Batch Reconciliation

• Total Credit-Card Batches
  Number of credit-card batches included in the reconciliation.
• Credit-Card Batch Amount
  Total amount settled or expected from credit-card batches.
• Did all credit-card batches settle as expected?
  Select Yes if the batch totals match the expected settlement.
• Batch Variance Reason
  Explain any batch variance, missing settlement, or processor issue.

Bank Comparison and Variance Review

• Bank Deposit Total
  Amount shown on the bank record for the deposit date.
• Book Deposit Total
  Total deposit amount recorded in the dealership books.
• Variance Amount
  Enter the over/short amount if the bank total does not match the book total.
• Variance Explanation
  Describe the cause of any discrepancy and the corrective action taken.
• Supporting Documents
  Upload deposit slips, bank statements, or batch reports if needed for audit trail review.

Manager Review and Sign-Off

• Review Status
  Select the final reconciliation status.
• Manager Comments
  Add any follow-up notes, corrective actions, or approval comments.
• Manager Signature
  Signature of the office manager or authorized reviewer.