SAOB Column Mapping
Map each LGU's SAOB Excel column headers to system fields so uploads can be auto-imported
📊
About SAOB Mapping
Configure Excel column mappings to enable automatic import of SAOB reports
How it works:
- Select the LGU from the dropdown
- Enter the exact Excel column headers used in their SAOB file
- System will automatically map columns during import
- Each LGU can have different column names
Required Fields:
- PPA Code
- Appropriation
- Allotment
- Obligation
- Balance
Note: Column headers are case-sensitive. Make sure they match exactly as they appear in the Excel file.