General Ledger

INSTRUCTIONS (GENERAL LEDGER) Using the Chart of Account enter the source documents for Global Bikes International (GBI)

Views 47 Downloads 8 File size 3MB

Report DMCA / Copyright

DOWNLOAD FILE

Recommend stories

Citation preview

INSTRUCTIONS (GENERAL LEDGER) Using the Chart of Account enter the source documents for Global Bikes International (GBI) using the General Ledger. The keystrokes for some of the exercises have been done for you. SOURCE DOCUMENTS Exercise 1: Display the Chart of Accounts Menu Path Trans Code

AccountingFinancial AccountingGeneral Ledger==>Information SystemGeneral Ledger Reports (New)Master Data Chart of Accounts S_ALR_87012326

Step 1: Go to your Chart of Accounts by entering the menu path or Transaction Code

Produced by Neal Mannas

Step 2: Double Click your Chart of Accounts a new screen will appear that looks as follows:

Step 3: In the chart of accounts field enter the following: Chart of accounts: GL00 (Global GBI chart of accounts) Chart of accts not assigned: 1 A screenshot is below:

Produced by Neal Mannas

Step 4: Click the Execute button

or press F8

A screenshot is below:

Produced by Neal Mannas

Step 5: View your chart of accounts, it should look as below:

Produced by Neal Mannas

Step 6: Print your chart of accounts as indicated in the screenshot below:

Produced by Neal Mannas

Produced by Neal Mannas

Note: Keep a copy of the chart of accounts with at all times as it makes it easier to do transactions in SAP.

Produced by Neal Mannas

Exercise 2 Purchase Invoice ### Q2GL Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

***Please note ### is your unique number*** Step 1: Go to your “Enter G/L Account Document” by following the menu path or entering the transaction code.

Step 2: Double Click “Enter G/L Account Document” and a screen should appear as below:

Produced by Neal Mannas

(The above screen may or may not appear, it depends if this is the first transaction you have done in the G/L. Make sure you choose US00)

Step 3: If your company code is wrong, click on Company Code and choose US00 as indicated in the screenshot below:

Produced by Neal Mannas

A screen will appears as indicated below:

Produced by Neal Mannas

Step 4: Enter the following information Document Date: Posting Date: Reference: ### Q2GL Click on G/L acct and enter account 740000 (Supplies Expense) Choose D/C: Debit Amount in doc. Curr.: 941.60 Cost Center: NAAD1000 On the next line enter the following: G/L acct: 300200 D/C: Credit Amount in doc. Curr: 941.60

Produced by Neal Mannas

Your final screen should look as indicated below:

Make sure the light turns green under accounting information. This shows that the debits and credits balance. Click the simulate

button at the top of your screen

Produced by Neal Mannas

A journal entry will appear that looks like in the screenshot below:

Produced by Neal Mannas

Click the Post button the screenshot below:

(Make sure you do no click the park button). The post button is located as per

Produced by Neal Mannas

Record the document number at the bottom of the screen as indicated in the screenshot below:

Produced by Neal Mannas

Exercise 3 Bank Credit Memo ### Q3GL Took a $10,000 loan from the bank to secure the purchase of new bicycle parts. The loan was deposited into the bank account. Create a new G/L account called 300### Bank Loan Payable. Remember ### is your unique number assigned to you by the instructor. Part A: Menu Path

Accounting  Financial Accounting  General LedgerMaster RecordsG/L Accounts  Individual Processing  In Chart of Accounts

Trans Code

FSP0

Step 1: Follow the menu path as indicated above or enter the transaction code. You should be in the following location:

Produced by Neal Mannas

Step 2: Double click the In Chart of Accounts program and your screen should look as below:

Produced by Neal Mannas

Enter the following information: G/L Account: 300### (Remember ### is your unique number) Chart of Accts: GL00 Click: Create button Account Group: Balance Sheet Accounts Balance Sheet Account Short Text: Bank Loan G/L Acct Long Text: Bank Loan Payable Your screen should look as indicated below:

Produced by Neal Mannas

Click

and then save

to create a new G/L account

Noticed when the data is saved it says data saved as indicated in the screenshot below:

Produced by Neal Mannas

Part B: Menu Path

Accounting  Financial Accounting  Master RecordsG/L Accounts  Individual Processing  Centrally

Trans Code

FS00

Enter the following information: G/L Account: 300### Company Code: US00 Click Create Button Click on Control Data Tab and enter the following:

Produced by Neal Mannas

Account currency: USD Tick: Only balance in local crcy Your screen should look like the one below:

Click on the Create/bank/interest Tab Field status group: ZGBS Untick: Post automatically only (if it is ticked, if it not ticked just leave it unticked) Click save button

Produced by Neal Mannas

Part C:

Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Step 1: Following the menu path go to the “Enter G/L Account Document” or enter the transaction code. The screenshot is below to get to “Enter G/L Account Document”

Step 2: Click on “Enter G/L Account Document” and enter the following information: Document Date:

Produced by Neal Mannas

Posting Date: Reference: ### Q3GL G/L acct: 100000 D/C: Debit Amount in doc.curr: 10,000 G/L acct: 300### D/C: Credit Amount in doc. Curr: 10,000 Click Enter button Your screen should look as indicated below:

Produced by Neal Mannas

Click the simulate

button

Your screen should look similar to the one below:

Click the Post button

Produced by Neal Mannas

Exercise 4 Sales Invoice ### Q4GL Charged $3,200 to Extreme Bikes for services provided. Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Step 1 Go to the menu path or enter the transaction number as indicated above.

Step 2: Enter in the following information:

Produced by Neal Mannas

Company Code: US00 Document Date: Posting Date: Reference: ### Q4GL G/L acct: 110100 D/C: Debit Amount in doc Curr: 3,200 G/L acct: 600000 D/C: Credit Amount in doc. Curr: 3,200 Click: Click: Click: Exercise 5 Sales Invoice ### Q5GL Charged $800 to Recreational Bikes for repairs. Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Exercise 6 Memo ### Q6GL Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

The invoice from ### Q2GL was entered incorrectly it should have been for $900. Produced by Neal Mannas

Step 1: Enter the following information: Document Date: Posting Date: Reference: ### Q6GL The screen will look similar to the one below:

G/L acct: Click the browse button and make sure you are on the tab “G/L accunt description in chart of acco…” and Enter Payab* as follows:

Produced by Neal Mannas

Produced by Neal Mannas

Click Choose Account: 300200

Produced by Neal Mannas

You should now be back to the main screen that looks like the one below:

Produced by Neal Mannas

Produced by Neal Mannas

Now enter the following information: D/C: Debit Amount in doc cur: 41.60 G/L acct: 740000 D/C: Credit Amount in doc. Curr: 41.60 Cost Center: NAAD1000 Your entry should look like the screenshot below:

Produced by Neal Mannas

Click: Click: Click Post: Exercise 7 Sales Invoice ### Q7GL Charged $5,000 to Snowy Bikes for bike decorations Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Produced by Neal Mannas

Exercise 8 Purchase Invoice ### Q8GL Received an invoice for $200 from Westcoast advertisers for legal and professional work. Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Exercise 9 Cash Sales Invoice ### Q9GL Received $1,500 cash from Stanley tours for bike rentals. Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Exercise 10 Cheque Copy ### Q10GL Issued cheque to pay for Invoice ### Q2GL for $900. Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Produced by Neal Mannas

Exercise 11 Cash Receipt ### Q11GL Received $800 from Recreational Bicycles refer to Sales Invoice ### Q5GL

Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Exercise 12 Bank Debit Memo ### Q12GL Bangkok Bank New York automatically deducted the utilities expense of $40 from our account that is paid directly to Clean Hydro. Menu Path

Accounting  Financial AccountingGeneral Ledger  Posting Enter G/L Account Document

Trans Code

FB50

Exercise 13 Printing the General Journal

Menu Path

Accounting  Financial AccountingGeneral LedgerInformation System  General Ledger Reports (New)Document  General Document Journal

Trans Code

S_ALR_87012287

Go to the menu path as indicated below or enter the transaction code:

Produced by Neal Mannas

Company Code - Enter US00 Fiscal Year - Currently we are in 2012 Posting date – the date range for your entries (Example 27.10.2012 to 27.10.2012 (Enter in the DD.MM.YYYY format) Reference – *###* (For example if your unique number is 050, you will enter *050*) A screenshot example is below.

Produced by Neal Mannas

Click: execute Ignore any warning messages by clicking View the report Check for all of your entries for the module.

Produced by Neal Mannas

Exercise 14 Print the following reports: 1. G/L Account Balances 2. Financial Statement Part 1: Menu Path

Accounting  Financial AccountingGeneral LedgerInformation System  General Ledger Reports (New)Account BalancesG/L Account Balances

Trans Code

S_ALR_87012277

Enter your company code as illustrated below (Remember everyone has their own unique company code):

Produced by Neal Mannas

Choose your fiscal year Click: execute View the report Part 2: Menu Path

Accounting  Financial AccountingGeneral LedgerInformation System  General Ledger Reports (New)Financial Statement/Cash Flow General  Actual/Actual Comparisons

Trans Code

S_ALR_87012284

Produced by Neal Mannas

Produced by Neal Mannas