Information Systems:Cash Book Not in Balance

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 bank balance in the G/L.

Open Amount not In Balance

*VA/480B*  Work with Cash Book reconciliation        8/13/08 15:58:08 FSR46001 
          Open transactions                                                   
------------------------------------------------------------------------------
Bank: 002  CIBC - Chequing Account (US)              Open......       10429.60-
                                                     Reconciled      106436.62 
                                                     Balance...       96007.02 
-------------------------------------------------------------------------------
2=Change  5=Display  6=Related documents  7=Connected entries                 
8=Reconcile  9=Unreconcile  10=G/L transactions                               
                                                                               
  Bank Dt  Doc date Rscd Transaction ref.                   Open amount Curr B
  002  CHQ 07/28/08 AP   235                                    969.60- USD   
  002  CHQ 07/30/08 AP   236                                   3500.00- USD   
  002  CHQ 08/06/08 AP   237                                   5960.00- USD   
                                                                               
                                                                        Bottom 
  Bank Dt  Doc date Rscd Transaction ref.                   Open amount Open  
  002                                                                   Y     
F1=Info  F8=Move cursor                                                        

In this case, the total of the open transactions does agree with the open amount in the header.

On a command line in ASW, key in GO CBACC and press enter. Select the option ‘Rebuild Cash Book Bank balances from transactions’.

Cash Book Not Equal to G/L

Use a query to find each period's total from the cash book transaction file, and compare each to the G/L.

- File name is SROCBA

- Select CABKCO as the bank number, and CACTTP as ‘ 1’ or ‘ 4’ (note those leading spaces)

- Sort on CAPERI accounting period

- Accumulate total of CASCTR bank amount in system currency

- Break on change in CAPERI accounting period

In ASW, go into G/L Transaction Enquiry.

- For the bank account, key each period into both the from and to period, and press enter to display those transactions

- Press F10 to display the total of the selected transactions.

- Compare each period to the query report.

- For the opening balance, select a period range from blank to one before the first period listed in the query report.

- Nancy can adjust the opening balance of the cash book (so far, that is what has always been incorrect).