# Dataloss when changing accounts on "Payslip Deduction Items" items

**URL:** <https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793>\
**Category:** Uncategorized\
**Created:** [April 26, 2019, 9:02am UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793 "2019-04-26T09:02:40Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 26, 2019, 9:02am UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/1 "2019-04-26T09:02:40Z")

</div>

When you setup payslips, the Payslip Deduction Items by default use an account called “Payroll liabilities”.  
If you later change that account to a new account, all entries that use this “Payroll liabilities” account are altered and are now put on the suspense account (banks tx, journal entries) etc.

The entries don’t show up in the suspense account of the bank account (the uncategorized column)\> They do however show up in the general suspense account.

Also, the “Payroll liabilities” account is nowhere to be found.

I would have expected this to remain active, as I have entries on this account.

If I restore the edit of the “Payslip Deduction Items” (make the account empty), things are back to normal.

It also does not adhere the lockdate.

I assume this happens with other built-in accounts as well

Also, if you’ve editted the entries, and change the setting, it updates everything back. Including things it shouldn’t

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 26, 2019, 12:15pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/2 "2019-04-26T12:15:30Z")

</div>

What you describe is not loss of data. As you said yourself, transactions are moved to _Suspense_ because they are now incomplete. When the action that moved them there is reversed, “things are back to normal.”

> [@joris\_manager](#):
>
> If you later change that account to a new account…

Please clarify this remark. Are you changing the name of the account in the chart of accounts, or changing the account to which a specific payslip item is posted?

> [@joris\_manager](#):
>
> entries don’t show up in the suspense account of the bank account (the uncategorized column

Bank accounts do not have _Suspense_ accounts of their own. There is just one _Suspense_ account. All incomplete or erroneous transactions are posted temporarily to that account.

> [@joris\_manager](#):
>
> the “Payroll liabilities” account is nowhere to be found.
> 
> I would have expected this to remain active,

But you apparently changed it, if indeed that is what you meant. Why would you expect it to still be unchanged?

> [@joris\_manager](#):
>
> It also does not adhere the lockdate.

That is because you are not modify a transaction, you are modifying the chart of accounts.

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 26, 2019, 12:42pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/3 "2019-04-26T12:42:00Z")

</div>

I’ve created a video to show what happens, and what is simply not correct.

Edit:  
higher res video:

[![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/9/59e371df152755ad6f865afb467fb39055180655.jpeg "manager") ](https://www.youtube.com/watch?v=iRnyKHc_juc)

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [April 26, 2019, 12:51pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/4 "2019-04-26T12:51:05Z")

</div>

Sorry, but the video stopped in the middle and no I get a message saying We’re processing this video Check back later

It would actually be clearer if you just posted the various edit screens of the transactions and payslip items, etc. I have to keep pausing the video to check the entries

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 26, 2019, 12:52pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/5 "2019-04-26T12:52:21Z")

</div>

> [@Joe91](#):
>
> Sorry, but the video stopped in the middle and no I get a message saying We’re processing this video Check back later

The new video should be up… screenshots would take something like 20-30 screenshots.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [April 26, 2019, 1:08pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/6 "2019-04-26T13:08:13Z")

</div>

OK, I can now see what you are saying

But once you setup your payroll properly, this should not be an issue. You do not usually re-configure your accounts in the way you describe regularly, if at all

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 26, 2019, 1:12pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/7 "2019-04-26T13:12:42Z")

</div>

No… it is a problem. I have booked 5 years of taxed under that account. Then wanted to split up these 2 accounts, and I had to rebook every single entry because all of a sudden, my entries were adjusted. If the account is in use, it should be available. It also changed the bookings before the lock date. It is an issue.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [April 26, 2019, 1:19pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/8 "2019-04-26T13:19:52Z")

</div>

As a user, I can only comment that there are structures internal to the working of the payroll accounting module that are hard-wired and that you need to take care if you want to change the way it is setup. I agree it is inconsistant in the way it shows the bank payment.

I presume that the internal structure of the database is using the payslips items to manage the accounting transactions so changing them is fraught with problems.

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 26, 2019, 1:34pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/9 "2019-04-26T13:34:20Z")

</div>

I understand that for all the features, there are built-in accounts. The thing is that I simply changed the account for the payslip items, and it affected all other transactions (bank, journal, any transaction that uses that account), that have nothing to do with the payslips itself. It did so without warning, and without adhering the lock date. At first I thought I had deleted the account by accident, and that why all transactions were under the suspense account.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 26, 2019, 2:18pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/10 "2019-04-26T14:18:04Z")

</div>

> [@joris\_manager](#):
>
> When you setup payslips, the Payslip Deduction Items by default use an account called “Payroll liabilities”.  
> If you later change that account to a new account, all entries that use this “Payroll liabilities” account are altered and are now put on the suspense account

I have tried to duplicate what you describe. I cannot reproduce your reported behavior. It is true that if you change the posting account for a payslip deduction item, all transactions using that payslip item will be changed to the new posting account. That is to be expected, because you have redefined the payslip item. But _Payroll liabilities_ does not disappear. See below, where _New test account_ is where the only deduction item is now assigned:

![02%20AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/a/7acfc329c4e567f68e175974b57e313eb87199af.png)

Nothing appeared in _Suspense_ after the change was made to the payslip item. So I think you have done something else.

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 28, 2019, 11:08am UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/11 "2019-04-28T11:08:57Z")

</div>

> [@Tut](#):
>
> I have tried to duplicate what you describe. I cannot reproduce your reported behavior. It is true that if you change the posting account for a payslip deduction item, all transactions using that payslip item will be changed to the new posting account. That is to be expected, because you have redefined the payslip item

Correct.

I just updated to the latest version, and if you follow the exact steps, it does exactly what I said.

I can send you the manager file. [Dropbox - Error - Simplify your life](https://www.dropbox.com/s/37ib6i6fjzx3bg6/test%20%282019-04-28%29.manager?dl=0)

If you then go the settings → payslip items → edit the deduction, and change the account to “wage taxes”. You’ll see that summary now has and item on the suspense account.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 28, 2019, 12:42pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/12 "2019-04-28T12:42:53Z")

</div>

@joris_manager, I tried to follow your example, but in the file you provided, the change to _Wage taxes_ has already been made. And your 100 payment is posted to _Suspense_. To be useful, you need to upload a test file that does not yet demonstrate the problem you think exists. Only then will I be able to follow your steps.

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 28, 2019, 2:47pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/13 "2019-04-28T14:47:09Z")

</div>

You can simply clear the “wage tax” in the payslip items.  
You’l see everything is normal. And if you then set it to wage tax again (or any other account), the error happens

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 28, 2019, 3:09pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/14 "2019-04-28T15:09:28Z")

</div>

No, I tried that. The problem is your payment is posted to _Suspense_. Where was it originally posted?

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 28, 2019, 6:28pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/15 "2019-04-28T18:28:26Z")

</div>

It’s under payroll liabilities. This is the whole problem I’m trying to explain.  
My payment is posted under payroll liabilties.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/4/848eefafb553f62a9880fd11202cffa2c9f4d749.png)

If I then change the payslip item’s account to “Wage Tax”. My payment goes to the suspense account:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/b/8b30034e830c5cf3609873cb6d8e6cfc780452ed.png)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 28, 2019, 6:35pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/16 "2019-04-28T18:35:19Z")

</div>

I understand that, @joris_manager. But your complaint included the fact that transactions showed up in _Suspense_. What I am saying is that you provided an example data file in which the change had already been made and the payment was already posted to _Suspense_. So I cannot test whether it was influenced by what you did to the payslip item or not. Your sample could have been incorrectly entered to begin with.

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 28, 2019, 7:41pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/17 "2019-04-28T19:41:58Z")

</div>

The current file (same link) now has:  
Payroll liabilities - 80,00  
No suspense account

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [April 28, 2019, 11:25pm UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/18 "2019-04-28T23:25:07Z")

</div>

OK. Starting where you started, I can reproduce the problem you describe **with your test data file**. But I cannot reproduce it in another test business. I thought perhaps it was related to the fact your payment posted to _Payroll liablities_ was larger than the balance, driving that account into debit territory. But that wasn’t it.

No matter what I do, or in what order, I can freely switch posting accounts on payslip items in my test business and they behave as expected. But the same actions with your test file generate the issues you describe. This is something @lubos will need to look at.

Sorry I can’t help.

---

<div class="post-metadata">

**Author:** ![joris\_manager](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@joris\_manager](https://forum.manager.io/u/joris_manager)\
**Post date:** [April 29, 2019, 6:43am UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/19 "2019-04-29T06:43:47Z")

</div>

Ok, we’re getting somewhere. For me it’s 100% repreducable. If you want we can do a skype or remote session. I can also record a video with a brand new file. I’m using the mac desktop version.

To me it seems like the built-in account gets deactiveted because the payslip-items aren’t using it. And then, the suspense account is used, because there’s an ‘error’ (similar to when you create an expense claim, but fail to set the payer… it will then also be on the expense account)

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [April 29, 2019, 7:41am UTC](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793/20 "2019-04-29T07:41:36Z")

</div>

@joris_manager I can reproduce this. You are right about what is happening.

`Payroll Liabilities` and `Wages And Salaries` accounts are only enabled if payslip items are using them.

But as @Joe91 pointed out, it is by design.

I think payroll implementation in Manager could have been simpler. There is some work I’m doing on payroll to support country-specific payroll reports. So I will keep this issue in mind.

I’d say this is not a bug since the system does behave the way it’s designed. But I agree the design does give unexpected result which is not good.

[Next page](https://forum.manager.io/t/dataloss-when-changing-accounts-on-payslip-deduction-items-items/21793.md?page=2)
