u/rainelbow

Thank you very much!

Solution Verified

Fantastic, thank you!

Wow, I can see how this is such a powerful tool.

Any chance you could clarify the "Pivot your columns" step? I see the "Pivot Column" option in the Transform tab, but I haven't really grasped how it works yet. My attempts are all ending with the error "We cannot convert the value null to type Text."

Solution Verified

Thank you! I have not used PowerQuery at all yet, but it's on my to-do list to learn. This seems like a nice relatively easy example to start with.

I'll try this tomorrow and confirm it works so I can award you a point.

Sweet, this helped! The real data is more complicated than my example, but this is giving me enough foundation to be able to manipulate it for the situation. Thank you!

I definitely agree with you there! That's what I'm trying to transform the data in the first screenshot into.

lol it was just grasping at straws, thinking about all the theoretical possibilities in order to make the year's numbers correct. Obviously fudging numbers is not the right answer, which is why I was asking the question, but thank you for your concern. <3

Thank you, I understand now!

I see. Sometimes it does come out of wages in a future pay period, but in that case it would be reducing that future pay period's wages, so possibly a different quarter. Thank you!

Edit: You and the other commenter both put me on the right track in my searches, so I see the difference between the pay-as-you-go, pre-pay, and catch-up options. Thanks again!

Interesting. So let's say because of winter break, someone only works 8 hours in a pay period, gross wages of $120, but their health plan costs $150 per pay period. Would you record that as $120 of pre-tax deductions and $30 of post-tax deductions?

Thank you!

Yeah, IL does the same thing regarding SS for certified employees, but it's not related to this issue. They would still be needing to subtract from SS for non-certified employees and Medicare from everyone, but they aren't. It's so strange, I don't understand how they could be doing this for years and not run into any issues with their audits.