You will need the Import permission to use the import tools, Accounting Settings to set up accounts, funds and starting balances, and Full Write Accounting to import entries.
Moving your books from QuickBooks to One Church Software comes down to four steps: pick a start date, export your lists and balances from QuickBooks, bring them into One Church, and set up the few things that don't carry over. This article walks through each one.
Before you start
Pick a start date. The first day of a fiscal year or a month works best. Your QuickBooks balances on the day before become your starting balances in One Church.
Finish the books in QuickBooks up to that date. Reconcile your bank accounts through the day before your start date, so the balances you bring over are ones you trust.
Export everything before you cancel QuickBooks. Keep a copy of your reports for your records and your auditor.
Turn on Accounting and set your fiscal year and method. See How do I enable Accounting? and How do I set my fiscal year and accounting method?
Decide what your QuickBooks classes become
Many churches use QuickBooks classes to track money by purpose or by ministry. One Church Software splits that job in two:
Funds - for money set aside for a purpose, such as a building fund or missions. Funds carry a balance. If a class tracks restricted money, it becomes a fund.
Tags - for labels you report on, such as a department, ministry or campus. Tags carry no balance. If a class only labels spending, it becomes a tag.
Export your data from QuickBooks
These steps are for QuickBooks Online. QuickBooks Desktop has the same lists and reports, and each can be exported to Excel from its own window.
Chart of accounts - go to Reports, then Standard reports, open Account List, and choose Export/Print > Export to Excel.
Balances on your start date - run the Trial Balance report as of the day before your start date and export it the same way. If your classes will become funds, also run it filtered to each class, so you know each fund's share of every balance.
Transaction history - if you want past years in One Church, run the Journal or General Ledger report for the years you need and export it.
Everything at once - QuickBooks Online can also export a set of reports and lists in one zip file from Settings > Export data.
Open bills and invoices - run your accounts payable and accounts receivable detail reports, so you know what is still unpaid on your start date.
Save each export as a CSV file before you use the One Church import tools.
Bring it into One Church
You can import the data yourself, or ask our team to do it for you. See How can I request for someone to import my data into One Church? If you are importing it yourself, work in this order:
Funds, then your chart of accounts. Rework your QuickBooks lists into the One Church templates. See How do I import a chart of accounts and funds?
Tags, if some classes became tags. See How do I set up tag groups and values?
Opening balances. Enter each account's balance from your Trial Balance as its starting balance, split across the funds it belongs to, dated before your start date. See How do I set starting balances?
History, if you want it. Import past transactions as journal entries, which support split lines, or import bank activity as register entries. See How do I import register entries into accounting?
Tip: You don't have to bring over every past transaction. Many churches start with opening balances only and keep QuickBooks reports for earlier years. Your One Church reports are then complete from your start date forward.
What to set up fresh
Bank connections - connect your bank again. See How do I connect my bank with Plaid?
Open bills and invoices - there is no import type for payables or receivables, so add the unpaid ones by hand. See How do I add a bill? and How do I add an invoice?
Budgets - there is no budget import, so create this year's budget in One Church. See How do I create a budget?
Reconciliations - start reconciling with your first month in One Church. Earlier reconciliations stay in QuickBooks.
After your import
Run the Trial Balance in One Church as of the day before your start date and compare it with the one you exported from QuickBooks. The totals should match. See What is the Trial Balance report?
Check that each fund's balance on the Statement of Financial Position matches what you expect.
Set the account and fund each giving designation posts to, so contribution batches post to the right place. See How do I set where a designation posts in accounting?
