Use Reports to review information in your database in predefined formats. The list of reports is a comprehensive collection of reports, useful for analyzing business performance and making decisions, formatted to make interpreting the information fast and efficient. They are organized by areas of interest, including Projects, Financials, and Administration reports.
Complementing the reports is a common user interface, called Report Options, which allows you to select, sort, and filter what and how much information you want to display on each report. You decide how you want to view the reports: on screen, hard copy (printed), or exported to files.
The ability to customize standard reports – or to add completely new reports – to meet even the most specific reporting needs is available within the common user interface. The software provides the development tools you need to produce useful, project and financial reports using Microsoft® SQL Server® Reporting Services (SSRS).
System-wide functionality is available in the Report Actions pane on the right side of the screen to allow different actions to be taken to preview, print, and export the results. Once the report is opened, different options may be selected to report on data differently.
Report Options allow you to enter the selection criteria to filter the data of your request. The Report Options UI is a “front end” that allows you to select the filters for each report. Selection criteria for filters vary by report and include options such as specific dates (due date, transaction date, discount date, document date, posted date, aging date), date ranges, status, customers, vendors, resources, projects, project managers, customer/vendor class, account dimensions, fiscal period/year, and more.
You may choose to display data in summary or detail format, hide or display zero balance records, and choose which document types to include on a report. The selection criteria to filter data allows information to be viewed easily from multiple perspectives.
When available, click the Show Advanced button to add additional selection criteria to the report filters for fields not automatically displayed in the Report Options screen. Click the Hide Advanced button to close the additional selection criteria filter window.
Click the View Report button to view the report results based on the selection criteria entered. The report output will display on the screen and can be paged through to preview the results. Upon approval of the report contents, use the options icons on the toolbar to print, export or archive the report as desired.
In the Report Actions pane, you can select different actions for the report, some before and some after the report is run.
The first box under Report Actions contains the name of the report. A short description of the purpose of the report is displayed below the name.
These are descriptions of the available report actions:
Run this Report runs the report using the latest criteria defined on the Report Options form.
Change the Options for this Report displays the Report Options screen again, so you can change the criteria the report should use to retrieve data. When satisfied with the criteria selection, click View Report to display the information matching the report options criteria.
Add this report to my Favorites menu saves the report, as it is currently defined, as a Favorite report under the Favorites dropdown on the main toolbar.
After you run a report, and when you are satisfied that the report contains the data you are looking for, you can select Export this report to a file. You will be prompted to select the location where the file will be saved as well as the name you want to assign to the file.
Save this report output to the archive places the contents of the report, the data file, in the archive folder for future reference. This saves the static report in electronic format for future reference.
Print this report sends the report output to a selected printer, file, fax, etc. Standard Windows print functionality is used to print the report.
Send this report to other users allows you to send a report output file to another user. The user can open the report from their My Task option or by selecting Reports | View an Archive Report from the main toolbar.
Create a new report from a copy of this one allows you to create custom reports using an existing report as the starting point. Microsoft SQL Server Data Tools must be installed on your workstation to modify SSRS. A message will appear if the Microsoft SQL Server Data Tools are not installed on your workstation.
The following is a list with descriptions of most reports included in the System. Project and Financial report names are linked to individual topics for more information.
1099-MISC – For printing 1099-MISC forms.
1099-NEC – For printing 1099-NEC forms.
Account Group List – Listing of Accounts, Departments, Territories, and Product Lines created in Chart of Accounts.
Accounts Payable Aged Invoices – List of all open invoices that contains their respective aging balance information.
AR Aging – List of all open invoices in Receivables.
Bank Account Reconciliation – Includes the bank account balance together with transactions since the last reconciliation date.
Budgets – Budget and/or Actual balances by Period either by Account (Summary) or Account Group (Detail).
Cash Requirements Report – Expected weekly cash disbursements based on existing Vendor Invoice due dates.
Check - ACH Payment Register – Accounts Payable check and ACH payments register.
Check - ACH Payment Register Detail – Accounts Payable check and ACH payments register with invoice details.
Company List – List of Company information from Company.
Customer Activity Report – Invoice, Adjustment, and Payment amounts by Customer for the date range that is specified.
Customer Invoice With Logo – Invoices with your company logo on them. You must add the logo to the report definition before you print the invoices. Does not support projects.
Customer Invoice Without Logo – Invoices without a company logo on them. Does not support projects.
Customer List – List of Customer information for Companies and People created in Customer.
Customer Statement – Prints all customer statements that meet the criteria that is specified in Report Options if the customer is flagged to receive statements in Customer. You can add your company logo to the report definition, if you want your logo to appear on the statement.
Customer Time Analysis – Displays a breakout of customer labor based on project and labor category. The breakout includes date, employee, billable hours, description, billable rate and billable amount.
Deluxe DLM145 AP Check Format – Deluxe multipurpose check format DLM145-stub-check-stub format with Name and check number preprinted in the header of both stubs.
Deluxe DLM205 AP Check Format – Deluxe multipurpose check format DLM205-stub-check-stub format with Name and check number preprinted in the header of both stubs.
Deluxe DLM279 AP Check Format – Deluxe multipurpose check format DLM279-stub-check-stub format with Name and check number preprinted in the header of both stubs.
Deluxe DLT104 AP Check Format – Deluxe multipurpose check format DLT104-stub-check-stub format with Name and check number preprinted in the header of both stubs.
Deposit Report – List of deposits.
Employee Summary Report – Approved and/or unapproved hours entered via the Project Timesheet by project.
Employee Timesheet Report – Approved and/or unapproved hours entered via the Project Timesheet by date.
Expected Cash Report – Expected weekly cash receipts based on existing Customer Invoice due dates.
Expense Report – Report that includes expenses submitted by team members.
Financials15Column – Report used when you run Financial Reports with the YTD by Period Column format.
Financials6Column – Report used when you run Financial Reports with a Column Format that contains 6 or fewer numeric columns.
Financials8Column – Report used when you run Financial Reports with a Column Format that contains 7 or 8 columns.
GL Trial Balance – Prints the General Ledger Trial Balance.
Invoices Report – Contains detailed invoices.
Job Billings Report – Displays Revenue, Expense, and Total invoiced/billed amounts for the current calendar year based on the As of Date. Also includes YTD Actual, Budget, and Variance amounts.
Job Recap Report – Displays Revenue, Expense, and Total billable amounts for the current calendar year based on the As of Date. Also includes YTD Actual, Budget, and Variance amounts.
Journals – Contains journals.
Labor Realization – Analysis of Actual versus Goal hourly billing rates realized by project by person.
Missing Timesheets – List of missing timesheets as of a specified timesheet date.
Person List – List of information about each person created in Person.
Profit and Loss Statement – Month to Date and Project to Date actual Project Profit and Loss compared to the Revised Budget.
Project Availability – Shows availability of project.
Project Billing Worksheet – Displays all billable transactions as of the date specified, together with a summary of previously billed amounts and budgets.
Project Budget Variance Report – Comparison of Project to Date Actual Hours and Amounts as of the period specified versus the Original and Revised Budget Amounts.
Project Customer Rate Breakout Report – Displays a breakout of customer labor based on project and labor category. The breakout includes date, employee, hours, description, rate and amount.
Project Invoice Detail With Balance – Standard project invoice format displaying full detail with AR payment and balance information.
Project Invoice Email Log Report – Email log report for project invoices.
Project Invoice With Tasks – Standard project invoice formation with task breakdown within Billing Type sections. Company name appears on the invoice. Does not support company logos.
Project Invoice With Tasks With Logo – Standard project invoice formation with task breakdown within Billing Type sections. Company name appears on the invoice. Logo from Internal Company.
Project Invoice Without Tasks – Standard project invoice format with task breakdown within Billing Type sections. Does not support logos.
Project Invoice Without Tasks With Logo – Standard project invoice format with task breakdown within Billing Type sections. Supports logos.
Project List – List of project information from Project.
Project PO Report – Comparison of Project PO and invoiced amounts to determine remaining amount on PO.
Project Profit Analysis – Summary of Month to Date, Year to Date, and Project to Date actual profitability at the project level as of the period specified. Also contains budget information, unbilled and AR balances and realized overall labor rates.
Project Profit Summary – Summary of Month to Date, Year to Date, and Project to Date – Budget, Hours, and Actual Profitability at the project level as of the period specified.
Project Resource Breakout Report – Displays an employee breakout by labor category/rate description by employee by project manager.
Project Resource Hours Report – Displays employee work hours compared to billable hours and billed amount.
Project Resource Utilization-Realization – Displays employee available hours, work hours, utilization %, billable hours, non-billable hours, billed hours, realization %, unbilled hours and billable amount.
Project/Resource Scheduling Detail – Details of scheduled project resource.
Project Status – Displays Budget to Actual for Revenue and Expense amounts - including Remaining amounts. Also includes Billed and Unbilled to-date amounts.
Project Time – Displays approved and/or unapproved hours submitted by using Project Timesheet.
Project Timesheet – Timesheet that include project-related transactions.
Project Transaction Report – Detail of all transactions posted to projects. Included Units, Cost, Billable, and Write-off amounts for each transaction.
Project Transactions With Billings – Detail of all transactions posted to projects. Included Units, Cost, Billable, Write-off, Billed, and Unbilled amounts for each transaction.
Project Transactions Summary – Month to Date and Project to Date Hours, Billable, Write-off, Cost, and Margin amounts summarized by Resource/Vendor as of the period specified.
Project Unbilled Aging – Detail for all unbilled transactions as of the period specified. Unbilled amounts are aged based on their transaction date versus the Aging Date specified for the report.
Resource Availability – Availability of a resource for projects.
Staff Utilization – Month to Date and Year to Date summary of time charged by employees by Utilization Category based on the period specified.
Staff Utilization by Periods – Summary of time charged by employees by Utilization Category based on the Periods specified.
Team Member List – List of Team Member and (optionally) Resource information created in Person and in Resource.
Vendor Activity Report – Invoice, Adjustment, and Payment amounts by Vendor for the date range that is specified.
Vendor List – List of Vendor information for Companies and Contacts created in Vendor.
Weekly Time Summary – Displays the total number of timesheet hours for employees based on the week end date entered.