Embedded Files
Built an end-to-end reconciliation workbook in Google Sheets that audits internal checkout orders against raw commercial bank statement feeds. It standardizes uncleaned transaction data, matches settlement amounts, and deconstructs ledger variances down to zero unallocated balance.
Port of Spain, Trinidad & Tobago (AST / EST) • Independent B2B Contractor
[01] Ingestion
Ingested raw export files (orders_log Raw and bank_feed Raw) containing inconsistent whitespace and formatting.
[02] Normalization
Applied =TRIM() to strip invisible spaces and standard text formulas to ensure Order IDs match reliably across sheets.
[03] Reconciliation Table
Calculated Expected Net Payouts by subtracting gateway processing fees from gross order totals (Gross - Expected_Fee).
[04] Variance Isolation
Calculated Settle_Variance (Expected_Net - Bank_Cleared_Net) to immediately isolate discrepancies line by line.
TOTAL VOLUME INGESTED
499 Production Records
GROSS SETTLEMENT AUDITED
$297,999.97 USD
FINAL VARIANCE TOLERANCE
$0.00 (100% Balanced)
System Audit Log // BATCH-OPS-8100
STATUS: CLOSED • ASSIGNEE: Kadeem Craigwell • RESOLUTION: RECONCILED TO ZERO
Ingested 499 commercial settlement records across Visa, Mastercard, AMEX, and ACH rails. Reconciled $85,788.88 in pending clearing holds ($41,130.98 ACH T+2 cutoffs; $44,657.90 rolling risk reserves). Normalization verified via =TRIM(); net clearance verified down to $0.00 unexplained variance.
Google Sites
Report abuse