External Financial Accounting (102)



Download 1.66 Mb.
Page16/21
Date09.01.2017
Size1.66 Mb.
#8080
1   ...   13   14   15   16   17   18   19   20   21

3.4Bank Accounting

3.4.1Bank Accounts

3.4.1.1Updating House Bank Account with House Bank ID


Use

If you want to run the automatic payment run program or if you want to post a bank statement automatically you need to set up the bank identification in your corresponding general ledger master data.



Procedure

  1. Access the activity using one of the following navigation options:

    SAP ECC menu

    Accounting ® Financial Accounting ® General Ledger ® Master Records ® G/L Accounts ® Individual Processing ® In Company Code

    Transaction code

    FS00

  2. On the Edit G/L Account Company code data screen, make the following entries:

    Field name

    Description

    User action and values

    Comment

    G/L Account




    100000




    Company Code




    1000




  3. Choose Create/bank/interest.

  4. Make the following entries:

    Field name

    Description

    User action and values

    Comment

    House bank




    AU




    Account ID




    GIRO




  5. Choose Save.

  6. On the Edit G/L Account Company code data screen, make the following entries:

    Field name

    Description

    User action and values

    Comment

    G/L Account




    101000




    Company Code




    1000




  7. Choose Create/bank/interest.

  8. Make the following entries:

    Field name

    Description

    User action and values

    Comment

    House bank




    MB




    Account ID




    CHF




  9. Choose Save.

  10. On the Edit G/L Account Company code data screen, make the following entries:

    Field name

    Description

    User action and values

    Comment

    G/L Account




    102000




    Company Code




    1000




  11. Choose Create/bank/interest.

  12. Make the following entries:

    Field name

    Description

    User action and values

    Comment

    House bank




    US




    Account ID




    GIRO




  13. Choose Save.

3.4.2Business Transactions

3.4.2.1Checking Deposit

3.4.2.1.1Defining Variants for Check Deposit/ Manual Bank Statement/ GL items: Administration

Use

In this step, you can create your own account assignment variants for check deposits to adapt the assignment and/or Chooseion of the account assignment fields to meet your company’s needs. One variant is shipped by default. This variant cannot be changed. If you do not want to use the standard variant, you can deactivate it. Any new variants you create must be activated.

The variants contain the following fields:

YB01: Amount, 10-Digit Check Number, Check Issuer, 8-Digit Bank Key, Reference Document No. (sel.), Customer Number (sel.)



YB02: Amount, 10-Digit Check Number, Check Issuer, 8-Digit Bank Key, Reference Document No. (sel.), Customer Matchcode (sel.)

Procedure

  1. Access the activity using one of the following navigation options:

    Transaction code

    OT45

    IMG menu

    Financial Accounting (NEW) ® Bank Accounting ® Business Transactions ® Check Deposit ® Define Variants for Check Deposits

  2. On the Line Layout Fast Entry: Administration screen, make the following entries:

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry Variant Active?

    Fast Entry Activation Date

    No. following Screen

    SAPMF40S

    SCHKR

    YB01

    X

    11.09.2000

    8002

    SAPMF40S

    SCHKR

    YB02

    X

    11.09.2000

    8001

  3. On the Line Layout Fast Entry: Variants screen, make the following entries:

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry No. of Lines

    SAPMF40S

    SCHKR

    YB01

    1

    SAPMF40S

    SCHKR

    YB02

    1

  4. On the Line Layout Fast Entry: Description of Variants screen, make the following entries:

    Language

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry Variant Descr.

    EN

    SAPMF40S

    SCHKR

    YB01

    Check (Check no/Ref./Customer)

    EN

    SAPMF40S

    SCHKR

    YB02

    Check (Matchcode)

  5. On the Line Layout Fast Entry: Variant Fields screen, make the following entries:

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry No. of Lines

    Fast Entry No. of Column

    Fast Entry Offset

    Compl. Field name

    Fast Entry Field Output Length

    SAPMF40S

    SCHKR

    YB01

    1

    01

    03

    FEBSCA-KWBTR

    14

    SAPMF40S

    SCHKR

    YB01

    1

    02

    18

    FEBSCK-SCH10_PRSC

    10

    SAPMF40S

    SCHKR

    YB01

    1

    03

    29

    FEBSCK-AUSST_PR

    13

    SAPMF40S

    SCHKR

    YB01

    1

    04

    43

    FEBSCK-BNK08_PRBL

    08

    SAPMF40S

    SCHKR

    YB01

    1

    05

    52

    FEBSCK-XBLNR

    16

    SAPMF40S

    SCHKR

    YB01

    1

    06

    69

    FEBSCK-KUNNR

    10

    SAPMF40S

    SCHKR

    YB02

    1

    01

    03

    FEBSCA-KWBTR

    14

    SAPMF40S

    SCHKR

    YB02

    1

    02

    18

    FEBSCK-SCH10_PRSC

    10

    SAPMF40S

    SCHKR

    YB02

    1

    03

    29

    FEBSCK-AUSST_PR

    14

    SAPMF40S

    SCHKR

    YB02

    1

    04

    44

    FEBSCK-BNK08_PRBL

    08

    SAPMF40S

    SCHKR

    YB02

    1

    05

    53

    FEBSCK-XBLNR

    16

    SAPMF40S

    SCHKR

    YB02

    1

    06

    70

    FEBSCK-KUNNR_MC

    07

  6. Choose Save.

3.4.2.2Payment Transactions

3.4.2.2.1Manual Bank Statement
3.4.2.2.1.1Making Global Settings for Electronic Bank Statement

Use

In this activity you make the global settings for the account statement. There are four main steps to be carried out:



  • Create account symbol
    Specify G/L accounts (such as bank, cash receipt, outgoing checks) whose postings have to be made from account statement. You assign account symbols to the G/L account numbers. These are required for the posting rules in step 2.

  • Assign accounts to account symbols
    Define postings to be triggered by possible transactions in the account statement (such as bank transfer, debit memo). In the Posting Specifications Debit ® Credit which you define here, use the account symbols from step 1, but not the G/L account numbers. This prevents similar posting rules being defined several times, the only difference between them being the accounts to which postings are made.

  • Create keys for posting rules
    Assign posting rules to possible transactions in account statement file. A list of assignments where one external transaction code is assigned to one posting rule is called transaction type.

  • Create a transaction type
    Assign bank details, for which the account statements have to be imported, to a transaction type. All the house bank accounts at a particular bank are assigned to the same transaction type.

tip
For the following entries you have one customizing topic. If you have entered the customizing topic you find all other settings in the Dialog Structure on the left hand side of the screen.

Procedure

  1. Access the activity using one of the following navigation options:

    Transaction code

    SPRO

    IMG menu

    Financial Accounting (NEW) ® Bank Accounting ® Business Transactions ® Payment Transactions ® Electronic Bank Statement ® Make Global Settings for Electronic Bank Statement

  2. Enter chart of accounts YAAU. Choose Continue.

  3. Create Account and assign them to Account Symbols:

You create account symbols to define the posting specifications. Before the posting rules are used, the individual account symbols are replaced by the account to which items are to be posted. In this step, you define how accounts are determined for a particular account symbol. To avoid you having to define a separate account symbol for each individual house bank account (each with a different G/L account and separate bank clearing accounts), the G/L Acct field can contain a masked output.

Account

Acct Mod.

Currency

G/L Acct

Text

AUSG-UEBERW-AUS

+

+

++++++++30

Foreign out. transf.

AUSG-UEBERW-INL

+

+

++++++++10

Domestic out. transf

BANK

+

+

++++++++++

Bank account

BANKEINZUG

+

+

++++++++40

Bank collection

GELDEINGANG

+

+

++++++++70

Cash receipt

KASSE

+

+

++++++++++

Cash on hand

SCHECKAUSGANG

+

+

++++++++10

Outgoing checks

SCHECKEINGANG

+

+

++++++++60

Incoming checks

SCHECKVERRECHNG

+

+

++++++++80

Check clearing acct

SONSTIGE

+

+

++++++++50

Other bank trans.

SPESEN

+

+

650010

Bank fees account

  1. Create Keys for Posting Rules:

In this step, you create the descriptions for the required posting rules. Each posting rule represents the business transaction on the bank statement in the SAP system, such as a check received, a credit memo or debit memo.

Posting Rule

Text

001+

Cash inflow via interim account

002 +

check credit memo through bank

003-

Cashed check

004-

Domestic transfer

005-

Foreign transfer

006-

Other disbursements

007+

Other receipts

008-

Cash payment

009+

Cash receipt

010+

Collection/direct debit

011-

Returns collection/direct debit

012-

Bank free

013+

Interest received

014-

Interest paid

015+

Payment by credit card

016-

Vendor direct debit

017+

Treasury receipts

018-

Treasury disbursements

  1. Define Posting Rules/Posting Specifications:

In this step, you create posting specifications for each posting rule. The posting specifications enable you to define how a particular business transaction (such as a credit memo) has to be posted.

Posting specifications comprise one or two posting records Debit Credit. The first posting record is called posting area 1 and involves a G/L account posting (BANK ACCOUNT CASH RECEIPT, for example). The second posting record, which is optional is called posting area 2 (CASH RECEIPT CUSTOMER, for example).



Depending on whether a posting transaction affects bank accounting only, or affects both bank accounting and subledger accounting, you define posting rules either for the first posting area only, or for both the first and second posting areas.




Pstg Rule

PosAr

PKey

Account (Debit)

PKey

Account (Credit)

Doc. Type

Pst Ty

Cash inflow via interim account

001+

1

40

BANK

50

GELDEINGANG

SA

1




001+

2

40

GELDEINGANG







DZ

8

Check credit memo through bank

002+

1

40

BANK

50

SCHECKEINGANG

SA

1

Cashed check

003-

1




SCHECKAUSGANG

50

BANK

SA

4

Domestic transfer

004-

1




AUSG-UEBERW-INL

50

BANK

SA

4

Foreign transfer

005-

1




AUSG-UEBERW-AUS

50

BANK

SA

4

Other disbursements

006-

1

40

SONSTIGE

50

BANK

SA

1

Other receipts

007+

1

40

BANK




SONSTIGE

SA

5

Cash payment

008-

1




BARAUSZAHLUNG

50

BANK

SA

4

Cash receipt

009+

1

40

BANK




BAREINZAHLUNG

SA

5

Collection/
direct debit

010+

1

40

BANK




BANKEINZUG

SA

5

Returns collection/
direct debit

011-

1

40

SONSTIGE

50

BANK

SA

1

Bank fee

012-

1

40

BANKGEBUEHREN

50

BANK

SA

1

Interest received

013+

1

40

BANK

50

ZINSERTRAG

SA

1

Interest paid

014-

1

40

ZINSAUFWAND

50

BANK

SA

1

Vendor direct debit

016-

1

40

AUSG-UEBERW-INL

50

BANK

SA

1




016-

2







50

AUSG-UEBERW-INL

KZ

7

Treasury receipts

017+

1

40

BANK




TREASURYEINGANG

SA

5

Treasury disbursements

018-

1




TREASURYAUSGANG

50

BANK

SA

4

Direct check deposit

CD01

2

40

SCHECKEINGANG







DZ

8

Check deposit via interim account

CD02

1

40

SCHECKEINGANG

50

SCHECKVERRECHNG

SA

1







2

40

SCHECKVERRECHNG







DZ

8

tip

Returns collections/direct debits are posted to the account for other interim postings, since they need to be post processed.



  1. Create Transaction Type:

In this step, you create the names and descriptions for the various transaction types required. House banks that use identical lists of business transaction codes (external transactions) can later be assigned to the same transaction type.

Trans. Type

Name

MC

MultiCash

  1. Assign External Transaction Types to Posting Rules:

In this step, you assign (external) business transaction codes to a posting rule (internal), which enables you to use the same posting specifications for different business transaction codes.

Ext Trans

+/-

Post. Rule

Int. Algthm.




001

-

003-

012

Outgoing check: check number same as payment doc. no.

002

-

003-

012

Outgoing check: check number same as payment doc. no.

004

-

016-

021

Reference document number search

005

-

016-

021

Reference document number search

009

-

011-

000

No interpretation

020

-

004-

019

Reference no. (DME management)

051

+

001+

020

Document number search

070

+

002+

000

No interpretation

071

+

010+

019

Reference no. (DME management)

082

+

009+

001

Standard algorithm

083

-

008-

001

Standard algorithm

201

-

005-

019

Reference no. (DME management)

202

+

001+

021

Reference document number search

206

-

005-

019

Reference no. (DME management)

401

+

017+

019

Reference no. (DME management)

401

-

018-

019

Reference no. (DME management)

402

+

017+

019

Reference no. (DME management)

402

-

018-

019

Reference no. (DME management)

411

-

018-

019

Reference no. (DME management)

412

+

017+

019

Reference no. (DME management)

413

-

018-

019

Reference no. (DME management)

414

+

017+

019

Reference no. (DME management)

415

-

018-

019

Reference no. (DME management)

416

+

017+

019

Reference no. (DME management)

417

-

018-

019

Reference no. (DME management)

418

+

017+

019

Reference no. (DME management)

808

-

012-

000

No interpretation

814

+

013+

000

No interpretation

814

-

014-

000

No interpretation

833

+

017+

001

Standard algorithm

833

-

018-

001

Standard algorithm

To enable the bank statement to find the item to be cleared in the vendor direct debit transaction, the bank details must be maintained in the vendor master record. The bank statement finds the vendor using the bank details and the item using the value (if unique).

tip

For algorithm 012, the number interval of the document numbers must be entered in the import report. For algorithm 026, the number interval of the reference document numbers must be entered (SD number assignment = XBLNR in the FI document). For detail about searching for the reference document number, refer to SAP Comment 0107592.



  1. Assign Bank Accounts to Transaction Types:

In this step, you assign each of your bank accounts to a transaction type.

Bank Key

Bank Account

Transaction Type

12345678



MC

12345678

123456789

MC

12345678

1234567890

MC

23456789



MC

23456789

987654321

MC

23456789

9876543210

MC

4842221

100000001

MC

4842221

100000002

MC
3.4.2.2.1.2Payment Transactions: Creating and Assigning Business Transactions

Use

In this step, you define an indicator and assign a posting rule for each business transaction.



Procedure

  1. Access the activity using one of the following navigation options:

    Transaction code

    SPRO

    IMG menu

    Financial Accounting (NEW) ® Bank Accounting ® Business Transactions ® Payment Transactions ® Manual Bank Statement ® Create and Assign Business Transactions

  2. Make the following entries:

Transaction

+-

Post. Rule

Account Mod

Int. Algthm.

Text

001+

+

001+

+

21

Cash inflow via interim account

002+

+

002+

+




Check credit memo through bank

003-

-

003-

+

12

Cashed check

004-

-

004-

+

19

Domestic transfer

005-

-

005-

+

19

Foreign transfer

006-

-

006-

+




Other disbursements

007+

+

007+

+

19

Other receipts

008-

-

008-

+

1

Cash payment

009+

+

009+

+

1

Cash receipt

010+

+

010+

+

19

Collection/direct debit

011-

-

011-

+




Returns collection/direct debit

012-

-

012-

+




Bank fee

013+

+

013+

+




Interest received

014-

-

014-

+




Interest paid

016-

-

016-

+

21

Vendor direct debit

017+

+

017+

+

19

Treasury receipts

018-

-

018-

+

19

Treasury disbursements
3.4.2.2.1.3Checking Deposit: Creating and Assigning Business Transactions

Use

In this step, you define an indicator and assign a posting rule for each business transaction.



Procedure

  1. Access the activity using one of the following navigation options:

    Transaction code

    OT53

    IMG menu

    Financial Accounting (NEW) ® Bank Accounting ® Business Transactions ® Check Deposit ® Create and Assign Business Transactions

  2. Make the following entries:

Transaction

+-

Post. Rule

Account Mod

Text

CD01

+

CD01

+

Direct check Deposit

CD02

+

CD02

+

Check deposit via interim account
3.4.2.2.1.4Defining Variants for Manual Bank Statement

Use

In this step, you create your own account assignment variants for the manual bank statement to adapt the assignment and/or Chooseion of the account assignment fields to meet your company’s needs. One variant is shipped by default. This variant cannot be changed. If you do not want to use the standard variant, you can deactivate it. Any new variants you create must be activated.



Procedure

  1. Access the activity using one of the following navigation options:

    Transaction code

    SPRO

    IMG menu

    Financial Accounting (NEW) ® Bank Accounting ® Business Transactions ® Payment Transactions ® Manual Bank Statement ® Define Variants for Manual Bank Statement

  2. On the Line Layout Fast Entry: Administration screen, make the following entries:

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry Variant Active?

    Fast Entry Activation Date

    SAP Rel.

    No. following Screen

    SAPMF40K

    KNTAZ

    YB01

    X

    23.08.2000

    620

    8000

    SAPMF40K

    KNTAZ

    YB02

    X

    23.08.2000

    620

    8001

    SAPMF40K

    KNTAZ

    YB03

    X

    23.08.2000

    620

    8002

  3. On the Line Layout Fast Entry: Variants screen, make the following entries:

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry No. of Lines

    SAPMF40K

    KNTAZ

    YB01

    1

    SAPMF40K

    KNTAZ

    YB02

    1

    SAPMF40K

    KNTAZ

    YB03

    1

  4. On the Line Layout Fast Entry: Description of Variants screen, make the following entries:

    Language

    Prog. Name

    Fast Entry Applic.

    Fast Entry Variant

    Fast Entry Variant Descr.

    EN

    SAPMF40K

    KNTAZ

    YB01

    Account Statement (Bank Ref.)

    EN

    SAPMF40K

    KNTAZ

    YB02

    Account Statement (Ref.doc.nr/vend)

    EN

    SAPMF40K

    KNTAZ

    YB03

    Account Statement (Matchcode)

  5. On the Line Layout Fast Entry: Variant Fields screen, make the following entries:

Prog. Name

Fast Entry Applic.

Fast Entry Variant

Fast Entry No. of Lines

Fast Entry No. of Column

Fast Entry Offset

Compl. Field name

Fast Entry Field Output Length

SAPMF40K

KNTAZ

YB01

1

01

03

FEBMKA-VGMAN

00

SAPMF40K

KNTAZ

YB01

1

02

08

FEBEP-VALUT

00

SAPMF40K

KNTAZ

YB01

1

03

19

FEBMKA-KWBTR

15

SAPMF40K

KNTAZ

YB01

1

04

35

FEBMKK-CHECT_KF

13

SAPMF40K

KNTAZ

YB01

1

05

49

FEBMKK-KUNNR

10

SAPMF40K

KNTAZ

YB01

1

06

60

FEBMKK-BELNR

10

SAPMF40K

KNTAZ

YB02

1

01

03

FEBMKA-VGMAN

00

SAPMF40K

KNTAZ

YB02

1

02

08

FEBEP-VALUT

00

SAPMF40K

KNTAZ

YB02

1

03

19

FEBMKA-KWBTR

15

SAPMF40K

KNTAZ

YB02

1

04

35

FEBMKK-XBLNR

16

SAPMF40K

KNTAZ

YB02

1

05

52

FEBMKK-KUNNR

10

SAPMF40K

KNTAZ

YB02

1

06

63

FEBMKK-LIFNR

10

SAPMF40K

KNTAZ

YB03

1

01

03

FEBMKA-VGMAN

00

SAPMF40K

KNTAZ

YB03

1

02

08

FEBEP-VALUT

00

SAPMF40K

KNTAZ

YB03

1

03

19

FEBMKA-KWBTR

15

SAPMF40K

KNTAZ

YB03

1

04

35

FEBMKK-KUNNR_MC

07

SAPMF40K

KNTAZ

YB03

1

05

43

FEBMKK-LIFNR_MC

07

SAPMF40K

KNTAZ

YB03

1

06

51

FEBMKK-BELNR

10

SAPMF40K

KNTAZ

YB03

1

06

51

FEBMKK-BELNR

10
3.4.2.2.2Electronic Bank Statement
3.4.2.2.2.1Defining Program and Variant Chooseion

Use

In this step, you can specify which programs the system offers for electronic bank statement processing.

Transaction FF.5 and FF_5 uses program RFEBKA00.

Transaction FF.6 and FF_6 uses program RFEBKAP0.

Transaction FEBC has no restriction.

You can also define your own variant here so that it appears immediately on the screen when you call up the transaction.



Procedure

  1. Access the activity using one of the following navigation options:

    Transaction code

    SPRO

    IMG menu

    Financial Accounting (NEW) ® Bank Accounting ® Business Transactions ® Payment Transactions ® Electronic Bank Statement ® Define Program and Variant Chooseion

  2. Make the following entries:

Transaction Code

Program Name

Variant

Do not display Prog.

FF.6

RFEBKAJ0




X

FF_6

RFEBKAJ0




X


Download 1.66 Mb.

Share with your friends:
1   ...   13   14   15   16   17   18   19   20   21




The database is protected by copyright ©ininet.org 2024
send message

    Main page