Convert a Citizens statement PDF to Excel

How to convert a Citizens statement PDF to Excel

1. Download the PDF: sign in to Citizens Online Banking, open the Document Center tab, filter by account and timeframe, and save the statement PDF. Use the downloaded PDF, not a scan or a phone photo of a paper statement: scans don't work yet.
2. Upload it above. Utilly reads the Checks, Withdrawals & Debits and Deposits & Credits sections and checks Previous Balance − checks − withdrawals + deposits = Current Balance. The preview shows Balanced ✓, or exactly how far off it is, before you pay anything.
3. Download the CSV and open it in Excel. Dates and amounts come in as real dates and numbers.
4. Save as .xlsx (File → Save As → Excel Workbook) if you want to keep formulas or formatting.

What we read on a Citizens statement

A Citizens "Checking Account Statement" (One Deposit Checking, for example) gives the period as "Beginning September 01, 2026 through September 30, 2026", then a Balance Calculation box, then TRANSACTION DETAILS grouped by type. Amounts carry no sign: the section they're in says which way the money went.

What this is based on: test statements built in Citizens' layout above, with made-up names and transactions (two checks, a section continued onto the next page, wrapped descriptions, and a December-to-January statement), plus two public Citizens checking statements. One is a real One Deposit Checking statement that had been re-saved on a phone: 30 of 31 rows read, and the one row we couldn't read (its date is an unreadable character in that PDF's text) showed up as a $700.00 difference in the balance check, exactly that row's amount. The other is an example statement whose own printed totals disagree with each other, so it can't balance: all 51 of its rows were read, including the check, and its deposits match its "Total Deposits & Credits" to the cent. We don't link to either because they contain people's details. We haven't run every Citizens statement style through it: Citizens Quest, Private Client and business checking, savings and money market statements, and Citizens credit card statements haven't been tested. The balance check tells you straight away whether yours read correctly.

What the Excel file looks like

Date,Description,Amount,Balance
2026-09-08,Check 1021,-450.00,
2026-09-02,7781 DBT PURCHASE - 120044 SAMPLE GROCERY PROVIDENCE RI,-64.18,
2026-09-17,7781 DBT PURCHASE - 552200 EXAMPLE HARDWARE CRANSTON RI,-112.09,
2026-09-01,SCHEDULED TRANSFER 1336400000,-1350.00,
2026-09-03,SAMPLE EMPLOYER PAYROLL PPD 090326,2412.33,
2026-09-24,FEE REFUND CREDIT FOR FEE ON 09/08/26 COURTESY CREDIT,37.00,

The rows keep the statement's order, section by section (checks, then withdrawals, then deposits), so you can tick them off against the PDF. To see the month day by day, sort by the Date column. Want money in and money out in two columns? Use =MAX(C2,0) and =MAX(-C2,0).

How far back Citizens statements go

Sources: Citizens: Checking Disclosures ("View statements online": up to 7 years of statements and check images in the Document Center), Citizens: Online Banking & Bill Pay FAQs (Document Center, 18 months of statements online and older ones through Contact Us, 18 months of transaction history, the Export button for Quicken), Citizens: Business Accounting Software Compatibility (Web Connect for Quicken, Quicken for Mac and QuickBooks). Checked Oct 27, 2026.

QuickBooks and Quicken files for Citizens

Citizens Online Banking can export recent transactions for Quicken and QuickBooks (Web Connect). If that export covers the dates you need, use it. For months it doesn't reach, statements a client sent you as PDFs, or when you want every row tied to the statement's Current Balance, start from the PDF. The same Utilly conversion that gives you Excel also includes:

One credit covers every format of that statement. If an export or a bank feed already brought in some of the same dates, start the PDF months where that stopped so nothing comes in twice.

Common problems

Catching up on months of statements? See catch-up bookkeeping from bank statements, and check any statement's totals with the free bank statement balance checker. Other banks: bank statement PDF to Excel, Chase statement to Excel, Bank of America statement to Excel, Wells Fargo statement to Excel, Capital One statement to Excel, U.S. Bank statement to Excel, Citibank statement to Excel, PNC statement to Excel, Truist statement to Excel, or Navy Federal statement to Excel.