This report allows you to run a chart of accounts listing. The selection criteria allows you to select all or multiple funds, a specific project or all projects. You can also filter by account mask. For example, if you just want a listing of all accounts consisting of HUD account 4190, you can enter that number in the mask and the report returns all related GL account numbers. You can also select a range of account numbers. This report is used as a reference document to research GL account numbers (usually by fund). Note: This report is also accessible from the Setup Reports tab.
A report of balances in all General Ledger Accounts for a specific period/month. It displays the account, description, starting balance, debits and credits and the ending balance. You may select one or multiple funds, project, or account mask. There are three grouping levels to allow grouping by fund (if multiple funds are selected), FDS account, HUD account, line item, sub line items and/or report groups 1, 2 and 3, if used. Select the report period/month and year. You may also choose to show other report options, such as excluding accounts with zero detail and a sub-tab for selecting specific accounts. This report is usually run on a monthly basis by fund to review all account balances.
This report allows the same selection criteria as Trial Balance 1, but also includes a net change for the debits and credits, as well as YTD debits and credits. This report is usually run on a monthly basis by fund to review all account balances and to review how the housing authority is doing compared to last year at this time.
This report allows the same selection criteria as the other Trial Balances, but along with the account number and description, just displays the debit or credit balance of the accounts with lines for making adjustments to the right. This report is usually used by fee accountants to record adjustments they would like made to any accounts.
This report allows the same selection criteria as the other Trial Balances, but only displays the interfund receivable and payable accounts for each fund selected. This report is used for ensuring that the “due to” and due from” accounts for the funds selected are in balance. It is usually run on a monthly basis and when run for all funds, the balances should be a net effect of zero if interfunding has been setup correctly.
A listing of General Ledger accounts for a specified period of time (range – month and year) that displays activity (transactions) for all or multiple (range of) accounts. This report is used for viewing specific activity that make up an account balance in order to research. You may select activity that has been accepted (posted) or not accepted. You may choose to display extended detail and/or transactions included in the adjustment periods of 13 and 14 if desired.
The same as the Detailed General Ledger, but will print in portrait style instead of landscape style.
This report allows the same selection criteria as the other Detailed General Ledger report options and is used for viewing the detailed activity in the interfund accounts for receivables and payables, if interfunding has been setup and is being used. This report would be used to research out of balance situations between funds.
Report that can be used to view transactions that have been posted to General Ledger from other programs (subsidiary ledgers). You may select one or all funds, a specific project or account mask. You may select a range of accounts and/or a specific date range. From the journal selection list, you would select the name of the journal you want to report on. You also have sorting and column format choices available and may choose to display only accepted (posted) transactions and include subtotals. For example, if you wanted to view everything that posted to General Ledger from Section 8 from January 1st through today, you would select the S8 Journal and enter that date range. This report is used in balancing the subsidiary ledgers to the General Ledger.
This report is used as another method to produce customized financial reports from General Ledger. Each General Ledger account has a field that can be marked for “Special Code Report 1, 2, or 3”. If that field is checked, the General Ledger account will appear on this report. A reporting period can be selected for a specific month and year. There are sub-tabs for formatting the report and consolidation of funds.
This report allows you to view all the activity related to cash, including income and expenses for any one fund or multiple funds. This report can be run for any specific time period (month and year), so that you can see what your cash situation is for that time period all in one report. This report is used by management to monitor cash flow, usually on a weekly basis.
This report is similar to Trial Balances 1 and 2 but has many extra features and is similar to a pivot table report created in Excel. From the selection criteria, you may select one or multiple funds. You have three grouping levels and may choose to group by FDS account, Fund, HUD account, Line Item, Report Groups and Sub Line Item. You may select an account number range and/or date range. As with other reports, you may preview the report by clicking on the “sheet of paper” icon on the tool bar. The program will display your report in a view similar to Excel. On this preview screen, you are then also able to change some of your selection criteria options. By clicking on the “+” next to each grouping, you can expand the view to see what accounts are included in that group. You may also click on “drop-down” arrows for each area to re-select anything you desire to change. If you then, click once more on the “sheet of paper” icon, you have a printed view of the report that then allows you to edit the format of the report by clicking on any of the tool bar icons. This report can be used as a regular Trial Balance or to monitor FDS accounting or any other General Ledger activity.
These are not current forms as they are no longer used. You may still run the reports if you wish to gather the data.
The Computation of Payments in Lieu of Taxes is available in the system for you to produce. Select the reporting period (calendar month and calendar year). When you click 
, the system launches the PILOT Form Wizard. Enter your property tax information in Part III. Enter Part IV, if applicable, and enter the limitation based on Annual Contribution. Enter whether or not the payment is based on Rent Charged or Rent collected. Click START. On step two, select the projects that apply. Click NEXT, and then click FINISH after you have confirmed the information entered is correct.
This report allows you to run a chart of accounts listing. The selection criteria allows you to select all or multiple funds, a specific project or all projects. You can also filter by account mask. For example, if you just want a listing of all accounts consisting of HUD account 4190, you can enter that number in the mask and the report returns all related GL account numbers. You can also select a range of account numbers. This report is used as a reference document to research GL account numbers (usually by fund). Note: This report is also accessible from the General Reports tab.
This report provides you with a listing of accounts grouped by account type. Account type is a field on the GL Account screen where you can indicate what type of account it is (cash, prepaid expenses, revenue from tenants, etc.). You may select all, one or multiple funds, a specific project or all projects, account mask, and/or account number range. This report is most commonly used to verify that all GL accounts have been assigned to the correct account type.
This report provides the same selection criteria as the Listing by Account Type, but refers to the HUD account type to which your GL account number has been assigned. This report is most commonly used to verify that all GL accounts have been assigned to the correct HUD account type.
This report provides the same selection criteria as the Listing by Account Type, but refers to the FDS line number to which your GL account number has been assigned. This report is most commonly used to verify that all GL accounts have been assigned to the correct FDS account code.
This report provides the same selection criteria as the Listing by Account Type, but refers to the field, Report Group 1, 2, or 3. If you are using these codes, this report will provide a listing of GL accounts that have been assigned to those Report Group numbers.
Note: Your agency must be using the WinTen² Budget program for any data to be returned on these reports.
This report provides for selection of just one fund, multiple funds or all funds. You may also select a specific project or account mask, as well as three grouping levels where you can choose from FDS account, Fund, HUD account, line item, sub line item and report groups. Select a reporting period (calendar month and year). You may choose to include expanded detail and exclude accounts with zero balances. You may also click on the sub-tab and select individual accounts for your report. This report is used for comparing the actual balances to what has been budgeted for the period of time selected.
This report provides for the same selection criteria as the Budget Comparison Report, but also displays the annual budget amount and the variance from what has been budgeted for each account. This report is used by management to monitor the budget progress for the year.
This report has the same selection criteria are available to you as in the Budget Comparison Report, but also compares the current month and the YTD figures to the budget. There is a column for the variance, so that you can see if the actual is better or worse than what has been budgeted. This report is used by management to monitor the budget progress for the current period and also the current year.
These reports are created using the Financial Report Writer and allow you to somewhat customize your own Financial Reports to provide to management and your Board of Directors. Balance Sheet and Income Statements are just two examples of the reports that can be created using this feature of the software.
Copyright © Tenmast Software 2010