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/09Daily Sales:Item A: 50.23Item B: 54.27Item C: 84.11Item 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???
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Great question and there are two way export date. Please follow step by step instruction.
In the Balance sheet screen click E : Export or press Alt+E.
Select the required language from the list of Languages displayed.
Select a format from the list of Formats displayed.
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
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.
Press Enter to accept the default Output Sheet Name.
To update the existing file select Yes in Update Existing File.
To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
Select Yes for the Field withColour, to retain the background colour in the exported file.
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
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...
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.
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.
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.