How can a User Import a Budget in Versa Cloud ERP?
To begin the import process, a user needs to go to Setup>Company>Budget. Once on the budget screen, there will 2 workflows:
1. If the user needs to update an existing budget: Click on the 'Edit' option on the Budget you want to update. One in the budget, click on the 'Download blank spreadsheet (CSV) for Importing'. This will give the user an empty template to populate the data. Once the budget file is updated, the user needs to come back to the budget in 'Edit' mode and click on the 'Import from Spreadsheet (CSV)'.
2. If the user needs to create a new budget and update the budget via an import: The user will need to create a 'New Budget'; and update all the details such as the Status, Type, Budget by, and Accounting period. The next step will be to the 'Download blank spreadsheet (CSV) for Importing'. Once the budget file is updated, the user needs to come back to the budget in 'Edit' mode and click on the 'Import from Spreadsheet (CSV)'.
Budget Import Template
Template Requirements
| Column Header | Description | Requirement |
| Name | The name is the description of the budget item and it is required for creating budget line items. | Mandatory |
| GL Account Name | GL Account Name will include the names of the income and expense accounts in the system and it is compulsory for creating budget items. | Mandatory |
| GL Account Number | GL Account Number will include the account numbers of the income and expense accounts in the system and it is compulsory for creating budget items. | Mandatory |
| Description | The line item description of a Budget | Optional |
| Justification | Optional | |
| Budget Period |
The budget Period contains the number that represents a period(1-4 for quarters 1-12 for months and 1 for year). Budget Period values can be between 1 to 12 and cannot be repeated for the same GL account. |
Mandatory |
Template
| Name | GL Account Name | GL Account Number | Description | Justification | Budget Period |
| USD Checking ***1053 | USD Checking ***1053 | '10000' |
Please Note: The user will need to add an additional column for each budget period.
Comments and Suggestions
0 comments
Please sign in to leave a comment.
Related articles