Accounting Chart of Accounts

[RJEY]

I have a chart of accounts export with both Account Classes and GL Accounts in the same column. Does anyone know how to create a table that shows each GL Account and its associated Account Class? See below:

Before:

REVENUES

1110-0001 RETAIL SALES

1110-0002 SHIPPING SALES

1110-0003 PRODUCTION SALES

COST OF GOODS SOLD

2110-0001 RETAIL COGS

2110-0002 COST COGS

2110-003 ALTERATIONS COGS

2110-004 FREIGHT COGS

Desired Result:

1110-0001 RETAIL SALES	REVENUES
1110-0002 SHIPPING SALES	REVENUES
1110-0003 PRODUCTION SALES	REVENUES
2110-0001 RETAIL COGS	COST OF GOODS SOLD
2110-0002 COST COGS	COST OF GOODS SOLD
2110-003 ALTERATIONS COGS	COST OF GOODS SOLD
2110-004 FREIGHT COGS	COST OF GOODS SOLD

[grazitti_sapna]

Hi @RJEY , you can try this.

Thanks.

[bhrmitra]

Hi RJEY,

Please refer to the screenshot below. This will work provided "GL Account" has a numeric field in it.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

[RJEY]

Thank you! This was perfect. I'm curious - could the workflow be edited to address a scenario where the Account Classes are at the bottom of each set of accounts vs. above each set of accounts? See revised example below.

Before:

1110-0001 RETAIL SALES

1110-0002 SHIPPING SALES

1110-0003 PRODUCTION SALES

REVENUES

2110-0001 RETAIL COGS

2110-0002 COST COGS

2110-003 ALTERATIONS COGS

2110-004 FREIGHT COGS

COST OF GOODS SOLD

Desired Result:

1110-0001 RETAIL SALES	REVENUES
1110-0002 SHIPPING SALES	REVENUES
1110-0003 PRODUCTION SALES	REVENUES
2110-0001 RETAIL COGS	COST OF GOODS SOLD
2110-0002 COST COGS	COST OF GOODS SOLD
2110-003 ALTERATIONS COGS	COST OF GOODS SOLD
2110-004 FREIGHT COGS	COST OF GOODS SOLD

[bhrmitra]

Hi  RJEY,

Whatever analytical process you can think of is possible manually can be absolutely done using Alteryx, that's what makes it so  powerful tool. Please find the attached solution.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

[grazitti_sapna · Accepted solution]

Hi @RJEY , an alternate solution to your problem.

Thanks.

[RJEY]

Thank you @bhrmitra! This is great. I appreciate you helping - I'm still learning the ropes with Alteryx.