fileforge

Bank statement to Excel › Guides

Turn debit and credit columns into one signed amount column

Many statements print money out and money in in two columns (Withdrawals and Deposits, Paid out and Paid in, Debit and Credit). Spreadsheets and import tools usually want one Amount column where money out is negative. Here is how to get that from the PDF, and how to check it is right.

Verified sample The sample below was produced by running this site's converter on a synthetic statement with Paid out and Paid in columns. It is not real data.

Steps

  1. Download the statement PDF from your bank. It needs a text layer; a photo or scan will not work.
  2. Open the bank statement converter and drop the PDF on it. Nothing is uploaded.
  3. Check the columns it found. The page lists them, for example "date, description, debit, credit, balance". It recognises common names such as Withdrawals, Deposits, Paid out, Paid in, Debit and Credit.
  4. Read the balance check. It confirms that opening balance plus each amount equals the next balance. When every row reconciles, the signs and amounts are right.
  5. Download Excel or CSV. The Amount column is one signed number per row: negative for money out, positive for money in. A SUM of the column gives net movement.

Sample: Paid out and Paid in become one Amount

Date	Description	Amount	Balance
2026-02-01	TRANSFER TO SAVINGS	-300.00	2820.40
2026-02-02	TRANSFER FROM SAVINGS	36.50	2856.90
2026-02-03	INTEREST PAID	1830.25	4687.15
2026-02-04	RENT PAYMENT LANDLORD LLC	-4.75	4682.40
2026-02-06	COFFEE HOUSE 0098	-62.18	4620.22
2026-02-07	ELECTRIC UTILITY AUTOPAY	-54.32	4565.90

36 transactions. Running balance: 36 of 36 rows reconcile.

When to double-check

Open the bank statement converter