How to set up integration between ParishSOFT Family Suite and ParishSOFT Accounting
With integration you will find closing a batch in Family Suite Offering, will be posted a deposit to the revenue accounts in Accounting.
There are 3 major steps in the integration process:
- Integrating the databases at the Parent organization level or the Individual organization level.
- Enabling user permissions.
- Mappings your funds and your batches.
After integration process is completed, to post an offering batch, you must Assign a Revenue Account to the batch.
Before beginning, you will need to take the following steps in Accounting:
- Get your ParishSOFT Accounting Database ID.
- Make sure that every staff member who will be closing batches has an account in ParishSOFT Accounting and permission to make deposits. You will need to know the Accounting username and password of every user who will be closing batches.
The first step is to integrate the databases. To do this you must have the administrator rights in Family Suite. You will also need your ParishSOFT Accounting Database ID. If you do not know your Accounting Database ID, contact ParishSOFT Accounting support.
- Log in with an acccount that has administrator permissions.
- From the Administration tab, select Organizations.
- Select your organization from the list on the left side and click the Edit Organization Record button.
At this point, the CN Membership and CN Accounting applications are integrated at the organization level.
Enabling User Permissions
Now that your databases are connected, you will need to link the user accounts in Family Suite to the accounts in Accounting.
From the Administration module, select the Manage Staff tab.
Go through the following steps for each person who will be closing batches in Family Suite.
Select a staff record to open the assignment access rights.
Click Edit Details. Check the Offering checkbox in the Accounting Integration section, and click the gear icon.
Enter the Accounting username and password and click Login.
Alternatively, a staff member can enter their own Accounting username and password by going to the Offering module and selecting the Settings tab. From this screen the user can enter their credentials and click Save.
The third step is to map your funds. Each fund needs to be mapped to a revenue account (or a Liability Account or a Dedicated Account) in ParishSOFT Accounting. Each fund in Family Suite can only be mapped to one revenue account in Accounting. However, a revenue account can have many funds mapped to it. When you start integration, you will have to map every fund you are using to a revenue account.
To map funds, go to the Offering Module and select the Funds tab.
Click on the Edit Fund icon next to the fund.
Click Edit to edit the fund.
Then select a Revenue Account from the drop down menu, and click Save.
If you have funds that you are no longer using, you do not need to map them to revenue accounts. However, you should give an end date to funds you do not want to use.
After you have mapped all funds, integration is complete.
After Integration: Mapping Batches
You must assign a revenue account to each batch before you close it; after integration is started, a user will be required to assign a bank account when they create a new batch. If any batches are open when you set up integration, you will need to assign them bank accounts so you can close them.
To edit existing batches, go to the Offering module and choose the Batches tab. Click on the pen and paper icon next to each open batch.
When the window opens, click Edit.
Select a Bank Account from the drop down menu and click Save. Then click Close.
This will assign a bank account to the batch. A user who creates a batch will have to pick the correct bank account from the list.