Is it possible to print Trial Balance in Excel Format? I got CSV format here. Is there any other option?
*This post is locked for comments
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.
Thank you Mariano Gomez
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
