Question about Intuit QuickBooks Pro Edition 2009 Full Version for PC

2 Answers

Need excel spreadsheet format to allow export of sales data to

Need to know the correct way to format my sales data in an excel spreadsheet so I can export data to quickbooks 2009. Example of type of data I need to import below: Date: 6/28/09 Daily Sales: Item A: 50.23 Item B: 54.27 Item C: 84.11 Item D: 44.33
I would like to be able to create a form in excel that will have either a row or column for each day's sales for an entire month, so I can then import an entire month's sales in one file. Can anyone help???

Posted by on

  • dmorauer Jun 27, 2009

    Does Quickbooks need the Dates as column headers or Row headers? Then would I breakdown the sales data into Item A, B, C, etc by columns or rows, etc.

  • dmorauer Jun 27, 2009

    Thanks Damien!!! This will help me save hours of work each month. Appreciate the help very much! David M.

×

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 221 Answers

Hello,
I have checked your post and this is what I have found that would help you:
http://support.quickbooks.intuit.com/support/Pages/KnowledgeBaseArticle/1005472

In this page you will find tools for importing from Excel, I'm also here to help

Posted on Jun 27, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,383 Answers

For that you have to create macro definitioon for it

Just add some of column .Aslo you can create function for it.

Posted on Jun 27, 2009

  • kishor
    kishor Jun 27, 2009

    Yes you can do it.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to export tally 9 to excel sheet


Hi,
Great question and there are two way export date. Please follow step by step instruction.
  1. In the Balance sheet screen click E : Export or press Alt+E.
  2. Select the required language from the list of Languages displayed.
  3. Select a format from the list of Formats displayed.
  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
  5. Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
  6. Press Enter to accept the default Output Sheet Name.
  7. To update the existing file select Yes in Update Existing File.
  8. To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
  9. Select Yes for the Field with Colour, to retain the background colour in the exported file.
And Second:
selecting the ASCII (Comma Delimited) format, the user can export all the reports or data from Tally.ERP 9. The data exported is converted to plain text separated with commas and stored in a file with the extension .txt. This file format is widely used for emailing and used for importing data into another company using Tally.ERP 9

More information please visit this link.
http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/Export_Formats.htm

Thanks,

Jun 10, 2014 | HP Office Equipment & Supplies

1 Answer

About microsoft excel


Made by Microsoft, used for creating, opening and managing spreadsheet data files created with the application. Spreadsheets allow you to manipulate numbers, formulas, information and extrapolate resulting information, graphs, charts, organized lists, export data to create all sorts of useful results.
Not sure what else you want to know...

Aug 22, 2012 | Facebook Computers & Internet

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

1 Answer

How to do tally 9.0 export data in excel


Hi,

Please follow the below step for solve your problem.

Step 1: Open Report Which you want convert in Excel.

Step 2: Press Ctrl+E

Step 3: Select Excel (Spreadsheet) in format option

Step 4: Press Ctrl+A

Then after you can got your data tally to excel.

thanking you

Sep 17, 2010 | Tally T2245 Matrix Printer

3 Answers

Export the data from excel to tally


  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.

Apr 21, 2010 | Microsoft Windows XP Professional

3 Answers

Export tally data to excel


tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Aug 27, 2009 | Tally T2245 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

3 Answers

Export ledger tally to excell


my name is saurabh yadav

i want to know that how export my sales book ledger export to excell form tally 7.2

Mar 10, 2009 | Tally T2245 Matrix Printer

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet


you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Computers & Internet

Not finding what you are looking for?
Intuit QuickBooks Pro Edition 2009 Full Version for PC  Logo

97 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

4336 Answers

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

Answer questions

Manuals & User Guides

Loading...