Budget Creation
Via CSV
The Chart of Account /Budget Files is a comma delimited file (csv). The hierarchy of file goes from left to right with the top or your organization being the left column to the lowest product/project in the 4th column. The First Row of the file will drive the labels of the application.
Sample File:
File Name
The Chart of Account File should be generated from your Core Accounting System that reflects your Hierarchy and Approved Budget Spending for AWS.Budgets (via file format) can be updated based on Customer requirements.
Customer_2025_true_2025-11-01_false_Budget_v1.csv
2025
effectiveYear - sets endDate to 2023-12-31. If isNew = true, startDate will be overridden to 2023-01-01
true
isNew - sets startDate to effectiveYear-01-01 and reloads the budgets
2025-11-01
startDate - sets when the budget becomes active. Must be 1st of month
false
isOverride - if you want to replace the existing entries, clears the database for given effective year and creates new entries
Customer Option
None
v1
None
I am a CCoE User and I want to create a New Budget for All Project for the New Budget Year.
I am a CcoE User and I want to up to update a Product’s Annual Budget on 7-01-XX
I am a CCoE User and I want to add a New Product and it’s budget
Chart of Account Integration
Admin users upload the Chart of Account File in the Configuration Page. The Chart of Account File is uploaded in the *.sorfile s3 Bucket and processed by Lambda into DynamoDB.
Invoice Integration
CCoE and Business Unit Users will be able to download csv to their desktops for integration into Core Financial and/or FP&A Solutions.
Last updated