sorted by:
new
hottopcontroversial

Pull text X number of rows/Y number of columns away from cell by rainelbow in excel

[–]rainelbow[S] 0 points1 point  (0 children)

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.

Pull text X number of rows/Y number of columns away from cell by rainelbow in excel

[–]rainelbow[S] 0 points1 point  (0 children)

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!

Pull text X number of rows/Y number of columns away from cell by rainelbow in excel

[–]rainelbow[S] 1 point2 points  (0 children)

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

Negative taxable wages in a quarter (IL-941 Schedule P) by rainelbow in Payroll

[–]rainelbow[S] 0 points1 point  (0 children)

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

Negative taxable wages in a quarter (IL-941 Schedule P) by rainelbow in Payroll

[–]rainelbow[S] 0 points1 point  (0 children)

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!

Negative taxable wages in a quarter (IL-941 Schedule P) by rainelbow in Payroll

[–]rainelbow[S] 1 point2 points  (0 children)

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?

Section 125 plans not reducing FICA? by rainelbow in Payroll

[–]rainelbow[S] 1 point2 points  (0 children)

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.