Skip to content

gl_entries

The general ledger, summarized to one journal per day per source. One row is one line of one journal.

One row is
one line of one journal
Columns
9
Rows in Sample
97,712
Rows in Standard
97,712
Rows in Full
97,712

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

Columns

ColumnTypeWhat it holdsValues or range
entry_idkeyintegerUnique id for the row.
journal_idintegerLines sharing a journal_id balance: debits equal credits.
entry_datedatePosting date.2018-01-01 to 2025-12-31
account_idintegerLinks to gl_accounts.
department_idintegerCost center, on expense lines that have one. Can be empty.
debitdecimalDebit amount in dollars.0 to 38,034,054.34
creditdecimalCredit amount in dollars.0 to 38,034,054.34
source_systemtextSystem that produced the journal.accounts payable; lodging; maintenance; manual journal; pass system; payroll; pos: LegacyPOS; pos: VelaluzPOS; purchasing; refund system; ticketing
descriptiontextWhat the journal is.

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.

entry_idjournal_identry_dateaccount_iddepartment_iddebitcreditsource_systemdescription
112018-01-012310539724.910lodgingLodging revenue recognized
212018-01-0141000539724.91lodgingLodging revenue recognized
322018-01-012310038034054.34lodgingOpening balance: stays booked before 2018
422018-01-01300038034054.340lodgingOpening balance: stays booked before 2018
532018-01-011000396979.510lodgingRoom bookings

Download from Kaggle