Review differences between bank and accounting records
Help me reconcile bank transactions with the accounting records for the month. Use the information provided and leave matches pending when they need supporting records. State whether the data covers the whole period or only part of it.
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:
- Period and currency:
- Opening balance: $ MXN
- Deposits: $ MXN ( transactions)
- Withdrawals: $ MXN ( transactions)
- Closing balance: $ MXN
RELEVANT TRANSACTIONS:
ACCOUNTING RECORDS:
CFDI ISSUED (include invoices from earlier months collected in this period):
CFDI RECEIVED (include invoices from earlier months paid in this period):
Perform the following:
1. Check that the opening balance plus deposits minus withdrawals equals the closing balance for each account. Also check the ledger balances against the entries provided.
2. Compare bank and accounting records. Use dates and amounts to propose matches, but ask for additional references before confirming ambiguous ones. Consider partial payments, grouped receipts, fees and timing differences; do not force a one-transaction-to-one-invoice match.
3. Identify unexplained transactions, possible duplicates and invoices awaiting collection or payment. Do not classify every deposit as a sale or every withdrawal as an expense. Separate transfers between own accounts, loans and other transactions only when supported by the information provided.
4. Produce a table with internal IDs, bank and ledger amounts, differences, review status and missing supporting records. Do not allocate the same amount twice without explaining its distribution.
5. Summarize balances and unresolved differences. If accounting records are missing or the data is only a sample, explain the limitation and do not declare the month reconciled. This comparison alone cannot establish the business's financial health.