Workflow Request:Developing a Trial balance (Monthly PL & BS) using General Ledger Details

Question

Hi Everyone!

I currently have an issue with a client's Trial balance using different account names/groupings when compared to the account names presented within the general ledger details, they have provided. I would like to create an Alteryx workflow which uses the general ledger details to create a monthly trial balance. I wanted to see if anyone in the Alteryx community has already made a workflow/macros for something like this. Any tips or recommendations are greatly appreciated! :)

DanM · Answer

@fteplits I would suggest adding more details and possibly sample data so that the Community can understand better what you are exactly looking for. As for the account naming issue, if you know what the different account names/groupings when compared to the account names presented are, you could create a look-up table using a Text Input and use the FindReplace tool to update the general ledger.