Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Access the Ledger module.

  2. Click on Budgeting.

  3. Click New.

  4. Specify a Budget Name. For example: 2014 Budget

  5. Specify a Fiscal Year option. For example: 2014 

  6. Optional: Specify a Description value.

  7. Click Save.

  8. Click Budget Method.

  9. If an option under Budget Method List does not exist:

    1. Click Insert.

    2. Specify a Company value. For example: 70

    3. Specify a Fiscal Year value. For example: 2014

    4. Specify the No. of Periods in the Fiscal Year. For example: 12

    5. Specify the No. of Day in the Fiscal Year. For example: 365

    6. For each Period in the No. of Weeks in Each Period column, specify a value.
      Note: You only need to specify rows for the # of Periods that you have.

      1. For example:
        1. Period 1 = 4 weeks 
        2. Period 2 = 4 weeks
        3. Period 3 = 5 weeks
        4. Period 4 = 4 weeks
        5. Period 5 = 4 weeks
        6. Period 6 = 5 weeks
        7. ...

    7. For each Period in the No. of Days in Each Period column specify a value.

      1. For example: 
        1. Period 1 = 28 days
        2. Period 2 = 28 days
        3. Period 3 = 35 days
        4. Period 4 = 28 days
        5. Period 5 = 28 days
        6. Period 6 = 35 days
        7. ...

    8. Click OK.

  10. If an option under Budget Method ListList does exist:

    1. Select the desired Budget Method option from the top grid for this budget.

    2. Click OK.

  11. Click the Import File button.

  12. Select the option of "Excel Files 2007" under the Files of Type option at the bottom of the window.

  13. Browse to the location on your computer or network to the Excel file.

  14. Click Open.
    The data from the file should now be displayed in an Import Budget screen. Review the data for accuracy.
     
  15. Click Import.

  16. Click OK to the Importing Data Is Successful message.

  17. Click Close.

  18. Click Save