SmartFusion Modules > Accounting > Fund Ledger/Budget Prep > Reports > Revenue and Expenditure Report

Recent Changes: 

6.212 - Fixed an issue, for capital project funds the Year to date column on the report did not include the current year amounts if a balance forward record existed for the account.

6.194 - Added fiscal year dropdown list for Month to Month checkbox if this is checked.Fixed issue for display grid option if Month to Month checkbox if this is checked.

6.188 - Handled "Track in BP" checkbox on filter, if checked the fund accounts will show on resulted data.

6.180 - Added a grid reporting option to the Fund Ledger report

6.165- Added a new check box for 'Month to Month' for the Revenue and Expenditure Report under the Fund Ledger module. If checked it will print a 'Revenue & Expenditure Statement by Month' report that will pull the actuals for the months in the calendar year. 

6.163- Modified the formula in the report for YTD column to include the balance forward amount for all account types if it is a capital project fund. Also modified the data pull to pull YTD amounts from start of fund date till current period end date for capital project funds if there is no balance forward record.

6.162 - Modified the formula for the '% Used' column to display '*100' if the Budget is 0 but the YTD column amount is non zero.

6.123 - Updated the way total encumbrances are calculated to include completed Purchase orders.  

Refer to bottom of page for changes prior to version 6.100

Introduction

Revenue and Expenditures report shows the current period amount, year to date totals budget, and percent used for each account. There are up to 4 sequencing options users may select to group data on the report. User may also choose to include encumbrances and prior year amounts (if run in fund ledger)

Report Selections

  • Report sequence - determines the sorting and grouping of the report (Sequence options available - ( 4 sorting levels allowed for both Revenue and Expenditure)
  • Group revenue and expenditure as last sequence - groups the revenues, expenditures, and other transactions after the other report sequences.
  • New page after sequence - Which sequence to include page breaks may be specified as well
  • Output options -Detail or Summary
  • Fiscal year start date
  • Range to include -Criteria or Dates
  • Include equity accounts
  • Print 'consolidated revenue & expenditure statement'
  • Print budget column first
  • Include encumbrances in yet amount - Only available in Fund Ledger
  • Print encumbrances in separate column - Only available in Fund Ledger
  • Apply encumbrances to budget percentages - Only available in Fund Ledger
  • Print account number
  • Print grand total
  • Include prior year amounts - Only available in Fund Ledger
  • Month to Month - Only available in Fund Ledger
  • Fiscal Year - Only available when Month to Month checkbox is checked.

Dev Notes

This report exists in both Budget Prep and Fund ledger; however, they do have separate vb.net files because there are minor differences to the reports. The crystal reports are shared though. There are two crystal reports - one for portrait and one for landscape.

  • Portrait - This report is used when 'Include prior year amounts' is not checked. There are two optional columns - Encumbrances (only available for FL) which will display if 'Print encumbrances in separate column' is checked and Remaining Balance which will display if 'Print budget column first' is checked.

  • Landscape(only available for FL) - This report is used when 'Include prior year amounts' is checked. Two additional columns will be include at the end of the report - 'Prior Year Period' and 'Prior Year YTD'. There are two optional columns - Encumbrances (only available for FL) which will display if 'Print encumbrances in separate column' is checked and Remaining Balance which will display if 'Print budget column first' is checked.

  • Month to Month(only available for FL) - This report is used when 'Month to Month' is checked. This prints a report of the actuals for each month from January to December for the Calendar year.

  • Fiscal Year(only available when Month to Month checked) - This report is used when 'Month to Month' is checked. This prints a report of the actuals for each month from January to December for the select fiscal year.

Changes Prior to Version 6.100

6.74 - Fixed issue where when going from one filter to another the previous filter's selections would stay selected.

6.63 - Fixed issues with the subtotals in the reports. Made them show deficiency instead of summing revenues and expenditures together.

6.48 - No longer proper case the descriptions of the accounts. They will be printed as they are entered.

6.36 - Added the option to group by revenue and expenditure last

6.33 
- Additional sequence has been added for Revenue and Expenditure
- Users now have the option for page breaks after each sequence
- Reports have been refactored and brought up to the style guide standards