Why are all my bank statement amounts negative?
A negative amount can be correct, a display choice, or a sign that a PDF or import needs review. Check the source statement, direction columns, and destination system before changing signs.
First check what the columns mean
A file with one signed Amount column usually represents money out with a minus sign and money in with a plus sign for a bank account. A file with separate Withdrawal and Deposit columns can show both as positive amounts because the column heading provides the direction. Do not add those columns together or assume they are signed.
Accounting import rules belong to the destination system. For example, Xero's current bank-statement CSV instructions use one Amount column, with income positive and expenses negative. Its credit-card instructions distinguish purchases from payments. Check the instructions for the account and workflow receiving your file.
| What you see | What to check |
|---|---|
| One Amount column; some values have a minus sign | Compare positive and negative entries with the source statement and the account's running-balance movement. |
| Separate Withdrawal and Deposit columns | Read the headings. Values may be unsigned; the columns provide direction. |
| Parentheses around values in Excel | Inspect the stored value. Number formatting changes appearance, not the value used in calculations. |
| PDF sign disagrees with the printed row | Compare the exact row and check for a trailing minus, parentheses, or a sign that blends into the page. |
Synthetic example: convert withdrawal and deposit columns
This invented bank-account example starts at 1,000.00. A 35.00 withdrawal lowers the balance to 965.00; a 70.00 deposit raises it to 1,035.00. The signed transaction amount is negative for the withdrawal and positive for the deposit.
| Date | Description | Withdrawal | Deposit | Signed amount | Balance |
|---|---|---|---|---|---|
| 2026-04-03 | Cafe purchase | 35.00 | — | -35.00 | 965.00 |
| 2026-04-04 | Supplier refund | — | 70.00 | +70.00 | 1,035.00 |
Excel formula for separate direction columns
If Withdrawal is in column C and Deposit is in column D, enter this formula in E2 and fill it down. It leaves a row blank when both inputs are blank.
=IF(D2<>"",D2,IF(C2<>"",-C2,""))
Only use it after confirming which source column is money out and which is money in. If your file already has one signed Amount column, do not apply the formula again.
Sum the signed amounts and compare the result with the change from opening to closing balance. A mismatch means you should review the source rows, signs, dates, and possible missing entries. A matching total does not prove every transaction was captured.
Check a number's value, not only its appearance
Select a value in Excel and inspect the formula bar. The SIGN function returns -1 for a negative number, 0 for zero, and 1 for a positive number. If an imported amount is text, fix the import type and locale first; changing its font or number format will not turn text into a numeric value.
Excel can display a negative amount with a minus sign, parentheses, or a chosen color. Those number formats do not change the underlying value. See Microsoft's current instructions for negative number display.
Could the PDF cause a sign mismatch?
Sometimes the issue begins before a spreadsheet is opened. A PDF may place a minus sign after the digits, or encode text differently from how it looks on screen. Bank Statement Converter documented one PDF where a trailing minus sign appeared in extracted text while blending into the page background. That is one document-specific report, not evidence about other banks or statements. Compare each questionable value with its printed row and running balance.
Before you change any signs
- Keep an untouched copy of the original CSV or PDF.
- Identify whether the file has one signed Amount column or separate direction columns.
- Verify a known withdrawal and deposit against the statement when both are present.
- Check whether Excel imported the amount as a number or text and whether a display format uses parentheses or color.
- Compare opening balance plus signed activity with closing balance when those values are available.
- Check the destination accounting system's current import instructions before preparing a handoff.
ExtractMint CSV notes
ExtractMint's current CSV export includes separate Withdrawal, Deposit, and signed Amount fields when available. Review the values against the PDF before using them. The PDF-to-CSV guide explains the export columns and review metadata.
ExtractMint is in beta, and no bank-specific format has been independently validated against real statements. An arithmetic match is useful as a cross-check, but it cannot prove that every transaction was captured.