Allocating Payroll to COGS and NON-COGS Accounts

I am looking for a set-up solution to facilitate allocating individual employee payroll expenses between Cost of Revenue accounts (COGS, but my company only provides services - no tangibles), and Operating Expense accounts.  For example, in a given week an employee may spend a portion of their time on equipment maintenance work (labour associated with maintenance to Operating Expenses) and the balance on providing services to customers (labour directly associated with service provision to Cost of Revenue).  Ideally, I would like to be able to capture this split at the time slip entry level.  I have looked at payroll expense groups (it seems you can only assign an employee to one expense group - so that doesn't seen to work), departmental accounting (it seems you can only assign an employee to one department - so that doesn't seen to work), and can't seem to figure out a clean solution.  Now, I'm new to bookkeeping and Sage so it's entirely possible I've overlooked something really rudimentary, but if anyone has any guidance on this issue, and proper COA and workflow set-up it would be greatly appreciated. Thanks.

  • 0

    Hi @Jeff Grant,

    Thanks for reaching out. Did you ever find an answer for this issue? If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.

    Time slips can be entered for employee's work to better track time and costs for separate products / tasks done for a customer or multiple customers.

    Also note that Sage Intacct is being offered to larger small businesses in Canada who are looking for a software solution that'll expand as business needs change. There's perhaps more flexible payroll options for this. Feel free to contact the sales team directly at 877-437-7765 to inquire and or request to be contacted via this site

    Point right https://www.sageintacct.com/company/contact-us

    Warm Regards,

    Erzsi

  • 0

    If you're getting beyond what Sage's built-in payroll will do, and are still basically happy with Sage otherwise, you might want to look at a 3rd party payroll software.  I have been very, very happy with Paydirt from qlab, it is a fully-Canadian company, excellent customer service, and very, very customizable.  It will even auto-allocate your wage burden expenses (employer share of CPP/EI/WCB/EHT....) to multiple departments or projects based on the split between pay categories.  I have one client who is allocating a supervisor's pay into 8 different departments each cheque, and it's all automatic.  When each payroll batch is posted in Paydirt, this creates a journal entry file for import into Sage.