General ledger software for Canadian businesses
Every amount on your reports comes from entries in the general ledger. In iBill you can click straight from a report line to the entries behind it, with dates, references and a running balance. No exporting and searching through spreadsheets.
Free · No credit card · All features included
How it works
Start from a report
On the trial balance, income statement or balance sheet, click an account to open its ledger.
Narrow it down
Set a period, or filter by class, location or project, including entries with no tag.
Read the detail
Each line shows the date, description, reference, debit, credit and the account's running balance. Click Close to go back to the report where you started.
Worked example: October in a Bank Account ledger
A web developer opens Bank Account (1200) from the balance sheet for October. The opening balance is $4,200.00.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| Oct 3 | Payment received: invoice INV-0118 | $2,260.00 | $6,460.00 | |
| Oct 7 | Expense: hosting renewal | $339.00 | $6,121.00 | |
| Oct 15 | Vendor bill paid: subcontractor | $1,575.00 | $4,546.00 | |
| Oct 31 | Bank fee (reconciliation) | $14.95 | $4,531.05 |
Each line's reference shows where it came from: a payment, an expense, a bill or a bank line. If an entry was voided, it and its reversal are left out of the balance, but the void stays in the journal so the history is complete.
The bank balance in iBill should match the bank statement once the month is reconciled; the running balance is how you spot the line where they part ways.
Two ways to read the ledger
The account ledger from a report is the quickest: one account, one period, with its running balance, 100 lines at a time. It's what you use to answer "what's in this number?"
Reports, General Ledger lists entries for all accounts, or one, between two dates, grouped by account with totals. It shows the most recent 200 entries in the range, so for a full year use the account ledger or ask your accountant to work from the trial balance.
Every line carries the reference and description of its source, so an amount in the ledger can be traced to the payment, expense, vendor bill or bank line that created it, and from there to the invoice, the receipt or the client. That trail is what an accountant or a reviewer looks for first.
What’s included, and what isn’t
- Running balances follow each account's normal side: debit for assets and expenses, credit for liabilities, equity and revenue.
- Filters for period and tags; the tag filter can also find entries with no tag.
- Journal Entries lists every entry with its type (invoice, payment, expense or manual), and voided entries can be hidden.
- Entries can't be deleted, only voided with a reason.
- Your accountant can be given read-only access to your books instead of a copy of them.
- Not included: exporting the ledger to a file, and a full-year general ledger report beyond the most recent 200 entries.
Questions
What's the difference between the general ledger and the journal?
Can I export the general ledger?
Can I filter by project?
Why doesn't my bank balance in iBill match the bank?
Related
See what's behind every number
From any report line to the entries behind it in one click. See the rest of the accounting tools.
Start freeFree · No credit card · All features included · Join 1,200+ Canadian Businesses