Cloud Cost Allocation Processing

Upload your Excel files to process cloud cost allocations and generate journal entries

Processing Mode Advanced Processing

Choose between standard allocation processing or advanced quarterly variance analysis

Filter Processing Mode
Exclude Mode: Skip items listed in filter files (default)
Include Mode: Process only items listed in filter files
Cloud Detail Postings
Required: Contains your cloud cost data from Azure, GCP, or other providers. Supports both CSV and Excel formats. The date column should be in MM/DD/YYYY format.
New CSV Format: date, vendor, category1, category7, category8, category9, vendor_account_identifier, vendor_account_name, resource_group, category4, total_amortized_cost
Legacy Excel Format: Date, Vendor, BU Code, Finance Sub Bus Unit, Cost Center, Business Unit, Account ID, Account Name, Resource Group (value), Core-UID, Cost (Amortized)
Cost Center & UID Filters
Optional: Excel file with 'COSTCENTER' and 'UID' sheets to control which items are processed or excluded.
UID to WBS Element Mapping
Optional: Maps UIDs to WBS elements for SAP journal entry generation. Helps with project tracking and reporting.
Cloud Posting Reference & Mappings
Required: Comprehensive mapping file containing Azure/GCP cost center mappings, BU codes, UID allocations, and filter lists.
COA Mapping File
Optional: COA (Chart of Accounts) mapping file containing Cost Center and Service ID mappings for enhanced journal entry descriptions.
Expected columns: Cost Center, Service ID, and other COA attributes for comprehensive mapping.
BU List File
Required: Business Unit mapping file containing the true BU Code and Business Unit mappings for validating Apptio data accuracy.
Expected columns: BU Code, Business Unit - used to audit category1 and category7 columns in the Apptio file.
Audit Fix File
Optional: Upload a previously generated CloudAllocations.xlsx file containing audit corrections.
Expected format: Standard CloudAllocations output format with Audit CC and Audit BU sheets containing corrections.
Previous Run File
Optional: Upload a previously generated CloudAllocations.xlsx file to intelligently merge Monthly Consolidated sheet values.
Smart Logic:
• Months with "_NonApptio": Uses current run's Apptio logic and BPC forecast (not copied from previous)
• Months without "_NonApptio": Copies all values (actual, forecast, variance) directly from previous run
Expected format: Standard CloudAllocations output format with Monthly Consolidated sheets.
Internal Forecast Data
Required: Select your quarter and upload the corresponding monthly forecast files. Each quarter contains 4 overlapping months with the last month being optional (except Q1 2026 which has 3 months). Each file should contain separate Azure and GCP sheets for that specific month.
Requirements: Excel file with "CFPF Plan" sheet containing filtered data for multiple fiscal years (FY26, FY27, FY28). Must include columns: Version (F001-F012), Scenario (CF), Category (AD Allocation Entry), Cost Element (67752), Solution ID (317*/318*), Cost Center, Service Area/Category/Service mappings, and either Full Year totals or monthly columns (001/2026 format).
Requirements: Excel file with a sheet named "BPC", headers at rows 11-12, data starting at row 13.
Required Columns: Cost Center, GL Account (67752), Business Justification (with "Solution ID: XXX"), Sub Vendor (Location Entry), Service Area/Category/Service.
Automatic Filtering: Only rows with GL Account = 67752, Sub Vendor = "Location Entry", and Solution ID starting with 317 (Azure) or 318 (GCP) will be processed.
Month Columns: Format "October FY 2026", "November FY 2026", etc.
Required
Required
Required
Optional
Required
Required
Required
Optional
Required
Required
Required
Optional
Required
Required
Required
Optional
Required
Required
Optional
Audit Sheet Password
Provide a password to protect the Audit BU and Audit CC sheets in the output workbook. Users will need this password to unprotect and edit.
Debug & Analysis Options
Generates additional sheets showing filtered items, mapping details, and processing statistics for audit purposes.
Your files are processed securely and not stored permanently
Sample Files

Download sample files to understand the expected format

Cloud Posting.xlsx Cloud data file
Cloud posting x-ref.xlsx Reference mappings
Internal Allocation_Apr_2025_V2.xlsm Internal forecast data

Processing your files...

This may take a few minutes for large files