Northline

Statement converter

Chase credit card statement to Excel

Card statements are not checking accounts. A purchase increases what you owe. A payment decreases it. Northline keeps that sign, then checks previous balance plus the activity against the new balance.

How Chase prints the activity

Look for Payments and other credits, then a Purchases section. Payments are often already negative. Purchases are positive amounts in their own section. Northline will not flip a minus sign a second time just because of the section heading.

The reconciliation anchors are Previous Balance and New Balance, not the checking-account wording Beginning and Ending. If either number is missing, the badge says the balance was not printed instead of pretending the file reconciled.

Columns in the spreadsheet

The export uses Charge and Payment columns rather than Withdrawal and Deposit, so a bookkeeper does not have to reinterpret the signs. The Amount column is the figure that has to add back to the new balance: charges positive, payments negative.

Excel and CSV include that amount. The QBO file flips card charges to the negative amounts QuickBooks expects on a credit card account, and flips payments the other way.

Questions

Is the new balance the amount I owe?

Yes. On a card, the balance we check is the amount owed, not cash in a deposit account. A reconciled badge means the activity explains that amount owed.

Northline is not affiliated with the bank named on this page. This is not tax or financial advice. Compare the export to the original statement. Read the disclaimer.