# Sage Intacct: General Ledger By Period

## Description

* Table containing the beginning balance, ending balance, and net change of the dollar amount for each month and for each account, category, and classification. This table can be used to generate a balance sheet and profit & loss (income statement) for your business based on your customer accounting period.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/sage_intacct/resources/sage_intacct_logo.svg" alt="" data-size="line"> Sage Intacct

## Columns

| Type    | Name                   | Description                                                                                                                |
| ------- | ---------------------- | -------------------------------------------------------------------------------------------------------------------------- |
| STRING  | account\_no            | ID of the account                                                                                                          |
| STRING  | account\_title         | Name of account                                                                                                            |
| STRING  | book\_id               | ID of the book                                                                                                             |
| STRING  | category               | Accounting category, like Cost of Sales Revenue                                                                            |
| STRING  | classification         | Accounting classification, like Revenue                                                                                    |
| STRING  | currency               | Currency of transaction                                                                                                    |
| STRING  | entry\_state           | State of entry                                                                                                             |
| STRING  | account\_type          | Income statement or balance sheet                                                                                          |
| DATE    | date\_year             | Year of entry year                                                                                                         |
| DATE    | period\_first\_day     | The beginning month of the entry date                                                                                      |
| DATE    | period\_last\_day      | The last day of the month of the entry date                                                                                |
| INTEGER | period\_net\_amount    | The net amount of the period of all balance-sheet transactions                                                             |
| INTEGER | period\_beg\_amount    | The amount at the beginning of the period, otherwise the difference between period\_ending\_amount and period\_net\_amount |
| INTEGER | period\_ending\_amount | The cumulative amount at the end of the period                                                                             |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/sage-intacct-general-ledger-by-period.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.