A GL dump is a raw export of every general ledger entry for a chosen period, listing date, account, narration, debit and credit. Auditors and accountants use it to test, trace and analyse the books.
What does GL dump mean in accounting?
GL stands for general ledger, the master record of every account in an organisation's books. A GL dump is a raw, unsummarised extract of that ledger: each transaction line is listed, instead of a trial balance or a formatted statement.
The word dump signals bulk data. It is normally handed over as a spreadsheet or text file, and the reader then filters, sorts or pivots it to answer questions.
What does a GL dump usually contain?
The columns differ from one accounting system to another, but most dumps carry the same core fields.
- Posting date and voucher or journal number
- Account code and account name
- Narration or description of the entry
- Debit and credit amounts
- The user who posted the entry and when
- Campus, cost centre or department, where the system supports it
Why do auditors and trustees ask for one?
A dump lets a reviewer test the books without relying on summaries. Auditors use it to sample entries, look for unusual postings such as round amounts or weekend entries, and confirm that the trial balance agrees with the lines beneath it.
Trustees and directors may ask for the same thing when they want to trace one expense, see how fee income was recorded, or compare two periods in detail.
- Sampling and vouching of transactions
- Checking that total debits equal total credits
- Finding duplicate or unusual entries
- Tracing a figure on a statement back to its source
- Carrying history across when changing accounting software
How is a GL dump different from other ledger outputs?
A general ledger report is laid out account by account and is meant for reading. A trial balance shows only closing balances. A dump is flat and complete, which makes it good for analysis and poor for casual reading. The table below sets them side by side.
What ledger detail does EDUBase give a school?
The Finance & Accounting module keeps a full double-entry ledger. Fee payments, refunds and salaries post to it automatically, and other income and expenses are entered on simple forms such as Add Expense and Add Other Income.
For entry-level detail, use the general ledger and GL inquiry, which lets you drill from any account into its entries for a date range, with print. Standard statements are also available: trial balance, P&L and balance sheet, plus a cash report for what came in and went out.
In the new ledger a posted entry is never edited or deleted; it is reversed and both entries are kept. That is what an auditor wants to see when reading ledger detail. For wider activity, the User Logging page shows who created, changed or deleted a record.
How should a school prepare ledger data for an audit?
A little preparation saves days once the auditor arrives. Agree the scope first, then make sure the books are settled before anyone extracts anything.
- Close accounting periods so nothing can be posted into them afterwards
- Agree the date range and campuses with the auditor in advance
- Check that the trial balance agrees with the ledger entries
- Keep reversal entries together with the originals they correct
- Note who approved large payments, discounts and salary changes
- Run the old and new ledgers side by side if you are switching, and compare account by account
GL dump compared with other ledger outputs
| Output | Level of detail | Best used for |
|---|---|---|
| GL dump | Every transaction line in a flat file | Audit testing, analysis, migration |
| General ledger report | Entries grouped account by account | Reading one account's history |
| Trial balance | Closing balance per account | Checking debits equal credits |
| Profit and loss | Income and expense totals | Judging performance for a period |
| Balance sheet | Assets, liabilities and equity at a date | Judging financial position |
| Cash report | Money in and out for a day or period | Daily cash control |
Related modules
- Finance & Accounting — Chart of accounts, journals, ledgers, trial balance, P&L and balance sheet, fed by fees and payroll.
- Fee Management & Challans — Fee plans, monthly challans, discounts, family payments and receipts, without spreadsheets.
- Payroll & Salaries — Salary plans, allowances, deductions, approvals, payslips and salary sheets, posted to the ledger.
- Users, Privileges & Activity Log — Give each staff member exactly the screens and actions they need, and see who changed what.