Banque Populaire Statement to Excel Converter

Banque Populaire states that if you decide to close all your bank accounts, you can keep accessing your digital documents for free during the legal retention period from your computer, without having to download them all beforehand — on condition that you keep the Banque à distance subscription that gives access to them.

That is more generous than banks which cut access on closure, but it still depends on a subscription you have to remember to keep. Downloading the relevés before closing removes the dependency; once converted, the history lives in one workbook you control.

The opening balance plus every signed operation must equal the closing balance on the relevé. FlowParse checks that on every statement, and each row against the running balance where it is printed. A crédit read as a débit moves the result by twice its amount, and a line lost at a page break leaves a gap — neither passes.

Relevés that pass are marked reconciled; anything else is shown in the preview with the difference and the rows around it.

Banque Populaire's site has its own sections for professionals and companies, and its CyberPlus Entrepreneurs Individuels service is built for sole traders — tradespeople, shopkeepers, liberal professions. Their bookkeeping starts from the bank statements: card takings from the payment terminal, supplier payments, URSSAF and tax debits, cheques received and deposited.

Converted, a year of professional relevés becomes a table the accountant can import, with card remittances, URSSAF prélèvements and supplier transfers each identifiable by libellé.

A shop or a practice sees its card takings credited as remittances from the payment terminal, often net of commission, and its cheques paid in as a remise with a total. Those lines are what the accountant matches against the till and the cheque deposit slips.

FlowParse keeps each line exactly as the relevé prints it, with its full libellé, so the remittances and deposits can be matched after import — and the solde proof confirms that none was dropped or duplicated.

For the bilan, the déclaration de revenus, a dossier de prêt or a succession, Smart Merge takes up to 100 Banque Populaire PDFs and builds one workbook: operations in date order, the source and account on every row, and a check that each closing balance is the next opening balance — so a month never downloaded shows up as a break.

Relevés from Crédit Agricole, BNP Paribas, Société Générale or Crédit Mutuel can be merged into the same workbook, column by column.

French expert-comptables commonly work in Cegid, Sage, EBP, Quadra or Pennylane. FlowParse exports a CSV with dates, libellé and signed amount for a bank import, plus an Excel file for review first.

Because the libellé is kept whole, each operation can still be lettered against its invoice after import, and the URSSAF and tax debits can be matched to their declarations.

1 234,56 with a space and a decimal comma is text in an English-locale spreadsheet, and 03/04 is the 3rd of April. Débits and crédits pasted into one column lose their sign. A prélèvement with a long mandate reference, or a card remittance with its commission details, wraps over two lines and becomes two rows.

FlowParse writes real signed numbers and unambiguous dates and keeps one operation per row; the solde proof confirms nothing was split or dropped.

An electrician runs a business through a Banque Populaire professional account and a personal account in the same regional bank. The accountant needs the professional account's twelve relevés for the bilan. The figures here are an illustration, not a real business's.

The electrician downloads the twelve PDFs from e-Documents and uploads them. FlowParse returns one workbook in date order, each relevé proved against its soldes. Filtering the libellés separates customer transfers and cheque deposits from supplier payments, the van loan and the URSSAF prélèvements; the accountant imports the CSV and letters the year against invoices without retyping a line.

Coverage: each closing balance equal to the next opening balance, so a missing month is visible. Accounts: professional and personal kept apart by the account column. Reconciled: every relevé proved before its totals are used.

And keep the PDFs. The relevé is the document of record for the tax office and the auditor; the spreadsheet is the working copy.

Relevés for current, professional and savings accounts list operations between two balances and convert the same way. Card statements with deferred debit convert as purchases against the debit that settles them.

Loan statements, transaction notices, securities statements and letters document a single event or summarise a contract. Keep them in e-Documents or with the file; convert the relevés.

Banque Populaire's FAQ ends with what it calls the right reflex: save your bank documents as they are published, so you have them beyond the legal archiving periods if you need them.

A monthly habit of saving the new relevé into a folder per account and year is also what makes conversion effortless — at year end the folder is complete and goes to FlowParse in one upload.