DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Export Reports to Excel-1


#1

@lubos, I’m currently having challenges exporting my reports to excel as csv or xlsx.
This is how my report exported as tsv looks like and can only be opened in notepad

Group	Profit and Loss Statement	20/09/2015
Income	Investment Income - Fixed Deposits	20,499.68
Income	Investment Income - Treasury Bills	4,387.19
Income	Sales	358,093.62
Expenses	Accounting fees	0.00
Expenses	Audit Fees	− 962.50
Expenses	Bank charges	− 1,211.79
Expenses	Cleaning Expense	− 200.00
Expenses	Communication Expenses	− 1,799.59
Expenses	Consumables	− 700.00
Expenses	Contract Execution Expenses	− 263,562.50
Expenses	Donations	− 6,000.00
Expenses	Electricity	− 1,100.00
Expenses	Entertainment	0.00
Expenses	Fees and Permits	− 500.00
Expenses	Fixed assets - depreciation	0.00
Expenses	Fixed assets - loss on disposal	0.00
Expenses	Foreign exchange gains (losses)	0.00
Expenses	Fuel and Lubricants	− 5,950.00
Expenses	Hotel Accomodation	− 2,460.00
Expenses	Insurance	− 7,202.60
Expenses	Legal fees	0.00
Expenses	Marketing Expenses	− 2,000.00
Expenses	Medical Expenses	0.00
Expenses	Motor vehicle expenses	0.00
Expenses	Printing and stationery	− 300.00
Expenses	Registration and Renewals	− 7,000.00
Expenses	Rent	− 20,000.00
Expenses	Repairs and Maintenance - Building	− 1,000.00
Expenses	Repairs and maintenance - Motor Vehicle	− 11,670.00
Expenses	Repairs and Maintenance - Office Equipment	− 300.00
Expenses	Social Security - 13% Employer Contribution	− 1,278.99
Expenses	Staff Welfare	− 24,960.79
Expenses	Tender Cost	− 7,400.00
Expenses	Training & Development Expenses	− 1,500.00
Expenses	Transport & Travelling Expenses	0.00
Expenses	Wages & salaries	0.00
Expenses	Water	− 400.00
	Net profit (loss)	13,521.73

#2

Manager only exports as TSV files. Your posting shows that it exported correctly. What is your question?

If you are asking how to import it into Excel, that’s an Excel question, not a Manager question. Look up the instructions in Excel Help. Exact procedures will vary depending on your operating system and Excel version.


#3

Either change the extension to xlsx or right click the file and select open with and open with excel and then do a file save as to save as excel file. I copied your data and both options worked for me!