Click here for a tutorial of Printing Statements.

Click here for Owner Navigation

Overview

Review, print, and e-mail statements for a single or all owners.  RDP recommends that the statements be printed and reviewed in detail before finalizing.  Printing and reviewing statements can be done throughout the month by accessing the Month-End submenu of the Owners main menu.  Once finalized, the system closes the statement.

Date Format

A formula for BegStatementDateDisplay is available to the OwnerRentalActivity, OwnerPayments, and OwnerDirectCharges sub-reports on all of RDPWin's standard statement reports.  The statements display the dates as ”from 12/31/05 to 1/31/06”, but displaying the format as ”from 1/1/06 to 1/31/06” is also available.  The formulas make it easier to change reports.  Properties that have the Always Process Owner Statements on Calendar Month Only (Switch 912-1) set to No most likely prefer the default date display.  Properties with that switch set to Yes, prefer the using the BegStatementDateDisplay formula.  For step-by-step instructions on how to change the format to ”from 1/1/06 to 1/31/06”, click Calendar Month Only.

Folio Transactions and Owner Statements

Owner statements are comprised of reservation revenue, less management commission and direct charges.  The owner of a room is paid based on the folio transactions.  When a transaction is posted to a folio, the system immediately calculates the new "owner amount" and places that transaction in a queue to be paid to the owner the next time owner statements are processed.  Owners are not paid on transactions posted to group masters, travel agents, or credit card masters.  This section describes how reservation revenue flows from the reservation to the owner statement.

%%2 Display in B200 Transaction

Every future reservation with a non-zero estimated total room charge has a B200 transaction equal to the total room charge. A good visual clue that this is a pre-posted transaction (not yet "real" to the financial reports ) is the "%%2" in the description. This is the variable replaced with the actual room number when the "real" B200 codes are posted either at check-in or when Post Nightly Charges is run.

Changing Estimated Totals on Advance Reservations

When advance reservations are changed, such as adding or subtracting days, the system automatically recalculates the estimated total room charge. The estimated totals shown on the reservation are changed as well as the total on the B200 transaction. Remember, whether dealing with an advance reservation, checked-in guest, or historical reservation, the totals on any reservation are always equal to the sum of the transactions.

Pre-Posted Transaction Flag

Transactions on advance/future reservations are considered "pre-posted". A pre-posted transaction does not appear on any audit reports or in the general ledger. Pre-posted transactions on the folio are marked with a "*" in the "Pre" column of the folio. If this field is blank, the transaction has been posted on a checked-in reservation and appears on all audit reports.

Transactions on Advance Reservations

Reservations show totals for estimated room charge, other charge-1, other charge-2, and security deposit. These totals are always equal to the sum of the transactions on the reservation.

Balance Forward Statements

Once revenue is processed and all direct charges are posted, owner statements can be printed.  The Balance Forward Statement provides the balance due from the last billing period plus any new reservation activity and direct charges not marked as no-print, as well as payments from and refunds to the owner.  Transactions marked as non-printing (with an "*") do not print on the balance forward statement.  The sum of all non-printing transactions must be zero or statements do not print at all.

Select Owners

Find Owner Button

Click "Find Owner" button to select a single owner from the "Owner Analysis grid".  The selected owner name is automatically sent to the "Starting Owner" field, and the "Ending Owner" and Property fields are disabled.

Owner Type

View and process statements by specific owner type.

Property

View and process statements by property.

Single Owner

Check this box to signify the processing of only one owner statement.  Once checked, the Ending Owner field is disabled.  The default setting is unchecked or "All Owners".

Starting and Ending Owner

When printing a range of statements, select from the drop-down list to signify with which owner to start and with which to end.  For example, process statements for Owner Numbers 123 - 428 or Dunn - Miller.

Select Statement

Include N/R Owners with No Activity and Zero Balance

N/R stands for Non-Rental, and "No Activity" means there are no transactions for the statement period.  Check this box to print or e-mail statements without regard to activity or balance belonging to non-rental owners. Properties can use N/R to track owner postings, etc., even though the room is no longer rented out to the public.  This field is only enabled if Include Statements with No Activity and Zero Balance is checked.  The three "Include" checkboxes are disabled when processing a single owner and ignored even if the boxes are checked, AND these settings are ignored when reviewing and finalizing.  These checkboxes ONLY affect e-mailing and printing.

Include OLD Owners with No Activity and Zero Balance

"No Activity" means there are no transactions for the statement period. Check this box to process statements without regard to activity or balance belonging to owners who do not currently own a room at the property.  This option allows for the printing of owner history as well as current owners.  This field is only enabled if Include Statements with No Activity and Zero Balance is checked.  The three "Include" checkboxes are disabled when processing a single owner and ignored even if the boxes are checked, AND these settings are ignored when reviewing and finalizing.  These checkboxes ONLY affect e-mailing and printing.

Include Statements with No Activity and Zero Balance

"No Activity" means there are no transactions for the statement period. Check this box to process all statements for the selected owner(s) regardless of activity and balance.  Statements with credits, amounts due, and zero balances are all included.  This checkbox is not checked by default.  This field is only enabled (and considered) if processing more than one owner (a range).  The three "Include" checkboxes are disabled when processing a single owner and ignored even if the boxes are checked, AND these settings are ignored when reviewing and finalizing.  These checkboxes ONLY affect e-mailing and printing.

New Activity Since Last Statement

This default setting prints a statement for the selected owner(s) displaying only transactions that have a posting date between the last statement date and the "New Activity Statement" date or all new activity for an owner since the last statement marker.  If processing for both multiple owners and "Previous Statement" are selected, this field name changes to "All Owners Previous Statement Date" and offers the calendar for date selection.  There are two ways to select the date: (1) Either select from the Deposit Due drop-down calendar by clicking on the down arrow; or (2) select the month, day, or year and use the up/down arrows on the keyboard.  The default is the current date.

When a Single Owner and "New activity since last statement" are selected, the "Previous Ending Statement Dates" drop-down is populated with the last statement marker date, but the field is disabled.

When Owner Statements Configuration Switch 912-01 "Always Process Owner Statements on Calendar Month Only" (Owners and Travel Agents only) is checked  and the "New Activity Ending Statement Date" is selected, the last day of the previous month is still displayed if it has NOT been finalized. If it has been finalized, the date is changed to the RDP system date. For instance, if the system date is 3/10/98 and the statement was finalized on 2/28/98, the "New Activity Ending Statement Date" is 3/10/98. This allows the property to view the current statement during the month without waiting until the end of the month. We do NOT allow them to finalize the statement on 3/10/98, just print and e-mail them. Again, this is ONLY when Single Owner is selected and the "Process Revenue on Calendar Month Only" switch is set to yes.

Owner

When printing a statement for a single owner, once the specific owner is selected, the Owner Number and Owner Name are displayed in these two fields.  To select a different owner, click the Find Owner button and select another owner or type an owner number in the Number field.

Previous Statement

If Single Owner is chosen, the drop-down box has the dates of all previous statements for that owner master. If All Owners is chosen, the statement date can be chosen from the calendar dropdown.

Single Owner Previous Statement Dates

When processing statements for a single owner and Previous Statement is selected, the Single Owner Previous Statement Dates field is populated with the dates of previous statements for that particular owner and allows the user to select one from the drop-down list.

Statement Report and Browse

Click the Browse button to search through folders to locate the appropriate home for the file. The system default is set to access the RDPNT/RDP/Reports10/Owner folder.  RDPWin currently offers several types of owner statement reports.  Statement.rpt offers basic owner statement information and Statement-SharedExspenses.rpt is used when properties and owners share expenses such as common area landscaping, etc.  Hotel Software Property Management System, Motel, Condo, Vacation Rental, Resort and Canadian Statements are handled differently.

Statement Actions

E-mail Tab

Statements can be printed or e-mailed. Select this tab to e-mail statements for the selected owners. This only applies to owners that have e-mail addresses on record.  Statements for owners cannot be printed until owner revenue has been processed.

Cancel

Once "E-mail All Statements" has been activated, a Cancel button appears to allow discontinuation of the action.

E-mail One/All Statement(s)

Click to send the e-mail(s).  The system displays a confirmation when the e-mail(s) have been successfully sent out.  The title of this button is based on the selection above for the Single/All Owner(s) radio button.  If Single, then the button reads "E-mail One Statement" and if All Owners is selected, this button is titled "E-mail All Statements".  When "All Owners" is selected and Print, E-Mail, or Close All Statements is clicked, a Result tab displays the status of the processing.

Select a Previous Report to View

Once emailing has been completed, a Result tab displays the outcome in a grid (similar to the one in Process Owner Revenue).  The system creates an XML report and allows the printing of that report.  To view a previous E-mail report, click the "Select a previous Report to View" down-arrow to select a date/time from the list.  Once chosen, click Display to view that report.  This is NOT available when a single owner is selected. Each individual Print, E-mail, and Finalize tabs has a drop-down box to allow selection.

Statement Report Format

The Crystal Report is attached to the e-mail as either an Adobe PDF file or a Word File.  PDF format is recommended, since it is better protected against changes by the guest.  Crystal Reports are not exported to HTML and/or included in the body of the e-mail because web based E-Mail, like Yahoo and Hotmail, alters the HTML to be unreadable.  If sending a PDF statement, the Adobe website should be referenced (www.Adobe.com) since the PDF Reader may not be installed on all computers.  This is a free download available on all computer platforms.

Additional Attachments

In addition to emailing owner statements, use the new "Additional Attachments" section of the E-mail tab to send multiple attachments to owners within the same email.  Enter the path to the selected document or click the Browse button to navigate to the desired report(s).  Use the Remove button to deselect any additional attachments selected.

Finalize Tab

Statements must be closed at the end of each statement period.  Select this tab to close statements for the selected owners.  The statement always shows all transactions since the last time a statement was closed.  After a statement is closed, no additional corrections can be made to the statement.  Corrections after closing a balance forward statement must be made in the next period.  When a balance forward statement is closed, the system generates a statement marker transaction, which defines the end of one statement and the beginning of the next.  Statement markers appear as a B7D@ transaction code whenever transactions are viewed for the owner. Balance forward statements can be reprinted for any past period from one statement marker to the next.


If statements are not closed, the next statement for the group master will include all activity instead of just new activity.  Even if no corrections were made to the first statement, statements must be re-printed.

When Pay By Direct Deposit is selected on the Owner Detail tab of the owner master, the Finalize tab of Owner Statements displays the Direct Deposit checkbox checked and disabled.

Select a Previous Report to View

Once statements have been finalized, a Result tab displays the outcome in a grid (similar to the one in Process Owner Revenue).  The system creates an XML report and allows the printing of that report.  To view a previous Finalize report, click the "Select a previous Report to View" down-arrow to select a date/time from the list.  Once chosen, click Display to view that report.  This is NOT available when a single owner is selected. Each individual Print, E-mail, and Finalize tabs has a drop-down box to allow selection.

Generate Check for Any Credit Balance

When statements are closed and this checkbox is checked, the system looks at the Generate checks for balance due switch on the owner master.  When both checkboxes are checked and the owner master has a negative balance, a check is generated for the total. If one of the boxes is unchecked, checks are not generated for any master even when there is a negative balance due.  This switch should not be checked in order to hold a balance "on account" for the owner.

Print Check From RDP

Checks are generated by the balance forward statement if the "Statements: Generate check on balance due" box is checked on the Owner Master. If a check is generated, it is placed in the check queue. The check queue is printed through option 80 - Check Maintenance on the RDP Main Functions menu. Check forms can be purchased from the RDP forms department at 1-800-RDP-PAPR (1-800-737-7277).

Review Button

Once all owner statements have been printed BEFORE FINALIZING and reviewed, access the Finalize tab and click the Review button to make sure the reservation information, charges, payments, and statement balances are correct.  The results are displayed in a grid.  Review the amount of the refund checks and the balances prior and after finalization.  Columns available from this grid are Number (owner), Type, Name, Balance Prior to Finalization, Generated Check Amount, Balance After Finalization, Charges Since mm/dd/yy (where the date is the statement date), Current Balance, and Status.  The Results tab is not available when dealing with only one owner.

Finalize One/All Statement(s)

Once statements have been printed, reviewed, and corrected, click Finalize One/All Statements to close the statement.  The system displays a confirmation when statements have been successfully processed.  The title of this button is based on the selection above for the Single Owner checkbox.  If Single, then the button reads "Finalize One Statement".  If Single Owner is unchecked, this button is titled "Finalize All Statements".  When "All Owners" is selected and Print, E-Mail, or Finalize All Statements is clicked, a Result tab displays the status of the processing.

Cancel

Once "Finalize All Statements" has been activated, a Cancel button appears to allow discontinuation of the action.

Print Tab

Once revenue and direct charges have been posted, statements can be printed or e-mailed. Select this tab to print statement for the selected owners or all owners.  Owner Statements cannot be printed until owner revenue has been processed.

Cancel

Once "Print All Statements" has been activated, a Cancel button appears to allow discontinuation of the action.

Printer

If the Print option is checked, the Printer field is enabled.  Select the printer to direct the statements to from the drop-down menu.  If the desired printer is not in the list, see your system administrator.

Exclude Owners w/ Email Address

When checked and "Print All Statements" is clicked, the system prints statements based on parameters set elsewhere on the form, but only for owner masters without a valid email address stored on the master.  Use this feature when the property's first choice is to email statements to all owners with a valid email address and print/mail statements to the remaining owner masters.

Note:  When statements are printed for owners that have a value in the email address field, check the address for validity.  The system knows when an email address is invalid.

Print One/All Statement(s)

Click to print statements for the selected owner(s).  When All Owners is selected and Print, E-Mail, or Close All Statements is clicked, a Result tab displays the status of the processing.

Preview One Statement

Click to display a sample of the selected report in the viewer.  If no owner is selected, the Find screen displays to allow for owner selection.

Preview All Statements

Click to display all owner statements (based on selected owner(s)and statement information) in the Report Viewer (in owner number order).  Use the Previous and Next buttons in the Report Viewer to navigate through the owners one at a time. There is also a Find button to go directly to any owner. Once the Find button is used, the Previous and Next buttons use the displayed owner as the new starting point. A detail button is also available to view all the owner detail (read-only).

The statement can be printed or exported to a PDF file using the standard Crystal Report Viewer buttons in the toolbar while displayed in the Report Viewer.

Select a Previous Report to View

Once printing has been completed, a Result tab displays the outcome in a grid (similar to the one in Process Owner Revenue).  The system creates an XML report and allows the printing of that report.  To view a previous Print report, click the "Select a previous Report to View" down-arrow to select a date/time from the list.  Once chosen, click Display to view that report.  This is NOT available when a single owner is selected. Each individual Print, E-mail, and Finalize tabs has a drop-down box to allow selection.

 

After the balance forward statement is printed, review it carefully.  There are many possible errors that may have occurred and need to be corrected before printing the final copy of the statement for the customer.  Possible errors include:
 

1. Incorrect format.  For example, the text "YOUR COMPANY NAME HERE" may still appear on the form.  The statement forms must be modified with the report writer prior to printing.
2. Incorrect ending statement date (causing some new transactions not to appear).
3. Missing transactions because of incorrect use of the "*" no-print flag.
4. Extra transactions because they were not marked as "no-print".
5. Missing transactions because they were not posted.
6. Missing payments because they were not posted.

Once printed, reviewed, and correct, statements must be closed or the next statement will include all activity instead of just new activity.  Even if no corrections were made to the first statement, statements must be re-printed.

Result Tab

When printing, e-mailing, or closing all statements, the Result tab appears and displays the status of each record.  Fields in the grid are Owner Number, Type, Name, Balance Due, and Status.  Totals are also displayed.  While the records are being processed, a status bar is displayed in the bottom left corner of the form.  It displays the percentage of statements processed until complete.  Once the action is complete, the status bar disappears.  The system displays a Status notification including the date of the statements processed and how many records were printed, e-mailed, or closed.
 

Email Results Sample Screen


Finalize Results Sample Screen

View Transactions

If no owner is selected when this button is accessed, the Find Owner screen opens. Once an owner is selected, the Transactions form opens to allow for viewing transactions and, if necessary, posting charges.  For more information, see Post Charges to Owners.

Calculation of Net Owner Amount

The system calculates the net owner amount on a given folio transaction as follows:

1. First, the system attaches the transaction to the folio and recalculates the total balance due on the folio. The transaction increments either the Room Charge (Bucket 0), Other Charge-1 (Bucket 1), or Other Charge-2 (Bucket 2) fields on the folio based on the "bucket number" assigned to the transaction.
2. The system next looks at the room number on the folio. The system checks the Owner Billing checkbox on the Room Master/Room Detail tab to see if the room is owned. If the Owner Billing field is checked, the system continues to the next step. If Owner Billing field is not checked, there will never be an owner payment on any folio for that room number even if the room is assigned an owner.
3. The system looks at the owner Pay Code assigned to the folio. The Pay Code appears on the Owner tab of the Reservation Details.
   
   Figure 1 - In this example, the folio is in Room Number 104 with an Owner Pay Code of OA (Default Owner Rates).
   
   
   Figure 2 - The total of all transactions already posted to this folio is $556.56.  (The final $94.16 transaction is pre-posted, however that column is not displayed here.)
    

Owner payment codes are defined in table C7 and assigned to room masters. Each reservation uses the owner payment code assigned to the room master as a default, but allows an override on a reservation-by-reservation basis. In this example, assume that owner payment code OA has been defined as: OA - 65, 0, 0, signifying that the owner receives 65% of room revenue (Bucket 0), and 0% of incidentals (Buckets 1 & 2).

The system then multiplies the owner payment code percentage for the transaction bucket times the amount of the transaction. In this example, the B200 transaction was for $408 for bucket zero (the Room Charge field) without tax. Since the owner payment code of OA for bucket 0 is 65%, the owner portion for this transaction is calculated as:

As shown in Figure 1 above, three nights at $80, two nights at $84 totaling $408 in posted room charges.  Taxes and pre-posted charges are not considered when figuring the Owner Amount.  The equation is calculated as $408 X 65% = $265.20 (the Owner Amount as shown in Figure 1 above.)

Hawaiian Statements

When Include Tax in Gross Revenue (B7DF) Reported to Owners (C1HAWAII) checkbox is checked in Owner Configuration, owners can be selected to pay the room revenue taxes to the taxing authority (as opposed to the management company paying the tax).  Not all owners are responsible for paying the tax on an owner-by-owner basis.  Use either the Statement-SharedExpensesHawaiiTax.rpt or the Statement-SharedExpensesHawaiiTax-Hide.rpt.  Whether the property or the owner is responsible for paying the taxes is the determining factor for which report to select.

Shared Expenses for Canadian Owners

When Include GST Tax in Gross Revenue (B7DF) Reported to Owners is checked in Owner Configuration, the GST (Goods and Services Tax) feature for Canadian customers is active and properties can selectively allow the passing the GST on a rental to the owner as well as adding GST on services/charges done by the property management company on the owner’s property on an owner-by-owner basis.
 

The tax information is calculated and included in the statement using RDPNT/RDP\Reports10\Owner\Statement-SharedExpenseCanadaTax.rpt in the following manner:

    Gross Revenue
    - Mgmt fee
    - Travel Agent Fee (optional)
    - Credit Card Fee (optional)
    = Owner Net

    + Total Tax (GST on the Gross Revenue)
    - Mgmt Tax (Mgmt portion of GST)

    = Owner's Final Statement Amount

The total for the owner is then the normal gross – mgmt fee and the extra GST-Mgmt GST. All other owner shared charges (TA Fee, Credit Card fee, etc.) work the same since the GST is calculated on the gross room revenue. The owner ends up sending the net GST (Total – Mgmt Portion) to the government and the property management company sends their portion of the GST to the government.

If the Owner Pays GST check box is not checked, the owner statement for that particular owner will not show the Total Tax and Mgmt Tax columns at all.

The GST is stored on the B7DF and B7DG codes. When the Generate Totals option is used, these taxes will be totaled to the tax 1 or tax 2 account in table B0 depending on the C1GST2 switch setting (No = Tax 1, Yes = Tax 2).

Steps

1. Select either one owner or all owners.
2. Select "New activity since last statement" radio button.
3. Decide on whether to include owners with no activity and check box if applicable
4. Decide on whether or not to print statements for N/R and Old owners with no activity and/or zero balance.
5. Verify the "Ending Activity Statement Date".
6. Confirm the correct owner statement report is selected.
7. Click "Print All Statements" to print hard copies of the statements for review or click "Preview All Statements" to process and view all statements on the computer screen.  Printing review statements can take a while.  Confirm the printer is not needed for the next 10 minutes or so.
8. Review all statements for accuracy.
9. Make any necessary changes by manually post charges to the owner for the month of the statement.
10. Finalize Statements.


1. Select Finalize tab under Statement Actions.
2. Check "Generate Check if Balance Due".
3. Check "Place Check in Print Queue".
4. Click Review.
5. Verify all information.
11. Click "Finalize All Statements".  Statements cannot be reopened to make changes once finalized.
12. Determine how owners are to receive statements:  e-mail or printed statements via regular mail.
    Email
    
    
    
    1. Select Statement Report Format (PDF or Word attachment).
    2. Enter any carbon copy e-mail addresses (CC).
    3. Complete the Subject and Body Text fields. 
    4. Select any additional attachments necessary.
    5. Select E-mail All Statements.
    6. Result are displayed in case of e-mail failure.
    Print
    1. Select Owner Statements to print one or all statements.
    2. Select the Previous Statement radio button.
    3. Select Statement Date.
    4. Select Print under statement actions.
    5. Select Print all statements.
13. Navigate to the Accounting menu and select Check Vouchers.
    
    
    1. Change Master type to Owner.
    2. Change voucher status to "Will print".
    3. Click Display.
    4. Verify the checks displayed are the checks desired.  To disallow the printing of any check in the list, change the status.
    5. Under Print Check, select the Print Test Check radio button.
    
    
    1. Load check into the printer.
    2. Enter a starting check number.
    3. Click Print.
    4. Verify the checks are aligned correctly.
    6. Select the Print Check radio button.

Tutorials

For more information, click Print a New Statement or Print a Previous Statement.

Save & Close, Save, and Close

Click here for instruction on how to Save and Close forms.

 
 

Click these links for Frequently Asked Questions or Troubleshooting assistance.

Last Updated 11/10/2008

---

© 1983-2004 Resort Data Processing, Inc. All rights reserved.