Statement converter
Citi credit card statement to Excel
Citi card statements print a sale date and a post date. The post date is the one that belongs in the books. The sale date stays in its own column when it is different, which matters for a charge that posts in the next statement cycle's first days but was made earlier.
Sections on the statement
Payments, credits and adjustments come first and reduce the balance you owe. Purchases increase it. Previous balance and new balance are the reconciliation pair. Fees, when they appear in their own section, are treated as charges.
Download the PDF from Citi online rather than scanning the paper statement. The account number we keep is only the last four digits, for the spreadsheet and the QBO account id.
What to review
A payment that posts on a different day from the sale date should show the post date in Date and the sale date beside it. If we attach a payment to the wrong section, the balance check fails by that payment's amount. Fix the charge or payment cell and the difference updates before you export.
Questions
Which date does Excel get?
The Date column is the post date. Sale date is a separate column, blank when the statement only printed one date or the two dates match.
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.