ATTACHMENT J.20 - Transaction Capture Report Template.xlsx

This is a Transaction Capture Report Template for the Campus Style Dining Venue (CSDV) Initiative, designed to standardize data submission requirements for meal transactions at Army installations. The template specifies the required data fields that contractors must capture and report for each transaction, including unique transaction identifiers, installation location references, military personnel identifiers (EDIPI), transaction date and time, meal type (breakfast, lunch, dinner), Army meal entitlement codes, itemized SKUs purchased, transaction totals, approved meal numbers, allowance amounts, and external transaction identifiers. The template includes example entries demonstrating proper data formatting, with sample transactions showing lunch and dinner meals with associated costs and timestamps that include timezone information to enable accurate post-transaction reconciliation.

This reporting template supports the NAFBA1-26-R-0028 IDIQ concession contract between the U.S. Army Installation Management Command (IMCOM) and a concessionaire contractor to operate Campus Style Dining Venues at Army Garrison locations in Hawaii. The data capture framework ensures standardized transaction tracking across multiple dining facilities, enabling accurate meal entitlement validation, financial reconciliation, and performance monitoring. Contractors must submit transaction data with complete information for authorized NAFI patrons' dining purchases, linking each transaction to specific meal entitlements and allowances to facilitate proper payment processing and fee calculations between the contractor and the NAFI.