ForgeNEX
← Back to the Academy
Sales

Create a workshop report and take it to Excel

Add up amounts, group expenses by status and save the analysis for later.

8 min · Intermediate

Screenshots show the CRM in Spanish.

Step 1 · Analysis > What to analyse

In Analysis, open What to analyse and choose Gastos del taller. This example brings together three made-up workshop expenses in a custom module.

Analysis > What to analyse
Analysis > What to analyse1Analysis > What to analyse1

Step 2 · Analysis > Calculations

Under Calculations, click Add calculation. The report adds up Amount and shows €140.00 as the total for the three expenses.

Analysis > Calculations
Analysis > Calculations1Analysis > Calculations1

Step 3 · Analysis > groups by status

Under Group by, choose Estado. Compare what has been paid with what is still due: the Pagado group adds up to €60.00, and Pendiente to €80.00.

Analysis > groups by status
Analysis > groups by status1Analysis > groups by status1

Step 4 · Analysis > Excel

Click Excel to download the report as .xlsx; the file keeps the data you can see and export for your role.

Analysis > Excel
Analysis > Excel1Analysis > Excel1

Step 5 · Save report

Click Save, call it Gastos por estado and save the report. If Share it with the team appears, leave it unticked to keep the report personal.

Save report
Save report1Save report1

Step 6 · Saved reports

Reload Analysis. The report stays selected and keeps its grouping by status; open it again under Saved reports.

Saved reports
Saved reports1Saved reports1

Was this helpful?

We do not store who answers: we only count.

Call us WhatsApp