Payroll

Hello all,I am new to Acumatica. What is the recommended approach for bulk importing of data from external timekeeping systems into the Payroll module?Specifically, my company is a franchisee of QSRs and the majority of our timekeeping is performed at the restaurant level through our POS system. We can currently get the data exported from our system either as a CSV or JSON formats. My question is, what is the recommended approach for importing such data into Acumatica’s payroll module for processing? We do not plan on using the Timekeeping features of Acumatica at our restaurants and entering the data manually is entirely impractical given the number of employees, so neither of these options will work. The system does not seem to expose a Web Service endpoint that could be used, nor did I see an “Import Scenario” that would be appropriate for bulk import. Any suggestions?Thanks!

Is there a way to setup a Flat Rate Earning code that could be added to the Employee Compensation Tab of the Employee Payroll settings ?? This Flat Rate Code would then automatically  be picked up on each Payroll run so one doesn’t need to import a Earnings file or hours file each run. I have a client that doesn’t want hours to appear on the paystub for the Salaried Employees as they are being paid a set amount whether they work 30 hours or 50 hours. This desire is to prevent any lawsuits on overtime for the Salaried positions.Thanks

Every rep firm we work with requires Line Item details on commissions reports.  The Commission Details report isn’t at all what it is named, it’s just a list of invoice numbers.The Commission Details report is not actually a “report” (.rpx), but there is a reference to PX.Objects.AR.ARSPCommissionDocEnq.  I hope that CommissionDocEnq indicates there is an enquiry/inquiry somewhere behind the scenes. Has anyone created a project to add Line Item information to this report?

We just switched over to Acumatica and processed our first payroll in the system. After processing, I realized an error in the HSA deduction/direct deposit where the HSA deduction is essentially being doubled up. In our old system, we could tie the HSA deduction to a specific HSA direct deposit account, so the amount specified in the deduction set up was automatically directed toward the account set up under the HSA direct deposit code. Acumatica apparently does not have the ability to do this, so our implementation team advised us to set up the HSA account under direct deposits, and specify the dollar amount to deposit into the account with the remainder going to the regular checking account. Unfortunately, this is actually doubling up on the HSA deduction.For example, say an employee’s net pay was $1,000, including an HSA deduction of $25. They should actually receive $1,000 in their bank account because the HSA deduction was already factored into the calculation of their net wages.

We are looking at outsourcing payroll and I wanted to here from others about what they are using.  We are a construction company and do work in multiple states.  We are currently looking at the following:WorkForce GoMiterLumberPlease let me know your thoughts if you use any of these softwares. Thanks,Jeff G.

When releasing in preproduction environment the following error is displayed: I have tried to replicate in my local environment this error but I don't get it, anyone has any idea?

Does anyone know if you check the box for use catch up contributions if it will look at the birthdate in the system? So, if you check it for everyone, even if they are not age 50 or older, it will look at the birthdate and NOT the check box? 

Hi We are having some internal issues regarding timecards approval status. Our approval status itself works fine, but once the employees time is approved, we would like to limit the possibilities to put the actual timecard to hold status.  Our final step in the approval process is the finance department, and once the timecard is approved, we would like to disable the hold button, exccept for members from a specific group in our company tree.  Is that possible?

Currently the Payroll Direct Deposit amounts are posted to the Cash account in detail instead of batch total.  I do not see a setting to update this nor can I find a document addressing this behavior.  I am sure I must be missing something… Thank you 

Hello Everyone,I was wondering how the payroll module pulls taxable wage amounts. Let’s talk about the California SUTA wage base amount. Say an employee has gross wages of $10,000. The taxable wages for the California SUTA will stop at $7,000 (unless overriden of course). Does it stop at $7,000 because Acumatica is pulling this limit from the tax symmetry engine?I am just trying to get confirmation on how this works.Thanks

We accidently withheld a 401K contribution who isn’t currently enrolled in it pre tax. How do we fix this??? HELP

ISSUE: Logged time from Service Appointments transferred to the employee time card is always not checked as “Billable”, so we manually have to check each line in order for it to be calculated correctly.POSITIVE POINT: Any logs coming from projects are automatically checked as billable. As you can see below, all items coming from appointments are unchecked. Those that have projects involved are checked.If I go into the Earning Type Codes, I can set the default coming from projects to be ‘Billable’, which is great! QUESTION: How can I do this for any logs coming from Service Appointments? Any ideas?Thanks in advance.

Hello all,I have been looking out for ways or steps/guide for processing commissions via Payroll in Acumatica. Would really be grateful. Thanks in advance.

Scenario 2)  Vacation days must count towards weekly over time.  We have a PTO bank for vacation and must deduct any vacation hours from the bank.  My Earning Type code is setup as “Time Off”. I’m looking for ideas on how I can have vacation hours taken still count towards the weekly OT. Thanks in advance. 

Hello! Does anyone have any clients who accrue their PTO by anniversary date and not calendar date? How do you handle that? Thank you!

Has anyone figured out how you would make a manual entry to an employees PTO bank. For example, if the accrual was setup wrong, or the company decided to give them some extra time for whatever reason. I can’t figure out how I would adjust the time they have for that pto. 

Hello community,How can we split the labor burden from payroll to projects by number of hours worked? So its like if a labor worked for 50 hours for 2 projects (30 for Project A & 20 for Project B) in a week how can I setup the system to evenly distribute these amounts into projects?Thanks.

Hello!We have 2 company benefits that we give the employee the option to pay the taxes on, so if they ever need to use it, they won’t be taxed on it.  The deduction is based on a formula, and doesn’t fit in to any of the preset options on the Deduction/Benefit set up (of being calculated as a flat amount, % of gross, % of net, % of custom, or amount by hour) The formulas are ((employee hourly rate x 2080)/52) x .00289 for the 1st benefitfor the 2nd benefit ((employee hourly rate x 40 x 0.60)/10) x 0.052Any suggestions on how to set this up? Thank you!

Has anyone ever had to make mass adjustments to multiple employees taxable wages before?When you go to the Taxes tab on the Paychecks and Adjustments screen, select a tax code you can manually enter taxable wage adjustments in the right hand pane. This is great but if we need to do this to 100-500 employees doing this manually is quite difficult and time consuming for the customer.Has anyone had any success? Screen: One of the import scenario’s I have tried:Import By Scenario with Error:There is clearly a Wage Type 

Two employee paystubs out of the entire company will not print with the rest. They used to print along with all the other paystubs but after a system update in February, they stopped. 

We just hit an error trying to Calculate Payroll we have never experienced before. We went into the trace and unfortunately it is another language to me…. See below. We have check the employee set ups, payroll employee settings, time activities, PTO banks, Deduction sequences, everything I could think of and I read through another post hoping for answers and nothing worked. This is happening on our three newest employees only (this would be their first check). If anyone has any ideas please send them our way… 

How do you make changes to time in the Work Crew Time Entry screen that is already in “Completed” status?

I am currently trying to configure an ACH file that my customer uses for payroll, and I am not sure how to have the transaction type change as needed. Currently, the code is 22, but if a check is $0, it needs to change to a 23 to indicate that it is a pre-note. I cant seem to find anything for this in the .txt file or the export scenario - what is the best way to go about this?

Hi. We are using Acumatica for time capture and payroll processing.When users are entering time, they should only be selecting cost codes that have Labor account groups setup for them in the cost budget. Right now, Acumatica will allow them to see and select all of the projects cost codes.To bypass this, we’ve created TASKS that only have Labor account group cost codes in it - then setting this to default task.The problem with that is there are multiple areas in Acumatica that the task then defaults to our Labor only task - so accounting has to change this each time.Would be ideal if there was a way for only certain account groups to be selected and seen at the time entry screen.

We are testing and hoping to implement the canadian payroll.  So far it is working ok, but we have a situation where we will need to start charging payroll taxes on the distances travelled when the next union agreement is implemented.  we didn’t have to do this before because the amount charged per km was under the limit specified.  The new amount is above that threshold and therefore need to charge the taxes on the amount over the threshold.  How do we go about doing this as we can’t add km on the timecard? whatever process it is to do this, we would have to do it to about 20-30 employees a week.