Last 4 Digits of your PSID_________________auckland server Acct__________________ (glxxxx)
e-mail address___________________________________________________
There are 168 exam points available in the five sections shown below:
Section 2 | Delete | 27 |
Section 3 | Add | 36 |
Section 4 | Modify | 36 |
Section 5 | Journal Voucher Posting | 60 |
Section 6 | Summary | 12 |
TOTAL POINTS | 171 |
Major | Minor | Sub 1 | Sub 2 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
1000 | 4000 | 0000 | 0000 | |||
1000 | 5000 | 0000 | 0000 | |||
6000 | 1000 | 3000 | 0000 | |||
6000 | 1000 | 4000 | 0000 | |||
1000 | 1000 | 0000 | 0000 | |||
4000 | 3000 | 3000 | 0000 | |||
9100 | 2000 | 0000 | 0000 | |||
7000 | 1000 | 1000 | 0000 | |||
9999 | 9999 | 0000 | 0000 |
Major | Minor | Sub 1 | Sub 2 | Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
9100 | 2000 | 0000 | 0000 | Satellite Emergency Phone | |||
1000 | 5000 | 0000 | 0000 | Cash Account Bank of Morgantown WV | |||
1700 | 3000 | 0000 | 0000 | Office Copier | |||
9000 | 5000 | 5000 | 0000 | Sail Repair | |||
1100 | 0004 | 0000 | 0000 | Shell Oil Stock | |||
1100 | 0005 | 0000 | 0000 | Blue Bell Ice Cream Stock | |||
9100 | 2000 | 0000 | 0000 | Gold Account Upgrade | |||
9000 | 3000 | 1000 | 0000 | Sea Captain Retirement Funds | |||
4000 | 3000 | 4000 | 0000 | Plunder Revenue | |||
4000 | 3000 | 6000 | 0000 | Annual Seaport Protection Revenue | |||
5000 | 1000 | 2000 | 0000 | Direct Labor - Deck Swabbers | |||
9100 | 9200 | 0000 | 0000 | Portsmouth Custom Uniforms |
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC |
2500 | 1000 | 0000 | 0000 | Harris County Sales Tax Payable | |||
3000 | 5000 | 0000 | 0000 | Paid In Capital | |||
1000 | 4000 | 0000 | 0000 | Petty Cash | |||
5000 | 1000 | 3000 | 0000 | Web Design Consulting | |||
1100 | 4000 | 0000 | 0000 | Royal Dutch Shell Stock | |||
4000 | 3000 | 6000 | 0000 | Dry Tortuga Safe Harbor Tribute | |||
9999 | 9999 | 0000 | 0000 | Suspense Account | |||
4000 | 3000 | 3000 | 0000 | Capt. Webb Online Sales | |||
8000 | 1000 | 3000 | 0000 | Direct Labor - Master Navigator | |||
7000 | 1000 | 2000 | 0000 | Direct Labor Treasure Salavage Team | |||
8000 | 1000 | 3000 | 0000 | Cannoneers Subtractors | |||
9000 | 4000 | 0000 | 0000 | Pirate Ship Liability Insurance Expense |
SRN: | 4811 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
4000 | 3000 | 1000 | 0000 | 757.42 | Bildge Sale Revenue | |||
1000 | 4000 | 0000 | 0000 | -757.42 | ||||
SRN: | 4812 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
8000 | 1000 | 3000 | 0000 | 312.21 | Part-Time Catalog Sales | |||
1000 | 2000 | 0000 | 0000 | -312.21 | ||||
SRN: | 4813 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | 5435.01 | Sold Microsoft Stock | |||
1100 | 0003 | 0000 | 0000 | -5435.01 | ||||
SRN: | 4814 | 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 Suspense Account | |||
9999 | 9999 | 0000 | 0000 | 975.00 | ||||
SRN: | 4815 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 6000 | 0000 | 0000 | 43364.43 | November Internet Revenue | |||
4000 | 3000 | 1000 | 0000 | -43364.43 | ||||
SRN: | 4816 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 9000 | 0000 | 0000 | 16372.32 | Diesel Fuel Expense | |||
1000 | 1000 | 0000 | 0000 | -16372.32 | ||||
SRN: | 4861 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -89132.13 | Ship Note Repayment | |||
2400 | 2000 | 0000 | 0000 | 89123.13 | ||||
SRN: | 4817 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -56013.18 | Galleria Store Remodel Labor | |||
6000 | 1000 | 1000 | 0000 | 56013.18 | ||||
SRN: | 4818 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1100 | 0005 | 0000 | 0000 | 8084.25 | Buy Blue Bell Stock | |||
1000 | 1000 | 0000 | 0000 | -8000.00 | ||||
1000 | 2000 | 0000 | 0000 | -80.00 | ||||
1000 | 3000 | 0000 | 0000 | -4.25 | ||||
SRN: | 4819 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1700 | 1000 | 0000 | 0000 | 347.71 | New Skull and Crossbones Flag | |||
1000 | 5000 | 0000 | 0000 | -347.61 | ||||
1000 | 2000 | 0000 | 0000 | -0.10 | ||||
SRN: | 4820 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -4000.10 | Move Cash to Field Account | |||
1000 | 3000 | 0000 | 0000 | 4000.11 | ||||
SRN: | 4821 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
9000 | 6100 | 0000 | 0000 | 832.93 | Overseas Phone Bill | |||
1000 | 1000 | 0000 | 0000 | -832.93 | ||||
SRN: | 4822 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -58916.74 | Dry Tortuga Fort Rental Expense | |||
9000 | 2000 | 0000 | 0000 | -58916.74 | ||||
SRN: | 4861 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 3000 | 0000 | 0000 | -911.26 | Compass | |||
1700 | 1000 | 0000 | 0000 | 911.26 | ||||
SRN: | 4823 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 4000 | 0000 | 0000 | -47.32 | Phone removal | |||
9000 | 6000 | 0000 | 0000 | 47.32 | ||||
SRN: | 4828 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -456.60 | Garbage Scow Lease | |||
9000 | 8000 | 0000 | 0000 | 456.00 | ||||
SRN: | 4829 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 2000 | 0000 | 0000 | -100.00 | Navigator Accuracy Bonuses | |||
5000 | 1000 | 3000 | 0000 | 100.00 | ||||
SRN: | 4830 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
1000 | 1000 | 0000 | 0000 | -9275.00 | Buy More MS Stock | |||
1100 | 3000 | 0000 | 0000 | -9275.00 | ||||
SRN: | 4838 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
4000 | 3000 | 2000 | 0000 | -8255.26 | Houston Store Revenues | |||
1000 | 3000 | 0000 | 0000 | 8255.26 | ||||
SRN: | 4839 | Fiscal Month |
12 | Outcome using SRCGL |
Outcome using SRCGLV |
Outcome using SRCGLC | ||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | |||
5000 | 1000 | 1000 | 0000 | 8715.70 | Annual Bonuses for the Crew | |||
1000 | 1000 | 0000 | 0000 | -8715.70 |
|
|
|
Final gl account count in "glmaster" Count=__________________ |
Final gl account count in "glmaster" Count=__________________ |
Final gl account count in "glmaster" Count=__________________ |
Final journal entry count in "je" Count=__________________ |
Final journal entry count in "je" Count=__________________ |
Final journal entry count in "je" Count=__________________ |
Final total balance from a44.asp $___________________ |
Final total balance from a44v.aspx $___________________ |
Final total balance from a44c.aspx $___________________ |
Which Cash accounts are overdrawn?
| Which Cash accounts are overdrawn?
| Which Cash accounts are overdrawn?
|
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).