Term Statements

Four combinations of updates are available for running term statements. This allows you to print statements that retain transactions for the whole term and then have a clean slate for the next term.

Example

Take a look at Tom Wise's transactions for the months of September through January (assuming that he did not have any prior balance) and how they would appear on the statements.

September Statement Run

Date	AR SBS	Transaction Description	Status	Amount
09/01/17	AC	Tuition - Full time	C	2,450.00
09/01/17	AC	Room and Board Fall	C	1,200.00
09/24/17	AC	Payment - Thank you	C	1,100.00-
09/24/17	BK	Bookstore purchases	C	125.00

Following is how his statement would appear for September. Notice that the beginning balance is $ 0.00 for both subsidiaries appearing on the statement.

STATEMENT
ID: 000000001				Date: 9/30/17
Name: Tom Wise
Date	Description	Charges	Credits	Balance
Accounts Receivable - Regular				0.00
09/01/17	Tuition - Full time	2,450.00
09/01/17	Room and Board - Fall	1,200.00
09/24/17	Payment - Thank you		1,100.00
	Subtotal:			2,550.00

Accounts Receivable-Bookstore				0.00
09/24/17	Bookstore purchases		125.00
Subtotal:				125.00

Statement balance:				2,375.00

Immediately after the statements are printed, the system updates the records as part of the same process. Since we selected the Update Statement Balances column, that process also happens at this time.

October Statement Run

Shown below are Tom's transactions for both September and October. Notice that the September transactions have been changed to a status of Y (Year) from the previous statement run. This is because the Update Statement Balances column was selected. October's transactions (status of C) have been entered into the system and posted since the last statement run.

Date	AR SBS	Transaction Description	Status	Amount
09/01/17	AC	Tuition - Full time	Y	2,450.00
09/01/17	AC	Room and Board - Fall	Y	1,200.00
09/24/17	AC	Payment - Thank you	Y	1,100.00-
09/24/17	BK	Bookstore purchases	Y	125.00
10/06/17	AC	Payment - Thank you	C	1,550.00-
10/10/17	BK	Bookstore purchases	C	56.00
10/12/17	AC	Parking fine	C	20.00

Following is how the statement would appear at the end of October. Notice that the beginning balance is still $ 0.00 for both subsidiaries. This is because the Update Period Balances column was cleared when the statements were run.

STATEMENT
ID: 000000001
Name: Tom Wise					Date: 10/31/17
Date	Description	Charges	Credits	Balance
Accounts Receivable - Regular						0.00
09/01/17	Tuition - Full time	2,450.00
09/01/17	Room and Board - Fall	1,200.00
09/24/17	Payment - Thank you		1,100.00
10/06/17	Payment - Thank you		1,550.00
10/12/17	Parking fine	20.00
	Subtotal:		1,020.00
Accounts Receivable-Bookstore						0.00
09/24/17	Bookstore purchases	125.00
10/10/17	Bookstore purchase	56.00
	Subtotal:					181.00
	Statement balance:					1,201.00

November Statement Run

The result of the statement run and update is shown below. Once again, the transactions that appeared on the statement now have a Y status, and November's transactions have been entered and posted since the previous statement run and have a C status:

Date	AR SBS	Transaction Description	Status	Amount
09/01/17	AC	Tuition - Full time	Y	2,450.00
09/01/17	AC	Room and Board - Fall	Y	1,200.00
09/24/17	AC	Payment - Thank you	Y	1,100.00-
09/24/17	BK	Bookstore purchases	Y	125.00
10/06/17	AC	Payment - Thank you	Y	1,550.00-
10/10/17	BK	Bookstore purchases	Y	56.00
10/12/17	AC	Parking fine	Y	20.00
11/03/17	AC	Payment - Thank you	C	500.00-
11/24/17	AC	Backpacking class charge	C	150.00

Following is how the statement would appear at the end of November. Notice that the beginning balance is still $ 0.00 for both subsidiaries. This is because the Update Period Balances column was cleared when the statements were run.

STATEMENT
ID: 000000001
Name: Tom Wise					Date: 11/31/17
Date	Description	Charges	Credits	Balance
Accounts Receivable - Regular						0.00
09/01/17	Tuition - Full time	2,450.00
09/01/17	Room and Board - Fall	1,200.00
09/24/17	Payment - Thank you		1,100.00

10/06/17

Payment - Thank you

1,550.00

10/12/17	Parking fine	20.00
11/03/17	Payment - Thank you		500.00
11/24/17	Backpacking class chg	150.00

Subtotal:

670.00

Accounts Receivable-Bookstore				0.00
09/24/17	Bookstore purchases	125.00
10/10/17	Bookstore purchase	56.00
Subtotal:			181.00
Statement balance:			851.00

December Statement Run

The result of the statement run and update is shown below with the September, October, and November transactions now with a Y status. Also shown are December's transactions with a C status. They were entered and posted since the previous statement run.

Date	AR SBS	Transaction Description	Status	Amount
09/01/17	AC	Tuition - Full time	Y	2,450.00
09/01/17	AC	Room and Board - Fall	Y	1,200.00
09/24/17	AC	Payment - Thank you	Y	1,100.00-
09/24/17	BK	Bookstore purchases	Y	125.00
10/06/17	AC	Payment - Thank you	Y	1,550.00-
10/10/17	BK	Bookstore purchases	Y	56.00
10/12/17	AC	Parking fine	Y	20.00
11/03/17	AC	Payment - Thank you	Y	500.00-
11/24/17	AC	Backpacking class charge	Y	150.00
12/14/17	AC	Payment - Thank you	C	400.00-
12/14/17	BK	Payment - Thank you	C	130.00-
12/28/17	AC	Bookstore purchases	C	45.00

For the last run of the term, we run the statements updating both balances:

Update Statement Balances	YES
Update Period Balances	YES

The statement for December appears as it did in the previous months, showing both old transactions for the term and new ones. However, because we updated both statement and period balances, both C and Y transactions are changed to a status of H (History). The transactions will not appear on any subsequent statements. Notice that the beginning balance is still $ 0.00 for both subsidiaries. This is because the Update Period Balances column was cleared when the statements were run.

STATEMENT
ID: 000000001
Name: Tom Wise			Date: 12/31/17
Date	Description	Charges	Credits	Balance
Accounts Receivable - Regular				0.00
09/01/17	Tuition - Full time	2,450.00
09/01/17	Room and Board - Fall	1,200.00
09/24/17	Payment - Thank you		1,100.00
10/06/17	Payment - Thank you		1,550.00
10/12/17	Parking fine	20.00
11/03/17	Payment - Thank you		500.00
11/24/17	Backpacking class chg	150.00
12/14/17	Payment - Thank you		400.00
Subtotal:				270.00
Accounts Receivable-Bookstore				0.00
09/24/17	Bookstore purchases	125.00
10/10/17	Bookstore purchase	56.00
12/14/17	Payment - Thank you		130.00
12/28/17	Bookstore purchases	45.00
Subtotal:				96.00
Statement balance:				366.00

January Statement Run

Date	AR SBS	Transaction Description	Status	Amount
09/01/17	AC	Tuition - Full time	H	2,450.00
09/01/17	AC	Room and Board - Fall	H	1,200.00
09/24/17	AC	Payment - Thank you	H	1,100.00-
09/24/17	BK	Bookstore purchases	H	125.00
10/06/17	AC	Payment - Thank you	H	1,550.00-
10/10/17	BK	Bookstore purchases	H	56.00
10/12/17	AC	Parking fine	H	20.00
11/03/17	AC	Payment - Thank you	H	500.00-
11/24/17	AC	Backpacking class charge	H	150.00
12/14/17	AC	Payment - Thank you	H	400.00-
12/14/17	BK	Payment - Thank you	H	130.00-
12/28/17	AC	Bookstore purchases	H	45.00

All transactions for the four months in the term now have a status of H. The statement balance for each subsidiary for the term that was just closed is carried forward to the next period's beginning balance.

If transactions for January are entered and posted, they will have a status of C .

Date	AR SBS	Transaction Description	Status	Amount
01/11/18	AC	Tuition - Full time	C	2,450.00
01/11/18	AC	Room and Board - Spring	C	1,200.00
01/24/18	BK	Bookstore purchases	C	235.00

Following is how the statement would appear at the end of January. Notice that the beginning balance for each subsidiary is the ending balance shown on December's statement. This is the new Period balance that was updated when we ran December's statement.

STATEMENT
ID: 000000001				Date: 12/31/17
Name: Tom Wise
Date	Description	Charges	Credits	Balance
Accounts Receivable - Regular				270.00
01/01/18	Tuition - Full time	2,450.00
01/01/18	Room and Board - Spring	1,200.00
Subtotal:				3,920.00
Accounts Receivable-Bookstore				96.00
01/24/18	Bookstore purchases	235.00
Subtotal:				331.00
Statement balance:				4,251.00