I need to create a journal entry report for payroll to send to a client. I have QBDProplus. They use classes to define payroll expenses by their division/departments. They would also like to be able to pay employees working in multiple departments (classes) and have all expenses allocated to the proper department. They have several management positions that are allocated by % to multiple departments.
I have unsuccessfully tried to consolidate this report where all the alike accounts are added together and reported - to have a more simplified report. Attached is the journal I modified from Accountant & Taxes reports. I have been told to export and use excel to consolidate but this will not work with multiple clients and over 500 employees.
As for the allocation, I have been told to produce multiple checks for employees for each pay period. Can't imagine having to do that.
If I upgraded to Enterprise Gold edition - would I be able to create this report and allocate payroll as needed?
I appreciate you for sharing your detailed concern, Wcos2015.
The option to assign classes to accounts, items, and names is only available using QuickBooks Enterprise. Since you're using Pro Plus, you can still use class tracking for transactions but the option to select which to assign classes is not available.
However, the Class feature is mainly used to track job costs for your company. That's why it won't flow into your Payroll Liability Items (such as the taxes) even after the right classes were assigned to the wages.
Creating separate paychecks for each of their wages would be the best option to successfully allocate the amounts to the correct classes.
Hope you’re doing great. I wanted to see how everything is going about paying your client's employees working in multiple departments you had yesterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.
Looking forward to your reply. Have a pleasant day ahead!