Open topic with navigation

Deferral Use Case (Date Based Anniversary)

Date Based Products - Anniversary

Monthly Recognition

Paid In Period of Start Date — Starts at Beginning of Current Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2008

Deferral End Period: 200805

Deferral Amount: $120.00

Recognition Amount: $10.00

Frequency: 1

Number of Periods: 12

Column / Period	200706	07	08	09	10	11
# Recognized	1	2	3	4	5	6
# Recognitions Left	11	10	9	8	7	6
Last $ Recognized	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00
Last Per Recognized	200706	200707	200708	200709	200710	200711
Next Per Recognized	200707	200708	200709	200710	200711	200712
Total Recognized	$10.00	$20.00	$30.00	$40.00	$50.00	$60.00
Balance	$110.00	$100.00	$90.00	$80.00	$70.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04	05
# Recognized	7	8	9	10	11	12
# Recognitions Left	5	4	3	2	1	0
Last $ Recognized	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00
Last Per Recognized	200712	200801	200802	200803	200804	200805
Next Per Recognized	200801	200802	200803	200804	200805	NULL
Total Recognized	$70.00	$80.00	$90.00	$100.00	$110.00	$120.00
Balance	$50.00	$40.00	$30.00	$20.00	$10.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid Prior to Start Date — Starts at Beginning of Next Period

Invoice Amount: $120

Product Term: 7/1/2007 — 6/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 7/1/2007

Deferral Start Period: 200707

Deferral End Date: 6/30/2008

Deferral End Period: 200806

Deferral Amount: $120.00

Recognition Amount: $10.00

Frequency: 1

Number of Periods: 12

Column / Period	06	07	08	09	10	11
# Recognized	0	1	2	3	4	5
# Recognitions Left	12	11	10	9	8	7
Last $ Recognized	$0.00	$10.00	$10.00	$10.00	$10.00	$10.00
Last Per Recognized	NULL	200707	200708	200709	200710	200711
Next Per Recognized	200707	200708	200709	200710	200711	200712
Total Recognized	$0.00	$10.00	$20.00	$30.00	$40.00	$50.00
Balance	$120.00	$110.00	$100.00	$90.00	$80.00	$70.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04	05	06
# Recognized	6	7	8	9	10	11	12
# Recognitions Left	6	5	4	3	2	1	0
Last $ Recognized	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00
Last Per Recognized	200712	200801	200802	200803	200804	200805	200806
Next Per Recognized	200801	200802	200803	200804	200805	200806	NULL
Total Recognized	$60.00	$70.00	$80.00	$90.00	$100.00	$110.00	$120.00
Balance	$60.00	$50.00	$40.00	$30.00	$20.00	$10.00	$0.00
Close Flag	0	0	0	0	0	0	1

---

Paid After Start Date — Starts at Beginning of Prior Period

Invoice Amount: $120

Product Term: 5/1/2007 — 4/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 5/1/2007

Deferral Start Period: 200705

Deferral End Date: 4/30/2008

Deferral End Period: 200804

Deferral Amount: $120.00

Recognition Amount: $10.00

Frequency: 1

Number of Periods: 12

Column / Period	06	07	08	09	10	11
# Recognized	2	3	4	5	6	7
# Recognitions Left	10	9	8	7	6	5
Last $ Recognized	$20.00	$10.00	$10.00	$10.00	$10.00	$10.00
Last Per Recognized	200706	200707	200708	200709	200710	200711
Next Per Recognized	200707	200708	200709	200710	200711	200712
Total Recognized	$20.00	$30.00	$40.00	$50.00	$60.00	$70.00
Balance	$100.00	$90.00	$80.00	$70.00	$60.00	$50.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04
# Recognized	8	9	10	11	12
# Recognitions Left	4	3	2	1	0
Last $ Recognized	$10.00	$10.00	$10.00	$10.00	$10.00
Last Per Recognized	200712	200801	200802	200803	200804
Next Per Recognized	200801	200802	200803	200804	NULL
Total Recognized	$80.00	$90.00	$100.00	$110.00	$120.00
Balance	$40.00	$30.00	$20.00	$10.00	$00.00
Close Flag	0	0	0	0	1

---

Quarterly Recognition

Paid In Period of Start Date — Starts at Beginning of Current Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2008

Deferral End Period: 200805

Deferral Amount: $120.00

Recognition Amount: $30.00

Frequency: 3

Number of Periods: 12

Column / Period	06	07	08	09	10	11
# Recognized	0	0	3	3	3	6
# Recognitions Left	4	4	3	3	3	2
Last $ Recognized	$0.00	$0.00	$30.00	$30.00	$30.00	$30.00
Last Per Recognized	NULL	NULL	200708	200708	200708	200711
Next Per Recognized	200708	200708	200711	200711	200711	200802
Total Recognized	$0.00	$00.00	$30.00	$30.00	$30.00	$60.00
Balance	$120.00	$120.00	$90.00	$90.00	$90.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04	05
# Recognized	6	6	9	9	9	12
# Recognitions Left	2	2	1	1	1	0
Last $ Recognized	$30.00	$30.00	$30.00	$30.00	$30.00	$30.00
Last Per Recognized	200711	200711	200802	200802	200802	200805
Next Per Recognized	200802	200802	200805	200805	200805	NULL
Total Recognized	$60.00	$60.00	$90.00	$90.00	$90.00	$120.00
Balance	$60.00	$60.00	$30.00	$30.00	$30.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid Prior to Start Date — Starts at Beginning of Next Period

Invoice Amount: $120

Product Term: 7/1/2007 — 6/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 7/1/2007

Deferral Start Period: 200707

Deferral End Date: 6/30/2008

Deferral End Period: 200806

Deferral Amount: $120.00

Recognition Amount: $30.00

Frequency: 3

Number of Periods: 12

Column / Period	200706	07	08	09	10	11	12
# Recognized	0	0	0	3	3	3	6
# Recognitions Left	4	4	4	3	3	3	2
Last $ Recognized	$0.00	$0.00	$0.00	$30.00	$30.00	$30.00	$30.00
Last Per Recognized	NULL	NULL	NULL	200709	200709	200709	200712
Next Per Recognized	200709	200709	200709	200712	200712	200712	200803
Total Recognized	$0.00	$0.00	$0.00	$30.00	$30.00	$30.00	$60.00
Balance	$120.00	$120.00	$120.00	$90.00	$90.00	$90.00	$60.00
Close Flag	0	0	0	0	0	0	0

Column / Period	200801	02	03	04	05	06
# Recognized	6	6	9	9	9	12
# Recognitions Left	2	2	1	1	1	0
Last $ Recognized	$30.00	$30.00	$30.00	$30.00	$30.00	$30.00
Last Per Recognized	200712	200712	200803	200803	200803	200806
Next Per Recognized	200803	200806	200806	200806	200806	NULL
Total Recognized	$60.00	$60.00	$90.00	$90.00	$90.00	$120.00
Balance	$60.00	$60.00	$30.00	$30.00	$30.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid After Start Date — Starts at Beginning of Prior Period

Invoice Amount: $120

Product Term: 5/1/2007 — 4/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 5/1/2007

Deferral Start Period: 200705

Deferral End Date: 4/30/2008

Deferral End Period: 200804

Deferral Amount: $120.00

Recognition Amount: $30.00

Frequency: 3

Number of Periods: 12

Column / Period	06	07	08	09	10	11
# Recognized	0	3	3	3	6	6
# Recognitions Left	4	3	3	3	2	2
Last $ Recognized	$0.00	$30.00	$30.00	$30.00	$30.00	$30.00
Last Per Recognized	NULL	200707	200707	200707	200710	200710
Next Per Recognized	200707	200710	200710	200710	200801	200801
Total Recognized	$0.00	$30.00	$30.00	$30.00	$60.00	$60.00
Balance	$120.00	$90.00	$90.00	$90.00	$60.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04
# Recognized	6	3	3	3	0
# Recognitions Left	2	1	1	1	0
Last $ Recognized	$30.00	$30.00	$30.00	$30.00	$30.00
Last Per Recognized	200710	200801	200801	200801	200804
Next Per Recognized	200801	200804	200804	200804	NULL
Total Recognized	$60.00	$90.00	$90.00	$90.00	$120.00
Balance	$60.00	$30.00	$30.00	$30.00	$00.00
Close Flag	0	0	0	0	1

---

Semi-Annual Recognition

Paid In Period of Start Date — Starts at Beginning of Current Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2008

Deferral End Period: 200805

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 6

Number of Periods: 12

Column / Period	06	07	08	09	10	11
# Recognized	0	0	0	0	0	6
# Recognitions Left	2	2	2	2	2	1
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	200711
Next Per Recognized	200711	200711	200711	200711	200711	200805
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04	05
# Recognized	6	6	6	6	6	12
# Recognitions Left	1	1	1	1	1	0
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200711	200711	200711	200711	200711	200805
Next Per Recognized	200805	200805	200805	200805	200805	NULL
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$120.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid Prior to Start Date — Starts at Beginning of Next Period

Invoice Amount: $120

Product Term: 7/1/2007 — 6/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 7/1/2007

Deferral Start Period: 200707

Deferral End Date: 6/30/2008

Deferral End Period: 200806

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 6

Number of Periods: 12

Column / Period	06	07	08	09	10	11	12
# Recognized	0	0	0	0	0	0	6
# Recognitions Left	2	2	2	2	2	2	1
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	NULL	200712
Next Per Recognized	200712	200712	200712	200712	200712	200712	200806
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$120.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200801	02	03	04	05	06
# Recognized	6	6	6	6	6	12
# Recognitions Left	1	1	1	1	1	0
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200712	200712	200712	200712	200712	200806
Next Per Recognized	200806	200806	200806	200806	200806	NULL
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$120.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid After Start Date — Starts at Beginning of Prior Period

Invoice Amount: $120

Product Term: 5/1/2007 — 4/30/2008

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 5/1/2007

Deferral Start Period: 200705

Deferral End Date: 4/30/2008

Deferral End Period: 200804

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 6

Number of Periods: 12

Column / Period	06	07	08	09	10	11
# Recognized	0	0	0	0	6	6
# Recognitions Left	2	2	2	2	1	1
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$60.00	$60.00
Last Per Recognized	NULL	NULL	NULL	NULL	200710	200710
Next Per Recognized	200710	200710	200710	200710	200804	200804
Total Recognized	$0.00	$0.00	$0.00	$0.00	$60.00	$60.00
Balance	$120.00	$120.00	$120.00	$120.00	$60.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04
# Recognized	6	6	6	6	12
# Recognitions Left	1	1	1	1	0
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200710	200710	200710	200710	200804
Next Per Recognized	200804	200804	200804	200804	NULL
Total Recognized	$60.00	$60.00	$60.00	$60.00	$120.00
Balance	$60.00	$60.00	$60.00	$60.00	$00.00
Close Flag	0	0	0	0	1

---

Annual Recognition

Paid In Period of Start Date — Starts at Beginning of Current Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2009

Batch Period: 200706

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2009

Deferral End Period: 200905

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 12

Number of Periods: 24

Year 1:

Column / Period	200706	07	08	09	10	11
# Recognized	0	0	0	0	0	0
# Recognitions Left	2	2	2	2	2	2
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	NULL
Next Per Recognized	200805	200805	200805	200805	200805	200805
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$120.00
Close Flag	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04	05
# Recognized	0	0	0	0	0	12
# Recognitions Left	2	2	2	2	2	1
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	200805
Next Per Recognized	200805	200805	200805	200805	200805	200905
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$60.00
Close Flag	0	0	0	0	0	0

---

Year 2:

Column / Period	200806	07	08	09	10	11
# Recognized	12	12	12	12	12	12
# Recognitions Left	1	1	1	1	1	1
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200805	200805	200805	200805	200805	200805
Next Per Recognized	200905	200905	200905	200905	200905	200905
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200812	200901	02	03	04	05
# Recognized	12	12	12	12	12	24
# Recognitions Left	1	1	1	1	1	0
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200805	200805	200805	200805	200805	200905
Next Per Recognized	200905	200905	200905	200905	200905	NULL
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$120.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid Prior to Start Date — Starts at Beginning of Next Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2009

Batch Period: 200705

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2009

Deferral End Period: 200905

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 12

Number of Periods: 24

Year 1:

Column / Period	200705	06	07	08	09	10	11
# Recognized	0	0	0	0	0	0	0
# Recognitions Left	2	2	2	2	2	2	2
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Next Per Recognized	200805	200805	200805	200805	200805	200805	200805
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$120.00	$120.00
Close Flag	0	0	0	0	0	0	0

Column / Period	200712	200801	02	03	04	05
# Recognized	0	0	0	0	0	12
# Recognitions Left	2	2	2	2	2	1
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	200805
Next Per Recognized	200805	200805	200805	200805	200805	200905
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$60.00
Close Flag	0	0	0	0	0	0

---

Year 2:

Column / Period	200806	07	08	09	10	11
# Recognized	12	12	12	12	12	12
# Recognitions Left	1	1	1	1	1	1
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200805	200805	200805	200805	200805	200805
Next Per Recognized	200905	200905	200905	200905	200905	200905
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200812	200901	02	03	04	05
# Recognized	12	12	12	12	12	24
# Recognitions Left	1	1	1	1	1	0
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200805	200805	200805	200805	200805	200905
Next Per Recognized	200905	200905	200905	200905	200905	NULL
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$120.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$0.00
Close Flag	0	0	0	0	0	1

---

Paid After Start Date — Starts at Beginning of Prior Period

Invoice Amount: $120

Product Term: 6/1/2007 — 5/31/2009

Batch Period: 200707

Fiscal Year: 1/1 — 12/31

Deferral Start Date: 6/1/2007

Deferral Start Period: 200706

Deferral End Date: 5/31/2009

Deferral End Period: 200905

Deferral Amount: $120.00

Recognition Amount: $60.00

Frequency: 12

Number of Periods: 24

Year 1:

Column / Period	200707	08	09	10	11
# Recognized	0	0	0	0	0
# Recognitions Left	2	2	2	2	2
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL
Next Per Recognized	200805	200805	200805	200805	200805
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00
Close Flag	0	0	0	0	0

Column / Period	12	200801	200802	03	04	05
# Recognized	0	0	0	0	0	12
# Recognitions Left	2	2	2	2	2	1
Last $ Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Last Per Recognized	NULL	NULL	NULL	NULL	NULL	200805
Next Per Recognized	200805	200805	200805	200805	200805	200905
Total Recognized	$0.00	$0.00	$0.00	$0.00	$0.00	$60.00
Balance	$120.00	$120.00	$120.00	$120.00	$120.00	$60.00
Close Flag	0	0	0	0	0	0

---

Year 2:

Column / Period	200806	07	08	09	10	11
# Recognized	12	12	12	12	12	12
# Recognitions Left	1	1	1	1	1	1
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200805	200805	200805	200805	200805	200805
Next Per Recognized	200905	200905	200905	200905	200905	200905
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Close Flag	0	0	0	0	0	0

Column / Period	200812	200901	02	03	04	05
# Recognized	12	12	12	12	12	24
# Recognitions Left	1	1	1	1	1	0
Last $ Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00
Last Per Recognized	200805	200805	200805	200805	200805	200905
Next Per Recognized	200905	200905	200905	200905	200905	NULL
Total Recognized	$60.00	$60.00	$60.00	$60.00	$60.00	$120.00
Balance	$60.00	$60.00	$60.00	$60.00	$60.00	$0.00
Close Flag	0	0	0	0	0	1

---