PBO BUDGET RECONCILIATION TEMPLATE
sssefwewfPBO BUDGET RECONCILIATION TEMPLATEDivision of Academic AffairsAcademic Resources and PlanningAdministration Building, 3rd Floor410-704-4480April 20151
Note: Budget Reconciliation Templates should be set up at the start of the fiscal year (July 1st) in order toprepare for monthly budget reconciliationsStep1.Open the Budget Reconciliation Template provided by PBO to begin setting up your budget for the newfiscal year (July 20XX- June 20XX) see image below 12
Step2.Rename this file to make it specific to your department budget (for example: Dept. 12220 FY2015). Besure to save this template in order to update monthly. *It may be best to save the DAT and DPR reports ina separate folder for each month see example image below3
Step3.Select the first tab on your Budget Reconciliation Template; entitled "Summary" see image below4
Step4.At the top of the “Summary” sheet, identify your department information in the headingsee images 4a. and 4b. below4a. (Department information heading)5
4b. (Department Budget heading completed)6
Step5.Run the DAT report for June 30, 2014 (The last month in the prior fiscal year)see image below7
Step6.Refer to your prior year DAT report (June 30, 2014) to update your FY 2014 expendituressee images 6a. and 6b. below6a. (DAT: FYD Expenditures for FY 2014)6b. (Select the “Operating Encumbrance” tab on your Budget Reconciliation Template. Update the FY 2014 Expenditurescolumn)8
Step7.Update the “Encumbered Amount” column with your projected operating encumbrances (including allequipment expenses) that you anticipate for the full fiscal year. Refer to your “FY 2014 Expenditures” asa tool to make an estimate see image below*Step 7 Note: The far right columns “Total” and “Encumbrance Balance” have prewritten formulas that will updatethe encumbrance balance on the summary sheet as you update your operating expenses each month. Be careful notto overwrite these formulas.9
Step8.Select the "Labor Distribution” tab on your Budget Template see image below10
Step9.Enter the name and salary amount of your anticipated contingent staff & student help see image below*Step 9 Note: (Formulas) Fringe benefit expenses will auto calculate once you enter the salary amount forcontractual employees. Be careful not to overwrite this column see image below11
Step10.Run your July DAT report (July 31, 2014) in order to load your current year Budget (FY2015)see image belowStep11.Select the “Budget Balance” tab on the DAT Report see image below12
Step12.Refer to the “Revised Budget” column on the DAT report to enter your Budget on the Summary sheet ofthe Budget Reconciliation Template see images 12a. and 12b. below12a. DAT: Revised Budget Column13
12b. Summary sheet: Enter Budget(Note: The shaded areas have prewritten formulas that will update as you enter your monthly activity.These fields are locked)14
Step13.Please see the “Reconciling PeopleSoft Reports” manual for instructions to reconcile your monthlyexpenditures15
Note: Budget Reconciliation Templates should be set up at the start of the fiscal year (July 1st) in order to prepare for monthly budget reconciliations Step1. Open the Budget Reconciliation Template provided by PBO to begin setting up your budget for the
budgets using the Excel template labeled “Project Budget Template” that is provided with the RFP. The Project Budget template consists of two parts: the Budget Summary (Tab 1 of the template), and the Budget Detail (Tabs 26 of the template). Start by completing the Budget - Detail by
Budget (Annual Budget) Revenues Expenses Multi-year (Actual; Budget; Budget) Project (program) Budget A project budget is the estimated financial plan for a project, for which funding is required. The total program budget is not just the grant r
files directly into the system to expedite the reconciliation process. Bank Reconciliation Interaction The following diagram illustrates the interaction between Bank Reconciliation and various modules. More information on module interaction can be found in "Concepts: How This Module Works" on page 3. Figure 1: Bank Reconciliation interaction
The Bank Reconciliation window will close, and a new entry will appear in the . Bank Reconciliations grid. If you would like to view the Bank Reconciliation report (the list of items cleared on this reconciliation), click Yes. Note You can Undothe reconciliation if a mistake has been made.
User Guide - Bank Reconciliation Manager Page 12 of 21 5. Bank Reconciliation This chapter describes how to use Bank Reconciliation Manager to reconcile the bank statement csv files with the transactions in Sage Accpac ERP. Automating the reconciliation process can save you a lot of time, especially, if you have a lot of transactions. (Please .
The amounts within your AR Aging Reconciliation will be verified to the AR Aging Report Submitted to Data Warehouse New AR Aging Reconciliation Template The New AR Aging Reconciliation Template along with some step by step instructions has been provided through the RACAR and AFR Listserv.
Account reconciliation tasks can be easily developed within Financial Close Management. This section will detail how account reconciliation tasks can be . reconciliation template can be attached directly to the account reconciliation as part of the task instructions. If revisions to the template are needed, the new
O U N D A T I O ANSF N Journal of . (Bassi and Sharma, 1993a; Bassi and Shar-ma, 1993b; Schat et al., 1997; Sharma and Dietz, 2006) tion of Proline under water stress indicate that the level and UV radiations, etc. Apart from acting as osmolyte for osmotic adjustment, proline contributes to stabilizing sub-cellular structures (e.g., membranes and proteins), scavenging free radicals and .
