Ledger Allocation Rule that leaves source accounts balance intact

(0) Share

Report

Posted on by Frank Hamelly | MVP...

46,633 Moderator

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

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

ZvikaR 190 on at

Like (0)

Report
Copy link

Link copied!

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

It sounds like this should address your requirement

Was this reply helpful? Yes No
Verified answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No