System Integration Consultant, Portugal

Which program issues each document?

This is the first integration question in Portugal, and it shapes every other one. Your accountant confirms which documents must be issued by software accepted under the tax authority's scheme, and the vendor must state in writing whether the specific product and edition, configured as you intend, qualifies. No platform should be assumed to qualify because of its name. Once those answers are in, I draw the document map:

In a split design, the ERP handles orders, stock and management accounting, and the invoicing program issues the documents. The interface between them has to be dependable, because an order that fails to cross means a customer who is not invoiced. The ERPNext page for Portugal shows one platform where this split is a common option, and my broader approach is set out under ERP integration.

Document codes, transport documents and the SAF-T file

Portuguese documents carry identifiers that must stay consistent across every system that touches them: a series registered for the issuing program, a unique document code and a QR code printed on the document. When an ERP and an invoicing program work together, the integration must carry those identifiers back, so the ERP, the customer portal and any CRM all show the same official number.

Transport documents add timing. Where your accountant says a movement of goods must be communicated before it starts, the warehouse or logistics provider must not dispatch until the document and any communication code exist. I specify which system creates the transport document, when, and what the warehouse receives. If a third-party warehouse ships for you, the integration with its system includes this step explicitly.

The SAF-T file depends on the same discipline. If invoices come from one program and receipts or adjustments from another, the data feeding the file must reconcile with the ledger. I define which system is the source for each part, and the test plan compares a trial file with the accounts before go-live. Your accountant decides how and when invoice data reaches the tax authority; the integration makes sure the data is complete and consistent when they need it. The Portuguese ERP business analyst page explains how I write these points into the requirements document.

Multibanco references, SEPA files and bank statements

Portuguese customers often pay through Multibanco references, alongside transfers, direct debits and mobile payment apps. Each method needs a matching rule, or finance ends up allocating receipts by hand.

• Payment references are generated per invoice through a payment service provider and printed on the document. Payment confirmations come back from the provider and close the open item automatically.
• Transfers are matched from bank statement files by amount, reference and customer, with unmatched items routed to a review queue rather than parked on a suspense account.
• Direct debits are collected through SEPA files from customers with valid mandates, and returned debits reopen the receivable with charges and a task for credit control.
• Supplier payments leave as SEPA transfer files from an approved proposal. Supplier bank details change only through an approval step.

Online payments and wallets settle through the provider in grouped payouts net of commission, so each payout is broken down into gross takings, provider fees and the net sum deposited. In a split design, I also decide whether receipts are recorded in the ERP or in the invoicing program, because both must agree for the SAF-T file and the accounts. Each bank and provider is trialed with real files, including a returned debit, before go-live.

Hotels, service centers, payroll and online sales

Hotels and tourism. A property management system handles reservations and guest folios; point-of-sale systems handle restaurants and bars. Finance needs daily revenue by department, deposits, payments by method and purchases by property. I map those flows for each property, decide which system issues guest invoices under the national rules and agree how differences are investigated. Hotel groups with several properties gain most from a single mapping standard.

Service centers. Nearshore delivery centers record time and costs that must become intercompany recharges. The group ERP may sit abroad while the Portuguese entity issues its invoices locally. I specify how timesheets and cost allocations flow, which system issues the recharge invoice and how both sides reconcile each month.

Payroll. Payroll is often prepared by the accountant or a payroll provider. The ERP needs a summarized journal by account and cost center, mapped with finance and reconciled to the payroll summary. Social security and tax filings remain with the provider.

Online sales. Webshop and marketplace orders arrive with customer tax numbers where given, payment status and shipping details. The mapping covers mainland, Azores and Madeira VAT cases as your accountant confirms them, returns and how each order reaches the issuing program in time to invoice.

Choosing methods, testing and ownership after go-live

For each flow I weigh the realistic routes: a native link between the ERP and the invoicing program, a connector offered by the local software supplier, an integration platform, bespoke code or scheduled files. The comparison covers reliability, running cost drivers, who answers when it breaks and how a rule change will be absorbed. A connector maintained by a small Portuguese supplier can be the right choice, provided the contract says how quickly it follows rule changes and upgrades on either side.

Testing uses Portuguese cases from your business: an invoice in each series, a credit note, a transport document before dispatch, a Multibanco payment, a returned direct debit, a hotel folio split between guest and company, a payroll correction and a failed transfer between ERP and invoicing program. Your accountant reviews a trial SAF-T file against the ledger before sign-off.

After go-live, any order that fails to reach the issuing program raises an alert to a named person the same day, and daily control totals compare documents issued with orders shipped. A runbook explains how to resubmit without creating a duplicate number. I deliver this from a distance and visit only by arrangement. For the sales side of these flows, see my CRM consulting for Portugal; for the whole system picture, see ERP consulting in Portugal.