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="HOTELCODE" date="2017-02-23">
	<Company>
		<CompanyName>COMPANY</CompanyName>
		<CompanyAddress>COMPANY ADDRESS</CompanyAddress>
		<ComapnyCity>CITY</ComapnyCity>
		<CompanyZip>ZIP</CompanyZip>
		<CompanyCountry>XXXX</CompanyCountry>
		<CompanyPhone>+PHONE NUMBER/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>USERID</UserID>
			<FolioText1>I love XXXX</FolioText1>
			<FolioText2></FolioText2>
			<PromotionText1>Have a nice day</PromotionText1>
			<PromotionText2></PromotionText2>
				
				<Payee>
					<PayeeName>PAYEE NAME AB</PayeeName>
					<PayeeAddress1>PAYEE ADD 1</PayeeAddress1>
					<PayeeAddress2>PAYEE ADD 2</PayeeAddress2>
					<PayeeAddress3>PAYEE ADD 3 </PayeeAddress3>
								-- AND ALL UNDER PAYEE MARKED IN GREEN
				</Payee>
				<Guest>
					<GuestName>GUEST NAME</PayeeName>
					<GuestFistName>First Name</GuestFistName>
					<GuestAddress1>Address</GuestAddress1>
					<GuestAddress2></GuestAddress2>
					<GuestAddress3> </GuestAddress3>
								-- AND ALL UNDER GUEST MARKED IN GREEN
				</Guest>
				
				<Reservation>
					<RESV_NAME_ID>RESV ID</RESV_NAME_ID>
					<ConfirmationNumber>CONFIRM NUM</ConfirmationNumber>	
					<ExternalReferenceNumber>REF NUM</ExternalReferenceNumber>						
					<CustomReferenceNumber>CUSTOM REF NUM</CustomReferenceNumber>
					<ArrivalDate>20200719</ArrivalDate>
					<ArrivalTime>15:53</ArrivalTime>
					<DepartureDate>20200721</DepartureDate>
					<DepartureTime>10:32</DepartureTime>
					<RoomNumber>517</RoomNumber>
					<LinkedProfiles>
						<LinkedCompany>COMPANY</LinkedCompany>
						<LinkedAgent></LinkedAgent>
						<LinkedSource></LinkedSource>
						<LinkedGroup>Group</LinkedGroup>
						<LinkedReservationContact>RES CONTACT<LinkedReservationContact>
						<LinkedBillingContact>BILLING CONTACT</LinkedBillingContact>
					</LinkedProfiles>
					<LinkedMemberships>
						<MemberClass Class="LOYALTY">
							<MemberType>EHS</MemberType>
							<Memberdescription>HOTELNAME</Memberdescription>
							<MemberNumber>MEMBER NUM</MemberNumber>
							<MemberLevel>GOLD</MemberLevel>
						</MemberClass>
						<MemberClass Class="FFF">
							<MemberType>SAS</MemberType>
							<Memberdescription>AIRLINE NAME</Memberdescription>
							<MemberNumber>MEMBER NUM</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 Company 2</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>