Create journal entries table with Alteryx output

kkhan003

I have calculated the amortisation and interest expense numbers through a complex workflow and summarised the data into monthly columns.

Now I want to create a separate table with accounting double entries using these numbers e.g. interest expense amount for Jan should be used to create the following journals..

Dr. Interest expense 3,231

Cr. Lease liability (3,231) - note that line item is not in my original data, I want to manually add it and then map it with negative amount of interest expense.

Any ideas on how this can be done?

Annotation 2019-10-13 003649.png

BrandonB

Because your months are columns in your dataset it looks like you will need to create rows for the additional line items that you want included and then union the data sets together.

When you do a union it stacks data between the two datasets and puts the data in the columns with matching column names. So if the value of the Dr. Interest Expense has the same column name as the January column header in your main data, it will be stacked when you feed both data sources into a union tool.