Convert a Philippine Bank Statement to Excel

BDO, BPI and Metrobank statement conversion, peso formatting, and the remittance transaction patterns worth handling.

Philippine bank statements use English-language layouts with peso amounts. The distinctive pattern is remittance activity, which shapes what these statements typically contain.

Remittance credits

Overseas remittances are a large part of many Philippine accounts, and they carry descriptors identifying the remitter, the originating country and the service used — Western Union, Remitly, a correspondent bank.

These descriptors are long and wrap across lines. As always, continuation lines carry no date and must be merged rather than emitted as separate rows.

Foreign currency conversion on remittances

A remittance often shows the source amount, the exchange rate and the peso amount credited. Only the peso figure belongs in the credit column — that is what actually landed in the account.

Value shown	Where it belongs
Peso amount credited	The amount you total
Source currency amount	Its own column, for reference
Exchange rate	Its own column where printed
Remittance fee	A separate debit row if charged to the account

Verifying

Philippine statements carry a running balance and period totals, so full verification is available. On an account with remittances, the totals check is particularly worth running — it catches the double-counting described above immediately.

What you get back

In the file	What you get
The bank's own columns	Every heading as printed, in the same order
Dates	Exactly as printed, with nothing reformatted
Descriptions	In full, remitter, country and service included, with wrapped lines joined into one cell
Amounts	Each figure where the bank printed it — the peso credit in its column, and a source-currency amount wherever the statement prints one
A Completeness sheet	Every row checked against the printed running balance, and the statement's own totals where it prints them

Nothing is moved between columns, so total the peso column only. If a source-currency amount sits in a column of its own, leave it out of every sum.

Using a converted statement as proof of income

Philippine bank statements are frequently needed as income evidence — for a visa, a loan, or a rental. Where income is remittance-based rather than salaried, that evidence is a pattern rather than a single line.

A converted statement makes the pattern demonstrable: filter to remittance credits, group by month, and the regularity is visible in a way that a stack of PDFs does not convey.

Frequently asked questions

Which Philippine banks are supported?

The reader works from the table on the page rather than a list of banks, so a statement from any Philippine bank is read the same way. The Completeness sheet tells you whether yours came out right.

Can I show regular remittance income clearly?

Filter to remittance credits and group by month. The regularity becomes visible, which is what an assessor is looking for.

Are e-wallet statements like GCash supported?

Yes, where a PDF statement is available. The layout is detected per file.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.