Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)
e-mail address___________________________________________________
EXAM TO BE RETURNED BY 5:30 PM FRIDAY MAY 2 TO 280E MH
Major | Minor | Sub 1 | Sub 2 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
1000 | 5000 | 0000 | 0000 | |||
7000 | 1000 | 3000 | 0000 | |||
8000 | 1000 | 3000 | 0000 | |||
4000 | 3000 | 5000 | 0000 | |||
9000 | 9000 | 0000 | 0000 | |||
9000 | 6000 | 0000 | 0000 |
Major | Minor | Sub 1 | Sub 2 | Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
2400 | 4000 | 0000 | 0000 | FICA Payable | |||
1800 | 9000 | 3000 | 0000 | Data Center Hardware | |||
9000 | 5000 | 5000 | 0000 | Data Center Lease Fees | |||
1100 | 0003 | 0000 | 0000 | Chevron Stock | |||
1100 | 0004 | 0000 | 0000 | Shell Oil Stock | |||
9100 | 2000 | 0000 | 0000 | Boston Penthouse Lease Expense | |||
1000 | 5000 | 0000 | 0000 | Cash Bank of Leona Texas | |||
4000 | 3000 | 4000 | 0000 | Capt Webb Boots Sales | |||
4000 | 3000 | 5000 | 0000 | Capt Web Parchment Sales | |||
5000 | 1000 | 4000 | 0000 | Direct Labor - Infrastructure Consultants | |||
1000 | 4000 | 0000 | 0000 | Cash Tom Petty | |||
1100 | 0008 | 0000 | 0000 | WalMart Stock | |||
1700 | 3000 | 0000 | 0000 | Antique Compass Collection |
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
3000 | 6000 | 0000 | 0000 | Retained Earnings | |||
1000 | 4000 | 0000 | 0000 | Cash Maryville Bank | |||
4000 | 3000 | 0000 | 0000 | Summary International Sales | |||
1100 | 6000 | 0000 | 0000 | Apple Stock | |||
9000 | 2000 | 0000 | 0000 | Boston Harbor Penthouse Lease | |||
9999 | 9999 | 0000 | 0000 | Suspense Account | |||
4000 | 3000 | 6000 | 0000 | Public Speaking Revenue | |||
9000 | 9000 | 0000 | 0000 | Auto Fuel Expenses | |||
7000 | 1000 | 3000 | 0000 | Direct Labor Big Data Consultants | |||
8000 | 1000 | 3000 | 0000 | Direct Labor Catalogue Sales Associates |
SRN: | 2811 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
7000 | 1000 | 3000 | 0000 | 64145.33 | Supervisory Salaries | |||
1000 | 3000 | 0000 | 0000 | -64145.33 | ||||
SRN: | 2812 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
8000 | 1000 | 3000 | 0000 | 5428.25 | Catalog Labor | |||
1000 | 1000 | 0000 | 0000 | -5428.25 | ||||
SRN: | 2813 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -23901.95 | Buy Chevron Stock | |||
1100 | 0003 | 0000 | 0000 | 23901.95 | ||||
SRN: | 2814 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
3000 | 6000 | 0000 | 0000 | -974.99 | Clear Suspense | |||
9999 | 9999 | 0000 | 0000 | 974.99 | ||||
SRN: | 2815 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 106398.24 | Internet Sales for March 2014 | |||
4000 | 3000 | 1000 | 0000 | -106000.00 | ||||
4000 | 3000 | 2000 | 0000 | -398.00 | ||||
4000 | 3000 | 3000 | 0000 | -0.20 | ||||
4000 | 3000 | 4000 | 0000 | -0.04 | ||||
SRN: | 2816 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 3300 | 1000 | 0000 | 2319.47 | Chevron Credit Card for Gasoline | |||
1000 | 4000 | 0000 | 0000 | -2391.47 | ||||
SRN: | 2861 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -34897.34 | FICA paid | |||
2400 | 4000 | 0000 | 0000 | 34897.34 | ||||
SRN: | 2817 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -1287.37 | Internet Store Maintenance | |||
6000 | 1000 | 1000 | 0000 | -1287.37 | ||||
SRN: | 2818 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1100 | 0004 | 0000 | 0000 | 40007.02 | Buy Shell Stock | |||
1000 | 2000 | 0000 | 0000 | -40007.02 | ||||
SRN: | 2819 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1700 | 1000 | 0000 | 0000 | 3820.48 | Buy New Sofa | |||
1000 | 3000 | 0000 | 0000 | -1910.24 | ||||
1000 | 2000 | 0000 | 0000 | -1910.24 | ||||
SRN: | 2820 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -76890.31 | Move Cash | |||
1000 | 5000 | 0000 | 0000 | 76890.31 | ||||
SRN: | 2821 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
8000 | 1000 | 0003 | 0000 | 309.51 | Buy Office Chair Cushions | |||
1000 | 1000 | 0000 | 0000 | -309.51 | ||||
SRN: | 2822 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 3000 | 0000 | 0000 | -90000.00 | Teamster Union Dues | |||
1000 | 1000 | 0000 | 0000 | -9000.00 | ||||
1000 | 2000 | 0000 | 0000 | -900.00 | ||||
1000 | 4000 | 0000 | 0000 | -99.01 | ||||
1000 | 1000 | 0000 | 0000 | -0.97 | ||||
9000 | 3000 | 0000 | 0000 | 99999.99 | ||||
SRN: | 2861 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 3000 | 0000 | 0000 | -58.11 | Buy Ergonomic Mouse | |||
9000 | 5000 | 0000 | 0000 | 58.11 | ||||
SRN: | 2823 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -185.15 | Delivery Drone Fuel | |||
9900 | 9000 | 0000 | 0000 | 815.15 | ||||
SRN: | 2828 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -492.91 | Delivery Drone Blades | |||
9000 | 9000 | 0000 | 0000 | 492.91 | ||||
SRN: | 2829 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -3400.00 | Store Supervisors Christmas Bonuses | |||
8000 | 1000 | 3000 | 0000 | 4300.00 | ||||
SRN: | 2830 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 19.00 | Deposit Cash for Stock | |||
3000 | 4000 | 0000 | 0000 | -19.00 | ||||
SRN: | 2838 | Fiscal Month |
11 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
7000 | 1000 | 1000 | 0000 | 80.00 | XMAS Bonus for the Captain | |||
1000 | 1000 | 0000 | 0000 | -80.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).