Example: Allocating Expenses with Percentages

This example shows how percentages can be used to distribute an expense to different accounts.

Chart of Accounts

You could set up an allocation account 99870 where unit code 1 is accessible and holds the department numbers for your company.

Chart of Account Allocations

You can then use the Chart of Account Allocations form to allocate the expense to different departments, based on percentages that you define. You would set up the Chart of Account Allocations form to contain these sequences and values for account 99870, unit code 1:

Allocation Account 99870


Sequence	Basis Type	Basis Rate	Distribution Account	Unit Code 1
1	Percentage	25.000	51551	100
2	Percentage	50.000	51551	300
3	Remainder	0	51551	500

In this rule, sequence 1 distributes 25% of the expense to department 100, using the distribution account 51551. Sequence 2 distributes 50% to department 300, and sequence 3 distributes the remainder (25%, but because you specified Remainder, it also includes any amount incurred from rounding) to department 500.

Journal Entries

This is the original journal entry for the expense:


Account	Debit	Credit	Comment
99870	10,000.00		Initial entry to allocation account
2000		10,000.00

This is the allocation entry that is generated during ledger posting:


Account	Unit Code 1	Debit	Credit	Comment
99870			10,000	Offset to initial entry
51551	100	2,500.00
51551	300	5,000.00
51551	500	2,500.00