coglog
Services Limited		  
Integrated Business Solutions

CASHBOOK REPORTS

8CBL04M - POST PAYMENTS TO CASHBOOK

This is how the transactions will appear in the Bank Reconciliation / Cash Book.
Key in Print for a list of the unrolled current payments:
Accounting Period: e.g. 15
Run option P Update, Print, Both, Re-print. 
Account     Date   Per.       Value      Ref.      C T S  Batch  Text

JONES    13/02/2004 23         114.66-       353   3 P U     353 Direct Credit
POLLY    13/02/2004 23         135.00-       353   3 P U     353 Direct Credit
Banking  13/02/2004 23       1,194.75-       353   3 P U     353 Debtors Banking
Banking  13/02/2004 23         300.00-       353   3 P U     353 Debtors Banking
Visa     13/02/2004 23       1,453.50-       353   3 P U     353 Visa
EFTPOS   13/02/2004 23         202.50-       353   3 P U     353 EFTPOS
Banking  13/02/2004 23         630.00-       353   3 P U     353 Debtors Banking

                             4,030.41-  = Run Total          353  = Update No.

Each creditors (or debtors) payment batch is given an Update / Run No. e.g. 149 (see in Bank Reconciliation)
and each update to the GL is given a batch No. which increments by 1 e.g. CR0150 (or DT0150) 
Account     Date   Per.       Value      Ref.      C T S  Batch  Text

COGITO   13/07/2009 15       2,194.00-    100488   3 P P       4

                             2,194.00-  = Run Total          149  = Update No.


Seq  Tp  P    Date    Account   Ref           Qty       Debit        Credit     Name

00010 A  15 13/07/09 CR0150
00020 P  15 13/07/09     870000   CBL04                2,194.00                Accounts Payable
                                  0000000000                                   Creditors Payments
00030 P  15 13/07/09     680000   CBL04                              2,194.00  National Bank000000                                     Creditors Payments
                          BATCH    TOTALS                 2,194.00      2,194.00

8CBL01 - Current Position

                          Bank Account

                         5,000.00  Opening Balance
                         2,000.00  Posted

                         7,000.00  Ledger Balance

                           100.00  Un-presented payments
                           250.00- Un-presented deposits

                         6,850.00  Current position

8CBP01E1 - Transaction Spreadsheet

Reports on CashBook Transaction file. This and the following program are designed specifically to export the CashBook directly into a spreadsheet. The first row carries the opening bank account balance, and the last 2 rows the closing bank account balance, and the final running total. The "A From" column includes an alphabetical aid to sorting the report while keeping with these Totals in their correct rows. 
A From  Date      Name      Ref	        In Out	Trans$   Bal
AA	28/01/14  Bank A/c  Opening Bal

8CBP02E1 - CashBook Spreadsheet

As above, but reports on CashBook Master file, and does not include all the datails.

CBPE 

A From  Date      Name      Ref	        In Out	Trans$   Bal
AA	28/01/14  Bank A/c  Opening Bal

8CBP01C1 - DT DIRECT CREDIT SCHEDULE REPRINT

Report the above by Run No. ranges - e.g.

Direct Credit Range: 314 to 314 CBP02 From 

               DIRECT CREDIT SCHEDULE No.
Supplier                       Bank A/c                   Paid

Cogito Services Ltd              1234 5678123  01      2,194.00

--------------------------------------------------------------------------------
                                            TOTAL      2,194.00
--------------------------------------------------------------------------------

8CBP02C1 CR CASHBOOK REGISTER

Run as above - defaults to run Un-presented payments - Creditors only. 
               Un-presented cheques
  Number    Account                              Type        Value       Paid     Banked   Status      Type    Run No.   Refer

  100488 COGITO   Cogito Services Ltd                       2,194.00   13/07/09   0/00/00  Un-presented Manual      4

------------------------------------------------------------------------------------------------------------------------------------
                           0.00  Presented          2,194.00  Un-presented           0.00  Cancelled

8CBP02C2 - CASHBOOK LIST (BOTH)

Run as above - defaults to run All 
               Cashbook Register
  Number          Type        Value       Paid     Banked   Status      Type    Account                        Run No.   Refer

  100488 COGITO   Cheque     2,194.00   13/07/09            Un-presented Manual  Cogito Services Ltd               4
       8          Payment    1,440.00-  14/07/09            Un-presented Comp.   Debtors Banking                   8

------------------------------------------------------------------------------------------------------------------------------------
                             2,194.00  Un-presented (Dr)
                             1,440.00- Un-presented (Cr)

8CBP02C3 - UN-PRESENTED REPORTS (BOTH)

Runs automatically from Bank Reconciliation or can be run from menu to select parameters.

CBP02

Set to Un-presented or select All, or Presented items only.
Date and Reference ranges may be selected.
Each payment batch is given a Run No. e.g. CR0004

Individual CR codes (e.g. COGITO) are reported for cheques but not for Direct Credits - each batch total has a Run No.

Each lodgement batch has a Run No. e.g. DT0008
Debtor's codes not reported for cheque payment, but are for direct credits.
Defaults to run Un-presented 
               Un-presented register
  Number          Type        Value       Paid     Banked   Status      Type    Account                        Run No.   Refer

  100488 COGITO   Cheque     2,194.00   13/07/09            Un-presented Manual  Cogito Services Ltd                4
     215          Paid       1,440.00-  14/07/09            Un-presented Comp.   Debtors Banking                    8

------------------------------------------------------------------------------------------------------------------------------------
                             2,194.00  Un-presented (Dr)
                             1,440.00- Un-presented (Cr)

8CBP02D1 - CR DIRECT CREDITS SCHEDULE

Each Direct Credit run is given a Schedule No. e.g. 0314 - the payment Ref. (like a cheque No.).
See this reference in Bank reconciliation when presenting this payment. 


               DIRECT CREDIT SCHEDULE No.    0314
Supplier                       Bank A/c                   Paid

Cogito Services Ltd              1234 5678123  01      2,194.00

--------------------------------------------------------------------------------
                                            TOTAL      2,194.00
--------------------------------------------------------------------------------

8CBP02P1 - DT Payments Register

The Run No. is the update number to the CashBook.
Also see 8CBP02C2 and 8CBP02C3.
Note that the Payment Type fields need an input e.g. *

CBP02P1 
                      Debtors' Payments Run No.   0632 to   0634
Customer                            Paid                Ref   Bank A/c

Cousins                             450.00  Cheque                               27/05/09    632
Fitzgerald                        2,340.00  Cheque            WPT    Hawera      28/05/09    633
Jacksons                          1,350.00  Cheque            CWD    Sydney      31/05/09    634
-----------------------------------------------------------------------------
                    3 Cheques     4,140.00

                      TOTAL       4,140.00

8CBP02P2 - DT BANKING SCHEDULE

                     BANKING SCHEDULE No.   0632
Customer                       Bank A/c                Ref.        Paid

Cousins                                                          450.00

                                                 1  Cheques      450.00

    Schedule   0632 27/05/2009              450.00    TOTAL      450.00

Fitzgerald                     WPT    Hawera                   2,340.00

                                                 1  Cheques    2,340.00

    Schedule   0633 28/05/2009            2,340.00    TOTAL    2,340.00

Jacksons                       CWD    Sydney                   1,350.00

                                                 1  Cheques    1,350.00

    Schedule   0634 31/05/2009            1,350.00    TOTAL    1,350.00
-------------------------------------------------------------------------
                                                      TOTAL    4,140.00
-------------------------------------------------------------------------