This document provides instructions for setting up and using a cash journal in SAP. It discusses:
1. Creating a general ledger account for the cash journal and defining amount limits.
2. Setting up a number range for cash journal documents.
3. Configuring a cash journal by specifying details like the company code and currency.
4. Creating, changing, and deleting business transactions in the cash journal.
5. Setting up print parameters to print the cash journal and receipts.
1 of 15
Download to read offline
More Related Content
Dora ppt5(fico)
1. Cash Journal
Cash Journal provides daily cash position report .
In companies everyday they take daily cash position report-Opening balance for the day,cash receipts for
the day,cash payments for the day and closing balance for the day.
In some companies Cash journal will be used for pretty cash account purpose.
Configuration steps to Cash journal:
Create GL account for cash journal
Amount limit
Define number range interval for cash journal
Set up Cash Journal
Create,Change,Delete business transactions
Set up print parameters for Cash journal
2. Create GL account for cash journal
In this activity, we create a G/L account, for example 100000, for the cash journal in the required
company code.
Note:
Ensure that the account
Can only be posted to automatically
Displays a unique account currency
If we want to run several cash journals with different currencies in this account, make sure that
The indicator Balances in local currency only is not set
The account currency corresponds to the company code currency
3. Amount limit
PATH: SPRO-Financial accounting(new)-Bank accounting-Business transactions-Cash journal-Amount limit
Use:
We use these functions to define limit values for the FI cash journal; where these limits are reached and
exceeded, the user is prompted (in an information dialog box) to run certain activities. The check is always
performed in the first local currency of the company code.
Activities:
Company code:
We do not have to enter a company code. The entry is then valid for all company codes within a client that
use the currency specified as the first local currency.
Currency:
Each amount must be specified by the classification of the currency. If you specify a company code, the
currency of the company code is entered in the currency field and you cannot change this.
Date and amount:
The amount limits are defined time-dependent ("Valid From").
4. Define number range interval for cash journal
PATH: SPRO-Financial accounting(new)-Bank accounting-Business transactions-Cash journal-Define
number range interval for cash journal
We have to define a number range interval for cash journal documents. Each document then receives a unique
number that does not clash with the G/L document number.
Requirements
Determine whether the number range interval 01 has already been predefined by the system.
Activities
If number range interval 01 has not been predefined, define the interval in the company code required,
usually with a document number
Interval from 1000000000 to 1499999999.
Note This number range assigns a unique number per company code to each cash journal document. In
addition, the cash journal documents are numbered sequentially per company code and cash journal.
5. Set up Cash Journal
PATH: SPRO-Financial accounting(new)-Bank accounting-Business transactions-Cash journal-Set up
Cash journal
To set up a new cash journal for a company code, enter the appropriate data for the following fields:
Company code
Cash journal number
G/l account
Currency
Document types for
G/L account postings
Outgoing payments to vendors
Incoming payments from vendors
Incoming payments from customers
Outgoing payments to customers
Save
6. Create,Change,Delete business transactions
PATH: SPRO-Financial accounting(new)-Bank accounting-Business transactions-Create,Change,Delete
business transactions
In this activity, we can create, change, and delete business transactions for the cash journal.
Enter the appropriate date for the following fields:
Company code
Business transaction number
Business transaction type
E (Expense)
R (Revenue)
B (Cash transfer cash journal to bank)
C (Cash transfer bank to cash journal)
D (Customers-incoming/outgoing payment)
K (Vendors-outgoing/incoming payment)
G/L account
Tax code
Cash journal business transaction
Business transaction block
Indicator that a business transaction is blocked for additional postings.
7. Set up print parameters for Cash journal
PATH: SPRO-Financial accounting(new)-Bank accounting-Business Set up print parameters for Cash
journal transactions
In order to print the cash journal and the cash journal receipts, we have to set up the corresponding print
program parameters per company code.
Enter the appropriate company code.
Specify the following print program parameters per company code:
For the cash journal:
Print program Usually RFCASH00
Report variant
For example, with entries FI_CASH_BB (Opening balance text), FI_CASH_EB (Closing balance text),
FI_CASH_CF (C/F text), FI_CASH_SI (Signature text)
8. Foreign Currency Transactions
For foreign currency transactions we have to configure these following basic steps. They are
Define Countries in my SAP Systems
Set Country-Specific Checks
Check Exchange Rate Types
Define Translation Ratios for Currency Translation
Enter Exchange Rates
9. Define Countries in my SAP Systems
PATH:SPRO-SAP Net weaver-General settings- Set countries-Define countries in my sap system.
We need the following information for each country:
General data
Foreign trade characteristics
Further test data
This data is then checked during master data maintenance. In the SAP standard delivery system, all
countries are defined according to the international ISO standard.
Activities
1. Check that the country entries are complete.
2. Add the missing countries, if necessary.
3. Use the ISO standard for your entries.
4. For each country, maintain the associated detail screen. In the detail screen you must, for example,
create test data.
10. Set Country-Specific Checks
PATH:SPRO-SAP Net weaver-General settings- Set countries-Set Country specific checks
For all countries with which our company maintains business relationships, we must include rules for checking
the following data:
Bank data
Postal data
Control data
This data is then checked during master data maintenance.
Activities
1. Complete the check rules for the new countries.
2. Use the ISO standard for our entries.
3. For each country, maintain the associated detail screen In the detail screen we should, for example, store the
check rules.
11. Check Exchange Rate Types
PATH:SPRO-SAP Net weaver-General settings- Currencies-Check exchange rate types
Transaction code: OBBS
Exchange rates for different purposes for the same date are defined in the system as exchange rate
types (we cannot delete existing entries).
If we need to carry out currency translations between a number of different currencies, we can
simplify exchange rate maintenance by entering a base currency for the exchange rate type.
Instead of entering translation rates between every single currency, we then only need specify the
translation rate between each currency and the base currency.
All currency translations then take place in two steps - into the base currency and from the base
currency into the target currency.
12. Define Translation Ratios for Currency Translation
PATH:SPRO-SAP Net weaver-General settings- Currencies-Define Translation Ratios for Currency
Translation
Transaction code:OB07
In this activity, we enter the translation ratios for currency translation.
We enter these ratios for each exchange rate type and currency pair.
We also specify whether we want to use an alternative exchange rate type for specific currency pairs.
Activities
1. Specify existing currency translation ratios for each exchange rate type for the currency pairs we need in
our company.
2. Enter the exchange rate type to which we want to switch with specific currency pairs in the Alt. currency
field.
13. Enter Exchange Rates
PATH:SPRO-SAP Net weaver-General settings- Currencies-Enter Exchange rates.
Transaction code :OB08
Exchange rates are required to:
Translate foreign currency amounts when posting or clearing or to check an exchange rate entered
manually
Determine the gain and loss from exchange rate differences
Evaluate open items in foreign currency and the foreign currency balance sheet accounts
The exchange rates are defined by period ("valid from").
We define:
the rate types under which we want to store our exchange rates in the step "Check Exchange Rate Type
the required currency keys in the step "Check Currency Codes
the conversion factors for
the currency pair
the exchange rate type
the date
14. Foreign Currency balances Revaluations
For Foreign currency balances Revaluations we have to configure these following steps:
Creation of GL accounts
Loan account
Exchange gain
Exchange loss
Define accounting principles
Assigned accounting principles to ledger group
Define Valuation methods
Define Valuation areas
Assign Valuation areas to accounting principles
Prepare Automatic postings for foreign currency valuations