Using eFolio Exports

You can export folio data to an XML file during the End of Day procedure or on demand using the following two export templates for creating exports:
  • EFOLIO_EXPORT is available to be generated during End of Day.

  • EFOLIO_EXPORT_DAY is available to be manually generated on demand.

    Note:

    eFolio Export is not supported by scheduled exports.

The generated export file contains data for billing folio settlements made with a selected payment method. For more information see: Managing Exports.

You can include custom reference numbers in the export when the Custom Numbers OPERA Control is active and customer numbers are configured..

eFolio Export Delivery Types

Multiple delivery types can be selected in a profile, with one delivery type selected as the primary. For more information, see Managing Profile Delivery Types
  • Electronic: transmits data to the recipient's bank.

  • Email: generates an email to the recipient.

  • Printing: sends by regular postal mail to the recipient.

When a guest settles a bill for a billing window with a payment type selected for eFolio Export, the cashier is prompted to select the delivery type and proceed with the settlement.

Posting

The Billing screen updates to display the Before Settlement Actions prompt when posting a settlement from the following:
  • Advance Bill

  • Early Departure

  • Interim Bill

  • Check Out

  • Credit Bill (through Billing)

  • Quick Checkout

You can select an eFolio delivery method from the delivery types defined on the profile.

Sample eFolio XML Export

<?xml version="1.0" encoding="UTF-8"?> <?xml version="1.0" encoding="UTF-8"?>
<OPERA_eFoliioExport hotel_code="ROSIE" date="2017-02-23">
	<Company>
		<CompanyName>XXXX</CompanyName>
		<CompanyAddress>XXXX</CompanyAddress>
		<ComapnyCity>XXXX</ComapnyCity>
		<CompanyZip>XXXX</CompanyZip>
		<CompanyCountry>XXXX</CompanyCountry>
		<CompanyPhone>+XXXXXXXXX/CompanyPhone>
		<CompanyFax> </CompanyFax>
		
		AND ALL OTHER UNDER EXPORT MAPPING FOR EFOLIO
	
	</Company>
	
	<eFolios>
		<EFOLIO>
			<FolioDate>20200721</FolioDate>
			<FolioTime>10:32</FolioTime>
				<FolioNumbers>
					<BillNumber>1234</BillNumber>
					<InvoiceNumber>9876</InvoiceNumber>
					<VoidNumber></VoidNumber>
					<CreditBill></CreditBill>
					<CustomNumber1>XXXX XXXX XXXX XXXX XXXX</CustomNumber1>
					<CustomNumber2></CustomNumber2>
					<CustomNumber3></CustomNumber3>
					<CustomNumber4></CustomNumber4>
					<CustomNumber5></CustomNumber5>					
					-- ALL NUMBERS RELATED TO THE FOLIO...
				
				</FolioNumbers>
			<CashierNumber>10</CashierNumber>
			<UserID>YOLO@XXXXX.COM</UserID>
			<FolioText1>I love XXXX</FolioText1>
			<FolioText2></FolioText2>
			<PromotionText1>Have a nice day</PromotionText1>
			<PromotionText2></PromotionText2>
				
				<Payee>
					<PayeeName>Oracle XXXXX AB</PayeeName>
					<PayeeAddress1>XXXXXXXXXX 4</PayeeAddress1>
					<PayeeAddress2>XXXX 1188</PayeeAddress2>
					<PayeeAddress3> </PayeeAddress3>
								-- AND ALL UNDER PAYEE MARKED IN GREEN
				</Payee>
				<Guest>
					<GuestName>XXXXX</PayeeName>
					<GuestFistName>XXX</GuestFistName>
					<GuestAddress1>XXXX Street 1</GuestAddress1>
					<GuestAddress2></GuestAddress2>
					<GuestAddress3> </GuestAddress3>
								-- AND ALL UNDER GUEST MARKED IN GREEN
				</Guest>
				
				<Reservation>
					<RESV_NAME_ID>123456789</RESV_NAME_ID>
					<ConfirmationNumber>8888888</ConfirmationNumber>	
					<ExternalReferenceNumber>EXPEDIA 7777777</ExternalReferenceNumber>						
					<CustomReferenceNumber>CUSTOM 222222</CustomReferenceNumber>
					<ArrivalDate>20200719</ArrivalDate>
					<ArrivalTime>15:53</ArrivalTime>
					<DepartureDate>20200721</DepartureDate>
					<DepartureTime>10:32</DepartureTime>
					<RoomNumber>517</RoomNumber>
					<LinkedProfiles>
						<LinkedCompany>XXXX Denmark</LinkedCompany>
						<LinkedAgent></LinkedAgent>
						<LinkedSource></LinkedSource>
						<LinkedGroup>XXXX XXXX Group</LinkedGroup>
						<LinkedReservationContact>XXXX XXXX<LinkedReservationContact>
						<LinkedBillingContact>XXXX XXXX</LinkedBillingContact>
					</LinkedProfiles>
					<LinkedMemberships>
						<MemberClass Class="LOYALTY">
							<MemberType>EHS</MemberType>
							<Memberdescription>XXXX Hotels of Sweden</Memberdescription>
							<MemberNumber>XXXX 3456 7890</MemberNumber>
							<MemberLevel>GOLD</MemberLevel>
						</MemberClass>
						<MemberClass Class="FFF">
							<MemberType>SAS</MemberType>
							<Memberdescription>Scandinavian Airline System</Memberdescription>
							<MemberNumber>XXXX XXXX XXXX</MemberNumber>
							<MemberLevel>SILVER</MemberLevel>
						</MemberClass>
						-- AND ALL OTHER LINKED MEMBERSHIPS TO THE RESERVATION
					</LinkedMemberships>
					
						-- AND ALL UNDER RESERVATION MARKED IN GREEN

				</Reservation>
				<Transactions>
					<Posting>
						<TransactionDate>20200720</TransactionDate>
						<TransactionTime>02:32</TransactionTime>
						<TransactionType>WRAPPER</TransactionType>
						<DebitCredit>DEBIT</DebitCredit>
						<TransactionID>XX</TransactionID>
						<WrapperTransactionID></WrapperTransactionID>
						<TransactionCode>9090i</TransactionCode>
						<TransactionDescription>Accommodation</TransactionDescription>
						<ArrangementCode>10</ArrangementCode>
						<ArrangementDescription>Accommodation</ArrangementDescription>
						<Quantity>1</Quantity>
						<Price>100</Price>
						<GrossAmount>100</GrossAmount>
						<NetAmount>82</NetAmount>
						<TotalVATAmount>18</TotalVATAmount>
						<VAT>
							<VATCode>20</VATCode>
							<VATDescription>20% VAT</VATDescription>
							<VATAmount>16</VATAmount>
							<VATCode>10</VATCode>
							<VATDescription>10% VAT</VATDescription>
							<VATAmount>2</VATAmount>
						</VAT>
						<Supplement>[NA Posting]</Supplement>
						<Reference></Reference>
						<CheckNumber></CheckNumber>
					</Posting>
					<Posting>
						<TransactionDate>20200720</TransactionDate>
						<TransactionTime>02:32</TransactionTime>
						<TransactionType>SUB</TransactionType>
						<DebitCredit>DEBIT</DebitCredit>
						<TransactionID>28</TransactionID>
						<WrapperTransactionID>27</WrapperTransactionID>
						<TransactionCode>1000</TransactionCode>
						<TransactionDescription>Accommodation</TransactionDescription>
						<ArrangementCode>10</ArrangementCode>
						<ArrangementDescription>Accommodation</ArrangementDescription>
						<Quantity>1</Quantity>
						<Price>80</Price>
						<GrossAmount>80</GrossAmount>
						<NetAmount>64</NetAmount>
						<TotalVATAmount>16</TotalVATAmount>
						<VAT>
							<VATCode>20</VATCode>
							<VATDescription>20% VAT</VATDescription>
							<VATAmount>16</VATAmount>
						</VAT>
						<Supplement>[NA Posting]</Supplement>
						<Reference></Reference>
						<CheckNumber></CheckNumber>
					</Posting>
					<Posting>
						<TransactionDate>20200720</TransactionDate>
						<TransactionTime>02:32</TransactionTime>
						<TransactionType>SUB</TransactionType>
						<DebitCredit>DEBIT</DebitCredit>
						<TransactionID>29</TransactionID>
						<WrapperTransactionID>27</WrapperTransactionID>
						<TransactionCode>2000</TransactionCode>
						<TransactionDescription>Breakfast</TransactionDescription>
						<ArrangementCode>10</ArrangementCode>
						<ArrangementDescription>Accommodation</ArrangementDescription>
						<Quantity>1</Quantity>
						<Price>20</Price>
						<GrossAmount>20</GrossAmount>
						<NetAmount>18</NetAmount>
						<TotalVATAmount>2</TotalVATAmount>
						<VAT>
							<VATCode>10</VATCode>
							<VATDescription>10% VAT</VATDescription>
							<VATAmount>2</VATAmount>
						</VAT>
						<Supplement>[NA Posting]</Supplement>
						<Reference></Reference>
						<CheckNumber></CheckNumber>
					</Posting>
					<Posting>
						<TransactionDate>20200720</TransactionDate>
						<TransactionTime>13:22</TransactionTime>
						<TransactionType>POSTING</TransactionType>
						<DebitCredit>DEBIT</DebitCredit>						
						<TransactionID>30</TransactionID>
						<WrapperTransactionID></WrapperTransactionID>
						<TransactionCode>3000</TransactionCode>
						<TransactionDescription>Mini Bar Drinks</TransactionDescription>
						<ArrangementCode></ArrangementCode>
						<ArrangementDescription></ArrangementDescription>
						<Quantity>2</Quantity>
						<Price>6</Price>
						<GrossAmount>12</GrossAmount>
						<NetAmount>9.60</NetAmount>
						<TotalVATAmount>2.4</TotalVATAmount>
						<VAT>
							<VATCode>10</VATCode>
							<VATDescription>10% VAT</VATDescription>
							<VATAmount>2.40</VATAmount>
						</VAT>
						<Supplement>2 Coca Cola</Supplement>
						<Reference></Reference>
						<CheckNumber></CheckNumber>
					</Posting>
					<Posting>
						<TransactionDate>20200721</TransactionDate>
						<TransactionTime>10:31</TransactionTime>
						<TransactionType>PAYMENT</TransactionType>
						<DebitCredit>CREDIT</DebitCredit>
						<TransactionID>31</TransactionID>
						<WrapperTransactionID></WrapperTransactionID>
						<TransactionCode>9000</TransactionCode>
						<TransactionDescription>Cash</TransactionDescription>
						<ArrangementCode></ArrangementCode>
						<ArrangementDescription></ArrangementDescription>
						<Quantity>1</Quantity>
						<Price>112</Price>
						<GrossAmount>112</GrossAmount>
						<NetAmount></NetAmount>
						<TotalVATAmount></TotalVATAmount>
						<VAT>
						</VAT>
						<Supplement></Supplement>
						<Reference></Reference>
						<CheckNumber></CheckNumber>
					</Posting>								
				</Transactions>
				<FolioTotals>
					<FolioBalance>0</FolioBalance>
					<FolioTotalGrossAmount>112.00</FolioTotalGrossAmount>
					<FolioTotalNetAmount>91.60</FolioTotalNetAmount>
					<FolioTotalVATAmount>20.40</FolioTotalVATAmount>
					<FolioVATDetails>
						<FolioVATCode>20</FolioVATCode>
						<FolioVATDescription>20% VAT</FolioVATDescription>
						<FolioVATAmount>16</FolioVATAmount>
						<FolioVATCode>10</FolioVATCode>
						<FolioVATDescription>10% VAT</FolioVATDescription>
						<FolioVATAmount>4.40</FolioVATAmount>
					</FolioVATDetails>
				</FolioTotals>
			</EFOLIO>
	</eFolios>
	

</OPERA_eFoliioExport>