Trial Balance in Excel Format

(0) Share

Report

Posted on by SandeepReddyChaganti

110

Is it possible to print Trial Balance in Excel Format? I got CSV format here. Is there any other option? 4454.Capture.PNG

*This post is locked for comments

All responses (3)

Answers (1)

dnodo on at

Like (2)

Report

RE: Trial Balance in Excel Format

We use this column format in Management Reporter and then use MR for our trial balance. Be sure you have the report set to Financial, Account and Transaction. When your report finishes, select Excel export in Report Viewer, be sure and select all reporting units to get the transaction level trial balance.

								Beginning	Current	Ending
								USD	Year	USD
Description	Account	Entity Name	Apply Date	Source	Doc ID	Doc Ref	Doc NO	Balance	Activity	Balance
DESC	ACCT	ATTR	ATTR	ATTR	ATTR	ATTR	ATTR	FD	FD	FD
		Entity Name	Transaction Date	Originating Audit Trail Code	Transaction Description	Originating Master Record Name	Originating Document Number	Actual	Actual	Actual
								BASE	BASE	BASE
								BASE	1:12	BASE
								YTD/BB	PERIODIC	YTD

AutoFit	15	20	10	AutoFit	AutoFit	AutoFit	AutoFit	16	15	16


				NP

SandeepReddyChaganti 110 on at

Like (0)

Report

RE: Trial Balance in Excel Format

Thank you Mariano Gomez
Verified answer

Mariano Gomez 26,225 on at

Like (1)

Report

RE: Trial Balance in Excel Format

Nope, there are no other options. Since Excel can open tab-delimited or CSV files, your only option are those 2. Excel can also import an XML data file (by enabling the Developer tab under options), but this file is used to export the report data definition to be used with Word Templates, so this should not be used, although data is exported with the definition.

Knowing that Tab-delimited and CSV work best, you can use Report Writer to create a stripped down version of the report, with the columns properly aligned and less of the lines and fluff that goes with the report itself. I have seen a number of customers do it this way with excellent results.