Hello:

I use Quickbooks Pro 2006 for Mac. As part of our accounting requirements (per our accountant for reporting) we must “split” many of our general expenses across four operating regions with each region’s portion of an expense being different based on its relative size in our total company…region 1 = 20%, region 2 = 3%, region 3 = 65%, region 4 = 12%. What we currently have to do for each expense is to hand calculate each amount for the four regions then enter each amount in the detail of the expense entry.



Our accountant is not familiar with an easier way to do these entries in Quickbooks for Mac, but I have to believe that with the sophistication of Quickbooks there is a way to enter a spit formula calculation and be able enter the total expense amount, tell the system to split it and have it automatically calculate and enter the four separate amounts.



Please let me know what possible alternatives I have to make this process automatic. Needless to say, it gets old and frustrating having to calculate these splits on many expenses monthly.



Thank you for any help you can give.

I can only get you half way there if at all, I think. It has to do with turning these expenses into something like an inventory item only there is a way to affect the pricing of those so its not a fixed number but rather a calculation. I have recently quit my job where it was used so I can't go play to find out more and I can't quite recall the term QB used... it was like "groups" or something like that? Sorry but that's my best guess... and it could be a nutso one too LOL.