We're beginning to sell bundles of our products and would like to allocate the revenue of the Bundle item across up to 3 revenue accounts based on percentages.
So far the only method I've found to do this is:
- Create a new Item for the bundle
- Create a new deferred revenue account for the bundle
- Create a new revenue account for the bundle
- Build an allocation schedule for the revenue account that will take total dollars at month end and allocate back to the other 3 revenue accounts by % of total
End result would be deferred is correct for bundles, the new revenue account balance is $0, and the original 3 revenue accounts have been populated with the correct percentages.
I've looked at Kits/Packages but it would seem that that would do the same thing essentially given they book revenue to a single account. I also looked at Groups but given our pricing is dynamic I don't believe that would work either.
Am I missing a better option?
Ex:
Bundle Item sales price is $15,000
Revenue Line 1 - 60% of total
Revenue Line 2 - 30% of total
Revenue Line 3 - 10% of total
Invoice populates Bundle Deferred Revenue Account.
Revenue recognition at month end populates Bundled Revenue Account
Allocation Schedule creates a JE at month end which takes ending balance of Bundled Revenue Account and allocates it 60% to Rev Line 1, 30% to Rev Line 2, and 10% to Rev Line 3.