Unanswered

Print 1099s from Multiple Tax IDs in One Company

(0) Share

Report

Posted on by Community Member

Does anyone know of any customizations or work arounds that would enable me to print multiple 1099s for one vendor from multiple Tax IDs in a single company? Let me explain . . .

I am currently running about 10 GP companies, each is it's own registered LLC with a unique tax ID number. I am wanting to consolidate all of the companies into one database and add a segment to the chart of accounts that would indicate the company. This would allow me to use the same set of vendors and customers in just one company and would also save us a ton of time switching back and forth between companies every day.

The only thing I haven't been able to figure out yet is how to handle the 1099 issue. If I have 1 vendor that 3 different companies pay in a given year then I would need to print 3 1099s for that vendor, one for each company that paid them. But GP would only allow me to print 1 1099 for the vendor and I would have to pick just 1 Company name and Tax ID to print on that 1099.

Hopefully what I am asking makes sense and hopefully someone has an answer for me.

Kevin Jones

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

mpolino on at

Like (0)

Report

1) Multifacility Processing from Binary Stream let's you setup a "facility" tied to the chart of accounts and can produce 1099's by facility. The setup is complicated though and it seems like a lot of work just for 1099's.

2) You may be able to do something with Green Shades. They can pull 1099 data into a spreadsheet for processing and printing along with combining the data from different sources. I would look here first.

Combining everything into one company DB often isn't the nirvana people hope for for lots of reasons. A customization or utility to rolldown vendors and customers along with a few extra GP licenses to facilitate DB switching may be a better option.

Mark

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Kevin,

     Before you implement this approach please get some tax advice on the legality. The IRS does not care how you expense your vendor invoices, only how you pay them. It sounds like you would use a single company to pay all your vendors. All the money paid by that company should be in one 1099 no matter who eventually gets the expense. We have 100 companies in our setup. We use only a few for payables and use the built in intercompany processing in Great Plains to spread the expense over the other companies. It works quite well. The 1099s are printed from the paying company, not the expensed to company.

     If you pay out of one company but act like it is paid by another company then the IRS might think you are trying to get around the reporting rules for 1099s. The vendors will not care. The total you report from 10 companies will still add up to the total you report from one company.

     Also, there are new rules for who gets 1099s starting in January 2011 that might complicate your plans.

Was this reply helpful? Yes No

Community site session details

Print 1099s from Multiple Tax IDs in One Company

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

Print 1099s from Multiple Tax IDs in One Company

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates