Skip to content

budgets

Monthly budget for each revenue and expense account, by department where the account has cost centers. One row is one account and department in one month.

One row is
one account and department in one month
Columns
5
Rows in Sample
4,608
Rows in Standard
4,608
Rows in Full
4,608

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
fiscal_yearintegerCalendar year.2018 to 2025
month_startkeydateFirst day of the month.
account_idkeyintegerLinks to gl_accounts.
department_idkeyintegerCost center, where the account has them. Can be empty.
budget_amountdecimalBudget in dollars. Revenue is negative, like a credit, so it can be compared with debit minus credit.0 to 24,524,000

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

fiscal_yearmonth_startaccount_iddepartment_idbudget_amount
20182018-01-0140009057100
20182018-02-0140009334300
20182018-03-01400012334800
20182018-04-01400011829400
20182018-05-01400011157100

Download from Kaggle