Record project revenue (Integrated with Sales, Timesheets, Accounting)¶

Requirements

This tutorial requires the installation of the following modules/applications:

The integration of the Project app with other apps of Viindoo software such as Sales, Purchases, Timesheets, Accounting, etc. helps businesses synchronize and aggregate data for tasks management, information traceability, recording revenue, costs for project implementation, etc.

This article talks about the integration above to record project revenue generated from:

Supply products and services from a sales order.
Calculate revenue by work hours of employees when performing tasks.
Other revenue could be issued on invoices to customers.

Activate the Profitability feature¶

Navigate to Project ‣ Configuration ‣ Settings, move on to the Analytics range and activate the profitability feature.

After enabled, the Analytic Account feature is enabled automatically, so you can use analytic account to analyze the revenue and costs for your projects.

Link analytic account on sale order¶

Create a new project, the system will automatically generate an analytic account.

On a sales order, you can assign the analytic account of the project that you want to collect revenue data. The revenue from invoices created from these sales orders will be recorded on the chosen analytic account.

Navigate to Sales ‣ Quotations, create a new quotation. In the Other Info tab, select the analytic account created above.

Select analytic account and project on a quotation

Note

In case, the sales orders of the products with the service type and at the Create on Order field of the product form is set Project & Task or Project, you will see the Project field on the sales order.

Accounting¶

With invoices created from sales orders which already have an analytic account attached to them, the system will update the information on the invoices automatically to track the revenue/cost of a task.
Note
- Based on the invoice policy, you can issue invoices based on the timing of the provided service or based on the project milestone.
If you want to collect arising revenue underived from the sales order, which was generated during the project duration, you can do as follow:

Navigate to Accounting ‣ Customers ‣ Invoices, create a new invoice or look for the draft invoice that you want to attach to your project to collect revenue.

Analyze revenue¶

Analyze revenue from project¶

Navigate to Project apps, choose the needed project, click to Edit:

Press to Gross Margin:

You can see all the revenue from invoices linked to the sales order of this project or invoices linked with the chosen analytic account.

Analyze revenue from Analytic Accounts¶

Navigate to Accounting ‣ Configuration ‣ Analytic Accounting ‣ Analytic Accounts and choose the analytic account of your project. In which, Debit is the costs and Credit is the revenue from the project implementation.

Search for the analytic account of the project. Press Gross Margin to see details of cost and revenue generated from the project implementation.