Managing Project Budgets – Certify Help Center

Certify AP allows companies to create and edit the budgets for each department at the project level, rather than at the GL level. This feature enables spend tracking through project budgets, as well as running reports on project spend versus the project budget.

This article shows you, a Certify AP user with the Configure Budgets permission, how to view and edit your company’s project budgets.

Step 1: Log into Certify AP and open the Budgeting tab. Next, click Configure/View Project Budgets.

Step 2: The Project Budget page opens.

Step 3: Select the Fiscal Year and Department dropdowns to filter which project budgets amounts should appear.

Please Note:

If a company chooses to restrict projects by department, each department page shows only the projects associated with that department.
If a company does not restrict projects by department, all departments show the same projects.

Step 4: After selecting a department and fiscal year, click Submit.

A table displaying the budget figures for the Projects in this department appears below.

Column(s)	Description
Project Name, Project Number, ERPID	The name, number, and ERPID of this project
Q1: Jan, Feb, Mar, etc	The budgetary amounts for each month in each quarter.
Total	The total budgetary amount for this project for this fiscal year.
Edit	Click the Edit () icon in any row to edit the budgetary amounts for that project.

Editing Project Budgetary Information

Step 1: On the Project Budget page, click the Edit () icon in the Project’s row.

Step 2: Add monthly budget amounts by entering them in the fields provided.

To copy the first month’s budget amount to all other months, in that fiscal year, enter the first month’s budget amount and click the Replicate () icon. The first month’s amount is replicated for each month.

To divide the Total budget evenly between the months of the year, scroll right to see the Total column. Enter the new total in the Total column and click the Distribute () icon.

Certify AP divides the amount in the Total column by 12 and assigns an equal amount to each month.

Step 3: After entering the budget amounts for the Project, click Update.

Uploading Project Budgets via Setup Utilties

If needed, a Certify AP Administrator can upload project budgetary amounts via Setup Utilties.

Step 1: On the Certify AP Home page, click the Gear icon on the top right. When the AP Configuration page opens, select Setup Utilities.

Step 2: The Data Import page opens. Click Start Import.

The Create Import page opens. Use this page to upload and configure the data.

Step 3: Download the Data Import Template and use the Project Budgets worksheet to upload the budget amounts.

Please Note: Full Account Number format should be DepartmentCode-ProjectERPID.

Step 4: Once the upload file is ready, follow the steps in the SetupUtilties to upload the project budgets.

Analyzing Project Spend vs. Budget

Once you upload your Project Budgetary amount, there are a few places to track project spend vs. budget amount.

Project Report

Step 1: On the Reporting tab, select Project Report.

The Project Report page opens.

Step 2: The Project Report page opens. Use the following search fields to choose what information to pull into the report:

Search Field	Description
List by	Select one of the radio buttons to list projects by: ● Department ● Project
Department	Click on the dropdown menu and select a department.
Date Range	Enter the time period in which to search for spending or click on the dropdown menu and select a date range.
Consolidate	Mark this checkbox to consolidate (combine) the projects for the department you chose and its child (sub) departments. If this checkbox is not marked, the report only shows projects for the department itself.
Transactions to include in Report	Mark the checkbox of each transaction to include in this report