How To - Use Word to create 1099b for members
Posted by Bruce Kamm on January 25 2010 04:59 AM
You can easily create custom 1099b's to email, fax or mail to your members using Microsoft Word or any other document management program that has Mail Merge. Just follow these few steps:
On manage.vbarter.com, click Reports > Accounting, 1099b. Then select Excel (csv), click Generate and your 1099b data of barter sales for each member will display.
«City», «State» «Zip»
1099B Tax Notice
Account Number: «Account_No»
January 25, 2010
The following amount representing your 2009 total barter sales is being reported to the IRS on Form 1099b: «Total_Sales»
The TIN we have on file for you is: «Fed_IDSSN»
Your Corporate name or IRS tax filing name is: «Legal_Corporate_Name»
If the TIN or Corporation Name is incorrect or you have made a corporate change, please call our offices ASAP: Add phone number here.
Finally, using Word, use Mail Merge and follow the directions to merge the data fields from your CSV file onto your 1099b letterhead template. The end result should be individual doc files that you can print and mail.