Balance sheet detail
Use the Balance sheet detail report in Menu > Reports to review the posting general ledger lines that make up balance-sheet balances through a selected period. It excludes draft, non-posting, and later activity, and it can be limited by filters or an amount selected from the Balance sheet.
Run the report
- Open Menu > Reports. In Search by report or description, enter the report name and press Enter.
- Select Balance sheet detail, or select an amount in the balance sheet.
- Select Change date range, choose the reporting period, and apply the change.
- Optionally filter by Account, Account type, Person or company, Transaction type, Item, or Transaction ID.
- Review the transactions. Select a transaction ID to open the source transaction.
- To download the report, select More actions > Export as PDF or Export as Excel (.xlsx).
How the report is calculated
The report shows the posting general ledger impact lines that make up balance sheet balances through the selected as-of period. Amount is the general ledger impact amount contributed by each line. Draft and other non-posting transactions and activity after the selected period are excluded. The displayed detail is further limited by the selected filters or by the balance sheet amount used to open the report.
Column definitions
The following table defines each column on the balance sheet detail report:
| Column | Description |
|---|---|
| Transaction type | The corresponding type of transaction for each amount. |
| Posting period | The period the amount was posted to the general ledger. This is the same as the posting period in the general ledger impact of the corresponding transaction. Selecting the posting period brings you to the corresponding accounting period. |
| Transaction date | The transaction date of the corresponding transaction. |
| Transaction ID | The ID of the transaction. Selecting the ID brings you to the corresponding transaction. |
| Person or company | The person, vendor, customer, or tax agency specified on the transaction. Selecting the person or company brings you to the corresponding vendor, customer, person, or tax agency record. |
| Amount | The value of the general ledger impact amount for each transaction in the corresponding date range. |