IntermediateBEHAVIORAL
Describe a situation when you had to reconcile conflicting financial records from two different systems. How did you determine which source was correct and complete the reconciliation?
data entry, bookkeeping
General

Sample Answer

Once our billing ledger and CRM showed $45k difference for a quarter. I created a reconciliation worksheet and mapped fields between the accounting system and CRM for 250 invoices. I prioritized tickets by amount and youngest discrepancies, then pulled original source documents: signed contracts, payment confirmations, and bank statements. That process revealed 18 invoices that had been marked paid in the CRM but not processed in accounting due to a batch upload failure. I reprocessed the batch, updated the journal entries, and added a daily cross-check that reduced mismatch days from 7 to 1. The reconciliation closed within two weeks and improved month-end close time by 30%.

Keywords

Built reconciliation worksheet and mapped fieldsUsed source documents (contracts, bank statements) to verifyFixed batch upload issue and implemented daily cross-checkOutcome: closed in two weeks and 30% faster month-end