SocrateCloud offers a number of predefined reports that can be used to display project information. The reports can be found in the Project Management menu and can be edited in order to comply with the organization's requirements. Details in Reporting.
Control report useful when, for existing products, expense reports need to be registered. The report returns the expense reports issued to projects and related information, registered within a specific period. Report parameters: Accounting Schema, period, Business Partner, Product.
Report Columns:
Business Partner = business partner on the project
Project = Project Name
Project Phase = name of the project phase;
Product = product used on the associated product phase line
Planned Qty, Planned Price, Planne Amt, Planned Margin = values taken from the associate project/phase line;
Movement Qty = total quantity issued to project;
Cost Amount = total amount issued to project;
Total Expense Qty = total quantity issued to project, on expense reports;
Movement Qty excluding period, Movement Qty Cost excluding period = total quantity and amount issued to project until the selected period (excluding);
Movement Qty period, Movement Cost period = total quantity and amount issued to project for the selected period;
Expense Qty period, Expense Amount Period = total quantity and amount issued to project and on expense reports for the selected month;
Total Qty = Movement Qty - Total Expense Amount - represents the quantity issued not registered on expense reports;
Total Cost Amount = Cost Amount - Expens Qty period - cost amount for the quantity issued to project and not registered on expense reports;
The report displays the amount invoiced and paid related to a project. The report is detailed by product and business partner, responsible providing the respective services, when the a "Service" type product is used.
The report is specifically designed for companies which use projects to register services. Report requirements:
projects are detailed at phase level (usually a phase for each month, according to the selected period);
the projects are invoiced based on hours issued to the project and project phases:
Project Type = Job (Work Order)
Invoicing Rule = Time & Material;
Invoicing Schedule = mandatory - indicates the invoicing periods;
the hours issued to project are registered through expense reports;
the expense report should be entered by each employee
an expense report should be entered for each period, and on expense report lines, all the corresponding projects should be included;
the expense reports are issued to the project using the Issue to Project - Expense process
the orders (and associated invoices and shipments) are generated based on project phases;
on a project, for a phase a single order/invoice is generated for all the included services, for the respective period
the order/invoice lines are grouped by product, depending on the expenses issued to project;
the receipts are registered and allocated to invoices;
The report displays the invoiced amounts and groups the receipt amounts by project, phase, invoice, product and employee.
The Project Realization - Info report can be used to display the usage percentage for services contracted using project lines. An example is a service/SLA contract with an included number of incidents/hours. The report displays the the percentage used and the initial contracted amounts.
The Project Realization - Product Categories report displays the percentage used and initial amounts grouped by product category.
The Project Line Detail report displays, depending on the selected filters, project lines and their corresponding product, amount and margin.
The Project POs not Issued report display project lines for which no purchase order is issued.
The Project Margin (Work Order) displays, for a project's lines, the ratio between planned amount and costs issued. Report parameters:
Project - project displayed on the report;
Accounting Schema - accounting schema used for cost determination
The Info Projects window displays all the projects within the system and their associated requests and documents (invoice, orders) for all project levels: project, phase, subphase.
Project Print Format - a project can be printed as a document, with the master using the values from the Product window and the details using the values from the Project line or Phase line tabs, depending on the project type.
Project/Employee Issue Report - presents detailed labor costs per project per employee and project structure. Employee costs are measured at TCA (total employee cost) or standard cost. The information is taken directly from the timekeeping.