Skip to content

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:

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?

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:

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 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 seeWhat has happenedWhat to do
‘The account does not exist.’The link points to a deleted account, or you are in another companyCheck at the top which company you are in and go back to Accounts
The statement comes out emptyThe account has no movements in that date rangeWiden From and To, and check the financial year
The balance doesn’t match what you expectYou are looking at a different financial year from the one you thinkThe financial year is chosen at the top of the screen
The account appears with the Group with journal lines warningIt is a group account that also receives direct movementsIt 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 tickedChange 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