Secondary Lines

Secondary Line Types

Note: Prior balance cells represent the previous day's end balance. The End Balance is the balance at the end of today.

Accounts Receivable

This line denotes how much gross revenue is in accounts receivable, and is used when you have charges, payments and adjustments to enter.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Prior Balance

 

 

 

 

Payments

 

 

 

X

End Balance

Prior Balance + Charges - Payments - Adjustment

X

 

 

Charges

 

 

 

X

Adjustment

 

 

 

X


Allowable children:

  • Accounts Receivable
  • A/R No Adjustment
  • A/R Ending Balance Only
  • Credit Cards
  • Credit Cards 1

Accounts Receivable Ending Balance Only

This line is used to enter the ending balance for an accounts receivable line, for that day. Use this line when you only have an end balance to enter.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Prior Balance

 

 

 

 

Charges

 

 

 

 

End Balance

 

X

 

X

Allowable children:

  • A/R End Balance Only

Accounts Receivable No Adjustment

This line denotes how much revenue, without any adjustments, is in accounts receivable line, and is used when you only have charges and payments to enter.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Prior Balance

 

 

 

 

Payments

 

 

 

X

Charges

 

 

 

X

End Balance

Prior Balance + Charges - Payments

X

 

 

Allowable Children:

  • AR No Adjustment
  • A/R Ending Balance Only

Adjustments

This line is used to display any adjustments that were made to the revenue. For example, you credit a portion of the room rate due to a housekeeping problem.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Gross

 

 

 

X

Net

Net = Gross*

X

 

 

*Amounts for Gross are manually entered and automatically copied into the Net column.

Allowable children:

  • Adjustments


Cash

This line is used to determine how much cash was collected.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

System Cash

 

 

 

X

Cash Out

 

X

 

X

Net Cash

System Cash - Cash Out

 

 

 

Cash Deposit

 

X

 

X

Over/Short

Cash Deposit - Net Cash

X

 

 

Allowable children:

  • Cash
    • Cash Out

Cash Out

This line is used to determine how much cash was dispersed. For example, a guest loses money in the candy machine and you give them a cash refund.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Cash Out

 

X

 

X

Allowable children:

  • Cash Out

Credit Cards

This line denotes how much revenue was taken in via credit cards for those credit card companies that do not pay on the same day, which means that Payments may not equal Charges.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Prior Balance

 

 

 

 

Charges

 

 

 

X

Payments

 

X

 

X

End Balance

Prior Balance + Charges - Payments

X

 

 

Allowable children:

  • Credit Cards
  • Credit Card 1

Credit Cards 1

This line denotes how much revenue was taken in via credit cards for those credit card companies that pay on the same day, resulting in Payments equaling Charges. Prior Balance and Ending Balance will always be 0.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Charges

 

 

 

X

Payments

Payments = Charges*

 

 

X

End Balance

Prior Balance + Charges - Payments

 

 

 

Prior Balance

 

 

 

 

*Amounts for Charges are manually entered and automatically copied into the Payments column.

Allowable children:

  • Credit Cards
  • Credit Cards 1

Custom Write-Offs (Funds)

This line is used for general write-offs, other than F&B.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Payments X X

Allowable children:

  • Custom Write-Offs

Decimal Statistic

This line is used to track data that the user wishes to track. These lines have decimals.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Amounts

 

X

X

X

Allowable children:

  • Amounts

F&B Write-Offs (Miscellaneous Lines)

This line is used to track F&B write-offs.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Revenue

 

X

 

 

Cash Out

 

 

 

 

Cost of Goods

Revenue X COG%

X

 

 

Tax

 

X

 

 

Total Ticket

Revenue + Tax + Tip

 

 

 

Expensed

COG + Tip

 

 

 

Allowable children:

  • None. However, these lines do have details which are entered in the Reconcile screen (See About F&B Write-Off Lines in the Using Revenue manual.

Funds Miscellaneous (Miscellaneous Lines)

This line is used to track miscellaneous dollars received.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Payments

 

 

 

 

Allowable children:

  • None

Integer Statistic

This line is used to track data that the user wishes to track. These lines do not have decimals.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Units

 

X

X

X

Allowable children:

  • Statistics

Log Number Rooms (Miscellaneous Lines)

This line is used to track the number of rooms that are used but not paid for, such as Comp Rooms.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Units

 

X

X

X

Allowable children:

  • None. However, these lines do have details which are entered in the Reconcile screen.)

Log Room Number (Miscellaneous Lines)

This line is used to identify which rooms were used but not paid for.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Units

 

X

X

X

Allowable children:

  • None. However, these lines do have details which are entered in the Reconcile screen.)

Market Mix

This line is used to track market mix data. This data does not count toward receipts.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Gross

 

X

X

X

Units

 

X

X

X

$/Unit

Gross / Units

 

 

 

Accounts:

  • Gross
  • Units
  • $/Unit

Allowable children:

  • Market Mix

Revenue Market Mix

This line is used to track Market Mix data. This data counts toward receipts.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Gross

 

 

 

X

Net

Net = Gross*

X

 

 

Units

 

X

X

X

$/Units

Net / Units

 

 

 

*Amounts for Gross are manually entered and automatically copied into the Net column.

Allowable children:

  • Revenue Market Mix

Revenue Miscellaneous (Miscellaneous Lines)

This line is used to track revenue from miscellaneous sources.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Gross

 

 

 

 

Net

Net = Gross

 

 

 

Tax

 

X

 

X

*Amounts for Gross are manually entered and automatically copied into the Net column.

Allowable children:

  • None. However, these lines do have details which are entered in the Reconcile screen.

Revenue Taxable

This line is used to display how much tax is owned on all revenue brought in.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Gross

 

X

 

X

Net

Gross - Adjustment

X

 

 

Adjustment

 

X

 

X

Tax

 

X

 

X

Allowable children:

  • Revenue Taxable
  • Revenue Miscellaneous

Revenue Units

This line is used to determine how much revenue was made per unit.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Gross

 

X

 

X

Adjustment

 

X

 

X

Net

Gross - Adjustment

X

 

 

Tax

 

X

 

X

Units

 

X

X

X

$/Units

Net / Units

 

 

 

Allowable children:

  • Adjustments
  • Revenue Market Mix
  • Revenue Units
  • Revenue Taxable
  • Tax
  • Revenue Miscellaneous

Tax

This line is used to determine how much tax is owed on money brought in.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Tax

 

X

X

X

Allowable children:

  • Tax

Vacant Rooms

This line is used to calculate unoccupied rooms in the property. Note: There must be a line somewhere in the structure that is configured with the code TTL_

RMS

(Total Rooms Occupied) in order for this line to calculate correctly.

Line Type Cell Structure:

Cell

Formula

Can Have Acct.

Can Have Offset Acct.

Can Have Interface Mappings

Units

Available Rooms - Total Rooms Occupied

X

X

 

Allowable children:

  • None