https://owl.unipharm.com/mediawiki/index.php?action=history&feed=atom&title=Information_Systems%3ACash_Book_Not_in_Balance 2026-09-01T12:47:53Z Revision history for this page on the wiki MediaWiki 1.35.4 https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Cash_Book_Not_in_Balance&diff=5597&oldid=prev 2016-10-03T23:05:12Z

<p></p> <p><b>New page</b></p><div>=Cash Book not In Balance=<br /> <br /> It can be out of balance in two ways; the ‘open’ amount not equal to the total of the open transactions, or the ‘balance’ not equal to the bank balance in the G/L.<br /> <br /> ==Open Amount not In Balance==<br /> <br /> *VA/480B* Work with Cash Book reconciliation 8/13/08 15:58:08 FSR46001 <br /> Open transactions <br /> ------------------------------------------------------------------------------<br /> Bank: 002 CIBC - Chequing Account (US) Open...... 10429.60-<br /> Reconciled 106436.62 <br /> Balance... 96007.02 <br /> -------------------------------------------------------------------------------<br /> 2=Change 5=Display 6=Related documents 7=Connected entries <br /> 8=Reconcile 9=Unreconcile 10=G/L transactions <br /> <br /> Bank Dt Doc date Rscd Transaction ref. Open amount Curr B<br /> 002 CHQ 07/28/08 AP 235 969.60- USD <br /> 002 CHQ 07/30/08 AP 236 3500.00- USD <br /> 002 CHQ 08/06/08 AP 237 5960.00- USD <br /> <br /> Bottom <br /> Bank Dt Doc date Rscd Transaction ref. Open amount Open <br /> 002 Y <br /> F1=Info F8=Move cursor <br /> <br /> In this case, the total of the open transactions does agree with the open amount in the header.<br /> <br /> On a command line in ASW, key in GO CBACC and press enter. Select the option ‘Rebuild Cash Book Bank balances from transactions’.<br /> <br /> ==Cash Book Not Equal to G/L==<br /> <br /> Use a query to find each period's total from the cash book transaction file, and compare each to the G/L.<br /> <br /> - File name is SROCBA<br /> <br /> - Select CABKCO as the bank number, and CACTTP as ‘ 1’ or ‘ 4’ (note those leading spaces)<br /> <br /> - Sort on CAPERI accounting period<br /> <br /> - Accumulate total of CASCTR bank amount in system currency<br /> <br /> - Break on change in CAPERI accounting period<br /> <br /> In ASW, go into G/L Transaction Enquiry.<br /> <br /> - For the bank account, key each period into both the from and to period, and press enter to display those transactions<br /> <br /> - Press F10 to display the total of the selected transactions.<br /> <br /> - Compare each period to the query report.<br /> <br /> - For the opening balance, select a period range from blank to one before the first period listed in the query report.<br /> <br /> - Nancy can adjust the opening balance of the cash book (so far, that is what has always been incorrect).<br /> <br /> [[Category: Finance Problems (I.T.)]]</div>

Norwinu https://owl.unipharm.com/mediawiki/index.php?title=Information_Systems:Cash_Book_Not_in_Balance&diff=558&oldid=prev 2015-10-19T17:19:26Z

<p>Created page with &quot;=Cash Book not In Balance= It can be out of balance in two ways; the ‘open’ amount not equal to the total of the open transactions, or the ‘balance’ not equal to the...&quot;</p> <p><b>New page</b></p><div>=Cash Book not In Balance=<br /> <br /> It can be out of balance in two ways; the ‘open’ amount not equal to the total of the open transactions, or the ‘balance’ not equal to the bank balance in the G/L.<br /> <br /> ==Open Amount not In Balance==<br /> <br /> *VA/480B* Work with Cash Book reconciliation 8/13/08 15:58:08 FSR46001 <br /> Open transactions <br /> ------------------------------------------------------------------------------<br /> Bank: 002 CIBC - Chequing Account (US) Open...... 10429.60-<br /> Reconciled 106436.62 <br /> Balance... 96007.02 <br /> -------------------------------------------------------------------------------<br /> 2=Change 5=Display 6=Related documents 7=Connected entries <br /> 8=Reconcile 9=Unreconcile 10=G/L transactions <br /> <br /> Bank Dt Doc date Rscd Transaction ref. Open amount Curr B<br /> 002 CHQ 07/28/08 AP 235 969.60- USD <br /> 002 CHQ 07/30/08 AP 236 3500.00- USD <br /> 002 CHQ 08/06/08 AP 237 5960.00- USD <br /> <br /> Bottom <br /> Bank Dt Doc date Rscd Transaction ref. Open amount Open <br /> 002 Y <br /> F1=Info F8=Move cursor <br /> <br /> In this case, the total of the open transactions does agree with the open amount in the header.<br /> <br /> On a command line in ASW, key in GO CBACC and press enter. Select the option ‘Rebuild Cash Book Bank balances from transactions’.<br /> <br /> ==Cash Book Not Equal to G/L==<br /> <br /> Use a query to find each period's total from the cash book transaction file, and compare each to the G/L.<br /> <br /> - File name is SROCBA<br /> <br /> - Select CABKCO as the bank number, and CACTTP as ‘ 1’ or ‘ 4’ (note those leading spaces)<br /> <br /> - Sort on CAPERI accounting period<br /> <br /> - Accumulate total of CASCTR bank amount in system currency<br /> <br /> - Break on change in CAPERI accounting period<br /> <br /> In ASW, go into G/L Transaction Enquiry.<br /> <br /> - For the bank account, key each period into both the from and to period, and press enter to display those transactions<br /> <br /> - Press F10 to display the total of the selected transactions.<br /> <br /> - Compare each period to the query report.<br /> <br /> - For the opening balance, select a period range from blank to one before the first period listed in the query report.<br /> <br /> - Nancy can adjust the opening balance of the cash book (so far, that is what has always been incorrect).</div>

Sheilav