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