|
Overview
Here are the system Custom Reports with a brief description.
Report Descriptions
| • | Account Inquiry by Date - The Account Inquiry By Date Report allows you to look at all transactions that go against the Sales Journal, Purchase Journal, Employee Reimbursables Journal, Receipt Journal (cash and accrual), Disbursement Journal(cash and accrual), General Journal for a particular Date Range. |
| • | Account Project Inquiry by Date - The Account Project Inquiry By Date Report allows you to search against all transactions that go against the Sales Journal, Purchase Journal, Employee Reimbursables Journal, Receipt Journal, Disbursement Journal, General Journal for a particular Date Range, Grouped by Project. The second level of detail groups on the Client, Employee or Vendor. |
| • | Accounting Timesheet – The Accounting Timesheet Report report reflects the most current version of the time sheet, reflecting any changes made in Timesheet Adjustments. The layout is similar to what you see in the Time Sheets applet for a specific Time Sheet Period End date. |
| • | Accounts Payable By Project - The Accounts Payable by Project Report gives you a list of unpaid vendor invoices grouped by Project. Additionally, you are given the ability to see all AP by selecting the "Include Closed Invoices" option. In that case it displays both paid and unpaid invoices (i.e. the entire history). This report uses the G/L period as the cutoff period so it is basically inception to date. |
| • | Aged WIP - The Aged WIP Report gives you an Aging list of transactions with a Bill Status of R (Ready to Bill) and H (Hold) that go against Billable (and optionally Opportunities) projects. This report displays five aging periods that are fixed. Additionally, you have the ability to "Drill-through" to the individual transactions. |
| • | Balance Sheet (Rolling 12 Month) - The Balance Sheet (Rolling 12 Month) Report is a statement of the companies financial position, which states the Assets, Liabilities and Owner's Equity (Capital) for a 12 month period (G/L Period). When you select a G/L Period, that period, and the prior 11 periods, are displayed on the report. Additionally, you are given the ability to see all "drill-down" into each account on the report. The blue hyperlink indicates where you can do this. |
| • | Balance Sheet with Drill down – The Balance Sheet with drill-down Report is a statement of the companies financial position, which states the Assets, Liabilities and Owner's Equity (Capital) at a particular point in time (G/L Period). Additionally, you are given the ability to see all "drill-down" into each account on the report. The blue hyperlink indicates where you can do this. |
| • | Bank Register By Date Report - The Bank Register by Date Report is a data sensitive report providing a running balance of a single bank account. There are four different report styles to choose from that sort and group by By Date, By Journal/Date, By Journal/Control Number, By Journal/Control Number/Date. You can optionally select which journals to include. |
| • | Benefit Accrual Status Report - The Benefit Accrual Status Report gives you the benefit amounts for the selected Benefit Project in the current Beneft Year. |
| • | Bill Review - The report must be enabled in Global Settings in the A/R tab to enable this feature. This report provides the necessary information for project managers to determine billing. |
| • | Bill Review Batch - The Bill Review Report provides the necessary information for project managers to determine billing.This report is the same as the Bill Review Report, but can be run in batches. |
| • | Billing Status - The Billing Status report allows you to search through all transactions that can have a billing status (Time Sheets, Purchase Journal, Employee Reimbursable Journal and the Disbursement Journal) for a specified date range. You are given the option to filter by Project, Journal and Billing Status. |
| • | Billings - The Billings Report gives you Hourly, Fixed Fee, ODC, OCC, ICC, Retainer, Retainage and Other revenue numbers for a specified Period Range. |
| • | Billings by State -The Billings by State report receipts broken down by Sales Revenue, grouped by State for a selected Period Range. |
| • | Budget Backlog Report - The Budget Backlog is a report that compares Budget Amounts (Labor,ODC,OCC & ICC) to Billed and Unbilled WIP (billing status of R or H). |
| • | Cash Requirements Report – This report allows you to run an outstanding Payables report, filtering by a Due Date range. |
| • | Change Orders - The Change Orders Report shows all Change Orders (approved/unapproved) that have been submitted against all projects (active/inactive) for a given date range. Note: Change Orders are Requested in Project Planning> Projects window. |
| • | Change Transaction Period Utility - The Change Transaction Period Utility is used to move a specific Journal Transaction from one G/L Period to another. You can optionally select a single version or move all versions to the new G/L Period. |
| • | Charge Organization Analysis – This report allows you to do an analysis of the charge org recorded in time sheets versus what the system currently would assign based on project setup rules. This report has an option so you can retroactively update time sheets. This report is useful if you set up the project rules after time sheets have already been entered. |
| • | Clients - The Firms report gives you a list of Firms with additional contact information. |
| • | Client Inquiry - This report displays both A/R and non-A/R transactions per Client. Options are available to display varying levels of detail such as project, WBS, invoice number and transaction detail. You can also run the report for open invoices only. If you do not supply a Client code it runs for all Clients. |
| • | Client Pay Performance – This report shows that average number of days it takes for a client to pay an invoice. You can set a minimum number of invoices required before a client appears on the report. |
| • | Consultant Tracking by Project then Vendor - Unlike the Pay When Paid report only consultant charges that have been linked to a Sales Journal entry are included. Also, only A/R invoices with links to consultant purchases are included. |
| • | Consultant Tracking by Vendor then Project - Unlike the Pay When Paid report only consultant charges that have been linked to a Sales Journal entry are included. Also, only A/R invoices with links to consultant purchases are included. |
| • | Contacts - The Contacts report gives you a list of Contacts with additional contact information. |
| • | Contract Backlog - The Contract Backlog is a report that compares Fixed Fee and Contract Amounts (Labor,ODC,OCC & ICC) to Billed and Unbilled WIP (billing status of R or H). It automatically filters based on project leader designation. Employees with the designation of Project Accountant can see all projects. |
| • | Disbursement Journal Single Transaction Report - The Disbursement Journal Single Transaction Report gives you the ability to sprint out a specific Disbursement Journal Entry for a specific Version. When in the Disbursement Journal applet, you can launch this report by simply clicking "Print" on the toolbar. The version showing is the one that will be displayed. Additionally, if "Show Audit Trail" is checked, you will see an audit trail of the changes made on that entry. |
| • | Disbursements by Date - The Disbursements By Date Report allows you to look at all transactions that go against the Disbursement Journal(cash and accrual) for a particular Date Range. |
| • | Employee Benefit Report - The Employee Benefit Report give an employee a detailed summary of their Benefit balances. You must be using the Benefit Accrual feature for this to populate with data. |
| • | Employee Inquiry - This report is sorted by employee and allows for inquiry of time and expense for a given date range. You can also set filters for an employee, project or labor code. |
| • | Employee Job Titles – The Employee Job Titles Report shows you the allowable Job Titles for your employees, including the Default Job Title. This report can be run for all active employees or one employee. Additionally, it points out Inactive Job Titles that are assigned to Employees. Group / Sort options include by Employee Name or Job Title Name. When run for a single project the report uses the project member tab overrides otherwise it uses employee setup information. |
| • | Employee Reimbursable Journal Single Transaction Report - The Employee Reimbursable Journal Single Transaction Report gives you the ability to sprint out a specific Employee Reimbursable Journal Entry for a specific Version. When in the Employee Reimbursable Journal applet, you can launch this report by simply clicking "Print" on the toolbar. The version showing is the one that will be displayed. Additionally, if "Show Audit Trail" is checked, you will see an audit trail of the changes made on that entry. |
| • | Employee Reimbursables by Date - The Employee Reimbursables By Date Report allows you to look at all transactions that go against the Employee Reimbursables (E/R) Journal for a particular Date Range. |
| • | Expense Check Stub - This report is designed to be run by the employee who receives a check. It will detail what expense sheet items are being paid on a given check. To make this available to all employees first give permissions to a group that includes all employees and then assign the report to appear in the Personal module. |
| • | Expense Code Listing – This report lists all the Expense Codes set up in the system. You are able to filter by Type, Status and by those only viewable in Expense Sheets. |
| • | Expense Group Assignment – This report lists the Expense Groups with all Projects that are using that Expense Group listed below. |
| • | Expense Group Detail – This report lists the expense group setup including expense codes and markups. |
| • | Expense Sheet Status Report - This report is designed to be run by the individual employee. It will give a status report on expense sheets for a given date range. Possible statuses are paid, processed (imported and approved by accounting but not yet paid), declined (rejected by accounting), mgr approved (approved by manager), submitted (by employee), and unsubmitted. To make this available to all employees first give permissions to a group that includes all employees and assign the report to appear in the Personal module. |
| • | Financial Statement Analysis Report - This report is used to Analyze the structure of Financial Statements built using the Financial Statement Designer. It displays three tables of information. The first table shows what accounts per statement line will be used. The second table shows what accounts are not referenced in the design. The third table shows what lines reference an account more than once. |
| • | Form 1099 Detail Backup - This custom report’s print options are identical to Form 1099’s load options. The report provides a detailed and summarized backup of the 1099’s. |
| • | General Journal by Date - The General Journal By Date Report allows you to look at all transactions that go against the General Journal (cash and accrual) for a particular Date Range. |
| • | General Journal Single Transaction Report - The General Journal Single Transaction Report gives you the ability to sprint out a specific General Journal Entry for a specific Version. When in the General Journal applet, you can launch this report by simply clicking "Print" on the toolbar. The version showing is the one that will be displayed. Additionally, if "Show Audit Trail" is checked, you will see an audit trail of the changes made on that entry. |
| • | General Ledger by Date - The General Ledger Report shows you the details of every transaction going in and out of your accounts using a Date Range as a filter. This report can help ensure that all your Accounts balance. |
| • | Home Organization Analysis – This report allows you to an analysis of the home org recorded in time sheets versus what the system currently would assign based on employee setup . This report has an option so you can retroactively update time sheets. This report is useful if you set up the employee org after time sheets have already been entered. |
| • | Income Statement with Budgets - The Income Statement is also called a Profit and Loss Statement (P&L). The purpose of the Income Statement is to show managers and investors whether the company made or lost money during the reported period. Income Statements represent a period of time, whereas the Balance Sheet represents a single moment in time. |
| • | Income Statement with Drill-Down – The Income Statement is also called a Profit and Loss Statement (P&L). The purpose of the Income Statement is to show managers and investors whether the company made or lost money during the reported period. Income Statements represent a period of time, whereas the Balance Sheet represents a single moment in time. Additionally, you are given the ability to see all "drill-down" into each account on the report. The blue hyperlink indicates where you can do this. |
| • | Inter company Transfers By Date - The Inter-company Transfers By Date report returns all Revenue from the Sales & General Journals posted against G/L Accounts with a Metric Type of either Inter-company Revenue or Inter-company Expense for a given date range. |
| • | Invoice For Retainage (Style 1) - The Invoice for Retainage is a way to invoice a client for retainage at the end of the project. You have the option create a posting entry against the Retainage account in the Sales Journal. Style 1 looks similar to the standard invoice designs that come "out of the box" with InFocus. |
| • | Invoice For Retainage (Style 2) - The Invoice for Retainage is a way to invoice a client for retainage at the end of the project. By running the report, a posting entry is created against the Retainage account in the Sales Journal. Style 2 looks similar to the Sales Journal Single Transaction report that come "out of the box" with InFocus. |
| • | Job Titles – The Job Title list report give you a list of Job Titles that live in the Job Titles Applet The report can be filtered by status and sorted by Job Code or Title. More on Job Titles |
| • | Labor By Location – The Labor by Location Report report reflects data the most current version of submitted Time Sheets. The primary purpose of this report is to Filter/ Group by Locations that can optionally be used. Locations are assigned to the Employee and are typically used to identify where the actual work was done, for insurance reasons. More on Locations |
| • | Labor Distribution Detail - This report shows the breakdown for labor distribution entries for a given G/L period range. You are able to specify up to five (5) sorting/grouping levels. |
| • | Labor Estimates - This report requires that you have Require Estimates-to-Complete turned on in Projects > General Tab. The report gives you the ETC hours the employee entered upon submitting their time sheet. |
| • | MC Consolidated Balance Sheet (FASB) - The MC Balance Sheet Report is a statement of the companies financial position, which states the Assets, Liabilities and Owner's Equity (Capital) for a specific period (G/L Period). |
| • | My Hours – This report is meant for access to be given all employees in the company. It allows the employee to list all their hours for any project date range they wish. |
| • | No Project Reference - Reports transactions with no project reference for a specified Time Frame, Journal Type(s), Metric(s). Additional filters include G/L Account, Org Unit and G/L Financial Type (Income and Expense or All). This report is useful when trying to tie out Project Profit to the Income Statement. Transactions that do not reference a project can cause variance. |
| • | Note Search - This report searches the text of marketing notes. |
| • | Opportunities - The Opportunities Report gives you a list of Projects that have a Charge Type of "Opportunity". |
| • | Pay History – This report shows employee pay history which can be useful when performing employee reviews. |
| • | Pay When Paid By Project – This report is similar to consultant tracking with a few notable exceptions besides format. Purchases not linked on a sales journal will appear on the report. There is an okay to pay columns. The okay to pay only applies to linked purchases and is based on monies received. In the case of partial payments, the receipts are prorated accordingly. This report also considers the new revenue type in cash receipts when computing consultant dollars received. |
| • | Pay When Paid By Receipt – This report operates off of a deposit date range. It requires that purchases be linked to Sales Journal and requires that breakdown receipt by revenue type is used. A unique feature of this report is it can create an A/P check batch based on the report's results. |
| • | Print a Check - The Print a Check Report allows you to Print a New Check or enter the previous check number and re-print a check. |
| • | Project Earnings by Org. Unit – The Project Earnings by Org. Unit report gives Current, Year To Date and Project To Date figures including Billed Revenue, Total Revenue, Spent, Profit, Profit Pct, Fee, Received, A/R, Un-billed and Effective Multiplier. The project summary report can be grouped by organizational unit. It also can filter based on a common org code at a given level. |
| • | Project Figures - Shows As of the Moment project metrics for a given project to all its WBS levels. It automatically filters based on project leader designation. Employees with a designation of Project Accountant can see all projects. By default, this report shows labor cost as zero. To show labor cost, make a copy of the report, then click Manage Parameters. Note the parameters and their details. Next, click on the wand ( ). When prompted that previous parameters will be cleared out, click Yes. All exposed parameters will be visible. Restore the details of the Project Path and My id parameters. Click Apply after each. Change the prompt type of the Show labor cost report (at either Pay Rate or Job Cost Rate, depending on the setting of the Calculate Labor Cost option (in the General Tab of Global Settings). |
| • | Project Metrics for Project Managers - This is a summary level (project level) report that will display most project metrics. It is using a new SQL view called ev_projectmetrics_nolaborcost to make querying simpler for summary type reports. This view contains no labor cost. |
| • | Project Revenue by Type Report - The Project Revenue by Type report sorts and groups revenue by Project Report Type or Market Sector. Many clients use either the report type or the market sector to identify the professional liability classification of a project. In this scenario you can run the report YTD to provide the necessary revenue breakdown. When you run the report you can either view billed or received. If you run the report using received the system uses the cash basis conversion to break down the receipts into its types of revenue (labor, ODC, OCC and ICC). When you run the report by market sector all metrics are factored by the market sector percentage entered on the project setup. |
| • | Project Scorecard - The Project Scorecard report gives you a comprehensive view of your project performance. It has drill-downs and charts to help dig into your data. |
| • | Purchases by Date - The Purchases By Date Report allows you to look at all transactions that go against the Purchase Journal for a particular Date Range. |
| • | Purchase Journal Single Transaction Report - The Purchase Journal Single Transaction Report gives you the ability to sprint out a specific Purchase Journal Entry for a specific Version. When in the Purchase Journal applet, you can launch this report by simply clicking "Print" on the toolbar. The version showing is the one that will be displayed. Additionally, if "Show Audit Trail" is checked, you will see an audit trail of the changes made on that entry. |
| • | Rate Schedule Assignment – The Rate Schedule Assignments report lists what rate schedules are assigned to what projects. |
| • | Rate Schedule Detail – The Rate Schedule Detail report lists the rate schedule setup including employees and job titles assigned and rates. |
| • | Receipts by Date - The Receipts By Date Report allows you to look at all transactions that go against the Receipt Journal (cash and accrual) for a particular Date Range. |
| • | Receipts by State - This report will show receipts for a given period of time by State as listed on the Project Address. |
| • | Receipt Journal Single Transaction Report - The Receipt Journal Single Transaction Report gives you the ability to sprint out a specific Receipt Journal Entry for a specific Version. When in the Receipt Journal applet, you can launch this report by simply clicking "Print" on the toolbar. The version showing is the one that will be displayed. Additionally, if "Show Audit Trail" is checked, you will see an audit trail of the changes made on that entry. |
| • | Revenue Analysis - The Revenue Analysis report returns revenue transaction in detail and summarized at the WBS level. It automatically filters based on project leader designation. Employees with the designation of Project Accountant can see all projects. |
| • | Sales by Date - The Sales By Date Report allows you to look at all transactions that go against the Sales Journal for a particular Date Range. |
| • | Sales Journal Single Transaction Report - The Sales Journal Single Transaction Report gives you the ability to sprint out a specific Sales Journal Entry for a specific Version. When in the Sales Journal applet, you can launch this report by simply clicking "Print" on the toolbar. The version showing is the one that will be displayed. Additionally, if "Show Audit Trail" is checked, you will see an audit trail of the changes made on that entry. |
| • | Sales Links - The Sales Links returns a list of all transactions that are linked to the Sales Journal entry. |
| • | Single Transaction Reports - All Journals have a Print option on the toolbar that prints the current transaction. These reports can print out any version of that transaction and can be printed in Audit Trail mode. |
| • | Standard Hours – This report lists employee hours and variance for a date range versus an inputted standard hours. This can be useful in determining who should get overtime. |
| • | Stored Procedure Code – This report shows the code that is contained in a stored procedure. Most reports and queries that ship with InFocus use stored procedures. This can be useful if you want to construct your own SQL queries that are based off an existing InFocus report or query. |
| • | Timesheet - This can linked to the Personal Time sheet applet and will render a physical time sheet that visually is comparable to the entry screen. This can be enabled by selecting the Custom Time sheet Report option in Global Settings in the Time & Expense tab. |
| • | Time Sheet Batch – Time Sheet Batch report is a copy of the Time sheet custom report that prints in personal time sheet. It has been modified to accept a date range and an employee and/or project filter. |
| • | Time Sheet with Overtime Types - The Time Sheet with Overtime Types report can be linked to the Personal Time sheet applet and will render a physical time sheet that visually is comparable to the entry screen. This can be enabled by selecting the Custom Time sheet Report option in Global Settings in the Time & Expense tab. This report supports using multiple Overtime Types created in Administration> Global Settings> Labels and assigned in Employees> Pay History Tab. |
| • | Time Sheet with Overtime Types Batch - The Time Sheet with Overtime Types report can be linked to the Personal Time sheet applet and will render a physical time sheet that visually is comparable to the entry screen. The report can accept a date range and an employee and/or project filter. This can be enabled by selecting the Custom Time sheet Report option in Global Settings in the Time & Expense tab. This report supports using multiple Overtime Types created in Administration> Global Settings> Labels and assigned in Employees> Pay History Tab. |
| • | Trial Balance with Drill Down - Displays account balances based on user driven criteria. Includes click in details for debits and credits. This report also includes End of Year Closing click in details. |
| • | Unbilled Summary by Org Unit - This report is useful for companies that want to make general ledger entries to capture WIP. The report has an option to post WIP to the general journal. You must have the PM Bill Review special permission Can Override Project leader to post to the general ledger. In order to perform the post you will also need to set up the posting accounts in the Revenue Recognition tab in Global Settings. When you choose to post a messages section will appear at the end of the report. The messages will display the journal entry number if successful otherwise it will display error messages. The auto-reverse feature in the general journal can be used to reset the values to zero in the next period. The report has standard PM Leader restrictions so can be safely used by project managers. |
| • | User Security Settings - User Security Settings allows you the see the User/Group security setup of individuals and/or Groups. |
| • | Vendor Inquiry Report - This report displays both A/P and non-A/P transactions per vendor. Options are available to display varying levels of detail such as project, WBS, invoice number and transaction detail. You can also run the report for open invoices only. If you do not supply a vendor code it runs for all vendors. |
| • | Unprocessed Expense Sheets – This report lists expense sheets line items that have not been either imported into the employee reimbursable journal or have not been declined. |
| • | WBS listing – This report lists the WBS structure for projects. |
| • | WBS Node Inquiry - This report returns work hours, cost, effort and revenue for a specified node of a project structure. For example, you can select Phase 001 and the report will return the data for all Phase 001's on all projects. It can be run for a date range or a G/L Period range. |
|