cancel
Showing results for 
Search instead for 
Did you mean: 

Un reconciled transaction report

Former Member
0 Kudos
228

Hi all,

When we run BRS report we will get reconciled transaction and Unreconciled transactions report

Under Unreconciled transaction we will get a headings and values as follows

Open in Book after dates xxxxxx Open in bank after date xxxxxx

_____________________________________________________________________________

Bank's Closing Balance xxxxxx Book's Closing Balance xxxxxx

Transaction in bank after date xxxxxx Transaction in book after date xxxxxx

Total in book for checking xxxxxx Total in bank for checking xxxxxx

If some one can explain, it will be a grate help

SBO version 2005 B

Kind regards

Rashid

Accepted Solutions (1)

Accepted Solutions (1)

msundararaja_perumal
Active Contributor
0 Kudos

Hi,

Here is the explanation,

1) Transactions in book after date:

In the Reconciliation-Selection Criteria window, if we define the Due

Date To field as 31.12.2008 for example, then all Transaction connected

to this G/L account with the Due Date to later then 31.12.2008 will be

summaried here;

2) Total in Books for Checking

It shows the difference between the amount in Books and the amount in

Bank; amount in our books to be cleared

3) Total in Bank for Checking

It should always be equal to the value of Total in Books for Checking,

amount in bank statement to be cleared

In fact the two means the same: difference between books and bank.

Former Member
0 Kudos

Hi,

Thanks for your reply , in the following scenario i need some clarification

VALUE DATE : 31.03.09

-

-


                                                                  Unreconciled Transactions                                             

Total credits in Books   :  Rs. 123,335.94                                    Total Debit in Bank :  Rs. 174,048.00

Total open in Books      :  Rs. -123,335.94                                   Total Credit in Bank:  Rs. 357,395.00

Total Open in Bank:   Rs. 184,347.00

-

-


Open in books after date :    (4,364,249.01)                                 Open in Bank After date  : 7,506,301.09

-

-


Bank`s closing Balance            :  5,266,069.84                  Book`s closing balance          :  (2,326,264.66)

Transactions in Bank after date :  2,402,915.24                  Transaction in books after date :  (2,181,982.30)

Total in books for checking       :  3,181,400.13                    Total in bank for checking        :   3,181,400.13

-

-


Balance as per Bank : 5,266,069.84

Balance as per SAP : -2,326,982.30

Differences 7,593,052.14

How can i get the list of unreconciled transactions in bank book and bank ledger matching with the above difference.

TIA

Kind regards

Rashid

Edited by: Muhammed Rashid on Sep 10, 2009 10:09 AM

Former Member
Former Member
0 Kudos

Hi!

Check this threads,

Former Member
0 Kudos

Hi Thanks for your reply

I would like to have more clarity on the following statement

1) Transactions in book after date:

In the Reconciliation-Selection Criteria window, if we define the Due

Date To field as 31.12.2008 for example, then all Transaction connected

to this G/L account with the Due Date to later then 31.12.2008 will be

summaried here;

How the system calculate this value

Option 1 - Debit amount + Credit Amount

option 2- Debit amount - Credit amount

Kind regards

Rashid

msundararaja_perumal
Active Contributor
0 Kudos

Hi,

The Due date to field(in the automatic reconciliation window) is actually it considers the document date and not the due date of any document.

I have reported the same to sap support,they did reply that this is the default behavior of the system.

Hope this clarifies you !

Answers (0)