Navigation:  Financial Management > Reports >

Bank Book

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

Main Menu > Financial Management > Reports > Bank Book

You get the list of Bank Ledger Accounts (under Group Bank Accounts and Bank OCC) from which you may select a Bank Ledger to see Bank Book of the selected Bank.

The first ledger account transacted in the voucher, the net amount of receipt (in Debit Column) / payment (in Credit Column) is listed. The amount of Opening & Closing Balance of the selected Bank Account and the total of Debits & Credits for the period are also shown.

Buttons in the Bank Book Report:

Buttons are explained in Using Reports (Register). Buttons specific to “Bank Book” are discussed here:

-P Periodical

To see periodical or month wise Bank Book Report.

-P Periodicity

Set the following Periodicity:

Bi Month: To see reports separately for 1st Half Month and 2nd Half Month. Transactions fall between dates 1st to 15th of any month will show under 1st Half Month and between dates 16th to Last Day of any month will show under 2nd Half Month.

Daily: Will show date wise report.

Half Yearly: Will show half yearly report for 1st Half Year and 2nd Half Year.

Monthly: Will show month wise report

Quarterly: Will show Quarterly Report for 1st Quarter, 2nd Quarter, 3rd Quarter and 4 Quarter.

Yearly: Will show Yearly Report.

^L Select Grp

Use this button to select Account Group. This is available in Periodical Report.

^S Reconcile

To reconcile your Bank Book with Banks Statement.

It shows the difference between the bank book of an organization as the statement provided by the bank itself along with corresponding entries and amounts.

Such differences may occur because of a cheque or a number of cheques issued by the organization have not been cleared yet, a banking transaction such as credit received or Turnover Tax, Multicity cheque clearing charges etc deducted by the bank, has not yet been recorded in the organization's bank book.

To reconcile an entry you just need to enter clearing date of the transaction as per bank’s statement in the “Entry Date” column and then press Alt+S to save.

-O Option

Set Bank Book Report option:

Entry Wise Detail

Yes = Set Yes to show balance figure in each entry row.

No = Set No if don’t want to show balance figure in each entry row. After set No the column Balance will be disappeared from the report and in this case balance will be showed as per option selected in field Method of Balancing.

Include Opening Balance

Set Yes to show Opening Balance in each balancing period, if set No Opening Balance will be disappeared from the report.

Method of Balancing

Daily: To calculate and show balance amount daily basis.

Monthly: To calculate and show balance amount monthly basis.

Yearly: To calculate and show balance amount yearly basis.

Print Voucher No

Set Yes to print voucher number else set No.

Select Voucher to Show

All Voucher:  Will show both ledgers of Debit and Credit Balance.

Debit Entries Only: Will show the ledgers only of Debit Balance.

Credit Entries Only: Will show the ledgers only of Credit Balance.

Show Reference Entry

Set Yes to show Reference Number attached with ledger else set No.

Show Cost Center

Set Yes to show the respective Cost Center else set No.

Show Narration

Set Yes to show Narration attached with transactions else set No.

Show Narration for Each Entry

Set Yes to show Narration attached with individual ledger else set No.

-L Select Led

To select a Bank Ledger Account.

Bank Reconciliation:

Bank reconciliation allows companies or individuals to compare their account records with the bank account balance records, to uncover any possible discrepancies.

 

Discrepancies may include:

Cheques recorded as a lesser amount than what was presented to the bank;
Money received but not lodged;
Payments taken from the bank account without the business's knowledge etc.

 

Since there are timing differences between when data is entered in the banks systems and when data is entered in the individual's/companies system, a normal discrepancy between account balances may occur. The goal of reconciliation is to determine if the discrepancy that occurred is due to error rather than timing.

A bank reconciliation done regularly can reduce the number of errors in an accounts system.

^S Reconcile

Use this button to open Bank Reconciliation Statement. This is not a bank book report but you can say that, it is a form by which you can compare your bank book to banker’s records, by which you can find and resolve several transaction errors. In this screen you will find every transaction which has no entry date. In entry date field you have to enter bank date, stated in the bank statement for that transaction.

Before giving entry date transactions will not reflect in account and theirs total debit and credit balance will show under Amount not reflected in Account. After giving entry date, transactions will reflect in account.

 

You can find the Bank reconciliation option in the following Reports:

Bank Book Report
Cash Book Report
Ledger Report.

Buttons in the Reconciliation Screen:

Buttons are explained in Using Reports (Register). Buttons specific to “Bank Reconciliation” are discussed here:

^S Set Date

Use this button to set current date for every transaction not reflecting in the account.

-A Show All

Use this button to show all transactions either reconcile or not.

-S Save

Use this button to save any changes made.

-O Opt Voucher

Use this button to open Reconciliation Option.

Reconciliation Option

Allow Back Date Reconciliation

Set Yes to do reconciliation in Back Days else set No.

Column to Display on Screen

Narration

Set Yes / No.

UDF1

Set Yes / No.

UDF2

Set Yes / No.

UDF3

Set Yes / No.

UDF4

Set Yes / No.

UDF5

Set Yes / No.

UDF6

Set Yes / No.

UDF7

Set Yes / No.

UDF8

Set Yes / No.

UDF9

Set Yes / No.

UDF10

Set Yes / No.

Line Narration

Set Yes to show Bank Name, Document Number etc entered during payment collection.

Printing Option

Format Files

Press <enter> and select the format files of the report from the list. You may select more than one formats, then during printing, you will get the formats selected ere in the list of selectable formats, from where you may select the desired format.

Show Narration

Set Yes to show Narration attached with transactions else set No.

Report as per Entry Date

Show Report as per Entry Date.

^P Print

Use this button to print Bank Reconciliation Statement.

-V Preview Dgn

Use this button to open preview designer for Bank Reconciliation Statement.

Bank Reconciliation Option:

Allow Back Date Reconciliation

Set Yes to allow back date reconciliation.

Format Files

Select format file from list and set that for reconciliation print preview.

Show Narration

Set Yes to show narration field in Reconciliation Screen.

Report as per Entry Date

Set Yes to show statement as per entry date.