There are certian payments paid annaully on behalf of the organization and charged to P&L on monthly basis. A Non-Inventory items is create for proper mapping and review the details accordingly. It is requested to please add Non-Inventory Items for Journal Entry tab.
In addition, there are also certain payments which are paid annaully on behalf of employees in advance and record as Prepayments. A portion is deducted from the employee’s pay and rest is charged to P&L as organization cost.
A report should be availible to identify prepayments and actuals balance at given period, including necessary adjust if an employee leave the organization.
We have tried multiple ways to obtain such information while tagging the employees or non-inventory item with custom reports but remain unsucessful.
We would apprecaite, if Manager can guide us to record and pull such information. It is also requested to add employees and non-inventory items in Journal Entries and Payment tabs.
What is your use case? Non-inventory items have no impact on the balance sheet. They are used as shortcuts for purchasing and selling. Why would you use them in a journal entry?
Any are you trying to select an employee directly in a journal entry? Employee selection is possible once you have selected, for example, Employee clearing account. An employee is not an account from or to which you transfer funds. Employees are subsidiary ledgers of control accounts. And all potential control accounts can be selected in journal entries.
I already addressed non-inventory items in journal entries above.
In payments, you can already select both employees and non-inventory items in appropriate places. So no changes are required.
You should be able to get everything you need by drilling down from the Summary on appropriate accounts. The exact procedure will depend on how you set things up. After drilling down, you should be able to view all debits and credits. Copy to the clipboard and manipulate to the desired format in a spreadsheet.
Manager is never going to provide every report you can dream of. That is why the copy capability exists.
Agreed it happens in a lots of reports and really helpful!
There is no common/unique field in prepayment and while expensing out the prepayment. If common/unique field is available then the purpose is fullfill.
It’s not about the dream; I hope there could be a lot of user who needs exact break-up of outstanding balances for audit and tax purpose; it is more critical.
@Rajwani, it is impossible to offer more detailed advice without knowing exactly how you have set up your accounts. If you set them up in any reasonable fashion, all the information you need is readily available. I regret to say you have a history of asking for special features for what you think is your unique situation, only to discover that what you want is already built into the program.
We have learnt a lot from Manager and respecting the same as it function. I am not trying to embed any uniqui requirement here. I am just requesting a break-up.
Below is the example:
Organization pays in bulk to third party 100,000 per year in July for x no. of employees. Unable to tag all employees therefore tried to opt for Non-Inventory Items for each employee.
A contribution of employee varies, one of the employee contribution is 1,000
An Employee bears 30% i.e 300 per year (25 per month)
P&L 70% i.e 700 per year (58 per month)
Contribution is adjusted through payslip 30% as employee deductions and 70% as employer contribution.
As of December, the balance of an employee is 502 but overall prepaid would be xyz with different running balance of each employee. As briefed above,
- if a bulk single payment of 100,000 is posted then how one can distinguish the break-up of each employee?
- if one tries to enter through Non-Inventory items which is still a longer process but may be one of the option comes in our mind but it is not available in payslip.
I hope, I have shared enough information to understand the need and situation. It is hopeful with your guidance we may be able to opt for wise solution or procedure.
@Rajwani why at all use Non-Inventory items when dealing with Payroll issues? You still did not provide as requested by @Tut the way you have setup your accounts so how can you expect any help?
Frankly I do not understand this approach. If it pertains grants or loans to employees you can search the forum how best to do this, but using non-inventory items is just weird. As recommended try first to use the program as it is designed. Yes, as you can see from the many ideas, some of which realised, others ignored, there are many items and things that users want changing.
It is up to the developer to chose those that he finds worth implementing. From the little I have seem it often seems motivated by a convincing use case that is defensible not only for the applicant but for the larger user group of Manager.
@Rajwani, I confess I am unable to follow your explanation. What you have shown seems to have no relationship to any feature of Manager. I cannot help you.
We have made the payment as one single payment and recorded in prepayments GL. We have not set-up the accounts yet. We tried way in which the information can be recorded and revealed in a desire break-up and accounts to divisions respectively in an automated way.
I understand, a program should not be changed for only one of the user. I am here to seeks all the possibilities a Manager can offer and support so we can correctly record the same and obtain the desire information using the guided parameters.