Automatic Distribution of G/L Transactions to Accounts

[former_member313593]

Is see in the G/L Chart of Accounts there is a way to automatically distribute account transactions to the cost centers, but how does one do it to actual accounts so it affects the balance sheet and/or profit and loss?

Example:

Do a journal entry to account 100-000 for $2,000 and have it automatically go against

account 100-001 $1,500

account 100-002 $200

account 100-003 $300

US companies use this technique to spread bills such as electricity and other utilities to various departments.

Regards,

[JesperB1]

Hi Scott,

The cost accounting functionality is only for internal reporting and will have bo effect on the actual posted amount of which GL account that is posted to.

From your description I would think that what you are looking for is found under:

Financials -> either

-> Transaction Templates to set a posting that will distribute the amount according percentages defined.

or

-> Recurring Postings where you set up a static template that can be used.

Both these can be used to later post Journal Entries.

The Transaction Template could be set up:

100-000 Credit 100% ($2,000)

100-001 Debit 75% ($1,500)

100-002 Debit 10% ($200)

100-003 Debit 15% ($300)

When creating the Journal Entry you select 'Template Type' -> 'Percentage' and then the templae you added.

In the first row of the Journal Enter the amount of $2000, the system will then automatically split the amount according to the percentages set up in the template to the other accounts.

Hope it helps,

Jesper

[Tracy6]

Hi Jesper,

I got the save requirement. 

Thus could you please provide more details about 'Template Type' -> 'Percentage' ? Where can I find it?

Thank you.

Tracy