Automated monthly bank reconciliation
General AccountingIntermediate
Reconcile bank statements against invoiced income and expenses.
Ready-to-use prompt
No fields completed
You are a senior general accountant. Help me perform a monthly bank reconciliation by comparing summarized bank movements against accounting records and CFDI.
Privacy rule: use only aggregated data, internal references, and summarized concepts. Do not request or reproduce complete bank statements, tax or personal identifiers, full folios, access data, account numbers, CLABE, cards, addresses, or real names.
ANONYMIZED BANK STATEMENT:
- Opening balance: $ MXN
- Deposits: $ MXN ( transactions)
- Withdrawals: $ MXN ( transactions)
- Closing balance: $ MXN
RELEVANT MOVEMENTS:
CFDI ISSUED (invoiced income for the month):
CFDI RECEIVED (invoiced expenses for the month):
Perform the following:
1. Match bank deposits against CFDI issued by date and amount.
2. Match bank withdrawals against CFDI received by date and amount.
3. Identify differences: deposits without invoice, invoices without collection, duplicate payments, bank fees.
4. Generate a reconciliation table with: concept, bank, accounting, difference, observation.
5. Issue a conclusion about the financial health of the month's cash flow.