Expense Budgets

How to create and import an expense budget

An expense budget can be defined as a total over a period of time or a specific allocation for various categories. These categories can include job expenses, task type heading, task type, or supplier expenses.

How to manually create a New Expense Budget

Steps: 

  1. Navigate to ACCOUNTING > Budgets > Expense Budgets.  
  2. Click on CREATE A NEW EXPENSE BUDGET.
  3. Click on the ACCOUNT NO. magnifying glass.
  4. Search and select the GL account for which you wish to enter a budget. 
    Screenshot 2023-05-08 at 12.31.05 PM


  5. Select the Office using the drop-down menu.
    Maria Large Knowledge Base Template -May-08-2023-04-36-20-2969-PM


  6. Select the Accounting Year
  7. Select the Current Budget Version.
  8. The budget amount can be entered separately for each month. 
    Maria Large Knowledge Base Template -May-08-2023-04-58-38-6236-PM


  9. Click CALC to re-calculate the total for the year as you make changes. 
    Maria Knowledge Base Template-May-08-2023-05-01-55-9221-PM


  10. Click SAVE & CLOSE
  • If the budget amount is the same for multiple months, enter the amount in the Default Amount box, select the box to the left of the months you wish to apply that amount to, and click the COPY DEFAULT AMT button.
  • The Account No. specified must have the Budget Expenses by Department and/or Job boxes checked on the General Ledger Account page, in order for the Department or Job fields to become active here. 

How to Import a New Expense Budget

Users can also import budget details using Accountability's standard import template.  

Steps:

Starting from the Search Expense Budgets page.

  1. Select the Import hyperlink. 
  2. Click Download template
  3.  Populate the template by entering the information using one line for each GL Expense Account/Department combination.

    Field Name  Description
    Office Code Required Field. 
    Accounting Year Code Required Field.
    Budget Version  Required Field.
    GL Account No General Ledger Account Number.
    GL Account Name  General Ledger Account Name.
    Department Code  Enter the relevant Department Code to create a budget for a department within that Expense GL Account.
    Job No Enter the relevant Job Number to create a budget for a job with that Expense GL Account.
    Month 1 Amt Budget amounts for the relevant Accounting Months of the Budget Year.


  4. Save the file.

  5. Navigate back to Accounting > Budgets > Expense Budgets.

  6. Click Import.

  7. Click on SELECT FILE and choose the Saved File.