I have several divisions of income such as Broadband Services, Backup services, Website Services etc.
I want to allocate income to the sales income account and use tracking codes to separate the income into broadband, backup, website etc.
I will have expense accounts such as outsource work, utilities, software purchases etc and I will use the same tracking codes to allocate them to broadband, website etc.
However I have no way to link a purchase or expense to a specific client. For example I might buy 1TB of backup storage for one client. This will go into the Utilities expense account and be allocated to the Backup Tracking code.
I have looked at disbursements, but the way disbursements works does not work in the way that I want it to with regards to the way the details are invoiced as I don’t want to pass the expense on - I want to make a profit on the sale and I don’t want to show my cost price and my commission on the sales invoice. Also I am not able to allocate disbursements to expense accounts (to categorise the expenses) that I want (even though they are not company expenses) and also some things I buy are never invoiced to the client directly as a product. For example my clients buy a backup service, but they don’t pay for the backup software as the cost of the software is incorporated into the backup service price. I also frequently buy multiple items for different clients in one purchase invoice. Thus disbursements doesn’t work for at this point in time.
I could create a broadband income and broadband expenses account and create tracking codes for each client, but this means that the outsourced work expenses and utilities expenses are all lumped up in the broadband expenses account and this approach will not work for the sales division as I want the inventory reporting information and I want to break the sales up into computer sales, software sales, whiteboard sales etc so I need the tracking codes for computer sales, software sales etc.
So I am thinking a better solution for both myself and perhaps for other people would be to have an option where you can allocate to whatever account you want, add a tracking code which would track whatever you want such as project/income for division etc and in addition have an option to specify which client an expense is applicable to.
The end result that I want to accomplish is to ascertain how much net profit I have made per client and I cannot do that unless I can specify which client an expense has been incurred for.
I hope that I have made sense here. Thank you