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