Column Mapping

Column mapping matches your source columns to standard SpendCraft fields. This is important because it ensures consistent data structure across sources, enables accurate spend classification, allows combining multiple sources into datasets, and powers analytics and reporting.

SpendCraft Standard Columns: Map your source columns to these SpendCraft fields:

• Recommended Fields: VendorName, InvNum, InvDate, InvAmount, and Spend.
• Optional Fields: NormVendorName, VendorCode, InvLineDesc, CostCenterCode, CostCenterDesc, GLCode, GLDesc, EntityName, ProductCategory, PONum, PODate, and ItemDesc.

How to Map Columns:

1. Open source and click "Column Mapping".
2. You will see two lists: Source Columns (left) and SpendCraft Columns (right).
3. Use the dropdown to select the SpendCraft column for each source column.
4. Cick "Save Mappings" when complete.