How do I view an account’s general ledger?
An account’s general ledger is the list of its movements with the running balance line by line. It answers ‘how much does this customer owe me, and for what?’. You view it in two places: from the account record and, without leaving where you are typing, from the Accounting journal itself.
How do I get to an account’s record?
Go to Accounting and then Accounts. The Ledger accounts screen opens with the chart of accounts of the financial year you have selected.
At the top left are the list filters:
- The Search by code or name… box. Both the code and part of the name work.
- The Account… box, which finds the accounts that start with what you type and shows all levels together, sorted by code:
440brings up subgroup440and, below it, all its sub-accounts. While it has something typed in it, the level selector is switched off. - The level selector: Groups, Subgroups and Sub-accounts. Sub-accounts comes ticked, which are the accounts you post to and what you are almost always looking for.
They combine: if you search for ‘clientes’ with Subgroups ticked, you get 43, 430, 4300…, and not each customer one by one; and ‘alce’ with Account 43 only brings up the 43 accounts that say ‘alce’. The list refreshes when you stop typing, not on every key press. On the right you can see how many accounts match the filter.
The list shows Code, Name, Status and Financial year balance, sorted by code. It has its own scroll bar and the header stays fixed. It isn’t loaded all at once: as you scroll down, it fetches the next accounts by itself.
Click the row to open its record. Inside there are three tabs: Details, General ledger / Statement and Monthly balances.
What is each level?
- Groups: the big blocks of the chart of accounts, with one digit. For example
4, Creditors and debtors. - Subgroups: all the intermediate levels, from two digits upwards:
43,430,4300… They are indented so you can see what hangs from what. This is where you look for an intermediate account. - Sub-accounts: the full accounts, the ones that receive journal lines. For example
43000025.
The Financial year balance of a group or a subgroup is the sum of everything that hangs from it: that of 43 adds together that of all the accounts that start with 43.
How do I see an account’s movements between two dates?
On the account’s record, go to the General ledger / Statement tab. Enter the dates in From and To and click View.
The table has one line for each journal line on the account, with these columns: Date, Journal entry, Description, Debit, Credit and Balance.
At the very top there is a Previous balance row. It is what the account was carrying before the From date. The Balance column starts from there and keeps adding up. At the bottom there is a Closing balance row with the result.
If you open the record of a group account, such as 430, the statement also adds up the movements of all its sub-accounts. That way you see the customer total at a glance without going customer by customer.
How do I see the general ledger without leaving the journal?
On the Accounting journal screen there are two tabs at the top: Journal and General ledger view. They are two ways of looking at the same journal entries:
- Journal: in the order they were recorded. It is how they are typed.
- General ledger view: by account, with the running balance. It is how they are reconciled.
If you go to General ledger view with the journal cursor on a journal line, you get the general ledger of its account: the debit one if the cursor is in the debit columns, the credit one if it is in the credit columns. That journal entry’s line comes up marked, so you see the journal line in its place. Each time you go in, it looks at where the cursor is.
It works the same with the journal entry open, even a read-only one (one that comes from an invoice): the cell you clicked or reached with the keyboard is what counts. And if after saving you carry on browsing the list, the list cursor is what counts, not the new journal entry left open at the bottom.
You can also type one account in the Account box: a sub-account (43000002, or its abbreviation with a dot, 430.2) or a group (430), which brings all its sub-accounts together. The magnifier, or F2, opens the chart of accounts to pick one. With Enter you run the query without touching the mouse.
The dates are the same as you had in the journal: changing tab doesn’t change the period you are looking at.
The table has Date, Journal entry, Account, Description, Debit, Credit and Balance, with its Previous balance at the top and its Closing balance at the bottom, just as on the account record. The Account column is useful when you view a group such as 430, because then the lines are from different sub-accounts.
The list is navigated with ↑ and ↓ (and Page Down, Page Up, Home and End). Enter, or a double-click on a line, takes you back to the Journal positioned on that journal entry. It is the short way round: the general ledger tells you where the imbalance is and the journal is where you fix it. Escape goes back to the journal without moving it.
How do I see the balance month by month?
On the account’s record, go to the Monthly balances tab. There is nothing to click: it loads with the financial year selected at the top.
The table has one row per month, with Month, Debit, Credit, Balance for the month and Cumulative. The Balance for the month is only what moved that month. The Cumulative carries on from January.
This view is the quickest for spotting an odd month: an amount that is out of line stands out without opening any journal entry.
Where do the movements I see come from?
All the account’s journal lines appear in the general ledger, wherever they come from. There are no separate books.
- The journal entries that each issued invoice creates when it is issued.
- The receipt and payment journal entries.
- The journal entries you have typed by hand in the Accounting journal.
- The *financial year*’s closing and opening journal entries.
The Journal entry column gives you the number. With that number you can go to the Accounting journal and see the complete journal entry, with all its lines.
Can I change an account’s name or block it?
Yes, on the Details tab of the record. You can change three things: the Name, the Blocked for new journal lines checkbox and the notes.
The Code and the Level can’t be changed. The code is the account’s identity.
The Blocked for new journal lines checkbox stops the account from being used in new journal entries. The movements it already had stay as they are. It is the way to retire an account without losing its history.
Changes are saved when you click Save, not as you type.
If the account is a customer’s or a supplier’s sub-account, the Linked business partner box appears. That link isn’t changed from here: it is changed on the customer’s or supplier’s record.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| ‘The account does not exist.’ | The link points to a deleted account, or you are in another company | Check at the top which company you are in and go back to Accounts |
| The statement comes out empty | The account has no movements in that date range | Widen From and To, and check the financial year |
| The balance doesn’t match what you expect | You are looking at a different financial year from the one you think | The financial year is chosen at the top of the screen |
| The account appears with the Group with journal lines warning | It is a group account that also receives direct movements | It is a warning, not an error. Tell whoever administers the ERP |
| You look for an account you know exists and get ‘No results’ | It is on another level: for example, you search for 430 with Sub-accounts ticked | Change the level; the search is kept. Or type the code in Account…, which searches all levels at once |
See also: Make a manual journal entry · Add a ledger account · Find and correct journal entries
More about Accounting
- How do I depreciate fixed assets?
- How do I find a journal entry and correct it?
- How do I close and open the financial year?
- How do I add a ledger account?
- How do I define the line items of the balance sheet and the income statement?
- How do I make a manual journal entry?
- How do I print or export what I see in accounting?
- How do I assign costs by department and by project?
- Keeping the accounts
- How do I write the notes to the annual accounts?
- What is the accounting dashboard?
- How do I allocate indirect costs?