There are two ways to get your bank transactions into the system. You can either import them via an export from your banking website, or via an automatic integration. This article explains both methods.
Automatically via Plaid
You will need the Link Bank Accounts permission to perform this action.
We've partnered with Plaid to directly integrate with most major banks and easily import transactions into your accounting. With this integration,
Your banking transactions will automatically be imported into the system daily.
Keep your accounting up to date with money coming in and out of your organization.
Using banking rules, incoming transactions can be automatically categorized and appear in your registers.
To get started, go to Accounting > Banking from the left hand menu and then click on the "Link Account" button at the top.
A pop up will appear introducing you to Plaid and how the process works. Click on the "Connect Bank Accounts" button.
Once you do, a pop up will appear which guides you through the process of finding your bank, logging in, and authorizing your transactions to be imported into One Church periodically. This is done in a safe and secure manner. Your bank credentials are not shared with One Church. For more information on how Plaid handles security, please see their website at https://plaid.com/safety.
Once you've chosen the bank accounts you want to connect, you'll be taken back to One Church where you can link them to the register account you want transactions to be imported into.
Important: only cash accounts and credit card accounts can be used to import transactions into. This is set via the Special Usage field when editing your chart of accounts.
If you need to create a new account to import transactions into, use the cog menu to the right of the dropdown to create one (choose Add New after opening the menu).
You can also indicate how much transaction history you want to import. By default, this will bring in the last 12 months of history. The amount of history that can be imported depends on the bank you are connecting to.
Once you are done mapping the bank accounts to your chart of accounts, click on Save to complete the process. It may take a few minutes before historical transactions are imported. The table will not refresh on it's own but you can come back later to click on the refresh button to see if the initial transactions have been imported.
After the initial import, the system checks for new transactions multiple times per day.
Important: To make changes to previously linked accounts or to connect new bank accounts, click on the same Link Account button at the top of the screen.
If you have trouble...
If your bank is not found in the list or you have trouble successfully connecting to your bank, please see this article for possible reasons why. If you still need assistance connecting your bank, please reach out to plaid support using this link.
For general Plaid help, visit their help center.
Manually via spreadsheet
Instead of having your transactions be imported automatically (see section above), you can instead import them manually. To do so, first go to your banking website and download a CSV of your banking transactions.
Afterwards, go to Accounting > Banking from the left hand menu within One Church. Choose the register account you want to import the transactions into and then click on the Import button.
A pop up will appear where you can upload the CSV file you got from your bank. Please note that it must be a CSV file and not an Excel file. If you have an Excel file, simply open it in Excel and save it as a CSV file.
Alternatively, you can click on the "download template file" button near the top if you want to manually add the transactions to a spreadsheet to then import.
Once the file is uploaded, mapping fields will appear. Choose the columns from the spreadsheet that correspond to the data being imported. The system will make a best guess as to which columns contain the needed data, but always review what columns it picked for accuracy.
Once you've mapped the fields, click on the Import button at the bottom to bring in those transactions.
Important: this import tool will automatically ignore any transactions that were previously imported. Specifically, it will ignore any transactions that have the same Date, Description, and Amount as any transaction already in the system.