Cashbook Journals

Cashbook Journals

Purpose

Cashbook Journals are used to move cash between the General Ledger and any accounts module

Timing

Cashbook Journals may be completed at any time

Access

The recommended access point is:
  1. Cashbook | Manual Reconciliation
This allows immediate reconciliation of the Cashbook Journal

Process

The Manual Reconciliation dialog will be presented
Field
Description
Bank
[F2] to highlight and  the bank account the cashbook journal is to be processed against

If you have multiple bank accounts it doesn't matter which is chosen as the effect on the bank will be no movement
Statement Number
[Tab] through this field
Reconciled Date
Enter the reconciled date

This will normally be the date of the original transaction being transferred
Closing Balance
Enter the amount displayed in the Current Balance field
[Tab]
Check the difference = 0.00
If this is not the case alter the Closing Balance to agree the Current Balance

 to present the Statement Transaction dialog

Field
Description
Date
This will default to the Reconciled Date entered on the previous dialog

Change the date to be the date of the original transaction
Type
Determine whether the originating transaction was a Deposit or Withdrawal

Change the Type to be the same as the original transaction

 to present the Cashbook Statement Analysis of Transaction dialog

Field
Description
Transaction Type
 the Transaction Type to code to the module the transaction should have been posted to
Account
Select the account or GL Code that the transaction should have been posted to
Amount
Enter the amount as a positive value


 to present the Cashbook Statement Analysis of Transaction dialog

FieldDescription
Transaction Type the Transaction Type to code to the module the transaction should have been posted to
AccountSelect the account or GL Code that the transaction should have been posted to
AmountEnter the amount as a negative value


The Statement Transaction total must be 0.00 to prove the Cashbook Journal balances


 to return to the Manual Reconciliation

Double Click the transaction line to change the Reconciled flag from 'No' to 'Yes'


Post to Other Systems should be run to post the journal transactions
    • Related Articles

    • View General Ledger Journals Transactions

      Purpose Provide a list of General Ledger transactions that have posted from the Cashbook, Account module processes and direct General Ledger journals. Any General Ledger transaction may be printed, showing the details of its originating journal. ...
    • View General Ledger Journals

      Purpose Provide a list of General Ledger Journals that have been created by system processes or directly from the General Ledger. Any journal may be printed, showing the detail entries making up the journal. Access General Ledger | View Journals ...
    • Importing Cashbook Bank Transactions

      Purpose To import Statement Transaction amounts into Vault so they can be processed through the cashbook Processing will convert the Statement Transaction Amount to a Statement Transaction Batch. Timing These processes should be undertaken daily for ...
    • Cashbook Statement Browse

      Purpose To provide a list of all Cashbook Statement Transaction Batches that have been entered to Vault To provide the ability to track where Cashbook Transactions have posted to To process Statement Transaction Batches Access Cashbook | Edit/View ...
    • Post Transactions to Other Systems

      Purpose This routine posts the Cashbook Transaction to Vault modules. Cashbook Transactions will not show on accounts or in the General Ledger until this routine is run. Note: Transactions do not have to be reconciled to Post to Other Systems. Timing ...