Budget
      Back to home
      1. EBMS Knowledge Base
      2. Financials
      3. Budget

      Importing a budget

      The FIle > Utilities > Text Import/Export Mappings can be used to import a list of budget values.    This powerful tool can import a list of values from a text (TXT) or comma separated values (CSV) file.    This is an alternative option to the more integrated MS Excel Add-In utility described in [Main] Excel Add-In > Overview.   The Text Import/Export Mappings utility allows budget values to be imported from various software applications besides MS Excel.   

      Add Budget Accounts

      1. Complete the following steps to import budget value:

        1. Open the budget dialog by selecting Financial > Budget from the main EBMS menu.

        2. Select the Fiscal Year.   Open a new year if necessary.  See Creating a Simple Budget for more details.

        3. Click on the Wizard button

        4. Select the Add by G/L Code wizard and populate the appropriate range of codes.   Review Change a Range of Budget Accounts section for more details on the options.

        5. Set the Total Calculation to Manual since all values will be imported from the spreadsheet.

        6. Set the Distribution to Equal as shown above.

        7. Set the drop down option to Yearly Basis if the budget being imported is an annual budget.   Set to Monthly Basis if the budget will be imported per month.

        8. Click OK to add list of budget records for each GL code.   

      2. Open the mapping utility by selecting File > Utilities > Text Import/Export Mappings from the main EBMS menu as shown below:

      3. Select the GL Budget mapping table that is installed within EBMS with the budget module and click Properties:

      4. Enter the Excel file name into Text File.

      5. Enable the Has Header Row option and copy the column header names to the Text Field column.

      6. Enter the name of the column that contains the Year of the budget.

      7. Enter the name of the column that contains the general ledger Account code.

      8. Enter the name of the column that contains the annual budget Total if the Yearly Basis is selected above.    Note that the monthly amounts will be calculated based on the Distribution setting.   Enter each monthly budget amount and skip the Total amount if the Monthly Basis setting is set.

      9. Click on the Create File button to complete the import.  

      Review the [Main] > Utilities > Text Data Import and Export Utility > Overview for more details on this import utility.  

      Repeat this import for additional budget years.