Journal entries in Alteryx

[AS]

Hi folks, 

I'm in a complex situation of passing journal entries of given data set.

Sales Order	Invoice value	Invoice date	Allocation start month	Allocation end month	11/30/2021
SO#1	13,31,430	07-12-2021	17-11-2021	17-11-2025	71,221

Entries would be pass like this

Date	Account	Debit	Credit
30-11-2021	Contract Assets	71221
30-11-2021	Deferred Revenue	-
30-11-2021	Revenue		71221
30-11-2021	Fixed Infrastructure Income	-
30-11-2021	Revenue ( Reimbursement of Expense Cloud Cost)	-
30-11-2021	Revenue ( Reimbursement of T&E)	-
31-12-2021	Account Receivable	XXX
31-12-2021	Contract Assets		`
31-12-2021	Deferred Revenue		XXX
31-12-2021	Contract Assets	-
31-12-2021	Deferred Revenue	XXX
31-12-2021	Revenue		XXX
31-12-2021	Fixed Infrastructure Income		-
31-12-2021	Revenue ( Reimbursement of Expense Cloud Cost)		-
31-12-2021	Revenue ( Reimbursement of T&E)		-

where there are 2 entries set-

1. At the time of invoicing, if there is no invoicing at the time of month end then no need to pass entries-

Account Receivable

Contract Assets

Deferred Revenue

2. Month end revenue recognition entry-

Contract Assets

Deferred Revenue

Revenue

Fixed Infrastructure Income

Revenue ( Reimbursement of Expense Cloud Cost)

Revenue ( Reimbursement of T&E)

[AS]

@atcodedog05 

[AS]

@BrandonB  Could you please help!

[AbhilashR]

Hi @AS, do you have an example of how would this be done in excel? Give it some dummy numbers and help us understand the logic for us to guide you through the process.

[AS]

thanks for replying