Automate G/L Trial Balance report export to Excel

Also, is there a way to show a tree view to see transaction details listed under the totals for each account?

I believe Sage Intelligence may be an option for automating the export to Excel process, using the Connector module.  Has anyone done this before?

  • 0

    I use a BOI infused ". XLSM" to automatically run the G/L Trial Balance to fill the related work file into a worksheet via a Power Query then connect a Pivot Table to it and show breakdowns with subtotals. Other tables can be added within Power Query that provide related fields.

  • 0

    Other options would be F9 or BizNet. They would let you run all your directly out of excel, but if it's just the trial balance you need I am not sure they would be worth the price. Visual Cut allows the automation of excel reports, but that would be more on a time schedule ie. export every day at 6 PM.