How to import transactions in Primavera

Importing Bank Transactions into Primavera

Primavera BSS is one of the leading ERP and accounting platforms in Portugal, widely used by small and medium-sized businesses as well as larger enterprises. Despite its powerful features, importing bank transactions from PDF statements into Primavera is a task that many accounting professionals still perform manually — a process that is both time-consuming and prone to errors.

The good news is that with the right tools and workflow, you can dramatically reduce the time spent on this task while improving the accuracy of your financial data.

Understanding Primavera Import Requirements

Primavera supports data imports through specific file formats, typically structured CSV or Excel files. The system expects certain fields in a defined order: transaction date, document number or reference, description, debit value, credit value, and sometimes additional fields like the bank account code or cost centre.

The exact format may vary depending on your Primavera version and configuration, but the principle is the same — you need clean, structured data in a file format that Primavera can read and map to its internal transaction structure.

Converting Bank Statements for Primavera

Bank statement PDFs are not designed for software import. They contain formatted tables, headers, footers, page numbers, and other visual elements that make direct import impossible. The conversion step is therefore critical.

Bank2PDF extracts transaction data from your bank statement PDF and outputs it in a clean, structured format. You can then adjust the output to match Primavera expected column structure. For many Portuguese banks, Bank2PDF already produces output that aligns closely with what Primavera needs, minimising the adjustment required.

The Import Workflow

A typical workflow involves three steps: convert the PDF using Bank2PDF, verify the output briefly to ensure all transactions were captured correctly, and then import the file into Primavera using its built-in import functionality. Most users navigate to the bank transactions module, select the import option, point to the converted file, and complete the process in under a minute.

For recurring imports, you can save the column mapping configuration in Primavera, which means subsequent imports require even less setup. The entire process — from PDF to imported transactions — can take less than five minutes, compared to an hour or more of manual entry.

Best Practices for Primavera Imports

Always reconcile imported transactions against the original bank statement to ensure completeness. Pay attention to the opening and closing balances, and verify that the total number of transactions matches. Keep the original PDF alongside the imported data for audit purposes. With a consistent workflow, importing bank transactions into Primavera becomes a routine task rather than a monthly burden.