Budgeting / Declining Checkbook

 

     

The budgeting feature, also know as a Declining Checkbook, permits the real-time tracking and analysis of a given purchase against a GL account. Access to real-time budget impact analysis is available throughout the buying and approval process.

Budget timing

Budget monies are updated at different times during the PO process: Accept PO, Receiving/ Reconciliation, REQ Fulfillment, and Manual entry (Budget Adjustment).  The budget amount is decremented based upon the Required Delivery Date of each document.

Accept/Submit

In the following situation, the budget is decremented when the Supplier accepts the PO.

  1. On-line Supplier – PO status changes to Accepted by Supplier.

 

In the following situations, the budget is decremented immediately when buyer Submits the PO:

  1. SOTF/Off-line Supplier – PO status changes to Fax/email/csv accepted

  1. SOTF/Off-line Supplier – Where fax is not processed correctly, the PO status changes to Fax failed connection not made. This allows the PO to be manually re-faxed without decrementing the budget twice.

  1. Punchout Supplier – PO status changes to Accepted by Supplier.

  1. Confirming PO (any type of supplier) – PO status changes to Accepted by Supplier.

Receiving/Reconciliation

During the Receiving/Reconciliation process, budget adjustments are made. The original PO entry is reversed and the new entry is made.  The Received date is used to determine the budget period which gets decremented instead of the required delivery date from the original PO.  Budget adjustments are also made based upon the Accepted quantity versus the order quantity.  You can also reverse the budget completely when using the Cancel PO button which also sets the PO’s status to Buyer Cancelled.

Inventory REQ Fulfillment

When using the Inventory feature, budgeting is not updated when a PO is accepted by the supplier. It is updated only when the REQ is fulfilled from the storeroom to the outlet (department).

Budget Adjustment (Manual entry)

In addition to automatic budget updates, the finance department can make manual adjustment entries.

  1. From the Main Menu, click on Budget Adjustment Entry.

  1. Select Manual from the Budget entry type dropdown list (defaulted).

  1. Notice that the entry has a Posted status of “No.” This will not be updated until the record has been created and the Update button is clicked.

  1. Enter a free form Short description of the transaction.

  1. If this transaction belongs to an existing PO, enter the PO Document number. (Include any prefix or leading zeros. Normally the length is 15.)

 

 

  1. Click on the Detail tab to enter the detailed information about this transaction.

  1. Type in or zoom to select the Period number, Department and GL account. These are all required fields.

  1. Type in the monetary adjustment amount (in the Home currency). A positive number increases the expense; a negative number reverses the expense.

 

 

  1. Click OK to save the detail record. Add any additional rows as needed.

  1. Click Save to save the entire adjustment record without posting it. The budget amount is not yet adjusted.

  1. Click Update after the adjustment is made and verified. This will post the record and no further changes can be made. The adjustment record is committed and the budget amount is adjusted.

Budget Impact

Budget Impact window is found on the PO tab for the buyer and Approvals tab for the approver.

 

Click Budget Impact to get real-time budget information to make budgeting decisions. All POs that have started the approval process are taken into consideration for the calculations including the current PO.

Note: Budget Impact is not available for a Storeroom PO. Budget update takes place when the REQ is fulfilled. The Budget Period displayed is based upon the PO’s required delivery date.

 

View the information in two ways by making a selection from the Department dropdown:

  1. This PO only. View the PO as a stand alone document.

 

  1. By department. View the PO as a part of all GL accounts within a department.

 

Note: Only the departments for which the buyer has security access are included in the dropdown list of departments.

 

Information about the budget, reserve amount, and POs in the approval process is calculated to display a real-time picture of monies available. Within this window is the Budget Reserve feature that allows the user to “artificially” transfer unused budget from one GL account to another. 

Budget Reserve

Feature Summary

Feature Details

  1. From either the PO or the Approval Tab  access the button to launch the Budget Impact screen.
     

  1. On the Budget Impact window, notice that the impact to the selected GL account for the PO’s balance is negative. Only negative balance GL accounts for the current budget period may have a Budget Reserve placed on it.  If the user tries to create a reserve against a GL account with a positive End Balance, the system prompts the user with an error. To access the Budget Reserve feature first select the Budget Row with the negative balance and  click Create Reserve.

 

On the Reserve Account screen enter the GL Code of the GL code to “Artificially Transfer the balance to – the “To Account”.  The system reads the entire amount of the negative balance, and creates a new “reserve balance” on a separate GL code that will be subtracted from the calculated Current Balance for users who subsequently access any PO’s assigned to the “To Account”.  NOTE:  No budget is actually ever “moved”.  The Budget Reserve’s purpose is to create the illusion that one account is lower to cover actual overages in a different account.  Select the Magnifying Glass to access the Zoom to select the “To Account”

  1. On the Reserve Account screen, the “overdrawn” Balance for all rows selected will be added together and defaulted into the New reserved amount field. This amount can be modified. Enter or zoom to select a GL account on which to place this reserve amount. If there is an existing reserve amount, it will be displayed.  After the reserve amount has been placed on an account, when the budget impact is next viewed, the Budgeted Amount and Current Balance will be reduced by the reserved amount.

NOTE: No actual budgeted amounts are modified. The Budget Reserve’s purpose is to create the illusion that the budgeted amount is lower for GL Account selected on the Reserve Account screen, to cover actual overages in the GL account(s).

 

 

 

 

  1. Select the desired GL code from the Zoom window by clicking Select

NOTE: the column on the right side of the screen, Reserve amt.   After a GL code has a reserve placed against it, the column will display that amount for the remainder of the current period.  If a GL code has multiple reserves placed against it , the Reserve amt field will display the sum of all reserves placed against it.

 

 

  1. The Reserve Account screen displays the Budget Reserve information. Any existing reserve for the GL account selected is displayed in the “Reserve amount” field.  The calculated “New reserve amt” may be edited by the user.
    To post the new reserve, select the Submit button.
     

 

  1. A confirmation box is displayed upon successful submission of the new Budget Reserve request.

 

Update Reserve amount from Budget Screen

  1. From the Main Menu, select Budget.

  1. Find the Period in the navigation list on the left.

  1. Click on the Budget amount detail tab on the right to display the detail rows.

  1. Click Edit on the specific Department/GL Account on which to place the reserve amount.

  1. Enter the Reserve amount.

  1. Click OK to save the detail row. Click Save to save the entire record.

Printing

To Print a Budget Report with Budget Reserve data, access the Budget Status report from the Main Menu

From the Report Parameter Screen select the appropriate columns and report parameter filters and click Run. Report results will be displayed.

Budget Setup and Maintenance

Period Maintenance

Period lengths are determined by and defined by Birch Street for the entire marketplace. They are usually the 12 months of the year but could be an annual period for large projects.

Budget Period Length Maintenance

Each property defines what are the Budget periods allowed in their property. This normally set up by the Birch Street integration team during original setup.

Company Application Setting

Each property (company) decides whether to use budgeting or not.

 

  1. Open the Company Application Setting Screen.

  1. Click on the Use budgeting checkbox to activate this feature.

  1. Type or zoom to select the Default period length code.

  1. Select what to display on the PO Print/View/Edit form from the Show budgeting codes on PO print/view dropdown list. The options are:

  1. Do not show GL Account

  1. Show only GL Account

  1. Show GL Account and Department Description

  1. Show GL Account and Department Code

  1. Show GL Account and GL Description only

  1. Show GL Account/Description and Department code

  1. Show GL Account/Description and Department code and Description

 

This is an example of Show GL Account/Description and Department code. The Product Description follows any budgeting information.

GL Accounts

GL Accounts are defined and attached to a Period length. GL Accounts are established by the marketplace administrator.

 

Note: Check the Approval required checkbox if this GL is required to go through approvals. Leave it unchecked for other approval criteria to take effect.

 

 

Budget (Manual entry/edit)

Update budget information in the entry screen if there are only one or two edits to make. To enter bulk entries, us the Budget Import/Export feature.

 

  1. From the Main Menu, select Budget.

  1. Find the Period in the navigation list on the left.

  1. Click on the Budget amount detail tab on the right to display the detail rows.

  1. Click Add Row to add a new Department/GL Account budget amount.

  1. Click OK to save the detail row. Click Save to save the entire record.

-- or --

  1. Click Edit on the specific Department/GL Account on which to edit.

  1. Modify the Department, GL account or Budget amount.

  1. Click OK to save the detail row. Click Save to save the entire record.

 

Note: The budgeted amount is only a guideline. The buyer can use more than the budgeted amount and use more than is budgeted. If the budget amount is zero but the Department/GL Account is defined, the account can be used.

 

Budget Import / Export

To facilitate bulk import of budget entries, use the budget import / export.

From the Main menu, go to

Administration > Declining Checkbook Maintenance > Budget Import Export.

 

  1. Click Export to retrieve the budgeting template.

Note: In order to fill in the proper information into the template, zoom to Period number, Department or GL accounts to view valid values to insert into the template. There is no entry on this screen. It is only used to export or import the template and to get valid values for the template.

 

  1. Click on the Open Existing Filter Selection dropdown box and select the *Budget Amount filter.

  1. Enter and filtering criteria below.

  1. Click GO.

 

 

  1. Save the template to the desktop, or somewhere where you will remember. Complete the standard procedures for saving a file.

 

 

  1. Open the template in Microsoft Excel for editing.

  1. Do not change the first three rows in the template in any way.

  1. Enter a valid value for the period number. Note: Only select periods found in the property’s period length as defined in Company Application Setting.

  1. Enter a valid value for the Department code. Prefix it with # (so that leading zeros are not lost).

  1. Enter a valid value for the GL account. Prefix it with #.

  1. Enter the Budget amount for the Department/GL account combination. The amount must be 0 or a positive amount.

 

  1. Click Import to open the Select Upload File window.

  1. Click Browse to select the completed Budget template.

  1. Click Submit to upload the file to the eProcurement system.

Note: All uploaded files are ready for use the next day after upload.