Grupo Select

Management and technology

Integrated management with an ERP: why connect your company's departments

When each department uses a different spreadsheet, the company wastes time reconciling numbers. See what integrated management is, what to integrate and what to watch for in operations with multiple companies and currencies.

Updated on · 6 min read

In many companies, each department has its own tool: sales uses an opportunities spreadsheet, finance has another for accounts payable, purchasing tracks orders by email and HR keeps documents in folders. Everything works until someone needs an answer that cuts across departments, such as "how much will we bill this month, and do we have the inventory to deliver?" That is when manual reconciliation begins.

Integrated management is the idea that these departments work from the same database. An ERP (Enterprise Resource Planning) is the type of system that makes this possible.

What an ERP is

An ERP brings together, on a single platform, the modules that support operations: sales, finance, purchasing, inventory, people and documents, among others. The difference compared with using several standalone systems is that information recorded in one module is available to the others, without re-keying.

An approved sales order, for example, can create the expected receivable in finance and reserve items in inventory. A received purchase updates the inventory balance and creates the account payable. Each record is created once and used by whoever needs it.

Why integrate each department

DepartmentCommon problem when isolatedWhat integration enables
CRMOpportunities in personal spreadsheets, history lost when someone leavesClient history visible to those with permission
SalesProposals and orders re-keyed in financeAn approved order becomes a financial forecast
FinanceCash flow built by hand from several sourcesAccounts payable and receivable fed by other departments
PurchasingOrders by email with no link to the budgetTraceable requisition, approval and order
InventoryBalance that differs between the system and the shelfReceipts and issues recorded at the source
HRPeople data scattered and duplicatedSingle employee record and costs by department
DocumentsFiles in local folders, conflicting versionsDocument linked to the record that created it

Practical benefits and limits

The most common gains from integrated management are less rework, fewer discrepancies between reports and faster answers to questions that involve several departments. It also becomes easier to trace who did what and when.

But an ERP does not fix poorly defined processes. If each department registers clients differently, the system will simply store the mess in a centralized way. Implementation requires agreeing on rules: who registers, who approves, which fields are mandatory. The outcome depends as much on the tool as on disciplined use.

Operations with more than one company

Business groups and entrepreneurs with several CNPJs (Brazilian company tax IDs) have an additional need: using a single platform without mixing up each company's information. This is what is called a multi-company environment.

Data kept separate by company

Each company needs its own financial entries, orders, inventory and documents. A receivable belonging to company A cannot appear in company B's cash flow. This separation must be guaranteed by the system, not depend on each user remembering to filter.

Permissions by user and by company

Not every user should see every company. A sales rep at one company does not need access to another company's finances. That is why permissions should be defined per user, indicating which companies they can access and, within them, which areas and actions.

Consolidation requires authorization

Seeing the group's consolidated numbers is useful for management, but it is a sensitive view. Consolidation should be available only to those authorized to see all the companies involved. Someone with access to a single company should not be able to see data from the others through a consolidated report.

Different currencies do not add up

Companies that operate in more than one country, or that bill in different currencies, need specific care: amounts in Brazilian reais and in pesos, for example, cannot simply be added together. Adding R$ 1,000 and $ 1,000 produces a meaningless number.

To consolidate amounts in different currencies, they must be converted into a reference currency using an explicit method, such as the exchange rate on a given date, the period average or the rate actually applied. The method should appear in the report, so readers know where the number came from. Without conversion, the correct approach is to show totals separately by currency.

Checklist before choosing or implementing an ERP

  • Which departments need to share information today, and where is data re-keyed?
  • Do the main records (clients, suppliers, products) have a defined owner?
  • Does the operation involve more than one company? Is data kept separate by company?
  • Can permissions be defined by user and by company?
  • Who can see the group's consolidated numbers?
  • Are there operations in more than one currency? What will the conversion method be?
  • How will current data be migrated and verified?

Where to start integrating

  1. Map the workflows that cause the most rework today, such as order-to-invoice or purchase-to-payment.
  2. Define the owner of each main record and the minimum data-entry rules.
  3. Clean the data before migrating: duplicate clients and suppliers become a problem inside the system.
  4. Set up companies, users and permissions before rolling out use.
  5. Implement in stages, starting with the departments with the greatest gains, and check the numbers against the old method for a period.
  6. Train users and review the rules after the first few weeks.

Select360 ERP

Select360 ERP is the management platform developed and used by Grupo Select's companies. It operates in a multi-company format, with permissions defined per user. If you want to learn about the platform and see whether it fits your context, request a presentation.

Discover Select360 ERP (opens in a new tab)

Read next