Sage 100

Client is on Sage 100c Premium 2017. They are now in a situation where they have to witthold federal taxes on several vendors. It appears that Sage cannot handle what the client needs. Essentially, they would need Sage to do with AP as it does with payroll. That is

1. Let me enter an invoice
2. Calculate the withholding (always constant for a vendor)
3. Ajust the invoice so that we will only pay the net.
4. Have a report that will instruct me how much to pay the government for the entire check run
5. Update the AP_Vendor1099Payments file to reflect gross amount in box 7 and withheld amount in box 4 (or whichever box is federal withholding

I don't see that Sage can do this out of the box. Does anyone know of a third-party that could handle this? I thought about actually using payroll but that is a little too "square peg in a round hole" especially at 1099 time.

------------------------------
Billy Balser
Sage 100 Consultant
Blytheco LLC
Atlanta GA
9495839500
------------------------------

One way that's a bit manual is to use a GL account to collect the withholding and then run a report periodically when its time to remit. Seems the 1099 would need to be adjusted as well during year-end.

i suspect you could script the invoice data entry withholding portion but am not 100%.

------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------

NO, this is not a current feature of Sage 100 Accounts Payable.  Here is a website link that explains it very well (for those of us wondering, why?). 
https://www.irs.gov/businesses/international-businesses/us-withholding-agent-frequently-asked-question
I would set up an AP Distribution Table with the amount (or percent) going to a payable GL account for this purpose.  Then use the advice in the article to write them a report that captures the details, so their CPA can assist with doing the necessary forms and remittance.  ​

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------