Withholding Tax with Cash Journal

Former Member · ‎05-07-2008

Hi Gurus,

Is that possible to post transaction below in Cash Journal FBCJ.

Cr. Petty cash 98,000

Cr. Provision for Withholding tax 2,000

Dr. Consultancy fee 100,000

Many thank.

BR,

Jack

Former Member · ‎05-07-2008

HI jack,

Posting a Customer Invoice

Prerequisite

The customer master records have been maintained. One of our customers has granted us automatic debit authorization, and one pays us by bank direct debit.

Procedure

To post an invoice, use the “Accounts Receivable Accounting: Posting Invoices” business process procedure.

You will now post an invoice for each of the customers.

1. Access the transaction choosing one of the following navigation options:

SAP menu Accounting  Financial Accounting  Customer  Document Entry  Invoice

Transaction code FB70

2. Make the following entries if it is not already been defaulted by the system:

Field name User action and values Remarks

Company Code BP01 BU SMB Company DE

3. Choose Enter.

To change the company code, choose Edit  Change Company Code.

4. On the Basic Data tab page in the Enter Customer Invoice: Company Code XXXX screen, make the following entries:

Field name User action and values R/O/C Remarks

Customer R Example

Invoice Date R Example

Reference R Example

Amount R Example

Currency R

Calculate Tax R

Tax Code R

5. Make the following entries:

Field name User action and values R/O/C Remarks

G/L Account R Sales revenue domestic

D/C R

Amount in Document Currency R Enter the gross amount. The system calculates the output tax automatically.

Tax Code R 16% tax on sales/purchases

Profit Center R

6. To check the document before it is posted, choose Simulate (F9).

This enables you to display the document, including the tax on sales/purchases to be posted, and to correct it if necessary.

7. Choose Post (Ctrl+S).

In the lower area of the screen, the system generates the message: Document 18000000xx was posted in company code BP01, where xx is the sequential document number posted by the system.

8. Make a note of the invoice document number.

When you call up the transaction for the first time, a dialog box appears for you to enter the company code. Enter company code BP01 here.

Result

The document is posted to the database and the G/L account and customer transaction figures are updated.

Manual Bank Statement

Use

The bank credits the automatic debit and the bank direct debit to your account.

For a detailed description of this procedure, refer to the “Manual Account Statement” business process procedure. This document describes the procedure for a check credit memo through the bank. The procedure for the bank direct debit / automatic debit will now be described here.

Entering and Posting a Manual Account Statement

Procedure

The following example shows you how to post an incoming check.

When you call up the transaction for the first time, the Specifications dialog box appears for you to make the following entries.

Field name User action and values Remarks

Internal Bank Determination Select indicator If this indicator is set, you can enter the house bank ID and the account ID. If the indicator is not set, you have to enter the bank number and the bank account number.

Start Variant BP01

Processing Type 4 You have to choose Processing Type 4. If you choose this processing type, you have to use transaction FEBA for further processing.

Transfer Value Date Select indicator

Choose Continue or Enter

You can also display this dialog box by choosing Settings  Specifications. Please check if the following data is entered.

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Banks  Input  Bank Statement  Manual Entry

Transaction code FF67

2. On the Process Manual Bank Statement screen, make the following entries:

Field name User action and values Remarks

Company Code BP01

House Bank DB

Account ID GIRO

Statement Number Current statement number (you can enter any number here) If you have forgotten the number of your previous statement, you can choose Overview to display your old statements. You can then copy the last statement from the overview or create a new statement. In this way, the statement number, statement date, and beginning balance are set automatically.

Statement Date Statement date (TODAY)

Beginning Balance Beginning balance = ending balance of the previous statement

Ending Balance Beginning balance + EUR XXX The bank credits EUR XXX to your account.

Choose Enter to confirm your entries.

3. On the Process Manual Bank Statement screen, make the following entries:

Field name User action and values Remarks

Transaction 002+

Value Date Value date of the item

e.g. today

Amount

Bank Reference Do not enter anything in this field because the bank does not provide any references.

Pushbutton Save The account statement is included in the system when you choose Save, but is not yet posted. You can still change the account statement or add new items to it.

Pushbutton Post The statement is posted online (in the background).

Transaction 002+ is for ‘Check deposit’ and contains the posting logic for the document to be posted. In this case, the document is posted:

From the bank to bank subaccount 280008 without clearing.

Result

Once you have posted the account statement, the system displays the posting statistics. These enable you to see how many FB01 postings (post without clearing) have been carried out with and without errors. This also applies to FB05 postings (post with clearing). In our example, one FB01 posting has been carried out.

Postprocessing an Account Statement

Use

Every time you post a manual account statement, you should postprocess it because the system cannot always clear all the items automatically. This is particularly important if the customer has not paid the total amount or has quoted the wrong reference. In this particular case, no clearing posting is carried out and, consequently, postprocessing is necessary.

Prerequisites

The manual account statement has been posted.

Procedure

To postprocess the account statement, use the data from the examples. The data in the table below is intended as an aid.

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Banks  Input  Bank Statement  Reprocess

Transaction code FEBA

2. On the Bank Statement Subsequent Processing screen, make the following entries:

Field name User action and values Remarks

Application Electronic and manual bank statement

Company Code BP01

House Bank DB

Account ID GIRO

Statement Number Statement number of the account statement that was posted last See Manual Account Statement, point 3.

Statement Date Statement date (TODAY) See Manual Account Statement, point 3.

Posting Area G/L accounting

3. Choose Statement Overview.

4. Double-click the bank details to display the statements from this bank. Double-click the statement number to display the statement items. A green checkmark next to the statement indicates that the postings have been processed without errors. You can see the posted document number in the individual statement items. Double-click an item to display further information, such as the reference, business partner, bank details, external transaction, note to payee, and so on. To display the document that was created, double-click the document number.

5. Choose the green arrow (Back F3) to return to the Bank Statement Subsequent Processing screen. In this screen, select Subledger accounting in the Posting Area field and choose Statement Overview (F8).

6. Double-click the bank details. A red cross next to the statement indicates that the account statement contains items that could not be posted. You have to postprocess these items. Double-click the statement and then the item. Choose Specifications  Change Method to change the posting method. Choose Display all screens. The posting method is described in the following note.

There are several options available for selecting the account statements to be displayed. You can display statements that have a particular statement status. There are three different statuses: all line items, only line items incompletely posted, and only line items completely posted.

The posting methods Display incorrect screens, Display all screens, Do not display screens specify whether all the screens, only incorrect screens, or no screens are displayed during postprocessing. The Display all screens method can be chosen for test and training purposes. Otherwise, you should choose the Display incorrect screens method.

You should always check G/L accounting and subledger accounting, since both types of accounting might contain postings that have not been carried out.

Result

The statement status has not changed because it was already green for both G/L accounting and subledger accounting before you postprocessed it.

Cash Journal Postings

Purpose

You can use the cash journal to manage cash transactions in your company. You can post cash receipts and cash payments, print receipts, and print out a cash journal. The cash journal in the R/3 System is a subsidiary ledger, which contains documents that are transferred from the cash journal to the general ledger in SAP FI. A cash journal is kept in one currency.

Cash Journal Description Currency

0001 Petty Cash EUR

The cash journal does not include functions for accepting and depositing checks.

Each cash journal is assigned a G/L account to which the documents in the general ledger are posted.

Cash Journal G/L account IKR

0001 288010

When a posting is made to a cash journal transaction, the documents with the following document types are posted:

Business Transaction Document Type

G/L account postings AB

Vendor: incoming/outgoing payments KZ

Customer: incoming/outgoing payments DZ

You can create your own business transactions that have to be posted. In the cash journal transaction FBCJ, you can create, change, and delete business transactions (menu path: Extras  Change Business Transaction). We provide the following business transactions for cash journal accounting:

Bus. transac. no. Bus. transaction type Text Account no. in

CC 0100 (0200) Tax

code

01 E = Expense Postal costs 682100 V0

02 E = Expense Shipping costs 682000 V1

03 E = Expense Office supplies 680000 V1

04 D = Customer posting Receipt from customer

05 K = Vendor posting Payment to vendor

06 B = Payment to bank Payment to Deutsche Bank 280015

07 B = Payment to bank Payment to Dresdner Bank 281015

08 B = Payment to bank Payment to BW bank 282015

09 C = Receipt from bank Receipt from Deutsche Bank 280014

10 C = Receipt from bank Receipt from Dresdner Bank

Cash trans. from Dresd.Bnk. 281014

11 C = Receipt from bank Receipt from BW bank 282014

12 R = Revenue Domestic sales in cash 500900 A1

13 B = Payment to bank account Payment to Postbank 285015

14 C = Receipt from bank Receipt from Postbank 285014

15 E = Expense Import Tax 262800 U1

16 E = Expense Office Supplies 7% 680000 V2

Process Flow

Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Banks  Input  Cash Journal

Transaction code FBCJ

The following business processes are described in the examples below:

• Posting an incoming payment

A customer pays an open invoice in cash to the amount of EUR 174,000. A receipt is printed for this. The customer’s open item is then cleared.

• Clearing the customer invoice

• Posting for One-time Customer

• Document split postings in the cash journal

• Direct postings to tax accounts

• Transferring cash from petty cash to a house bank account by means of an electronic account statement

We transfer EUR 11,000 from petty cash to our account at Deutsche Bank. The bank subaccount is then cleared by means of an electronic account statement.

• Paying cash to a vendor, followed by reversal

We pay a vendor EUR 580 in shipping costs, including 16% VAT, in cash. This document is then reversed because the invoiced amount is to be transferred.

• Printing the cash journal

Posting Open Items

The incoming payment business transaction for customers is only relevant once an open customer item has been posted.

For detailed description see chapter Posting an Customer Invoice at Reference Business Processes. For this process use the following data.

Make the following entries:

General data:

Transaction Cust. Posting / document date Reference Amount Cur. Calculate tax

1 Invoice 108 Today's date FBCJ01 174,000.00 EUR X

2 Invoice 109 Today's date FBCJ02 27,724.00 EUR X

Item data:

G/L account Debit / credit Amount in document currency Tax code Payment tab page:

1 500900 Credit 174.000,00 A1 Payment term 0001

2 500900 Credit 27,724.00 A1 Payment term 0001

Posting an Incoming Payment

Procedure

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Banks  Input  Cash Journal

Transaction code FBCJ

2. On the Cash Journal XXXX Company Code XXXX screen, make the following entries:

Field name User action and values Description

Company Code: Cash Journal: BP01

0001

If the system does not request you to make an entry, check whether you are already in the correct cash journal.

If necessary, choose Change Cash Journal to select the correct cash journal.

Choose the Cash Receipts tab page if it is not already displayed.

Display Period Today's date

or choose Today. The entries in these fields are used to restrict the cash documents.

Business Transaction 4

or choose the transaction

PAID TO/RECEIPT FROM The entry in this field defines the document type to be posted and the offsetting account for the cash account.

Amount 174,000.00 In this field, you enter the amount that is paid in by the customer in cash. An open item to the amount of EUR 174,000 is outstanding for customer 108. The customer pays this open item in full.

Receipt Recipient Mr. Smith In this field, you enter the name of the person paying in the amount. This is then printed on the receipt.

Text Cash payment for open invoice You can enter a short text for the business transaction here.

Customer 108 Enter the customer number.

Reference FBCJ01 Enter the invoice document reference number here.

Save Sel. Select the line that you have just entered and choose Save Sel. When you choose this pushbutton, the data you entered and selected is saved. However, your entries have not yet been posted in the general ledger. The document status changes to yellow.

Document statuses:

Red traffic light

The cash journal entry has been recorded in the system; initial checks have been carried out for the data entered.

Yellow traffic light

The entry has been saved in the cash journal.

Green traffic light

The entry has been saved in the cash journal and posted in the general ledger.

Red cross

The document has been reversed.

Save When you choose this pushbutton, ALL the entries in the cash journal, and not just those you selected, are saved.

Internal Document Number The cash journal document number is assigned when you save a document. The document number appears in the Internal Document Number field.

Post Sel. Select the appropriate line(s) and choose Post Sel. When you choose this pushbutton, the data you have to select is posted. A document is also created in the general ledger. The document status changes to green.

Post When you choose this pushbutton, ALL the entries in the cash journal, and not just those you selected, are posted to the general ledger.

Receipt Select the appropriate line(s) and choose Receipt. Choose Receipt to print a receipt for the document selected.

You cannot reverse a document once a receipt has been printed.

Follow-on Doc. Select the appropriate line(s) and choose Follow-on Doc. The document posted in SAP FI is then displayed. Choose Follow-on Doc. to display the FI document for the G/L account.

You cannot reverse a cash document once the receipt for it has been printed.

If the customer makes use of a cash discount, the lost cash discount is not posted until the customer invoice has been cleared.

Clearing the Customer Invoice

Use

Once the incoming payment has been posted as described above, the customer invoice must be cleared. The customer invoice is not automatically cleared when incoming payments are posted in the cash journal. For more information on clearing invoices, refer to the Account Maintenance: Manual Clearing business process procedure.

Procedure

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Customer  Account  Clear

Transaction code F-32

2. On the selection screen make the following entries:

Field name User action and values Description

Account 108 Enter the account to be cleared.

Company Code BP01

Clearing Date Today's date Enter the clearing date here. Today’s date is defaulted in this field. Choose Enter.

Additional Selections Reference Enter a reference here.

Process Open Items Choose Process Open Items.

Reference FBCJ01

Process Open Items A list of all the open items selected is displayed. Select and activate the items that are to be cleared at the same time and post them.

3. Choose Process open items to start the report.

4. Mark or demark the items which belong together. Balance must be zero.

5. Save your clearing by choosing Post (Ctrl+S).

Result

The documents are cleared and a clearing document is posted. Check customers account with transaction FBL5N (Display / Change line items). You can repeat this process for customer 109.

Postings to One-time accounts

Use

The incoming payment business transaction for customers is only relevant once an open customer item has been posted. Use a CPD customer (One-time customer).

For detailed description see chapter Posting a Customer Invoice at Reference Business Processes. For this process use the following data.

Make the following entries:

General data:

Transaction Cust. Posting / document date Reference Amount Cur. Calculate tax

1 Invoice CPD Today's date FBCJ03 15.300,00 EUR X

Item data:

G/L account Debit / credit Amount in document currency Tax code Payment tab page:

1 500900 Credit 15.300,00 or * A1 Payment term 0001

Posting an Incoming Payment

Procedure

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Banks  Input  Cash Journal

Transaction code FBCJ

2. On the Cash Journal XXXX Company Code XXXX screen, make the following entries:

Field name User action and values Description

Company Code: Cash Journal: BP01

0001

If the system does not request you to make an entry, check whether you are already in the correct cash journal.

If necessary, choose Change Cash Journal to select the correct cash journal.

Choose the Cash Receipts tab page if it is not already displayed.

Display Period Today's date

or choose Today. The entries in these fields are used to restrict the cash documents.

Business Transaction 4

or choose the transaction

PAID TO/RECEIPT FROM The entry in this field defines the document type to be posted and the offsetting account for the cash account.

Amount 15.300,00 In this field, you enter the amount that is paid in by the customer in cash. An open item to the amount of EUR 174,000 is outstanding for customer 108. The customer pays this open item in full.

Receipt Recipient Mr. Smith In this field, you enter the name of the person paying in the amount. This is then printed on the receipt.

Text Cash payment for open invoice You can enter a short text for the business transaction here.

Customer CPD Enter the customer number. New window opens. Fill it with Customer data.

Reference FBCJ03 Enter the invoice document reference number here.

Save Sel. Select the line that you have just entered and choose Save Sel. When you choose this pushbutton, the data you entered and selected is saved. However, your entries have not yet been posted in the general ledger. The document status changes to yellow.

Document statuses:

Red traffic light

The cash journal entry has been recorded in the system; initial checks have been carried out for the data entered.

Yellow traffic light

The entry has been saved in the cash journal.

Green traffic light

The entry has been saved in the cash journal and posted in the general ledger.

Red cross

The document has been reversed.

Save When you choose this pushbutton, ALL the entries in the cash journal, and not just those you selected, are saved.

Internal Document Number The cash journal document number is assigned when you save a document. The document number appears in the Internal Document Number field.

Post Sel. Select the appropriate line(s) and choose Post Sel. When you choose this pushbutton, the data you have to select is posted. A document is also created in the general ledger. The document status changes to green.

Post When you choose this pushbutton, ALL the entries in the cash journal, and not just those you selected, are posted to the general ledger.

Receipt Select the appropriate line(s) and choose Receipt. Choose Receipt to print a receipt for the document selected.

You cannot reverse a document once a receipt has been printed.

Follow-on Doc.. Select the appropriate line(s) and choose Follow-on Doc.. The document posted in SAP FI is then displayed. Choose Follow-on Doc.. to display the FI document for the G/L account.

You cannot reverse a cash document once the receipt for it has been printed.

If the customer makes use of a cash discount, the lost cash discount is not posted until the customer invoice has been cleared.

Clearing the Customer Invoice

Use

Once the incoming payment has been posted as described above, the customer invoice must be cleared. The customer invoice is not automatically cleared when incoming payments are posted in the cash journal. For more information on clearing invoices, refer to the Account Maintenance: Manual Clearing business process procedure.

Procedure

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Customer  Account  Clear

Transaction code F-32

2. On the selection screen make the following entries:

Field name User action and values Description

Account CPD Enter the account to be cleared.

Company Code BP01

Clearing Date Today's date Enter the clearing date here. Today’s date is defaulted in this field. Choose ‘Enter’

Additional Selections Reference Enter a reference here.

Process Open Items Choose Process Open Items.

Reference FBCJ03

Process Open Items A list of all the open items selected is displayed. Select and activate the items that are to be cleared at the same time and post them.

3. Choose Process open items to start the report.

4. Mark or demark the items which belong together. Balance must be zero.

5. Save your clearing by choosing Post (Ctrl+S).

Result

The documents are cleared and a clearing document is posted. Check customers account with transaction FBL5N (Display / Change line items).

Document Split Postings in the Cash Journal

Use

You can define different account assignments, tax codes, or business areas for each cash journal item. This differentiation makes it easier to enter the cash journal document.

Based on the split in the cash journal document, the system creates offsetting posting items and cash journal items and a summary tax item.

Procedure

1. Access the transaction choosing one of the following navigation options:

Menu path Accounting  Financial Accounting  Banks  Input  Cash Journal

Transaction code FBCJ

2. On the Cash Journal XXXX Company Code XXXX screen, make the following entries:

Field name User action and values Description

Company Code: Cash Journal: BP01

0001

If the system does not request you to make an entry, check whether you are already in the correct cash journal.

If necessary, choose Change Cash Journal to select the correct cash journal.

Choose the Cash Payments tab page if it is not already displayed.

Display Period Today's date

or choose Today. The entries in these fields are used to restrict the cash documents.

Business Transaction 16

or choose the transaction

OFFICE SUPPLIES 7% The entry in this field defines the document type to be posted and the offsetting account for the cash account.

Split Choose the split button A new window opens. Enter at least one additional business transaction.

The system proposes the original amount for the first business transaction. Once you have entered additional business transactions, you have to adjust the original amount so that with the additional line items, it corresponds in total to the total amount displayed on the bottom right of the screen.

Text 3

OFFICE SUPPLIES 16 %

Cost Center Transaction 16: cost center 1101

Transaction 3:

cost center 1102

Copy The system determines the respective tax amounts and displays them in the lower area of the dialog box. Choose the button Copy.

Reference FBCJ04 Enter the invoice document reference number here.