File Format
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:
.png)
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_2023_true_2023-11-01_false_Budget_v1.csv
2023 |
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 |
2023-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.
.png)
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.
.png)