Financial types and accounting

[jaapjansma]

Hey all,

I have a question a client of us uses the financial types to identify the type of sponsoring he receives. For example for emergency flights, for medicine flights, for mission flights etc....)

But he also wants to track in which bank account the money came in.
So in the accounting sections we got different bank accounts (numbers 1920, 1930 etc) but as we record a contribution we record the financial type and the financial type is also linked to the accounting scheme.

How do I configure the contributions in such a way the contribution is recordded on the right bank account and on the right reservervation (e.g. mission flights)?

Right know we use the financial type to indicate the reservation and we have put a custom field on contribution recording the bank account (but not linked to the accounting section of civi). So we have a kind of a solution what works for the moment but I was just wondering if I missed something about the financial types.

[Detlev]

What about using separate Payment Instruments for each bank account?

[jaapjansma]

That could be a possibility but it still seems not logical at all. And it means that as we have three possible funds and three bank accounts we end up with nine possibilities... And it in the accounting section it still doesn't get added in right accounts.

[Detlev]

In my understanding, the account number associated with the financial type, should be similar to the respective account number in your finance accounting system.

So, if you export the data from CiviCRM, you can import them into your accounting system easily. (ideally you do not import each single row, but only the sum per account per month).

What is the use case for storing the bank account, where the money came in? My guess: certain bank accounts match (more or less) to certain contribution reservation (e.g. medicine flights...)...

[joanne]

From your initial description I had assumed that the income for emergency flights could come in via any of the three bank accounts and ditto for the other flight types.

Is that the situation or does all the income for emergency flights comes in via bank account 1920 (say); all the income for medicine flights comes in via bank account 1930; all the income for mission flights comes in via bank account 1940?

[jaapjansma]

Hey Joanne,

No all contributions come into the bank accounts (mixed up). So bank account 1920 has a mix of donations towards emergency flights and towards other types.

Detlev: The reason I want the bank account is that civi should have balance on the bank account which is accurate.

[joanne]

I am not an expert, but it seems to me that if you are looking for a non-code solution that leads to the correct balance in each of the revenue accounts and in each of the bank accounts then you will have to have nine financial types ie. all combinations of the 3 revenue account (emergency, medicine, mission) and the 3 Asset (BANK) accounts (1920, 1930,1940).

You haven't said how the contributions are recorded.  If it is offline then choosing descriptive names for you financial types (eg Emergency1920) will make the choice of financial type easy for office staff.  If it is online then you will need to set up your contribution pages carefully.

[jaapjansma]

So back to my question I have to setup a financial type for each revenue account and each bank account (emergency 1920 and emergency 1921, mission 1920 and mission 1921)? Am I right? Than I know I understand the financial type right and I will keep my solution as it is because that is easier for my client.