Record project revenue (Integrated with Sales, Timesheets, Accounting)¶
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.
To integrate this feature, you need to install the following apps:
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.
Note
In case, the sales orders of the products with the service type and at the Service Tracking field of the product form is set Create a task in sales order’s 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¶
Project overview¶
Navigate to Project, click Overview on the specific project to see their revenues.
Along with that, the system will automatically calculate the profitability based on the recorded data.
Invoiced: The amount before VAT of issued invoices that linked with this project.
To invoice: The amount before VAT of not issued invoices that linked with this project.
Other Revenues: All revenues that are not links with this project but linked to the analytic account of the project.
Timesheet costs: Costs based on the Timesheet cost configured on the HR settings of your employees. This cost is calculated as follows: Configured timesheet cost of the employee multiplied by the work hours logged on the timesheet.
Total: Calculated as follows: Invoiced + To invoice + Other Revenues - Timesheet costs.
Project revenue and costs analysis using analytic account¶
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 Cost/Revenue to see details of cost and revenue generated from the project implementation.