Insightly and Prowi: Automated Commission for Growing Businesses
Insightly is a CRM system that combines sales and project management in a unified platform. It's designed for small and medium-sized businesses that want to track customer relationships, pipeline, and projects without juggling multiple systems.
At Prowi, we see a strong match in connecting Insightly with our platform for commission and bonus. Today, sales data from Insightly comes into Prowi via CSV, and commission is calculated live on the imported data. This creates a seamless flow from sales activity to reward. A direct integration is on our roadmap.
From Opportunity to Commission Without Manual Steps
Many companies use Insightly to manage their sales process, but when data needs to be converted to commission, the numbers still often end up in spreadsheets. This creates a bottleneck with manual calculations and risk of errors.
With Prowi, most of the process can be automated today. Closed opportunities are exported from Insightly and loaded into Prowi via CSV, ideally on a fixed schedule. Commission and bonus are calculated according to your own models, and the rep sees the result in the app as soon as the data is loaded. Approval flows ensure quality, and the final amount can be sent directly to the payroll system.
What syncs from Insightly
There is no direct connection to Insightly today, so data comes in by file. The Insightly integration on the roadmap will read the same fields directly.
- Data: value, close date, rep (email), status and optionally product, discount or any other field the plan needs.
- Direction: one way, from Insightly to Prowi. Prowi never writes anything back to Insightly.
- Frequency: every time a new file is loaded. A scheduled CSV can run hourly, daily or on demand.
- Changes: if a sale comes in again with a new value or status, Prowi recalculates and puts the difference on the next open statement as a correction.
The file import is described on the CSV and MySQL integration page.
How to set it up with Insightly
- Create a report or export in Insightly with won opportunities and the fields the plan needs: who, when, how much and status.
- Load the file into Prowi and map the columns once. Reps are matched on their email.
- Build the commission plan in Prowi with your rates, targets and rules.
- Run a shadow calculation on a closed month and compare it with your current spreadsheet before you go live.
- Put the export on a fixed schedule and tell us you use Insightly. Demand decides which integrations we build first.
What you can calculate with Insightly data
Insightly is used by growing companies that link sales and projects, and that often reward both closed sales and delivered milestones. Typical models are milestone bonuses and flat-rate commission. The calculation is the same whether data arrives by file or through a direct integration, so you lose nothing by starting with CSV.
Benefits of an Integration
Automated calculations without errors: Manual spreadsheets are a source of errors. With Prowi, these risks are eliminated. Calculations happen automatically using the same rules every time, and results can be audited down to individual opportunities.
Real-time insight for reps: As soon as a closed deal from Insightly is loaded, the rep can see in the Prowi app what they've earned. They can follow their goals, see forecasts, and compare performance with the rest of the team.
Full transparency: Both reps and management can follow how commissions are calculated. This builds trust and reduces disputes over calculations.
Stronger overview for management: Instead of spending time checking Excel sheets, management always has updated numbers. Documentation of all calculations through audit trails ensures compliance.
Flexibility to try new models: With Prowi, you can experiment with new incentive models without changing anything in Insightly. This makes it easier to optimize the commission structure over time.
Who Benefits from the Integration
For sales reps, the integration means commission becomes visible and motivating in everyday work. The reward feels closer to the effort when it can be seen shortly after a closed deal.
For sales managers, the integration provides a new tool for managing the team. They can see who's performing and how the commission structure affects behavior. It becomes easier to set goals and follow up on them.
For finance teams, the integration reduces the monthly workload. Data is already validated and ready for payout, freeing up time for more value-creating tasks.
Interested in an Insightly Integration?
We build integrations based on demand from our customers. If Insightly is your CRM and you want a direct integration with Prowi, we'd love to hear from you. Your feedback helps us prioritize which integrations we develop next.
Contact us to register your interest and help shape our roadmap. We gather input from customers and users to ensure we build the integrations that deliver the most value.
The Future of Insightly and Prowi
Insightly gives growing businesses a unified view of sales and projects. Prowi makes commissions simple, accurate, and motivating. When the systems are connected, you get a solution where sales work and reward are closely linked.
It's not just about saving time. It's about creating a system where employees can trust the numbers and where management can make decisions based on real-time data. Book a demo today and experience how Prowi can transform your commission process.