The General Ledger lists the accounting entries of your company. Frappe Books makes these entries when you submit a document, such as an invoice or a payment. Use it to see the entries of a period, an account, a party, or a document.
Click Reports > General Ledger in the sidebar. On a phone, tap Reports in the bottom tabs. For the controls that all reports share, such as export and print, see Reports.
Open From a Document
- To see the entries of a document, open the submitted document and click View > Accounting entries in the page header. On a phone, tap the … button in the header, and then tap Accounting entries.
- After you submit an invoice, a payment, or a journal entry, you can also click View accounting entries in the message.
- To see the entries of a customer or a supplier, open the saved party and click View > General Ledger.
The report opens with Ref Type and Ref Name, or Party, set. From a document, From Date and To Date change to the date of the document. When you open the General Ledger from the sidebar again, Frappe Books clears Ref Type and Ref Name. It also sets the dates back to their default values.
Filters
| Filter | Description |
|---|---|
| From Date and To Date | The period of the entries. The default period starts one year before today and ends today. |
| Ref Type and Ref Name | One type of document, such as Sales Invoices or Payments, and one document of that type. Select Ref Type first. |
| Account | Shows only the entries of this account. For a group account, shows the entries of all the accounts below it. |
| Party | Shows only the entries of this customer or supplier. |
| Group By | Puts the entries in groups by Party, Account, or Reference (document). |
| Include Cancelled | Also shows the entries of cancelled documents. |
| Ascending Order | Shows the oldest entries first. By default, the newest entries show first. |
Balances
The report starts with an Opening row and ends with a Closing row.
- Opening is the balance before From Date of the entries that match the other filters.
- Balance in each entry row is the opening balance, plus the debits, minus the credits, up to that entry. Frappe Books adds the entries from the oldest to the newest, also when the newest entries show first.
- Closing shows the total debit, the total credit, and the balance at the end of the period.
A negative balance is a credit balance. Each document has equal debits and credits. So, without an Account filter, the balance is usually zero. To see the balance of one account, select it in Account, or set Group By to Account.
With Group By, each group has its own Opening row and a Total row. An empty row separates the groups.
Cancelled Documents
When you cancel a document, Frappe Books makes reverse entries with the same date. A reverse entry moves the same amount to the other side. Frappe Books marks the original entries and the reverse entries as reverted.
By default, the report does not show reverted entries. To show them, select Include Cancelled. The Reverted column then shows Reverted for these entries. They cancel each other, so the closing balance does not change.
On a Phone
Each entry shows the account, the document number, the party, the amount with Dr or Cr, and the balance. To open the document of an entry, tap the entry, and then tap the button with the document number, such as Open SINV-1001.
The buttons below the header show From Date, To Date, Account, and Party. To change the filters, see Change the Filters.