Skip to content
Knowledge base · Finance & accounts

What does Finance › General Ledger show, how is it different from GL Inquiry and Journal Inquiry, and can I export it to Excel?

Where in EDUBase: Finance › General Ledger

Last updated

Finance › General Ledger is the line‑level dump of your books for a date range: every debit and credit line of every posted entry, across all accounts, one row per line. It is the report to hand an accountant who wants the raw postings, and the one you export to Excel.

Steps

  1. Go to Finance › General Ledger. It opens on the 1st of this month → today.
  2. Set Select Start Date / Select End Date and press Get Record — nothing changes until you press it.
  3. Read the rows: Campus, Trans ID, Trans Date, Code, Line Item, Amount, Account Name, Dr/Cr, Memo, Payment Id, and who created / updated the entry and when.
  4. Use the column filters (campus and account are dropdowns; the rest are free text) and the header sort to narrow it.
  5. Click a Code to open Finance › GL Inquiry for that account with the same date range already filled in.
  6. Use the table's Excel button to download the rows you are looking at; the browser's Print gives you the list under your school header.

How it differs from its neighbours

  • Journal Inquiry — one row per entry (with a "+" to open its lines); it is where you print a voucher or edit / delete. General Ledger shows the same entries already opened out into lines and has no edit or delete.
  • GL Inquiry — one account at a time, with opening balance and running balance. General Ledger is all accounts with no running balance.
  • Trial Balance — one line per account with totals. General Ledger is the detail behind those totals.

Common confusion

  • "There is no data." The screen only shows the range you asked for; widen the dates and press Get Record. Entries also follow the global Switch Campus selection and your own campus rights — a campus you cannot see is not in the list.
  • Two rows with the same Trans ID are one entry — its debit line and its credit line (or more). Do not add them up as separate transactions; the Amount column is per line.

Who can use it

The screen follows the Finance → Finance Reports privilege in Admin › Users & Privileges — the same one as Journal Inquiry and GL Inquiry.

See EDUBase running on your own school's data.

A 30-minute online demo, in English or Urdu, using your fee plans and classes. No installation, no commitment.