CSV to QBO Converter for Nonprofits: Import Donation, Grant and Bank CSVs into QuickBooks

Every other business can categorize a deposit by looking at who sent it. A nonprofit cannot, because the question is not who paid, it is what the money is allowed to be used for. Under the FASB reporting model in ASU 2016-14, contributions land in one of two buckets: net assets without donor restrictions, or net assets with donor restrictions. That distinction comes from what the donor said at the moment of the gift, or from an award letter, and neither of those things exists anywhere in a bank feed. The feed carries a date, an amount and a payer string. Restriction is not a field it has.

So the classification has to arrive from the system that recorded the intent. That is the donation platform export, the grant award schedule, the event registration report, or the spreadsheet a development director keeps. Those files are all CSV or Excel, which is exactly the format QuickBooks is worst at accepting. That gap, between the system that knows the restriction and the ledger that has to report it, is the whole reason nonprofit bookkeepers convert files instead of relying on the feed.

Online giving does not deposit gifts. It deposits payouts. A platform batches everything it collected over a day or a week, subtracts its processing fees, and sends one ACH to the operating account. If the batch straddles a month end, that single deposit belongs partly to two fiscal periods. The feed shows one credit from a company name. The books need every gift at its gross amount, the processing fees as an expense, and each gift assigned to the fund the donor chose. Only the platform's export has that, and it exports to CSV.

Grants behave differently and are no easier. Most government awards are reimbursement based, so the money comes in after the spending, as a plain ACH credit from a state or federal agency carrying a payment number and nothing else. Nothing in that line says which award it reimburses or which budget period it covers. Foundation grants arrive as checks with a letter that lives in a filing cabinet. Event revenue arrives as one settlement deposit that mixes ticket sales, sponsorships and auction proceeds, which have to be split between exchange revenue and contribution revenue before anyone can report on them.

ASU 2016-14 requires every nonprofit to present an analysis of expenses by both nature and function, which in practice means the same dollars reported twice: once as salaries, rent and supplies, and again split across program services, management and general, and fundraising. The Form 990 asks for the same split in Part IX. You cannot produce that from a card feed showing a vendor name and an amount, because the vendor does not tell you which program spent the money.

Federal money raises the stakes. A Single Audit is triggered when an organization expends $1,000,000 or more in federal awards in a fiscal year, a threshold raised from $750,000 by the 2024 revisions to the Uniform Guidance and applying to fiscal years beginning on or after October 1, 2024. Under that kind of review the auditor traces individual charges back to the award. Line level detail imported from the source file survives that. A monthly summary journal entry does not.

QuickBooks handles the split with classes, which is why the edition matters. Class and location tracking start at QuickBooks Online Plus, so a nonprofit on Simple Start or Essentials has no way to tag a transaction to a program at all. QuickBooks Desktop has classes in every edition, which is one reason so many organizations never left it. Either way, the tagging only works if the transactions came in as separate lines in the first place.

Premier Nonprofit Edition was the standard for church and small charity bookkeeping for two decades, and a great many organizations are still running it. Intuit stopped selling new Pro Plus, Premier Plus and Mac Plus licenses in September 2024, so the installed base is now frozen in place: the 2024 release is the last non-Enterprise version, supported until September 30, 2027, and Enterprise Nonprofit is the only Desktop nonprofit product still sold. None of that changes the import problem. QuickBooks Desktop cannot import a bank or credit card CSV in any version or year. Its only banking import is a .qbo Web Connect file, loaded through Banking, then Bank Feeds, then Import Web Connect File. Converting the file you already have is the supported route in.

The converter reads .csv, .txt, .xls, .xlsx and .xlsm in any column order. It handles mixed date formats, strips dollar signs and thousands separators, reads either a single signed amount column or separate debit and credit columns, and writes a valid .qbo with a unique ID on every transaction so QuickBooks can tell a re-import from genuinely new activity. It also exports the same data to XLSX or CSV, which is what an auditor asks for when they want a workpaper rather than a ledger.

Use classes for the funds and let the chart of accounts stay clean. Create one class per restricted fund or grant, tag every contribution and every expense paid from that fund, then release restrictions with a journal entry between two net asset accounts when the purpose is met. Class tracking requires QuickBooks Online Plus or any Desktop edition.

Not natively. QuickBooks is a single ledger system, so true fund accounting is approximated with classes for funds, customers or projects for grants, and separate net asset equity accounts for restricted and unrestricted balances. That approach satisfies most auditors for small and midsize organizations. Large multi fund entities usually outgrow it and move to a dedicated fund accounting package.

It depends on the detail you need. Converting the platform export to .qbo brings each gift into the bank register as its own dated line you can categorize and class, which is what reporting and reconciliation require. If you also need donor records, pledges and year end giving statements inside QuickBooks, those have to come in as sales receipts through a list import or the platform's own integration.

Set the grant up as a class, and the funder as a customer if you want a receivable. Conditional grants are recognized as revenue when the conditions are met, not when the cash arrives, so a reimbursement draw is normally applied against a receivable rather than booked as new income. Tag every expense charged to the grant with the same class.

Record the gross gifts as contribution revenue and the platform's fee as a separate expense, so the two net to the amount that actually hit the bank. Reporting gifts at the net figure understates both contribution revenue and expenses, and it will not agree to the donor acknowledgements you sent. The platform's settlement export gives you both numbers.

If you track more than one fund or program, yes. Class and location tracking begin at Plus, and without them there is no way to tag a transaction to a program, which makes the functional expense analysis and the Form 990 split guesswork. Simple Start and Essentials can only separate activity by account, which forces a bloated chart of accounts.

Tag each expense with a class at the moment it enters the ledger, using one class for each program plus one for management and general and one for fundraising. Shared costs like rent and payroll get allocated across those classes on a documented basis. Then the class based profit and loss maps straight onto Part IX without a rebuild in a spreadsheet.

No. QuickBooks Desktop cannot import a bank or credit card CSV in any version, including Pro, Premier, Premier Nonprofit and Enterprise. The only banking import it accepts is a .qbo Web Connect file through Banking, then Bank Feeds, then Import Web Connect File. Converting the CSV your bank or platform hands you is the standard workaround.

It still runs, but it is no longer sold. Intuit stopped selling new Pro Plus, Premier Plus and Mac Plus licenses in September 2024, and the 2024 release is the last non-Enterprise version, with Intuit services supported until September 30, 2027. The file keeps opening after that; what stops is anything that depends on Intuit's servers, including bank feeds.

Yes on Desktop, with a caveat on Online. File imports have no ninety day limit, so a January to December export goes in as a single .qbo on QuickBooks Desktop. QuickBooks Online caps manual uploads at 350 KB and 1,000 rows, so a full fiscal year usually needs splitting by quarter or by month for a busy organization.

Not if the date ranges do not overlap. Every transaction in a converted .qbo carries a unique ID, which is the field QuickBooks checks against activity it has already seen, so a repeated import is normally recognized and skipped. The habit that avoids trouble is importing clean, non overlapping periods per account and reconciling each month before loading the next.

Direct Connect stops on that date, and Direct Connect bill pay stops with it, so any QuickBooks Desktop account that pulled transactions automatically will go quiet. Web Connect .qbo imports are not affected and keep working. Organizations staying on Desktop move to downloading a file each period, either a .qbo if the bank still offers one or a CSV they convert.