Historical transactions import

Want to see how you’re tracking against goal from your very first month? Share your historical transaction data with Flip.to and we’ll load it into Spacetime—so room nights and revenue are measured against your targets from day one, no waiting for new bookings to accumulate.

Before you begin: This one’s for the data or IT contact at your property—whoever can pull a transaction export from your booking engine, PMS, or data warehouse. Your Customer Success Manager will help coordinate the hand-off, and is standing by if you have any questions along the way.

What to include

Send every transaction with a stay date that falls inside the import window you’ve agreed with your Customer Success Manager. Stay date is the period the guest was physically on-property—so we need both arrival and departure dates to land each stay in the right goal months. Include the reservation date too, which is the date the booking was originally created.

Required fields

A simple CSV works great. Use the field names below—they let us map your data straight into Spacetime.

Field	Description	Format
name	Full name of the property.	String
code	Internal identifier used by the booking engine.	Alphanumeric
reservation_date	When the reservation was created, in UTC.	yyyy-MM-ddTHH:mm:ss (e.g. 2026-03-15T13:25:21)
crs_number	Booking engine confirmation number.	String
amount	Total pre-tax amount for the room purchase.	Decimal (0.00)
currency	ISO 4217 3-character currency code (e.g. USD).	String
arrival_date	Check-in date.	yyyy-MM-dd
departure_date	Check-out date.	yyyy-MM-dd
adults	Total adult guests on the reservation.	Integer
children	Total child guests on the reservation.	Integer
rooms	Total rooms on the reservation.	Integer

A few formatting notes

• Dates follow ISO 8601—yyyy-MM-dd for dates, and yyyy-MM-ddTHH:mm:ss in UTC for timestamps.

• Amounts are decimals, no currency symbols and no thousands separators.

• Property codes match what’s currently configured in your booking engine, so reservations line up with the right property in Spacetime.

Sending it over

When the file’s ready, share it with your Customer Success Manager via a secure file share—Google Drive (link shared directly with your CSM), a one-time Dropbox link, or your own SFTP all work well. If you’d prefer a different method, just let your CSM know and we’ll set one up.

Once it’s loaded, hop back into the Goals tab and you’ll see history feeding into the same calendar heat map and progress views—ready to dial in from there.