Sage 100

2017 standard. Is there any where to get the correct tax deposits other than the employer expense summary? Many times the end user forgets to print it then needs to see the correct deposit amounts later. The general ledger posting doesn't provide the required detail. Is the perpetual history report a reliable source to calculate tax deposits?

You could get it a few different ways. 1.) Run a 941 with the Sch B (if they are a semi-weekly depositor) to get the total liability accrued since you said GL doesn't provide the detail. 2) Run a Perpetual History report however make sure they double up on the soc and medi (I have some that do it that way and they often forget the match). 3) Run a Check History report and the same would apply as the perpetual to remind them to double up the soc and medi.

I believe PR_40 and PR_41 (used by Aatrix) have that info

@KathyPurkiss The 941 doesn't provide the detail, state wh, or uc. The perpetual history report doesn't contain the employer liability for medicare over 127,200 (the employee limit), nor does it contain the .9% additional medicare tax once the employee reaches the threshold ($250K married filing jointly, $200K single, etc.). The .9% additional medicare tax threshold is different dependent on the taxpayer filing status.

@BethBowers PR_40 looks like it will work. Now I need to convince the customer to pay me to create a report.

@DougHiggs I should have requested more clarification in regard to what type of taxes you were referring to. Yes there are thresholds for soc sec and the addt'l med over cap is for employees only. When I do my reconciliations, I use the perpetual history and run a gross to taxable gross tie-back to make sure everything is calculated properly. If they are in need of getting the withholding amounts for state taxes, that is provided on the perpetual history and/or check history reports. If they are in need of getting the UC (I'm assuming you are referring to unemployment taxes, they can run the quarterly tax reports and/or the quarterly government reports. Those are normally filed quarterly (at least for the states that I prepare). You said above that there is an employer liability for medicare over 127,200 in taxable gross wages, however that is the soc cap which there is no employee nor employer match over that cap. The additional medicare is for the employee only for anything over 200,000 in taxable gross wages (of course based on their filing status this can change). I'm sorry for not getting further clarification before answering.