Ledger Allocation Rule that leaves source accounts balance intact

(0) Share

Report

Posted on by Frank Hamelly | MVP...

46,532 Super User 2025 Season 1

How do I configure an allocation rule that will read the balances in a range of accounts (for example - 700000 thru 750000, my payroll accounts) and use that sum to credit an allocation account (799000) rather than credit the individual source accounts? We want the source account balances unaffected.

Thanks

*This post is locked for comments

All responses (3)

Answers (2)

Verified answer

Frank Hamelly | MVP... 46,532 Super User 2025 Season 1 on at

Like (1)

Report

RE: Ledger Allocation Rule that leaves source accounts balance intact

Thank you sir. That did it! Also, I discovered you can specify a range of accounts to use as the basis for the allocation. The allocation rule will sum the transactions in all accounts in the range and allocate the sum out to the offset account specified in the Offset tab.
Suggested answer

ZvikaR 142 on at

Like (0)

Report

RE: Ledger Allocation Rule that leaves source accounts balance intact

Did you look at using "Ledger Allocation Rules" while using the "allocation basis" option?

It sounds like this should address your requirement
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Ledger Allocation Rule that leaves source accounts balance intact

Hello Frank,

To credit account 799000 you can simply select this account in the offset tab of the allocation rule form.

However, I do not think that it is possible to have only a single allocation journal line created for the balances on accounts 700000-750000.

Best regards,

Ludwig