A summary of the financials export via API are necesasry. This would mostly be the information on the Financial Transaction report. Where we could use the "id" version over the "code" for efficiency (i.e. we can use rate_id rather than rate_code, guest_id rather than guest_name, etc). Fields Required Include:
Financial Transaction Id
Hotel Code (hotel_id preferred)
Transaction Date
Transaction Time
Charge Code
Charge Code Desc
Reference
Currency
Amount
Room Type
Rate Code
Source
Origin
Market
Segment
Confirmation Number
External Reference Number
Guest Name
Guest Card Id
Company Card Id
Company Name
Ta Card Id
Travel Agent
Group Id
Group Name
Account Number
Bill Number
Invoice Number
Folio Number
Pre Stay
Post Stay
User Name (nice to have but not necessary)
Charge Group
Charge Type
Ar Invoice Number
Cc Payment Reference
Transaction Details
Room Number
Reservation ID
Account Offset (Deposit/Ledger/AR)
If there is a way to indicate which taxes are associated to which charge that would be super useful as current settings don't always align w historicals so its difficult to tie out to past reservations. Something like the below w nesting would work (although please note below example is not at the transactional level we are looking for)
Ex: Currently we might see a tax for $1 and another for $10 so we could infer that the $10 was due to room charge and the $1 was from parking, but it would help if there were a more reliable way to link.
Requested By Sentral:
A summary of the financials export via API are necesasry. This would mostly be the information on the Financial Transaction report. Where we could use the "id" version over the "code" for efficiency (i.e. we can use rate_id rather than rate_code, guest_id rather than guest_name, etc). Fields Required Include:
Financial Transaction Id
Hotel Code (hotel_id preferred)
Transaction Date
Transaction Time
Charge Code
Charge Code Desc
Reference
Currency
Amount
Room Type
Rate Code
Source
Origin
Market
Segment
Confirmation Number
External Reference Number
Guest Name
Guest Card Id
Company Card Id
Company Name
Ta Card Id
Travel Agent
Group Id
Group Name
Account Number
Bill Number
Invoice Number
Folio Number
Pre Stay
Post Stay
User Name (nice to have but not necessary)
Charge Group
Charge Type
Ar Invoice Number
Cc Payment Reference
Transaction Details
Room Number
Reservation ID
Account Offset (Deposit/Ledger/AR)
If there is a way to indicate which taxes are associated to which charge that would be super useful as current settings don't always align w historicals so its difficult to tie out to past reservations. Something like the below w nesting would work (although please note below example is not at the transactional level we are looking for)
Ex: Currently we might see a tax for $1 and another for $10 so we could infer that the $10 was due to room charge and the $1 was from parking, but it would help if there were a more reliable way to link.