{"id":70910,"date":"2025-11-03T15:26:41","date_gmt":"2025-11-03T14:26:41","guid":{"rendered":"https:\/\/churchtools.academy\/help\/non-knowledgebase\/uncategorized\/how-do-i-import-my-chart-of-accounts-from-optigem\/"},"modified":"2026-07-03T14:07:36","modified_gmt":"2026-07-03T13:07:36","password":"","slug":"how-do-i-import-my-chart-of-accounts-from-optigem","status":"publish","type":"docs","link":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/import-from-optigem\/how-do-i-import-my-chart-of-accounts-from-optigem\/","title":{"rendered":"How do I import my chart of accounts from Optigem?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">To sync transaction data from Optigem to ChurchTools, you\u2019ll need to set up your chart of accounts in ChurchTools first. To do this, export your accounts from Optigem, edit the data, and then import them into ChurchTools. Here\u2019s a step-by-step guide on how to do it.  <\/p>\n\n<h2 class=\"wp-block-heading\">1. Prepare ChurchTools<\/h2>\n\n<h3 class=\"wp-block-heading\">1.1 Create Account Groups in Finance<\/h3>\n\n<p class=\"wp-block-paragraph\">In the Finance module, you create all <em>the account groups<\/em> you need for your chart of accounts in advance.  <\/p>\n\n<p class=\"wp-block-paragraph\">To learn how to create account groups and other master data in the Financials module, see the article &#8221; <a href=\"https:\/\/churchtools.academy\/de\/help\/churchtools-module\/stammdaten\/30-wie-lege-ich-einen-kontenrahmen-an\/#2-toc-title\">How do I create a chart of accounts?&#8221;<\/a><\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#22c55e;border-left-width:0.5rem;background-color:#dcfce7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Tipp<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">In Step 3.2, you&#8217;ll then map the account groups in the import file accordingly.<br><br>Alternatively, you can simply create an &#8221; <em>Optigem Import<\/em> &#8221; account group. In that case, you won\u2019t need to adjust the import file, since the <em>\u201cOptigem-Import\u201d<\/em> account group is set as the default for all accounts. However, this means you\u2019ll need to manually assign the accounts to the various account groups in Finance after the import is complete.  <\/p>\n<\/aside>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">If you have assigned all accounts to only one account group (e.g., Optigem Import), budgets, for example, cannot be calculated correctly because bank accounts must be designated as cash accounts for this purpose.<br \/><br \/>If you want to calculate budgets, you should definitely assign at least the <em>\u201cBank and Cash Balances\u201d<\/em> account group to the relevant accounts and adjust the accounts accordingly in your import file.<\/p>\n<\/aside>\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<h3 class=\"wp-block-heading\">1.2 Create Tax Rates<\/h3>\n<\/blockquote>\n\n<p class=\"wp-block-paragraph\">If you want to assign specific tax rates to accounts, create all <em>the<\/em> necessary <em>tax rates<\/em> in the Finance module beforehand. In step 3.5, you can then adjust the tax rates in the import file accordingly. <\/p>\n\n<p class=\"wp-block-paragraph\">To learn how to set up taxes, check out the article &#8221; <a href=\"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/master-data-finance\/19-how-to-add-taxes\/\" id=\"7179\">How Do I Set Up Taxes?&#8221;<\/a><\/p>\n\n<h2 class=\"wp-block-heading\">2. Export and prepare general ledger accounts from Optigem<\/h2>\n\n<p class=\"wp-block-paragraph\">Next, you&#8217;ll need to export the accounts you&#8217;ve been using from Optigem and prepare them for import into ChurchTools. You have two options for doing this. One is to export your general ledger accounts as an Excel file, and the other is to run an SQL query directly in Optigem, which will return only the account numbers and names.  <\/p>\n\n<h3 class=\"wp-block-heading\">Option 1: Export your general ledger accounts as an Excel file from Optigem<\/h3>\n\n<p class=\"wp-block-paragraph\">To do this in Optigem, follow these steps:<\/p>\n\n<p class=\"wp-block-paragraph\">Open the general ledger accounts and access the <em>data sheet<\/em> in the <em>View<\/em> tab.<\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-20.png\"><img decoding=\"async\" width=\"190\" height=\"178\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-20.png\" alt=\"Screenshot: View the Optigem data sheet\" class=\"wp-image-17139\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\">Next, switch to the &#8221; <em>More<\/em> &#8221; tab and click on &#8221; <em>Excel<\/em>.&#8221;<\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-21.png\"><img decoding=\"async\" width=\"197\" height=\"176\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-21.png\" alt=\"Screenshot: Select Optigem Excel\" class=\"wp-image-17141\" style=\"object-fit:cover\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\">Then save the export under the name of your choice. You don&#8217;t need to save the export steps. <\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-22.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"741\" height=\"545\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-22.png\" alt=\"Save the file exported from Optigem (screenshot)\" class=\"wp-image-17143\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-22.png 741w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-22-300x221.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-22-360x265.png 360w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\">Open the Excel file and select the entire table. Under &#8221; <em>Data<\/em>,&#8221; sort everything by <em>subaccount<\/em>. <\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">Subaccounts from Optigem are automatically assigned to the main account, since there are no subaccounts in ChurchTools.  <br><br>If you need this breakdown, you&#8217;ll be able to assign the relevant bookings to the appropriate cost centers after the transaction data has been synchronized.<\/p>\n<\/aside>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-23.png\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"567\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-23.png\" alt=\"Screenshot: Select the table and sort by subaccounts\" class=\"wp-image-17145\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-23.png 940w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-23-300x181.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-23-768x463.png 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-23-360x217.png 360w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\">In the sort warning, you specify that <em>numbers and numbers formatted as text<\/em> should be <em>sorted separately<\/em>.<\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-24.png\"><img loading=\"lazy\" decoding=\"async\" width=\"403\" height=\"236\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-24.png\" alt=\"Screenshot of Excel Sort Warning\" class=\"wp-image-17147\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-24.png 403w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-24-300x176.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-24-360x211.png 360w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\">Select and then delete all rows that <strong>do not<\/strong> contain <strong>a 0<\/strong> in the &#8221; <em>Subaccount<\/em> &#8221; column.<\/p>\n\n<h3 class=\"wp-block-heading\">Option 2: SQL Query<\/h3>\n\n<p class=\"wp-block-paragraph\">If you only want to export the account number and name, the easiest way to do this is with an SQL query.<\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1218\" height=\"135\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren.png\" alt=\"Screenshot: How to Run an SQL Command in Optigem\" class=\"wp-image-42230\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren.png 1218w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren-300x33.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren-1024x113.png 1024w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren-768x85.png 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren-360x40.png 360w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_SQL-Kommando-ausfuehren-220x24.png 220w\" sizes=\"(max-width: 1218px) 100vw, 1218px\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\">To do this, open the first fiscal year you want to import in Optigem (1), and then use the question mark (2) to enter an SQL command (4).<br \/><br \/>Enter the following SQL command here and confirm your entry by clicking OK.<br \/><br \/><code>SELECT Sachkonten.[Hauptkonto-Nr], Sachkonten.Kontoname FROM Sachkonten WHERE (((Sachkonten.[Hauptkonto-Nr]) In (select [HK] from Teilbuchung)) AND ((IIf(([Personenunterkonten] Or [Art]&gt;=3) And [Unterkonto-Nr]&gt;0,-1,0))=0)) ORDER BY Sachkonten.[Hauptkonto-Nr];<\/code><br \/><br \/>Optigem will then display the account numbers and names in a table.<\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">Subaccounts from Optigem are automatically assigned to the main account, since there are no subaccounts in ChurchTools.  <br><br>If you need this breakdown, you&#8217;ll be able to assign the relevant bookings to the appropriate cost centers after the transaction data has been synchronized.<\/p>\n<\/aside>\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_Ergebnis-SQL-Kommando.png\"><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"527\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_Ergebnis-SQL-Kommando.png\" alt=\"Screenshot of the SQL query results\" class=\"wp-image-42232\" style=\"width:368px;height:auto\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_Ergebnis-SQL-Kommando.png 433w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_Ergebnis-SQL-Kommando-246x300.png 246w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_Ergebnis-SQL-Kommando-360x438.png 360w, https:\/\/churchtools.academy\/wp-content\/uploads\/2025\/11\/Optigem_Ergebnis-SQL-Kommando-41x50.png 41w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/a><\/figure>\n\n<h2 class=\"wp-block-heading\">3. Fill in and customize the account import template<\/h2>\n\n<h3 class=\"wp-block-heading\">3.1 Fill in the ChurchTools-Optigem account import template with your data<\/h3>\n\n<p class=\"wp-block-paragraph\">Download this <a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/ChurchTools-Optigem-Kontenimportvorlage.xlsx\" data-type=\"attachment\" data-id=\"11820\">account import template<\/a>.<\/p>\n\n<p class=\"wp-block-paragraph\"><strong>Copy all the rows from your export file and <\/strong>paste them into the &#8221; <em>General Ledger Accounts from Optigem<\/em> &#8221; tab in the account import template. Be sure to overwrite all the sample data. The template is designed so that the account numbers and names of your accounts are automatically transferred to the &#8221; <em>Account Import<\/em> &#8221; tab <em>in ChurchTools<\/em>.  <\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">If fields marked in red appear in your data, as shown here, it means you haven&#8217;t deleted all the rows that <strong>do not<\/strong> contain <strong>a 0<\/strong> in the <em>&#8220;Subaccount<\/em> &#8221; column. In this case, repeat step 2b and copy the data from your export file again. <br><br><img loading=\"lazy\" decoding=\"async\" width=\"326\" height=\"163\" class=\"wp-image-41312\" style=\"width: 300px\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/CleanShot-2025-10-16-at-15.25.20.png\" alt=\"Screenshot of an Excel spreadsheet with subaccounts highlighted in red\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/CleanShot-2025-10-16-at-15.25.20.png 326w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/CleanShot-2025-10-16-at-15.25.20-300x150.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/CleanShot-2025-10-16-at-15.25.20-100x50.png 100w\" sizes=\"(max-width: 326px) 100vw, 326px\" \/><\/p>\n<\/aside>\n\n<p class=\"wp-block-paragraph\">Finally, in the <em>&#8220;Import Accounts to ChurchTools<\/em> &#8221; tab, select the last visible row and use the small triangle to scroll the table down until <strong>all your accounts<\/strong> are <strong>visible<\/strong>.<\/p>\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-25.png\"><img loading=\"lazy\" decoding=\"async\" width=\"934\" height=\"214\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-25.png\" alt=\"Screenshot: Make Accounts Visible in the General Ledger Export File\" class=\"wp-image-17149\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-25.png 934w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-25-300x69.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-25-768x176.png 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-25-360x82.png 360w\" sizes=\"(max-width: 934px) 100vw, 934px\" \/><\/a><\/figure>\n\n<p class=\"wp-block-paragraph\"><strong>Add a 0 to the beginning of all account numbers less than 1,000<\/strong> so that all account numbers are 4 digits long; in other words, write 0520 instead of 520.<\/p>\n\n<h3 class=\"wp-block-heading\">3.2 Optional: Customize Account Groups<\/h3>\n\n<p class=\"wp-block-paragraph\">Under &#8221; <em>Account Group&#8221;<\/em> in the <em>&#8220;Account Import to ChurchTools<\/em> &#8221; tab, <em>&#8220;Optigem Import&#8221;<\/em> is selected by default. If you have already created your own account groups in ChurchTools (see step 1a), you can now assign them directly to the relevant accounts here. <\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">&#8211; If the <em>&#8220;Account Group<\/em> &#8221; column is missing or left blank, ChurchTools will use the first account group from the master data in &#8220;Finances&#8221; by default during import.<br \/>&#8211; The accounts can still be adjusted after the import.<\/p>\n<\/aside>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#22c55e;border-left-width:0.5rem;background-color:#dcfce7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Tipp<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">If you&#8217;re not sure which account groups correspond to which accounts, or whether an account is an EB account or a donation account, you can search for the account in <a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2024\/07\/skr03.csv\" data-type=\"link\" data-id=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2024\/07\/skr03.csv\">the SKR03 chart of accounts<\/a> to find the correct account group and determine whether it&#8217;s a donation account, etc.<\/p>\n<\/aside>\n\n<h3 class=\"wp-block-heading\">3.3 Optional: Mark donation accounts<\/h3>\n\n<p class=\"wp-block-paragraph\">In this step, you select the donation accounts by entering a 1 or an x in the &#8221; <em>Donation Account<\/em> &#8221; column.<\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">&#8211; If the <em>&#8220;Donation Account<\/em> &#8221; column is missing or left blank, the account will not be created as a donation account when imported into ChurchTools.<br \/>&#8211; Accounts can still be edited after import.<\/p>\n<\/aside>\n\n<h3 class=\"wp-block-heading\">3.4 Optional: Select Opening Balance Sheet Accounts<\/h3>\n\n<p class=\"wp-block-paragraph\">In the <em>&#8220;EB Account&#8221;<\/em> column, you should also mark <em>the account<\/em> with a 1 or an x to indicate that it is an EB account. EB accounts are typically accounts starting with 9000. <\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">You can also manually designate these accounts as EB accounts in ChurchTools even after they have been imported.<\/p>\n<\/aside>\n\n<h3 class=\"wp-block-heading\">3.5 Optional: Fill out the tax form<\/h3>\n\n<p class=\"wp-block-paragraph\">In the &#8221; <em>Sales Tax&#8221;<\/em> column, enter the name of the tax rate. This must already exist in the master data in Finance (see point 1b). <\/p>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Hinweis<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">&#8211; If the <em>&#8220;Sales Tax<\/em> &#8221; column is missing or left blank, no tax rate will be assigned to the account when it is imported into ChurchTools.<br \/>&#8211; You can also add the tax rate manually after importing into ChurchTools.<\/p>\n<\/aside>\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#22c55e;border-left-width:0.5rem;background-color:#dcfce7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Tipp<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">We recommend that you compare the account groups in your template and in ChurchTools before importing and align them if necessary. Only entries that match 100% can be imported. <\/p>\n<\/aside>\n\n<h3 class=\"wp-block-heading\">3.6 Save Document<\/h3>\n\n<p class=\"wp-block-paragraph\">Once you have correctly adjusted all the data, make sure the <em>&#8220;Account Import to ChurchTools<\/em> &#8221; tab is currently selected. Save your adjusted account import via <em>File<\/em> &gt; <em>Save As&#8230;<\/em> in <em>CSV UTF-8 (comma-separated values)<\/em> format as a CSV file. <\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"284\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-5.png\" alt=\"Screenshot: Saving the General Ledger Export File\" class=\"wp-image-11351\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-5.png 659w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-5-300x129.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-5-360x155.png 360w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/figure>\n\n<p class=\"wp-block-paragraph\">Since the account import template contains multiple sheets, you&#8217;ll be asked if you want to save only the active sheet. Confirm this prompt. <\/p>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"316\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-6.png\" alt=\"Save a screenshot of the active sheet of the general ledger export file\" class=\"wp-image-11353\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-6.png 292w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/09\/image-6-277x300.png 277w\" sizes=\"(max-width: 292px) 100vw, 292px\" \/><\/figure>\n\n<h2 class=\"wp-block-heading\">4. Import Accounts into ChurchTools<\/h2>\n\n<p class=\"wp-block-paragraph\">In <em>the Finances module<\/em>, open the <em>master data<\/em>, go to the <em>accounts<\/em>, and open the <em>context menu<\/em> for the accounts.<\/p>\n\n<p class=\"wp-block-paragraph\">Here, select &#8221; <em>Import costs from CSV file<\/em>.&#8221;<\/p>\n\n<p class=\"wp-block-paragraph\">We&#8217;ll show you exactly how to do this in our guide, &#8221; <a href=\"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/import-and-export-finances-en\/how-to-import-account-data-from-a-file\/\" id=\"37906\">How do I import account data from a file?<\/a>&#8220;<\/p>\n\n<aside class=\"wp-block-group ct-artikel-zum-weiterlesen has-background is-layout-constrained wp-container-core-group-is-layout-79a8db7e wp-block-group-is-layout-constrained\" style=\"border-radius:8px;background-color:#f9fafb;margin-top:24px;margin-bottom:24px;padding-top:32px;padding-right:24px;padding-bottom:32px;padding-left:24px\">\n<h2 class=\"wp-block-heading has-medium-font-size\">Read more<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/import-and-export-finances-en\/how-to-import-account-data-from-a-file\/\" id=\"37906\">How to import account data from a file?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/churchtools.academy\/de\/help\/churchtools-module\/optigem-import\/wie-importiere-ich-projekte-aus-optigem-als-kostenstellen-nach-churchtools\/\" data-type=\"docs\" data-id=\"7628\">How do I import projects from Optigem as cost centers into ChurchTools?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/sync-finances\/how-to-synchronize-accounting-data\/\" data-type=\"docs\" data-id=\"7632\">How do I synchronize transaction data?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/churchtools.academy\/de\/help\/churchtools-modules\/verbindungen-konfigurieren\/verbindung-mit-optigem-herstellen\/\" data-type=\"docs\" data-id=\"7618\">Establish a connection with Optigem<\/a><\/li>\n<\/ul>\n<\/aside>\n","protected":false},"excerpt":{"rendered":"<p>To sync transaction data from Optigem to ChurchTools, you\u2019ll need to set up your chart of accounts in ChurchTools first. To do this, export your accounts from Optigem, edit the data, and then import them into ChurchTools. Here\u2019s a step-by-step guide on how to do it. 1. Prepare ChurchTools 1.1 Create Account Groups in Finance [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[692],"doc_tag":[],"knowledge_base":[224],"class_list":["post-70910","docs","type-docs","status-publish","hentry","doc_category-import-from-optigem","knowledge_base-churchtools-modules"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","pp_force_visibility":null,"pp_subpost_visibility":null,"pp_inherited_force_visibility":null,"pp_inherited_subpost_visibility":null,"acf":[],"year_month":"2026-07","word_count":852,"total_views":"4","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Victoria Weidemann","author_nicename":"vweidemann","author_url":"https:\/\/churchtools.academy\/en\/author\/vweidemann\/"},"doc_category_info":[{"term_name":"Import from Optigem","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/import-from-optigem\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"Modules","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/","term_slug":"churchtools-modules"}],"knowledge_base_slug":["churchtools-modules"],"_links":{"self":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/70910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/comments?post=70910"}],"version-history":[{"count":2,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/70910\/revisions"}],"predecessor-version":[{"id":70913,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/70910\/revisions\/70913"}],"wp:attachment":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/media?parent=70910"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_category?post=70910"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_tag?post=70910"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/knowledge_base?post=70910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}