QuickBooks for Churches With Bank Statements Converted to QBO Files

Convert church bank statements to QBO files for QuickBooks. Offerings, giving payouts and fund accounts imported with totals checked, months caught up in hours.

Upload your bank statement

PDF, JPG, PNG, BMP, HEIC or TIFF, up to 50MB

Churches get bank statements into QuickBooks by converting each PDF statement to a .qbo Web Connect file and importing it into the matching bank account, so offering deposits, online giving payouts, building fund transfers and card charges land with the dates and amounts the bank printed. The parsed total is checked against the statement before you download, and you code each line to a fund class afterwards. Upload a statement at the top of this page to see your own church's lines in a few minutes.

This page is for the church treasurer, the part-time church bookkeeper and the outside bookkeeper who keeps books for several congregations. The typical trigger is familiar: the previous treasurer stepped down, the bank feed stopped syncing months ago, or the finance committee wants reconciled reports before the annual meeting and the only complete record is a folder of PDF statements.

A real .qbo file QuickBooks accepts

Built for the statements US banks actually send, checked before it exports.

Reconciliation

Every total checked against the statement

The converter adds up the transactions it parsed and matches that to the statement total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

OCR

Scans and phone photos read line by line

OCR runs before parsing, so a scanned or photographed paper statement comes out the same as a digital PDF.

Volume

A year of statements in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Locked files

Password-protected PDFs handled

Enter the password on upload. Multi-column and multi-page statement layouts are parsed too.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your statement to QuickBooks

Three steps. No column-mapping wizard.

1

Upload the PDF statement

Drag in a PDF, a scan, or a phone photo. Password-protected and multi-page files are fine.

2

Review the reconciled rows

Every transaction is extracted and checked against the statement total. You see the parsed rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, email [email protected].

Why church books fall behind the bank

Church money moves through more accounts than most small businesses of the same size. A congregation of 200 to 300 people often runs an operating checking account, a building fund savings account, a missions or benevolence account, and a card for staff purchases. Many of these accounts sit at a local bank or credit union whose QuickBooks connection is unreliable, and savings accounts that see four transactions a month are exactly the ones nobody bothers to connect.

Volunteer turnover makes it worse. Treasurers serve terms, and a handover usually happens in the middle of a fiscal year. The new treasurer inherits a QuickBooks file that stops in some month and a bank that will happily email PDFs going back years. Bank feeds in QuickBooks Online typically pull only about 90 days of history when you reconnect, so the gap before that has to come from the statements themselves.

Finally, giving has moved online. Online giving platforms pay out to the church checking account in batches, often net of processing fees, while the plate offering still arrives as a weekly cash and check deposit. Both show up on the statement as single lines that need splitting or coding, and neither can be done well until the lines are in QuickBooks.

A worked example after a treasurer handover

Take a church whose treasurer left in January and whose new treasurer starts in October. The books stop at December of the prior year. The church has four accounts. Assume operating checking averages 70 lines a month, the building fund savings 4, the missions account 6 and the church card 25. Nine months of catch-up is 36 statement PDFs and 945 bank lines. These are illustrative counts to show the arithmetic; use your own statements.

StepTyping the statements in by handConverting to .qbo and importing
Getting 945 lines into QuickBooksAbout 5 hours at 20 seconds a line, plus a second pass to catch typos36 PDFs uploaded in one batch on Plus, then one import per statement
Proving the data matches the bankRe-add each page and compare to the statementParsed totals checked against each statement before export, then a normal monthly reconciliation
Coding offerings, payouts and transfersTyped in alongside every lineBank rules code repeat payees and giving payouts after import
Separating the building fund and missions moneyEasy to post to the wrong account by handEach account's .qbo imports only into that account
Ready for the finance committeeAfter the typing and checking are doneAfter review and reconciliation, usually the same week

The time saved matters, but for a church the bigger win is trust. Every line in the register traces to a page of a bank statement, nothing was retyped by a volunteer, and the reconciliation report shows each month tying to the bank's ending balance. That is what a finance committee or an internal audit team wants to see after a leadership change.

How church transactions map in QuickBooks

QuickBooks does not have a separate fund module, so churches use the Class field for funds such as General, Building and Missions. Class tracking starts on QuickBooks Online Plus. Once the statement lines are in, this is how the common church items usually land.

Line on the bank statementQuickBooks treatmentFund class
Weekly plate deposit of cash and checksDeposit to Offering or Tithes income, matched to the counting sheet totalGeneral Fund
Online giving payoutSplit into gross gifts and the platform fee expense, using the payout reportBy the fund each donor chose
Transfer from checking to building fund savingsTransfer between the two bank accounts, not incomeBuilding Fund
Mission trip deposits from membersIncome to a missions or trip accountMissions
Pastor payroll including housing allowancePayroll expense, housing allowance tracked as its own payroll itemGeneral Fund
Benevolence check to a family in needBenevolence expense, with board approval on fileBenevolence

The housing allowance line deserves care. The IRS explains in Publication 1828, the tax guide for churches and religious organizations, that a minister's housing allowance must be designated in advance and is excluded from federal income tax but not from self-employment tax. The bank statement only shows the payroll payment, so the designation and the split belong in your payroll records, not in the import.

What the converter does and what it does not

The converter reads the statement, PDF, scan or phone photo, and gives you every line with its date, description and amount, plus a .qbo file for QuickBooks Online or Desktop and Excel and CSV copies of the same data. It checks the parsed total against the statement so you can see a missed line before you import. Bulk upload on Plus takes up to 50 files at once, which covers a year of four accounts in one go.

It does not know who gave. A bank statement shows one deposit for Sunday's offering or one payout from the giving platform, not the names behind it, so donor records and year-end contribution statements stay in your giving or church management software. The IRS requires a written acknowledgment for any single gift of $250 or more, as set out in Publication 1771 on charitable contributions, and that letter comes from donor records. The converter's job is the bank side of the books, which is the side that has to reconcile.

Who usually buys this
  • A new treasurer inheriting a gap. Months of statements, a file that stops, and a finance committee meeting on the calendar. The catch-up bookkeeping workflow walks through the import order.
  • A bookkeeper serving several churches. Different banks, different statement layouts, the same monthly close. The accountant and bookkeeper batch routine fits that practice.
  • A church moving off spreadsheets into QuickBooks. Prior years exist only as PDFs, and the opening balances have to tie. The guide to importing old bank statements into QuickBooks covers the history load.
  • Ministries and church schools with their own accounts. Separate statements, same fund classes. Broader charity setups, grants and Form 990 work are on the nonprofit version of this page.
How to convert your church statements
  1. Upload the PDF statements for one account at the top of this page. Scans of mailed statements are fine.
  2. Check the extracted lines and the totals against the statement on screen.
  3. Download the .qbo file and import it into the matching bank account in QuickBooks Online or Desktop.
  4. Code the lines with bank rules and fund classes, then reconcile the month to the ending balance. Our page on reconciling bank statements in QuickBooks covers that step.
Frequently asked questions

Can a church use QuickBooks for accounting?

Yes. Many churches run their books in QuickBooks Online and use classes as funds, such as General, Building and Missions. It is not purpose-built fund accounting software, but with class tracking, bank rules and monthly reconciliation it handles the books of most small and midsize congregations well.

Which QuickBooks is best for churches?

QuickBooks Online Plus is the usual choice for churches because it is the first Online plan with class tracking, which is how designated funds are separated. Smaller plans can record income and expenses but cannot report by fund. Churches with payroll for staff also add QuickBooks Payroll or an outside payroll provider.

How do I track designated funds in QuickBooks for a church?

Create a class for each fund, such as Building, Missions and Benevolence, and tag every gift and expense to it. The Profit and Loss by Class report then shows what came in and went out of each fund. Money moved to a separate savings account is recorded as a transfer, not income.

How do I get old bank statements into QuickBooks for a church?

Convert each PDF statement to a .qbo file and import it into the matching bank account. Manual imports have no date limit, unlike bank feeds that usually reach back about 90 days. Import the months in order, then reconcile each one so the opening balance and every ending balance tie to the bank.

Which plan exports the .qbo file?

The Plus plan and above export .qbo files, and Plus includes bulk upload of up to 50 statements at once. A new account converts its first three statements free, once, with no card, so a treasurer can test the output on the church's own bank before buying. Plan details are on the pricing page.

Get the church books current this week

Convert your first statement free.

Upload a PDF, see every transaction extracted in seconds. No card to try it.

Still comparing tools? See our bank statement to QuickBooks converter comparison.

Related guides

Upload one month of the operating account at the top of this page and compare the lines with the PDF. If it matches, run the rest of the year through bulk conversion and bring the finance committee reconciled reports instead of a stack of statements.