Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)
e-mail address___________________________________________________
EXAM TO BE RETURNED BY 5:30 PM MON DEC 4 TO 280E MH
There are 174 exam points available: Delete 24; Add 39; Modify 39; Post 60; Summary 12)
Major | Minor | Sub 1 | Sub 2 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
1100 | 0004 | 0000 | 0000 | |||
1000 | 4000 | 0000 | 0000 | |||
6000 | 1000 | 3000 | 0000 | |||
9000 | 9000 | 0000 | 0000 | |||
4000 | 3000 | 3000 | 0000 | |||
7000 | 1000 | 4000 | 0000 | |||
8000 | 1000 | 1000 | 0000 | |||
9999 | 9999 | 0000 | 0000 |
Major | Minor | Sub 1 | Sub 2 | Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
1100 | 0004 | 0000 | 0000 | Investments | |||
2400 | 2000 | 0000 | 0000 | Texas Sales Tax Payable | |||
2400 | 3000 | 0000 | 0000 | Harris County Property Tax Payable | |||
1000 | 5000 | 0000 | 0000 | Cash Bank of St. Louis | |||
1700 | 1000 | 0000 | 0000 | Furniture and Fixtures | |||
1900 | 3000 | 0000 | 0000 | Prepaid Interest | |||
1100 | 0004 | 0000 | 0000 | Facebook Stock | |||
1100 | 0006 | 0000 | 0000 | Target Stock | |||
9100 | 2000 | 0000 | 0000 | New Propeller for the Yacht | |||
1000 | 6000 | 0000 | 0000 | Cash California Bank, Stockton Branch | |||
4000 | 3000 | 5000 | 0000 | Yacht Sails Sale | |||
4000 | 3000 | 4000 | 0000 | Holiday Liquidation Sale Revenue | |||
5000 | 1000 | 4000 | 0000 | Direct Labor - Tar and Feather Crew | |||
9100 | 4000 | 0000 | 0000 | Seamen Belt Buckle Expense | |||
7000 | 1000 | 5000 | 0000 | Contract Programmer Expenses |
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
7000 | 1000 | 4000 | 0000 | US Centers Total Expense | |||
3000 | 5000 | 0000 | 0000 | PIC | |||
1000 | 5000 | 0000 | 0000 | Cash American Bank of East St. Louis | |||
9000 | 9000 | 0000 | 0000 | Electric Power Expense | |||
9100 | 1000 | 0000 | 0000 | Bank Credit Card Interest Expense | |||
4000 | 3000 | 3000 | 0000 | Web Site Sales | |||
9999 | 9999 | 0000 | 0000 | Suspense Account | |||
4000 | 3000 | 2000 | 0000 | Houston Store Sales | |||
8000 | 1000 | 3000 | 0000 | Direct Labor - Contract Programmers | |||
7000 | 1000 | 3000 | 0000 | Direct Labor Temporary Officers | |||
8000 | 1000 | 7000 | 0000 | Direct Labor Navigator Fees | |||
9100 | 2000 | 0000 | 0000 | New Office Sign | |||
9000 | 8000 | 0000 | 0000 | Sanitation Expense |
SRN: | 4211 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
4000 | 3000 | 5000 | 0000 | -316.83 | Xmas Sale Reveunue | |||
1000 | 4000 | 0000 | 0000 | 316.83 | ||||
SRN: | 4212 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
8000 | 1000 | 1000 | 0000 | 6230.01 | Hacker ransom | |||
1000 | 3000 | 0000 | 0000 | -6230.01 | ||||
SRN: | 4213 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -45505.71 | Buy More Target Stock | |||
1100 | 0006 | 0000 | 0000 | 45505.71 | ||||
SRN: | 4214 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
3000 | 5000 | 0000 | 0000 | -974.10 | Clear the Suspense Account | |||
9999 | 9999 | 0000 | 0000 | 974.10 | ||||
SRN: | 4215 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 5000 | 0000 | 0000 | 1037.81 | Yacht Sail Advertising Rental | |||
4000 | 3000 | 5000 | 0000 | -1037.81 | ||||
SRN: | 4216 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 8000 | 0000 | 0000 | 134.92 | Garbage Expense | |||
1000 | 1000 | 0000 | 0000 | -134.92 | ||||
SRN: | 4271 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -328.44 | Repayment | |||
2400 | 2000 | 0000 | 0000 | 328.44 | ||||
SRN: | 4217 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -3.43 | Welcome Mat Expense | |||
6000 | 1000 | 2000 | 0000 | 3.48 | ||||
SRN: | 4218 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1100 | 0007 | 0000 | 0000 | 1378.20 | Buy Twitter Stock | |||
1000 | 1000 | 0000 | 0000 | -1300.20 | ||||
1000 | 2000 | 0000 | 0000 | -70.00 | ||||
1000 | 3000 | 0000 | 0000 | -8.00 | ||||
SRN: | 4219 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1700 | 1000 | 0000 | 0000 | 19.53 | New Green Stapler | |||
1000 | 6000 | 0000 | 0000 | -19.35 | ||||
1000 | 2000 | 0000 | 0000 | -0.20 | ||||
SRN: | 4220 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -371.21 | Move Cash to Hawaii | |||
1000 | 5000 | 0000 | 0000 | 371.21 | ||||
SRN: | 4221 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 6000 | 0000 | 0000 | 242.19 | Long Distance Phone Bill | |||
1000 | 3000 | 0000 | 0000 | -224.19 | ||||
SRN: | 4222 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 5000 | 0000 | 0000 | -530.20 | Limo Rental Expense | |||
9000 | 2000 | 0000 | 0000 | -530.20 | ||||
SRN: | 4271 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -14.15 | Bought New Wall Clock | |||
1700 | 1000 | 0000 | 0000 | 14.15 | ||||
SRN: | 4223 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 6000 | 0000 | 0000 | -2145.12 | New iPhone 11 prototype | |||
9000 | 6100 | 0000 | 0000 | 2145.12 | ||||
SRN: | 4228 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -39.32 | Party Hats for the Office Party | |||
9000 | 5000 | 0000 | 0000 | 38.32 | ||||
SRN: | 4229 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -3330.21 | Cashier Bonuses | |||
5000 | 1000 | 3000 | 0000 | 3330.21 | ||||
SRN: | 4230 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 200750.00 | Sell Stock | |||
1100 | 0003 | 0000 | 0000 | -200750.00 | ||||
SRN: | 4238 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
4000 | 3000 | 3000 | 0000 | -54.02 | Gangplank Salvage Sales | |||
1000 | 3000 | 0000 | 0000 | 54.02 | ||||
SRN: | 4239 | Fiscal Month |
7 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
5000 | 1000 | 1000 | 0000 | 221.01 | Vacation Bonuses for the Store Crew | |||
1000 | 2000 | 0000 | 0000 | -221.01 |
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).