Question about Intuit QuickBooks Simple Start 2010 Full Version for PC (28287023895)

Open Question

Hello! How can export the report into excel using Quickbooks pro 6.0?

Posted by on

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

EXPORT TALLY7.2 DATA INTO EXCEL SPREADSHEET


Hi,

Please follow the below step for your problem.

Go to Gateway of Tally> Balance Sheet (Here you can choose any report which you want export in tally)

Step 1: In the Balance sheet screen click E: Export or press Alt+E.

Step 2: Select the required language from the list of languages displayed.

Step 3: Select a format from the list of formats displayed.

Step 4: By default, the exported file will be stored in C:\Program files\Tally.ERP 9 for windows 7 and C:\Tally.ERP 9 for windows XP operating systems.

Step 5: Press Enter to accept the default output sheet name.

Step 6: To update the existing file select yes in update existing file.

Step 7: To format the contents of the file selects yes in Excel (Spreadsheet) formatting.

Step 8: Select yes for the filed with color, to retain the background color in the exported file.

Step 9: Accept to export the Balance Sheet to an excel file.

Thanking you

davevipul197

Jun 04, 2011 | Tally T2245 Matrix Printer

2 Answers

How can i export the data tally to excel


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Nov 24, 2010 | Tally T2245 Matrix Printer

1 Answer

I HOW I EXPORT TALLY 7.2 DATA IN EXCEL FORMAT


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.


Hope this is helpful. Let us know if the issue is resolved.



*Rating and Comments are invited for this solution

Nov 10, 2010 | Tally T2245 Matrix Printer

1 Answer

I have QuickBooks Pro 2005 and was able to easily export to Excel. That is no longer an option and I have to export to a cvs file. What happened and how do I fix it?


Open QuickBooks. At the top of your screen to the right you should see two black arrows next to your ICON's that say things like reminders, search and feedback. Do you see the arrows? Click on them. This will take you to another screen to add or subtract your ICONs or shortcuts. Click "add" and then scroll the options until you see "Export to Excel" and choose it. Then hit "ok" and close the boxes until you are back on your desktop.

Jun 17, 2010 | Intuit QuickBooks: Pro 2005 for PC

1 Answer

Tally odbc


Whatever reports you want ot convert in Excel there is a command in Tally to Export File. you can select excel in export configuaratin. Even .CSV formats can also be opened in excel.
To Export File in Excel .. In tally Goto that report and press ALT+E or look for "Export Command on Tally Toolbar or left panel.

Mar 23, 2010 | Tally T6218 Matrix Printer

1 Answer

Add a excel format in tally


Sir,

What to Export ?
Tally has a facility to export its data to other applications like spreadsheets, word processing software and other database software. Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. You can export it to another company using Tally that will import it directly.

How to Export?
You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Thanks
Good Luck

Aug 14, 2009 | Adaptec Computers & Internet

1 Answer

Will not let me use underline or italic in create


hi
iam
deepak mishra
plz give me Excel (vlookup) formula.....









deepak mishra
deepakmishra143@ymail.com

Jun 08, 2009 | Intuit QuickBooks Pro 2007 Full Version...

1 Answer

Is there a way to import an excel spreadsheet into quickbooks as expenses without the use of IIF?


You can save the file as a csv (comma seperated values) which will lose all the formatting in the excel sheet and save only the single worksheet. You should then be able to open this in quickbooks.

May 08, 2009 | Intuit QuickBooks: Pro 2005 for PC

1 Answer

I am a property manager. How do I email my Quickbooks Pro 2007 files to my clients who don't have Quickbook? I finally resolved it by printing all of my transactions I had done in 2008 with my client's...


Hi deanroussel,

First off, if the client doesn't have Quickbooks, then sending them the files wouldn't do them a whole lot of good right? So, what I would do, is when your run the report in Quickbooks, look for the excel icon, click that icon, and it will send the data to excel in a really nice format for the client to review. This is probably the best way, because most people have excel, and it's create a rather small file to send to them.

Best of Luck

Mark

Jan 16, 2009 | Intuit QuickBooks Pro 2007 Full Version...

Not finding what you are looking for?

Open Questions:

Intuit QuickBooks Simple Start 2010 Full Version for PC (28287023895) Logo

Related Topics:

23 people viewed this question

Ask a Question

Usually answered in minutes!

Top Intuit Computers & Internet Experts

Scott Fair
Scott Fair

Level 2 Expert

237 Answers

Dan Shibata
Dan Shibata

Level 3 Expert

542 Answers

Mike

Level 3 Expert

4340 Answers

Are you an Intuit Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...