Problem Senior A1

Omnis Mus Problem Senior A1 (--> use with OMBASE01.MDB)

General journal entries can be entered using either transaction analysis format or debit credit format.  Transaction analysis format is the initial setting.  This preference can be changed from the Main Menu (click Options), and/or from the keyboard used to input numbers in a general journal transaction (click Format).

1. Enter the following transactions into the general journal.

All of the following may be dated June 12.

1a. A cash payment of $450.29 for a previously accrued expense.  (decrease 20200 Miscellaneous Accrued Expense)

1b. Purchase of supplies for $512.40 cash.  (increase 10410 Supplies)

1c. Received $400 cash for services provided to a customer.  (Increase account 60200 Other Revenue)

1d. Reimbursed the Petty cash fund $82.10 for a Miscellaneous expense (account 80400)

1e. Declared a cash dividend of $0.50 per share, payable on July 31.  (35009 Dividends Declared is a contra-equity account)


2. Order Processing

Open the Orders form. The orders form functions as a sales journal. Orders become sales when the order is shipped and shipping charges are entered into the order.

a: Enter shipping charges for the following orders:

(Click Options, Edit Order in Record mode Shortcut: double-click the shipping field)

1007 $34.12

1008 $12.75

1009 $45.30

1010 $18.54

b: Post Sales (shipped orders)

To post orders, click Options and then click Post.

Only the following orders will be posted:

-Those with shipping charges (meaning that the order is shipped).

-Those not previously posted.

Posting will:

update the accounts receivable subsidiary ledger

update the general ledger with summary data.


3. Order Processing - Additional Transactions

Enter the following items into the Orders form.

None of these orders have been shipped.

Order number 1011

Customer: Moon Electronics (12102)

Date: 6/12

Order type: email

Items:

40 1346720000 BridgeKnight

12 1713620500 BridgeBrain

30 2056988333 MrBridge

25 4509833100 BridgeStar

50 6000310005 EasyBridge

60 6055044500 ValueBridge

Order number 1012

Customer: Tillie's Shop (12110)

Date: 6/12

Order type: fax

Items:

12 2044590910 BetterBridge

80 4098048900 CheckerBrain

50 6088805600 VisualBridge

25 6088806500 VisualChess

50 7034554666 Bridge Mus

Order number 1013

Customer: Games Galore (12149)

Date: 6/12

Order Type: phone

Items:

30 2092350999 ChessWiz

12 2304500010 Interactive Chess

50 3023469877 Molly's Bridge

80 6088806500 VisualChess

40 8077680800 Network Bridge

Order number 1014

Customer: Video Boutique (12103)

Date: 6/12

Order Type: phone

Items:

20 0834210205 BridgeGuest

24 1713620500 BridgeBrain

30 2022521015 MsBridge

12 4509833050 ChessStar

18 8923405000 BridgePrince

Order number 1015

Customer: Bridge Things (12145)

Date: 6/12

Order Type: fax

Items:

25 6088805600 VisualBridge

200 7034554666 Bridge Mus

20 8077680800 Network Bridge

40 8097643400 Omnus Bridge

Order number: 1016

Customer: Jack's (12130)

Date: 6/12

Order Type: mail

Items:

80 1713621000 ChessBrain

44 2090515020 ChessChamp

50 2304500010 Interactive Chess

210 4098048900 CheckerBrain

60 4509833050 ChessStar


4. Receipts on Account

Open the Receipts on Account form.

a: Enter the following receipts.

Number: 1009

Customer: 12135 Zap!

Date: 6/12

Credit: 0.00

Cash: 2,010.86

Number: 1010

Customer: 12131 Queen's

Date: 6/12

Credit: 270.00

Cash: 3,003.54

Number: 1011

Customer: 12120 Wonderful Times

Date: 6/12

Credit: 20.00

Cash: 750.50

Number: 1012

Customer: 12122 Gamemeister

Date: 6/12

Credit: 120.00

Cash: 8,920.00

b: Post Receipts

To post receipts, click Options and then click Post.

Posting will:

update the accounts receivable subsidiary ledger

update the general ledger with summary data.

Only receipts not previously posted will be posted.


5. Purchases

Open the Purchases form.

a: Enter the following purchases.

Number: 1007

Vendor: 15212 SpaceCat

Due date: 7/12

Invoice: 126000

Amount: 675.00

Freight: 14.50

Number 1008

Vendor: 23045 Snow Software

Due date: 7/12

Invoice: 30433

Amount: 1,200.00

Freight: 45.25

Number 1009

Vendor: 60888 Kiss Software

Due date: 7/12

Invoice: 311

Amount: 850.00

Freight: 22.25

Number 1010

Vendor: 99444 PC Resources

Due date: 7/12

Invoice: 4566

Amount: 1,275.00

Freight: 35.85

b: Post Purchases

To post purchases, click Options and then click Post.

Posting will:

update the accounts payable subsidiary ledger

update the general ledger with summary data.

Only purchases not previously posted will be posted.


6. Payments to Vendors

Open the Payments to Vendors form.

a: Enter the following payments.

Number 1007

Vendor 08342 Bridgemeisters

Date 6/12

Credit 50.00

Cash 2,000.00

Number 1008

Vendor 17136 MollyWare

Date 6/12

Credit 38.00

Cash 3,250.15

Number 1009

Vendor 45098 Game Bits

Date 6/12

Credit 0.00

Cash 698.00

Number 1010

Vendor 65778 Nandos

Date 6/12

Credit 289.00

Cash 2,500.00

b: Post Payments

To post payments, click Options and then click Post.

Posting will:

update the accounts payable subsidiary ledger

update the general ledger with summary data.

Only payments not previously posted will be posted.


7. Order Processing

Open the Orders form.

a: Enter shipping charges for the following orders:

1011 $29.18

1012 $34.25

1013 $72.20

1014 $18.25

1015 $40.00

1016 $72.12

b: Post Sales (shipped orders)

To post orders, click Options and then click Post.

Only the following orders will be posted:

-Those with shipping charges (meaning that the order is shipped).

-Those not previously posted.


8. Enter the following transactions in the general journal.

All of the following may be dated June 30.

8a. Analysis of account 10440 Miscellaneous Prepaid Expense indicates that it should have a $225 balance on June 30.  (increase 80400 Miscellaneous expense)

8b. Record the payroll for the month:

Salaries $6,000.00

Accrued Payroll $4,200.00

Accrued Payroll-Taxes $950.00

Accrued Payroll-Other $850.00

8c. Employer's payroll tax expense is 12%.  Increase Payroll Taxes expense and Accrued Payroll-Taxes

8d. The Fixed Assets (account 10500) are being depreciated by the straight-line method over 25 years. The estimated residual value is $20,000. Record depreciation expense for the 6 months ending June 30.

8e. An aging analysis was performed to estimate bad debts expense.  There should be a $1,200 allowance for bad accounts as of June 30.

8f. Supplies were counted and found to be $2,800 at June 30.

8g. Accrue the following expenses.

Increase account 20200 Miscellaneous Accrued Expense for each expense unless there is a specific liability account for the expense.  If an expense has a prepaid balance in the general ledger, properly reflect the reduction of the prepaid balance in your journal entry.

8g1. Advertising expense $150.45

8g2. Insurance expense $250.00

8g3. Interest expense $380.00

8g4. Janitorial expense $125.00

8g5. Property tax expense $96.12

8g6. Rent expense $1,600.00

8g7. Utilities expense $392.74

8g8. Shipping expense $305.25


9. Close Accounts: Prepare Statements

The ending inventory was costed at $156,000.

Omnis Mus will ask for this figure when you close the accounts.

Open the general ledger, and click Options. Click Close Accounts.

Financial statements may be viewed after closing from the Report form.

Review the financial statements, and correct any errors as necessary.  If you make any corrections, then you must Close Accounts again to have the financial statements updated for your corrections.

You may Close Accounts as often as you wish.

PLEASE NOTE:

Post Closing Entries will zero all revenue and expense accounts.  Do not Post Closing Entries until you are certain that you are finished with your assignment(s).   If in doubt, do not Post Closing Entries. You do NOT have to post Closing Entries to produce financial statements.