rich Posted March 30, 2010 Report Share Posted March 30, 2010 I had client with 199 Sch d transactions and he provided me Excel sheet but sale and purchase items are in not sch D format.As per previous postings on this forum I saved them as .cvs files and imported it into ATX,but it shows as all purchase items and then all sale items in ATX Import sheet.Is there any way I can reconcile and group sale and purchase together? or just efile as it is because ATX dont show any e-file error. BTW its TD Ameritrade spreadsheet. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
rfassett Posted March 30, 2010 Report Share Posted March 30, 2010 I do not think the program will fix issues with your spread sheet. If your spread sheet does not have the sale and corresponding cost on the same line, then I do not think it will show that way in the program. I did one this morning that the client had prepared according to my specs. He had 248 transactions, they all matched up purchase and sale and date bought and date sold on the respective line in the csv file. I imported that into ATX and it could not have been much sweeter. It did take me about 15 minutes because the dates did not import for some reason. So I copy and pasted the dates. Created another column with an F for filer and yet another column of ones for transaction type. I copied and pasted those into ATX, changed 5 transaction types to fours and four transaction types to sevens and I was done. Absolutely amazing. The client had actually emailed me the csv file last evening, ahead of our scheduled appointment at 9:00 this morning. When we walked into the conference room I threw the Schedules D and D-1's on the table and said I was up all night inputting that info and he owes me $2,000. He is a brand new client and does not understand my humor, I guess, because his chin hit the table. Quote Link to comment Share on other sites More sharing options...
kcjenkins Posted March 30, 2010 Report Share Posted March 30, 2010 Rich, before you import it, rearrange the excel format to put things in the order you want them to be in. THEN you can save it as a .csv file, and import that. That should fix your problem. That is the great thing about using the excel program to arrange the data any way you want it, first. Quote Link to comment Share on other sites More sharing options...
Catherine Posted March 30, 2010 Report Share Posted March 30, 2010 Rich, before you import it, rearrange the excel format to put things in the order you want them to be in. THEN you can save it as a .csv file, and import that. That should fix your problem. That is the great thing about using the excel program to arrange the data any way you want it, first. The one problem with the import is that there is no "mapping" for the transaction type and filer/spouse/joint columns. When it's tons and tons of entries, AFTER you do the import, SAVE. then un-protect Sch. D, paste in the "F's" and "S's" and "1's" etc, re-protect and re-save, and it's complete. Save just before unprotecting so if anything goes wrong you can quit without saving. For belt-and-suspenders approach, duplicate the return, then open and save again, then muck with unprotecting. Catherine Quote Link to comment Share on other sites More sharing options...
Randall Posted March 31, 2010 Report Share Posted March 31, 2010 The one problem with the import is that there is no "mapping" for the transaction type and filer/spouse/joint columns. When it's tons and tons of entries, AFTER you do the import, SAVE. then un-protect Sch. D, paste in the "F's" and "S's" and "1's" etc, re-protect and re-save, and it's complete. Save just before unprotecting so if anything goes wrong you can quit without saving. For belt-and-suspenders approach, duplicate the return, then open and save again, then muck with unprotecting. Catherine If importing to Sch D in ATX does't work, rearrange the spreadsheet into the Sch D format the best you can and mail as an 8453 attachment. Quote Link to comment Share on other sites More sharing options...
josap Posted March 31, 2010 Report Share Posted March 31, 2010 I do not think the program will fix issues with your spread sheet. If your spread sheet does not have the sale and corresponding cost on the same line, then I do not think it will show that way in the program. I did one this morning that the client had prepared according to my specs. He had 248 transactions, they all matched up purchase and sale and date bought and date sold on the respective line in the csv file. I imported that into ATX and it could not have been much sweeter. It did take me about 15 minutes because the dates did not import for some reason. So I copy and pasted the dates. Created another column with an F for filer and yet another column of ones for transaction type. I copied and pasted those into ATX, changed 5 transaction types to fours and four transaction types to sevens and I was done. Absolutely amazing. The client had actually emailed me the csv file last evening, ahead of our scheduled appointment at 9:00 this morning. When we walked into the conference room I threw the Schedules D and D-1's on the table and said I was up all night inputting that info and he owes me $2,000. He is a brand new client and does not understand my humor, I guess, because his chin hit the table. Can you explain the prcedure to get the infrmation in the correct format when you have saved the excel file as csv? I would like to use this method but I am not aware of how to do it. Quote Link to comment Share on other sites More sharing options...
rich Posted March 31, 2010 Author Report Share Posted March 31, 2010 To fix excel file was a headache but after that it was ok.Thanks to all for great help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.