Convert Millennium BCP Bank Statements to Xero Format

To convert a Millennium BCP PDF bank statement to Xero format, upload your PDF file to BankStmtConverter, select Xero as the output target, and download the converted CSV file. The converter automatically extracts transaction dates, descriptions, payments, receipts, and balances, formatting the output so you can import it directly into your Xero bank feed without manual column adjustments.

How do I convert Millennium BCP statements to Xero?

Getting your monthly statement data from Millennium BCP into Xero requires five straightforward steps:

1. Download your PDF statement: Log in to your Millennium BCP online banking portal and download your official PDF account statement (Extrato de Conta).
2. Upload the document: Drag and drop your original digital PDF or scanned statement into the converter interface.
3. Select Xero format: Choose Xero from the list of output options. The engine prepares the file using Xero's required CSV structure.
4. Review and download: The tool runs a mathematical balance check against the opening and closing balances printed on your statement. Download the ready-to-import CSV.
5. Import into Xero: In Xero, go to Accounting > Bank Accounts, find your Millennium BCP account, click Manage Account > Import a Statement, and upload your converted file.

How does the Xero import workflow work?

Xero accepts bank statement lines via CSV files that follow specific column arrangements. When you manually copy data from a PDF, you often have to split combined narrative strings, fix European decimal separators (commas versus periods), and merge separate debit and credit columns into signed amounts.

BankStmtConverter produces a CSV file configured specifically for Xero with standard headers: Date, Amount, Payee, Description, and Reference. Millennium BCP statements list outgoing payments as debits and incoming transfers as credits. The converter transforms debits into negative numeric values and credits into positive values, allowing Xero to populate your bank reconciliation dashboard accurately.

Because Portugal standardizes dates using the day-first convention, dates are formatted as DD/MM/YYYY. When uploading to Xero, confirm that the date format selection on the import preview screen matches DD/MM/YYYY to avoid transposed month and day records.

What data is extracted from Millennium BCP statements?

Millennium BCP statements contain structured account tables with distinct Portuguese banking fields. The extraction engine identifies and parses:

• Data de Movimento (Transaction Date): The day the transaction occurred.
• Data-Valor (Value Date): The official accounting posting date.
• Descritivo / Movimentos (Transaction Narrative): Detailed information including transaction types, Multibanco payment codes, direct debits (SEPA DD), SIBS terminal receipts, and account transfer notes.
• Valor / Débito (Debit): Outgoing transactions, service fees, stamp duty (Imposto do Selo), and outgoing SEPA transfers.
• Valor / Crédito (Credit): Incoming payments, client settlements, point-of-sale deposits, and interest.
• Saldo Contabilístico / Saldo Disponível (Running Balance): Historical balances used to verify that no transaction line was missed during extraction.

If you prefer to work with spreadsheet models before importing into your general ledger, you can also convert to Millennium BCP to Excel or raw Millennium BCP to CSV.

Comparison: Manual Entry vs. Converter

Worked Example: Millennium BCP Statement in Xero Format

Here is an example of transactions extracted from a Portuguese business account with Millennium BCP:

Once imported into Xero, each negative amount shows on the left side of the reconciliation dashboard as a spent item, while positive amounts appear as received items, ready to match against your existing bills, invoices, or bank rules.

Does the converter handle scanned Millennium BCP statements?

Yes. If you have older paper statements or scanned PDF archives from Millennium BCP branches, optical character recognition (OCR) reads the visual layout. The OCR engine detects skewed lines, low-resolution typography, and border lines common in Portuguese banking slips.

To guarantee data integrity, the system calculates the sum of all extracted debits and credits against the opening and closing balances stated on the original Millennium BCP document. If there is a discrepancy of even a single cent, the line item is flagged for review.

Data Privacy and Security

Your financial documents are processed over encrypted connections. BankStmtConverter operates a strict data retention policy: uploaded statements and generated files are automatically deleted after processing and are never stored long-term or shared with third parties. For teams working across multiple banking institutions, see our directory of supported Portuguese banks.