Ledger Report – O2VEND Back Office

The Ledger Report in O2VEND provides a detailed summary of all financial transactions between your business and customers or suppliers. Use this report to track credits, debits, and balances across a selected date range — making reconciliation and account review simple and accurate.

Purpose of the Ledger Report

The Ledger Report displays all entries for a selected customer, supplier, or ledger account. It helps you:

  • Review invoices, receipts, payments and returns.
  • Check opening and closing balances for a period.
  • Reconcile accounts and prepare audit trails.
  • Identify outstanding or overdue amounts.

Types of Ledger Reports

  • Customer Ledger Report — Lists all transactions (invoices, receipts, credit notes) for a specific customer.
  • Supplier Ledger Report — Shows purchases, payments, and returns related to a supplier.
  • General Ledger Report — Aggregates accounting transactions across selected accounts.

How to View the Ledger Report in O2VEND

  1. Log in to Back Office.
  2. Click Reports in the sidebar.
  3. Under Account Books, choose Ledger Report.
  4. Select a Customer or Supplier from the dropdown (example: Poonam Sharma).
  5. Set the Date Range (for example: 01-04-2025 to 31-03-2026).
  6. Choose Branch if required (example: Delhi NCR).
  7. Click View Report to display the ledger.
  8. Use Export All to download the report or Print for a printer-friendly copy.
Ledger Report – O2VEND Back Office

Tip: Use pagination controls to navigate long ledgers and the Export All button to download the entire result set.

Ledger Report Fields (What each column means)

Field Description
Date & Time When the transaction was recorded (timestamp).
Name Customer or supplier name related to the transaction.
Note Optional reference code (e.g., EP-SI_55_Delhi).
Details Transaction type & reference (e.g., Sales: EP_RC_55_Delhi).
Debit Amount debited (outgoing) for that account.
Credit Amount credited (incoming) for that account.
Opening Balance Account balance at the start of the selected date range.
Totals Sum of Debit and Credit columns for the period.
Closing Balance Final balance after all transactions in the chosen period.

Example Use Case

Selecting Customer: Poonam Sharma and Branch: Delhi NCR shows all sales and payments for that customer during the selected period. Totals (Debit / Credit) and Closing Balance appear at the bottom so you can quickly see the net outstanding amount.

Export & Print

  • Export All — Download the full ledger as Excel/CSV (useful for accounting software or sharing).

  • Print — Generates a clean, printable view for physical filing or review.

Frequently Asked Questions (FAQ)

Q1 — Can I filter the Ledger Report by branch or date range?
A — Yes. O2VEND allows filtering by both branch and custom date range for flexible reporting.

Q2 — How do I find the total outstanding balance?
A — Check the Closing Balance at the bottom of the ledger. It displays the net amount owed or due after all transactions for the selected period.

Q3 — Can I export or print the Ledger Report?
A — Yes. Use Export All to download the ledger (Excel/CSV) or Print to generate a printer-friendly copy.

Q4 — Does the Ledger Report include both sales and payments?
A — Yes. The report lists invoices, payments, credit notes and returns for the selected customer or supplier.

Q5 — What should I do if amounts don’t match my accounting records?
A — Verify invoice and receipt entries, check for duplicate or missing transactions, and confirm date range/branch filters. If needed, reconcile with journal entries or consult your accountant.

O2VEND Ledger Report | Customer & Supplier Account Book Overview

``