on 2009 Sep 09 1:04 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi!
Please see the Document on the below link,
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
User | Count |
---|---|
96 | |
9 | |
8 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.