How to download transactions from Citi
Sign in to Citi Online in a web browser, open the account or card, and look for a Download or Export option above the list of transactions. Choose the date range and a CSV or spreadsheet format. Downloads are easier from the website than from the app, where export options are limited.
Menus change. Citi updates its online banking from time to time, so the exact button names may differ from what's described here. If you can't find the option, search Citi's help pages for “download transactions”.
What a Citi CSV looks like
| Status | Date | Description | Debit | Credit |
|---|---|---|---|---|
| Cleared | 01/05/2026 | SHELL OIL 5744 | 48.20 | |
| Cleared | 01/06/2026 | ONLINE PAYMENT, THANK YOU | -250.00 | |
| Pending | 01/08/2026 | AMAZON.COM*AB12 | 19.99 |
Debit is money out and Credit is money in. On some card exports the credit is written with a minus sign, as above, which makes a simple “credit minus debit” formula in Excel come out wrong. The converter reads which column a number is in, not its sign, so a payment to the card is always money in. Dates are month-first (01/05/2026 is 5 January).
Common problems with Citi files in QuickBooks
- QuickBooks wants one amount column. A 3-column QuickBooks CSV needs a single signed amount. The converter merges Debit and Credit into one, or writes QuickBooks’ 4-column layout if you prefer separate columns.
- Pending transactions. Rows marked Pending can still change or disappear. To avoid duplicates, import a period once its transactions have all cleared, or remove pending rows before converting.
- Payments shown as charges. If you import a card file into a bank account in QuickBooks, payments and purchases look reversed. Import card files into the credit card account.
- Commas in descriptions, such as “ONLINE PAYMENT, THANK YOU”, are kept intact.
Import the converted file into QuickBooks Online
- In QuickBooks Online, go to Transactions → Bank transactions and choose Upload transactions (it may sit under the arrow next to Link account).
- Select the file you downloaded from the converter, then pick the QuickBooks account it belongs to. Use the credit card account for a card export — not a bank account.
- For a CSV, map Date, Description and Amount, and choose the date format shown in step 3 of the converter. A QBO file skips this screen.
- Review the transactions in the For review tab, then compare the QuickBooks balance with your statement for the same date.
The full walkthrough, with every screen, is in our QuickBooks Online import guide.
Frequently asked questions
Why are Citi credits negative in my download?
Some Citi card exports write credits (payments and refunds) with a minus sign in the Credit column. The converter treats anything in the Credit column as money in, whatever its sign.
Should I include pending transactions?
Pending transactions can change before they post. Importing them can create duplicates later, so it’s safest to import a period once everything in it has cleared.
Does it work with Citi credit card exports?
Yes. Import the converted file into your credit card account in QuickBooks so purchases and payments land the right way round.
Can I get QuickBooks’ 4-column layout instead?
Yes. Choose the 4-column QuickBooks CSV in step 3 to keep money out and money in in separate columns.
Is my Citi data uploaded anywhere?
No. The file is converted in your browser and the result is saved to your device.