Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)
e-mail address___________________________________________________
EXAM TO BE RETURNED BY 4:00 PM MON NOV 25 in class
There are 165 exam points available in the five sections shown below:
Section 2 | Delete | 24 |
Section 3 | Add | 33 |
Section 4 | Modify | 36 |
Section 5 | Journal Voucher Posting | 60 |
Section 6 | Summary | 12 |
TOTAL POINTS | 165 |
Major | Minor | Sub 1 | Sub 2 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
1000 | 5000 | 0000 | 0000 | |||
1000 | 7000 | 0000 | 0000 | |||
6000 | 1000 | 4000 | 0000 | |||
9100 | 2000 | 0000 | 0000 | |||
4000 | 3000 | 3000 | 0000 | |||
9000 | 9000 | 0000 | 0000 | |||
7000 | 1000 | 0000 | 0000 | |||
9999 | 9999 | 0000 | 0000 |
Major | Minor | Sub 1 | Sub 2 | Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
9100 | 3000 | 0000 | 0000 | Radar Maintenance | |||
1000 | 5000 | 0000 | 0000 | Cash Bank of Dawsonville | |||
1700 | 2000 | 0000 | 0000 | Copier Xerox #982547 | |||
9000 | 5000 | 0000 | 0000 | Paper Clips | |||
1100 | 0004 | 0000 | 0000 | WYSIWYG Stock | |||
1100 | 0005 | 0000 | 0000 | Fatal Error Inc. Stock | |||
9100 | 2000 | 0000 | 0000 | New Wheelhouse for the Yacht | |||
1000 | 7000 | 0000 | 0000 | Cash 1st Bank of Leona | |||
4000 | 3000 | 6000 | 0000 | Treasure Auction Revenue | |||
5000 | 1000 | 2000 | 0000 | Direct Labor - Harbor Pilot Fees | |||
9100 | 9600 | 0000 | 0000 | Periscope Sunshades |
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
2000 | 2000 | 0000 | 0000 | Long Term Debt -- Notes Payable | |||
3000 | 5000 | 0000 | 0000 | PIC | |||
1000 | 4000 | 0000 | 0000 | Local Petty Cash | |||
5000 | 1000 | 3000 | 0000 | Catalog Department Temporary Helpers | |||
1100 | 3000 | 0000 | 0000 | Mutual Fund Investment | |||
7000 | 1000 | 4000 | 0000 | Office Cleaning Service | |||
9999 | 9999 | 0000 | 0000 | Suspense Account | |||
4000 | 3000 | 2000 | 0000 | Houston Galleria Store Sales | |||
8000 | 1000 | 2000 | 0000 | Direct Labor - Holiday Temporary Workers | |||
7000 | 1000 | 2000 | 0000 | Direct Labor Lobby Greeters | |||
8000 | 1000 | 3000 | 0000 | Direct Labor Part Time Front Office Staff | |||
9000 | 4000 | 0000 | 0000 | Insurance Expense |
SRN: | 4211 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
4000 | 3000 | 6000 | 0000 | 356.22 | Treasure Sale Revenue | |||
1000 | 4000 | 0000 | 0000 | -356.22 | ||||
SRN: | 4212 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
8000 | 1000 | 2000 | 0000 | 927.73 | Holiday Temporary Staff | |||
1000 | 4000 | 0000 | 0000 | -927.73 | ||||
SRN: | 4213 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 50000.01 | Sold Microsoft Stock | |||
1100 | 0003 | 0000 | 0000 | -50000.01 | ||||
SRN: | 4214 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
3000 | 6000 | 0000 | 0000 | -975.00 | Clear The Suspense Account | |||
9999 | 9999 | 0000 | 0000 | 975.00 | ||||
SRN: | 4215 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 6000 | 0000 | 0000 | 334.71 | Treasury Auction Revenue | |||
4000 | 3000 | 6000 | 0000 | -334.71 | ||||
SRN: | 4216 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 9000 | 0000 | 0000 | 6876.25 | Fuel Expense | |||
1000 | 2000 | 0000 | 0000 | -6876.25 | ||||
SRN: | 4261 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -148532.00 | Loan Repayment | |||
2000 | 2000 | 0000 | 0000 | 148532.00 | ||||
SRN: | 4217 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -210.12 | Houston Store Newspaper Ads | |||
6000 | 1000 | 2000 | 0000 | 210.12 | ||||
SRN: | 4218 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1100 | 0004 | 0000 | 0000 | 83047.41 | Buy WWYSIWYG Stock | |||
1000 | 1000 | 0000 | 0000 | -83000.00 | ||||
1000 | 2000 | 0000 | 0000 | -40.00 | ||||
1000 | 3000 | 0000 | 0000 | -7.41 | ||||
SRN: | 4219 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1700 | 1000 | 0000 | 0000 | 1941.41 | New Carpets for the Captain Cabin | |||
1000 | 5000 | 0000 | 0000 | -1941.31 | ||||
1000 | 2000 | 0000 | 0000 | -0.10 | ||||
SRN: | 4220 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -3001.10 | Move Cash to Dawsonville Account | |||
1000 | 3000 | 0000 | 0000 | 3001.10 | ||||
SRN: | 4221 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 6000 | 0000 | 0000 | 147.09 | Cell Phone Bill | |||
1000 | 4000 | 0000 | 0000 | -147.09 | ||||
SRN: | 4222 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -1656.74 | Limousine Rental Expense | |||
9000 | 2000 | 0000 | 0000 | -1656.74 | ||||
SRN: | 4261 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 3000 | 0000 | 0000 | -111.15 | Draperies for the salon | |||
1700 | 1000 | 0000 | 0000 | 1111.15 | ||||
SRN: | 4223 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -345.13 | Phone outlet installation | |||
9000 | 6000 | 0000 | 0000 | 345.13 | ||||
SRN: | 4228 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -88.60 | Grease Removal | |||
9000 | 8000 | 0000 | 0000 | 88.68 | ||||
SRN: | 4229 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -1943.29 | Catalog Staff Bonuses | |||
5000 | 1000 | 3000 | 1000 | 1943.29 | ||||
SRN: | 4230 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -28705.00 | Buy More Fatal Error Stock | |||
1100 | 5000 | 0000 | 0000 | -27805.00 | ||||
SRN: | 4238 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
4000 | 3000 | 6000 | 0000 | -10021.31 | Treasury Auction Revenue | |||
1000 | 3000 | 0000 | 0000 | 10021.31 | ||||
SRN: | 4239 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
5000 | 1000 | 1000 | 0000 | 8760.00 | Annual Bonuses for the Store Crew | |||
1000 | 1000 | 0000 | 0000 | -8760.00 |
final gl account count in "glmaster" (using SRCGL as the initial glmaster) |
final gl account count in "glmaster" (using SRCGLV as the initial glmaster) |
final gl account count in "glmaster" (using SRCGLC as the initial glmaster) |
Count=__________________ |
Count=__________________ |
Count=__________________ |
final journal entry count in "je" (using SRCGL as the initial glmaster) |
final journal entry count in "je" (using SRCGLV as the initial glmaster) |
final journal entry count in "je" (using SRCGLC as the initial glmaster) |
Count=__________________ |
Count=__________________ |
Count=__________________ |
final total balance from a44.asp | final total balance from a44v.aspx | final total balance from a44c.aspx |
$___________________ |
$______________________ |
$_____________________ |
| ||
|
|
|
BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER
ORDER.
BE SURE TO: SHOW THE OVERALL glmaster
BALANCE.
BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster
TABLE.
BE SURE TO: SHOW THE REPORT TIME AND DATE.
Make sure your index.htm file has working links to each assignment component (I will not grade dead links)
BE SURE TO: ORDER THE REPORT IN ASCENDING sourceref and ASCENDING
srseq ORDER.
BE SURE TO: SHOW THE NUMBER OF JOURNAL ENTRIES IN
THE je TABLE.
BE SURE TO: SHOW THE REPORT TIME AND DATE.
SO, you will turn in 10 documents (in the following order, staple together the individual documents -- i.e, ten staples):
Put your name, Student Number, Database Acct # on the top page of each of
the 10 documents.
Make sure your index.htm file has working links to each assignment component
Bind the pages so that they DO NOT fall apart.
email me at parks@uh.edu if you have issues (include your database name and pwd).