Monthly Financial Report sample

Monthly Financial Report Description and Instructions Provided below is a description and instructions related to the following Monthly Financial Reports: Option 1.. The cells or columns in both of the Sample Reports are filled in with the following colors to determine if they are: 1) pre-filled automatically from another schedule 2) calculated automatically using data from other columns or cells within the spreadsheet 3) generally are filled in once per year, potentially with periodic updates or modifications or 4) require monthly data entry from a source outside the report.. Schedule 6: Expenditures - Department Detail Schedule 6 provides the expenditure, budget and projected expenditure amounts for each department for the following line-item categories: Personal Services Salaries Personal Services Overtime Personal Services Other Sub-Total Personal Services Purchased Professional Services Purchased Property Services Purchased Other Services Supplies Other Objects TOTAL The amounts for all of the columns in Schedule 6 involve data that will need to be entered, with the exception of the Projected at Year End and Variance Over/(Under) columns, which are calculated by Excel.. Projected 2 Months for Personal Services Salaries (100, 101): The projected amount for salaries for the last two months of the year in the Sample Report involves a calculation in the spreadsheet that multiplies the Bi-Weekly or Weekly Payroll located below the TOTAL line for each department by the number of pay periods remaining in the fiscal year (which is fed automatically from Schedule 1: Report Summary).. In regard to the 60 day entries and adjustments included under the Prior Year Taxes column in Appendix 1, these are accounted for (or netted-out ) in the Projected 2 Months column in Schedule 5 by subtracting the amount collected through