I have entered details for each of our employees and then under “Payslip Items” I created the very basic items such as salaries and transport allowance. The salary was pointed to the salary account and the transport allowance to the transport account.
I then went to payslip and created one for the month of June. After creation, I chose to “Spend Money” wherein I opted for the bank transaction, created a new bank transaction. Here, information such as the employee details and the net pay appears with the entire amount being passed on to the “Employee Clearing Account”.
Two things here:
Why does the account detail as reflected in the “Payslip Items” not get carried over to the “Bank Transaction”. Ideally, it should debit salary with X, transport with Y and credit bank with X+Y
How do I clear the clearing account? If it has to be done manually, it would be a lot of trouble going through the Payslip summary statement and transferring each employees amounts one by one to the salary and transport accounts respectively. Ours is a really small organisation where I could go through the trouble but for a medium sized company I would assume it would be a task by itself.
After a pay slip is generated you technically haven’t paid the employee, you have just accrued or recognized the need to pay the employee.
Manager places this amount which has to be paid to the employee into a lability account. It is wrong to credit cash/bank or deduct it from bank/cash immediately because salaries are accrued first before they are paid to the employees.
Now to clear the amount in the employee clearing account, go to the bank
account you want to spend money from to pay the employees. Select spend money and select the employee clearing account. Now select the employee in question and enter the amount you are paying.
This is the best way to do salaries. Manager keeps track for you the balances due to be paid to employees perfectly.
Because the bank transaction does not involve those details or the accounts they are posted to. They are on the payslip. Paying an employee is equivalent to crediting your bank account and debiting Employee clearing account. Salary and Transport were debited when the payslip was created and Employee clearing account was credited.
Thank you friends I have now understood that part of it. I guess I got confused cause I saw all the amounts lying in the Employee Clearing Account and did not see the relevant numbers under the Salary and Transport allowance head.
After your help and having cleared the employee clearing account, I noticed that the amounts still did not reflect in my expense account and that is when I noticed all those amounts lying in my Suspense Account.
When I defined the payslip items, I had selected Salary and chose the salary account and for transport allowance I chose the Transport Allowance account. Would you know why it still debits those to the suspense account?
Attached are screenshots of the Suspense Account, Payslip in Edit mode and the bank transaction in edit mode. I hope that these pictures will help you help me understand where I have gone wrong
Now go to settings and give us a snap shot of the ‘Salaries’ payslip items settup under ‘Payslip items’ settings. Should be under earnings. We have to know the liability (credit) and Expense (debit) accounts you selecting for that payslip item.
If required, I could send the entire back up to anyone if it can help. And … no, nothing confidential in it right now as we are still setting it up and figuring our way forward.
Hi Joe,
When I click on the suspense account, I see the list of all the employees with their amounts. I click edit on this particular employee and get:
This is the key to your problem, @Paparazzi. If all your employees’ payslips are in Suspense, you are making a systematic error. Based on what you have shown so far, I don’t know what that error is. But I would like you to try one thing.
Edit James Merry’s payslip. Where the default, gray “1” appears for Qty, actually type in the number 1. Then Update the payslip. Tell us what happens. I just tested this, and it did not make any difference, but something subtle is obviously going on.
Can you also post a screen shot of your Chart of Accounts under Settings? I am looking for unusual things you might have done with account setup or naming that could be causing the problem.
Hello Friends,
Sorry, we had closed by the time I saw your message and since we only had the desktop edition (since we were setting it up), I did not have access. Following my inability to provide you the information, I have now subscribed for the cloud edition so that I will be able get my data at any time
With regard to the chart of accounts, the part that relates to salary & wages is as below:
I thought perhaps we were making some progress! As @Joe91 noticed, there seemed to be a problem with your naming of accounts.
Your payslip earnings item, Salary, is set up to post to the expense account, Wages & salaries. That is the name of the default account for earnings items.
However, your chart of accounts shows that you have renamed the default account as Salary, with account code 220100. That is the designation that should show when you set up the payslip item. But it doesn’t. So that is a bug. I will submit a separate bug report on that problem.
The confusing thing is that while the new name for the account does not show when you set up the payslip item, it does show in the chart of accounts and on the Summary page. And payslip entries using the earnings item with the old account name show up under the new name on the Summary page. Despite the discrepancy, such payslips do not go to Suspense.
I think this is a problem for @lubos to examine. I will invite him into this topic.
Thanks Tut Really appreciate the help you and Joe have extended.
So, for now, I’ll just go ahead and enter all the other information … I’m getting my colleague to all the information from January onward as it is not too voluminous. Once the bug has been fixed, I guess either the problem will rectify itself or worst case is that I’ll just have to go back and edit the payslip for about 6 months. This again is not too much given the benefit that the cloud edition of Manager will give.
Once again thank you … and please … if it is not a problem. can you let me know when the bug has been fixed by re-visiting this thread?
I have now understood that part of it. I guess I got confused cause I saw all the amounts lying in the Employee Clearing Account and did not see the relevant numbers under the Salary and Transport allowance head.
