Manual BRS, plz urgent

[Former Member]

Dear all,

Im facing problems when im preparing manual bank reconciliation statement from T-codes FF67,

->we created 3 GL Accounts(1) outgoing cheques clearing account

(2) incoming cheques clearing account

(3) Bank account.

cheques which we are receiving we will enter in incoming cheques clearing account

we are making payment to vendors that we are entering in outgoing check clearing account

now we are facing issues when we are posting following documents.

import remittance payments

receipts of foreigne remittance

Direct debits i.e. bank charges

return of cheques of customer parties

return of cheques of vendor parties

issue of DD payments

direct electronic transfer payments

direct electronic transfer receipts

direct electronic clearing system

interested debited to on loan directly to our account

interested credited on fixed deposits

loan given to employees

loan deduction to employees

advance adjusted to employees.

please suggest me to resolve these issues

[Former Member · Accepted solution]

It again depends how your client want to segragate Sub bank control accounts.

For example If you want to have track seperaltely what all outgoing payment made through check, DD seperately then create two Sub control account. If you want to club togther than you can specify one bank sub GL Account for both.

[Former Member]

Hi Pl open Bank clearing GL accounts for the following.

Direct debits i.e. bank charges - <b>suspense clearing account to handle such misc items which are directly debited by bank</b>.

return of cheques of customer parties - AR unpaid clearing account

return of cheques of vendor parties - AP unpaid clearing acccount

similarly u can maintain upto 9 clearing accounts for a single bank account.

Later on u can proceedfurther with the manual brs

[Former Member]

Dear experts,

thank you very much for your suggestion.

please give me detail procedure to resolve this issue.

[Former Member]

Hi,

Out of the total transaction, only bank charges can be expense out. For rest all the transaction needs to be segregated into incoming and outgoing for the bank. Accordingly, create business transaction in Manual BRS for incoming i.e. Dr. Main Bank A/c and Credit Incoming Account. and for outgoing in reverse way.

For bank charges, you can directly debit to expense account and credit main bank account.

Hope this helps, if yes, please assign points.

Regards,

Harish

[Former Member]

Hi Syed,

It is purely imposible to maintain all the above transactions with only the GL accounts u have mentioned. U need to have cople more, like Bank Charges, Int. on Loan, Int. Fixed Depo. etc.

Just think interms of target GL account for those perticular transactions then u will get the answer your own.

Satish

Please assing Points