CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Integrator Discussion (Moderators: JoeMurray, Parvez, pkeogan) »
  • Financial types and accounting
Pages: [1]

Author Topic: Financial types and accounting  (Read 1621 times)

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Financial types and accounting
November 22, 2013, 01:32:38 am
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.
Developer at Edeveloper / CiviCoop

Detlev

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
    • Software für Engagierte e.V.
  • CiviCRM version: 4.5
  • CMS version: Drupal
Re: Financial types and accounting
November 22, 2013, 03:48:24 am
What about using separate Payment Instruments for each bank account?

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Financial types and accounting
November 22, 2013, 05:25:01 am
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.
Developer at Edeveloper / CiviCoop

Detlev

  • I post occasionally
  • **
  • Posts: 68
  • Karma: 2
    • Software für Engagierte e.V.
  • CiviCRM version: 4.5
  • CMS version: Drupal
Re: Financial types and accounting
November 22, 2013, 07:52:56 am
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

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Financial types and accounting
November 22, 2013, 02:01:23 pm
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?

« Last Edit: November 22, 2013, 02:08:43 pm by joanne »

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Financial types and accounting
November 26, 2013, 01:55:16 am
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.
Developer at Edeveloper / CiviCoop

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Financial types and accounting
November 26, 2013, 02:42:07 am
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

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Financial types and accounting
November 26, 2013, 03:31:23 am
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.
Developer at Edeveloper / CiviCoop

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Integrator Discussion (Moderators: JoeMurray, Parvez, pkeogan) »
  • Financial types and accounting

This forum was archived on 2017-11-26.