Bank Statement Upload & Reconciliation Form

General Details

Bank Statement Upload

Bank Reconciliation Details

Bank-wise Closing Balances

Bank Name Account Number Closing Balance (₹) Action

Help

Use the prompt to quickly fill the bank statement upload and reconciliation form. Ensure your prompt follows the specified format for accurate parsing.

Tips for Writing Prompts:

Need More Help?

Contact support at support@example.com or refer to the user manual.

Follow this prompt format:

Create a bank reconciliation period uploadDate bank account file bookBalance statementBalance [deposits ] [withdrawals ] [notes ] [balances ]

Keywords (use exactly as shown): Create, bank reconciliation, period, uploadDate, bank, account, file, bookBalance, statementBalance, deposits, withdrawals, notes, balances

Values:

  • statement_period: YYYY-MM (e.g., 2025-04)
  • upload_date: YYYY-MM-DD (e.g., 2025-04-25)
  • bank_name: sbi, hdfc, icici, axis
  • account_number: Account number (e.g., 12345678901)
  • file_name: File name (e.g., statement.pdf)
  • book_balance: Numeric amount (e.g., 100000.00)
  • statement_balance: Numeric amount (e.g., 95000.00)
  • unreconciled_deposits: Numeric amount (e.g., 5000.00)
  • unreconciled_withdrawals: Numeric amount (e.g., 2000.00)
  • reconciliation_notes: Notes (e.g., Minor discrepancies due to pending checks)
  • bank_balances: Comma-separated, format: (e.g., sbi 12345678901 100000.00, hdfc 98765432109 75000.00)

Examples:

  • Create a bank reconciliation period 2025-04 uploadDate 2025-04-25 bank sbi account 12345678901 file statement.pdf bookBalance 100000.00 statementBalance 95000.00 deposits 5000.00 withdrawals 2000.00 notes Minor discrepancies due to pending checks balances sbi 12345678901 100000.00, hdfc 98765432109 75000.00
  • Create a bank reconciliation period 2025-03 uploadDate 2025-03-20 bank hdfc account 98765432109 file statement.xlsx bookBalance 75000.00 statementBalance 74000.00