Custom Reports
All custom reports are developed by our team using Microsoft SQL Server Management Studio and seamlessly transferred to your Vista database upon completion.
Payroll
This report prints total Federal Tax, EIC, Social Security, and Medicare amounts in separate columns for each date wages are paid. The Social Security and Medicare amounts include both employee withholdings (deductions) and employer-paid amounts (liabilities). Medicare amounts include withholdings for the Additional Medicare Tax, which became effective January 1, 2013. Beginning and Ending Paid Date inputs may be used to limit the amount of information returned. It is recommended that users set up default deduction and liability codes for the parameters in the Report Titles program. To do this, enter each respective deduction or liability code in the"Parameter Default" column of the grid.
This report is similar to the PR Employee Earnings Comparison, however it only lists the total deductibles taken per employees. Deductible include federal withholding, income taxes, FICA - Social Security, FICA – Medicare, PTO, 401K, Medical Insurance,etc. etc.
This report compares earnings, hours, deductions, and net pay by employee between one payroll period against another. It’s helpful for those who wants to rely on these sets of data to make decisions/operation direction.
This report includes all employee’s leave code (ex. PTO, Sick Pay, COVID-19 Leave)with the total accumulation and available balance for each employee through a certain date inputted.
The Payroll Timecard Entry report prints one line per posted time cards and provides the option of sorting by the employee’s name (alphabetically by last name), employee’s number, job number, or crew number.
This report uses company pay information and fits a #9 envelope. It also includes MICR encoded line at the bottom (which requires the MICR font to be installed on any client that will print checks).
The PR Check Print Stub prints the actual borders and headings along with the earning and deduction information on Coaxis check forms with a blank stub. Because this check format is not bound to the pre-formatted check stubs, users have more flexibility in modifying the report.
This report displays a list of 21 potential problems (aka exceptions)that occur during a payroll audit. It’s important to clear exceptions because this can lead to many issues down the line, including an employee going unpaid and even inaccurate wages paid out to them. There are 2 levels of exception:
Warnings: Draw attention to something unusual
Errors: Shows something that has gone wrong and must be corrected.
Statement of an employee’s wages with the ability to sort by PR Company, PR Group, and Job. Report includes JC Co, Job,Craft, Class, Rate, Earn Code, Fringe Rate, and Number of Employees.
Finance
The Finance Team regularly generates avariety of custom reports, both for internal use and for our clients. We have the capability to tailor these reports to display the specific data required, particularly in areas such as Job Costing and Work in Progress.
Timecard hours grouped by SM Work Order and Service Site over a date range. Report includes Date, Technician, Class, SM Pay Type, Hours, Description of Work, and Status.
The SM Work Order List Report shows SM Work Orders together with their Purchase Orders and Billings. Check the flag for the Scope details in order to have these also displayed on the report. Report includes Customer, Work Order, Description,Estimated Hours, Actual Hours, Remaining Hours, Billed, Paid, Balance, Billed Hours, To Bill, Technician, Scope, and Scope Description.
This report gives users the ability to see the cost and revenue details for a range of work orders down to the Work Completed line. Users can sort the data into,at most, three different hierarchical levels, with the first level always being required. If the levels chosen does not include Work Order AND the show Work Completed lines check box IS checked, the report will automatically turn on Work Order as a hierarchy level as Work Completed lines do not make sense without showing the related Work Order.
Timecard hours grouped by SM Technician. You also have the ability to sort by a specific SM Work Order, Customer, or Service Site. This report includes Technician,Customer, Service Site, Date, SM Pay Type, Hours, Description of Work, and Status.
This invoice report is used to produce invoices for work that has been completed and billed in the Service Management module. This report is intended to be run from the SM Invoice Review and Printing program.
The earnings recap summarizes hours and earnings for each sort. This report prints one line per posted timecard and provides the option of sorting by Employee’s:
Last Name
Number
ob: When sorting by job, all timecards with a job number will be included under the job, even if the timecard will not be charged to the job.
Crew
Check Sort
This report lists out the Tech Package items along with the amount of users, price, and total amount for the specified company or companies. You are given the choice of showing employees or not.
This report is a more thorough and detailed report than the canned report that Vista provides. The Project Management Contract is sorted by all of the company’s contract number with an overview of the project’s health. If the user clicks on the contract number on the report, it breaks down the information further, including general contract detail, accounts receivable summary, accounts payable, and cost involved (including labor, material,subcontractor, equipment, burden, and misc.).
This report displays projected contract margins for a provided star tand end contract date. The details include projected revenue, cost, profit and margins displayed on a graph with dynamic data points that display margin information on mouse hover.
This report prints an invoice that includes the Contract Item and Description, Current Contract Amount, Percent Complete and Total to Date for the Contract and Item. Users also have the option to print contract notes, setup in the JB Contract Info form, which display under the contract number and description.
This report prints a Summary of the Invoice including change order summary information and then prints the Contract Items on the billing. Report includes Item Number, Description of Work, Scheduled Value, Work Completed(From Previous Application) (This Period in Place), Materials Presently Stored,Total Completed and Stored To Date, %, Balance to Finish, and Retainage.
This drill down will only show Batch ID's that were either created by or posted by the user running the report. The data on the drill down will also only show Batch ID's that have had their batch reports automatically added to HQBC when the 'Attach Batch Reports to HQ Batch Control' checkbox is checked in the corresponding Company Parameters module.
This report is a more simplified version of the GL Income Statement CM & YTD report. It’s simplified because it only shows the grand totals of Revenue, Direct Costs, Gross Profit After Direct Costs, Indirect Expenses, Gross Profit, General and Administrative, Net Income from Operations, Other Income/ (Expense), and Net Income (Loss).
Report compares Monthly Account net activity to a specific Budget Code based on Accounts and Months entered.
This report displays a standard Income Statement. It runs accounts under the company specified on the parameter screen and will display activity from the "Beginning Month" parameter through the "Ending Month" parameter. (If "Beginning Month" is left blank, the beginning of the fiscal year will be used.)
The report can be further narrowed by the optional Part 2 and Part 3parameters. These parameters will accept a comma-separated list of values (no spaces). Look ups are available for these parameters, but the look ups do not support multiple values.
This report requires Major categories to be properly set up on the GL Account Part 1. Specifically, each Income or Expense account that should show on this report should be assigned to a Major Category that has the Income Statement Order filled in with a value that reflects the order in which that Major Category should appear on the Income Statement. Minor Categories are available for further grouping but are not required.
This report breaks out Revenue, Direct Costs, Indirect Expenses,General and Administrative Expenses, and Other Income / (Expense). This report will exclude any Memo or Header type account.
This report displays a standard Income Statement. It runs for accounts under the company specified on the parameter screen, and will display activity from the "Beginning Month"parameter through the "Ending Month" parameter. (If "Beginning Month" is left blank, the beginning of the fiscal year will be used.)
Statement of financial position shown in a graph for a range of months. Report includes:
Current Assets - Assets
Property Plant and Equipment-Assets
Current Liabilities -Liabilities and Equity
Long Term Debt and Liabilities- Liabilities and Equity
Equity - Liabilities and Equity
This report displays a standard Balance Sheet. It runs for accounts under the company specified on the parameter screen and will display activity from the beginning of the fiscal year through the "Through Month"parameter.
This report requires Major categories to be properly set up on the GLAccount Part 1. Specifically, each account that should be shown on this report should be assigned to a Major Category that has the Balance Sheet Order filled in with a value that reflects the order in which that Major Category should appear on the Balance Sheet. Minor Categories are available for further grouping but are not required.
The Current Year Retained Earnings section is an accumulation of the accounts that appear on the Income Statement. Specifically, it is those accounts that have a Major Category with Income Statement Order filled in.
This report will exclude any Memo or Header type account. The report also rounds amount to the nearest whole dollar. Because of this, discrepancies may appear between the amounts displayed and their calculated totals.
A listing of sales tax invoices and the corresponding sales tax from receipts.
This is an intentionally simplified report that lists the invoice, date, customer, description, and amount. The report, which may be run for a range invoices or dates, can also be used to identify the customer from a cash receipt referencing an invoice when the name on the check does not match a customer from AR Customers. The invoice amount includes any applied credit memos, write-offs, and adjustments. Because the purpose of this report is to provide a way to reconcile printed invoices to the original invoice, the amounts are not reduced by released retainage.
This report prints a basic invoice with the company logo added.
The AR Aging is an aging of customer transactions. Although the report is normally run to print one line per open invoice (Level of Detail parameter = (I)nvoice), applied transactions (i.e. payments, credit memos, etc.) may be printed in the same aging columns as the invoice when selecting (T)ransaction level of detail. On account payments are aged according to the payment transaction date. The report can also be summarized one line per customer. An Input is available to enter specific receivable types; for example,if only 1 and 2 are required, the entry would be "1,2." If all are desired, leave the parameter blank The report also allows subtracting discounts offered from the current balance when the aging date is less than the invoice's discount date. A parameter is also available to override the standard 30 days between columns. Notes are printed from the Invoice header for the Invoice transaction if the Notes parameter is set to Y.
The AR Aged Analysis by Customer/Contract shows a total of all customers owe to the company since the payment transaction date. It sorts the invoice balances into columns as:
Current
1 -30 days past due
31 to 60 days past due
61 to 90 days past due
Over 90 days past due
The AP Vendor Totals report lists one line for each vendor called at runtime and prints the Vendor Number, Name, Invoice Amount, Paid Amount, Discount Offered, and Discount Taken. Includes parameter for Begin and End Payment Date and Comp Code.
Sorted by Vendor, Paid Month, CM Company,CM Account, and CM Reference, this report prints check, EFT, credit service, or Nvoicepay payment information in bold, and then lists each transaction paid by that payment.
The report list compliance codes for a range of vendors. With an option to include compliance codes that are not flagged as 'All Invoices' in HQ Compliance Codes.
List of accounts payable transactions for a specified month. This report sorts by General Ledger account so that you can see exactly what transactions were posted for the month and account in GL. This report will not correctly reflect sales tax that is directed to another cost type/GL account.
This report is designed to be remittance advice for the vendor and is intended for use with open payment batches. The report prints a new page per payment sequence, and includes the following report parameters: Company, Month, BatchId, Effective Date, and Print All Remittance Reports.
This report lists all the payables due the dates (MM/DD/YYYY). It totals up by vendor, with the current balance due, discounts to be taken, net balance due, and then a grand total of the cash required to pay everything listed.
Users can choose whether to include unapproved payables and whether open payables should be included based on their due dates or their discount dates.Transactions on hold and transactions due later than the report date specified will not be included.
Equipment
This report shows a list of both purchased and disposed equipment with when the equipment was purchased and when it was sold (and for how much to recognize if it’s a gain or a loss).
This report shows all equipment that the company has (including purchased and disposed).
This report shows the amount the equipment is depreciated by month to date, year to date, and accumulated prior year depreciation taken. It also shows the depreciation method taken and depending on which type of depreciation is taken, shows the number of months to depreciate, factors of decline, and depreciation expense account print with each asset. The report will include assets that have not been disposed of and assets that were disposed of in the fiscal year.
Sorted by their asset account order, this report lists the equipment’s purchase price, and optionally the month it was disposed.