Hi folks, I'm in a complex situation of passing journal entries of given data set. Sales Order Invoice value Invoice dateAllocation start monthAllocation end month 11/30/2021 SO#1 13,31,43007-12-202117-11-202117-11-2025 71,221 Entries would be pass like this DateAccountDebitCredit30-11-2021Contract Assets 71221 30-11-2021Deferred Revenue - 30-11-2021Revenue 7122130-11-2021Fixed Infrastructure Income - 30-11-2021Revenue ( Reimbursement of Expense Cloud Cost) - 30-11-2021Revenue ( Reimbursement of T&E) - 31-12-2021Account Receivable XXX 31-12-2021Contract Assets ` 31-12-2021Deferred Revenue XXX31-12-2021Contract Assets - 31-12-2021Deferred Revenue XXX 31-12-2021Revenue XXX31-12-2021Fixed Infrastructure Income - 31-12-2021Revenue ( Reimbursement of Expense Cloud Cost) - 31-12-2021Revenue ( 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 AssetsDeferred Revenue 2. Month end revenue recognition entry- Contract AssetsDeferred RevenueRevenueFixed Infrastructure IncomeRevenue ( Reimbursement of Expense Cloud Cost)Revenue ( Reimbursement of T&E)

Any update on this JE issue? I am hoping the Alteryx community can build together some accounting resources like that needed for JE reconciliations.

Journal entries in Alteryx

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)

Developer

Custom Tools

Expression

Accepted answers

All comments

@atcodedog05

@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.

thanks for replying

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703