Skip to main content

How do I import a chart of accounts and funds?

Bring your funds and chart of accounts into One Church Software from a spreadsheet or your previous accounting software using the Import Data tool, in the right order.

You will need the Import permission to use the import tools, and the Accounting Settings permission to manage your chart of accounts and funds.

If you already have a list of accounts and funds, in a spreadsheet or in your previous accounting software, you can import them instead of adding each one by hand. Both are import types in the Import Data tool, and each has its own template.


Import in this order

  1. Funds first. Each account can name a Default Fund, so the funds need to exist before the accounts that use them.

  2. Chart of Accounts next. List parent accounts before the sub-accounts that sit under them.

  3. Starting balances after that, once your accounts and funds are in place. See How do I set starting balances?

  4. Entries last, such as register or journal entries. See How do I import register entries into accounting?

Run the import

  1. Open Settings & Tools (Cog icon in the tool-bar) and choose Tools/Utilities > Import Data.

  2. Click New Import.

  3. Set Type to Funds or Chart of Accounts.

  4. Click download template file to get a CSV with the right column headings, then fill it in. You can also use your own CSV, as long as its first row holds the column headings.

  5. Click Browse to choose your file, or drag and drop it onto the upload area.

  6. Map your columns to the One Church Software fields, then finish the import.

The New Import window with Type set to Funds and the download template file link

For more on mapping columns and checking an import afterwards, see How do I import data into One Church?

Funds template columns

  • Account Number and Name - how the fund appears, such as 30001 - General Fund.

  • Description - an optional note about the fund.

  • Category - the group the fund belongs to.

  • Color - the color used for the fund in charts.

  • Active - whether the fund is active.

To learn what a fund is before you build your list, see What is a fund in accounting?

Chart of Accounts template columns

  • Number and Name - the account number and name, such as 1000 - Checking.

  • Type - Asset, Liability, Equity, Income or Expense. An account's type can't be changed after it is created, so check this column carefully. See What are the account types in accounting?

  • Category - the group the account is listed under on reports, such as Current Assets.

  • Description - an optional note about the account.

  • Default Fund - the fund the account uses by default. It must match a fund that already exists.

  • Parent - for a sub-account, the account it sits under.

  • Active - whether the account is active.

  • Register?, Receivable?, Payable? and Bad Debt? - the account options that decide where the account can be used. See What do the account options mean?

Tip: Starting balances are not part of either template. After the import, open each account or fund and set its balance on the Starting Balances tab.

Other Helpful Articles

Did this answer your question?