I need advice on setting up a new dataset.

A company who uses Adagio to provide accounting services to their clients is starting a new line of business. One of their clients issues monthly checks to individuals; they are annuity payments and the amount never changes for each individual. Until Payables has a real archive function, they will be importing the monthly invoices from Excel.

Here's the catch. They need to withhold federal and state taxes from the payments, and track and report the amounts paid and withheld on a 1099 at the end of the year. The actual issuing of the 1099s will be done outside of Adagio, using data extracted by GridView.

There are multiple states involved.

Being in the US, I rarely deal with taxes on vendor payments, but I'm wondering if I can do this using the taxes built into Payables, making the rate negative.

Thanks in advance for any ideas.

Steve