Ledger Report

A Ledger Report is a summarized report of all the Debit and Credit transactions  along with  running balances of a specific Ledger over a selected period of time.

Working with Ledger Report in RealBooks

 

You use the general ledger report to check and display movement of accounts in a specified period.You also have the opportunity to select drill-down fields; this causes the report and all key figures to be drilled down to the selected drill- down field.  The default report has the following fields for user input.

Input for Ledger Report

  • Search Ledger : Search the ledger name
  • From Date: Transactions from this date will be shown. And a single amount summarizing the transactions prior to this date will come as Opening Balance
  • To Date : Transactions till this date will be shown. And a single amount summarizing the transactions prior to this date will come as Closing Balance
  • Monthly View(Optional) : Can click on the monthly option if monthly summary is required. When searching for more than 2 months, this option gets activated by default. Where there is a large data set, it is recommended that we first run the monthly summary and drill down to the transactions. 
  • Search : Execute the search.

 

 Columns in Report

The default report has the following fields –

  • Segment : Branch / Segment Code
  • Date : Date of Transaction
  • Vnum : Voucher Number
  • Description : Offset Account and transaction narration also appears here. You can use the short key shift + enter to view the narration and activity details for the transactions.
  • Vtype : Voucher type name of Transaction
  • Debit : Amount Debited
  • Credit : Amount Credited
  • Rn Bal : Stands for Running Balance. Closing Balance till that transaction.
  • Group : Colours marked by user for classifying transactions for daily use
  • Tag : It is an another way of grouping ledgers and transactions

 

RealBooks provides you with many options in Ledger Report to make your work easier-

  • Approved : Select approved option for viewing the approved vouchers that are marked in green.
  • Unapproved : Select unapproved option for viewing the unapproved vouchers that are marked in red.
  • My Task : Shows the approvals that are pending
  • Doc Attached :  Shows the transactions with document attached
  • Without Doc : Shows the transactions without document attached
  • Entry Information : Shows the creator name, creation date and time, last updated date and time with the user name
  • Narration : Displays the narration in the description column
  • Ledgers : Will show all additional ledgers
  • Notes : Displays the note in the description column
  • Bank Reconciled Date : Bank reconciliation date appears of the bank voucher
  • Item Wise : Item details appears for inventory transactions(purchase, sale, etc)
  • Bill Wise : Party bill no appears
  • Hide Unselect Voucher : Vouchers that are not selected can be hidden
  • View Hidden Voucher : Vouchers that are hidden can be viewed separately
  • Ledger Master View : Ledger is being viewed in master format
  • Bill Status Report : Shows the bill wise outstanding position
  • Tag : It is an another way of grouping ledgers
 

 

Filtering, Hiding the Ledger Report

Filtering

  • Can filter all the fields to get the specific details of the specific voucher
  • Green Line present on the left side of the voucher denotes that the particular voucher has been approved and if its a Red Line then it is not yet approved
  •  R- symbolize that the voucher has been Reconciled
  • If there is any issue related to any voucher then a colour can b given to it by typing nos.- 1 to 6 and it will appear on the extreme right side of the particular ledger. You can also give more than one colour to the specific voucher.

TO WORK ON THE PARTICULAR ENTRY, CLICK ON THE SETTING OPTION ON THE RIGHT SIDE OF THE PARTICULAR VOUCHER WHERE YOU WILL GET THE FOLLOWING OPTIONS

  • Voucher Edit : You can edit your voucher
  • Voucher View : You can view your voucher
  • Hide Voucher : You can hide the individual voucher from this setting option
  • Stock Wise : Shows the stock details of the individual voucher
  • Approval Details : Shows you who approved the voucher and you or the one who approved can add a comment in the comment dialogue box
  • Create User Task :
  • View User Task :
  • Generate Invoice : You can generate the invoice and can even print it
  • Last Invoice :
  • Tag : It is an another way of grouping ledgers
  • Notes : Displays the note in the description column
  • PDF For Voucher Summary : Shows you the summary of the voucher in PDF format
  • PDF For Voucher Print : You can generate the voucher print / money receipt

Printing & Exporting the Ledger Report

RealBooks provide you to export your data in ledger reports and print it in Excel or PDF format like-

  • Excel with Details : Can export reports in excel format with its details
  • Excel without Details : Can export reports in excel format without its details
  • Excel Pivot Structure : Can generate report in pivot structure
  • Excel Purchase : Can export reports in excel format with its purchase details
  • Excel Sales : Can export reports in excel format with its sales details
  • Excel Accounts Voucher : Can export reports of account voucher in excel format
  • PDF with Details : Can export reports in PDF format with its details
  • PDF without Details : Can export reports in PDF format without its details
  • PDF ( Bulk Invoice Print ) : Multiple invoice can be generated and printed in PDF format
  • PDF Confirmation Reports with Details : Can export reports in excel format with confirmation with its details
  • PDF Confirmation Reports without Details : Can export reports in excel format with confirmation without its details

Short-Keys Available in Ledger Report

RealBooks provides you with special short-keys to save your valuable time-

  • Narration – N
  • Ledgers – L
  • Item Wise – I
  • Bill Wise – B
  • Hide Unselect Voucher – U
  • View Hidden Voucher – H
  • Tag – T
  • Ledger Master View – V
  • To know the Details of individual Ledger – Shift+Enter