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

• 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