The Unpaid Charges Report is a CSV export listing all charges that have no receipt allocated against them within a selected date range.
Overview
The Unpaid Charges Report is a .csv export of all Charge Transactions that do not have a Receipt Allocation for the selected date range. Charge Transactions include Rates and Sundry Charges.
Receipt Allocation is the automatic background process of allocating payment to unpaid charges on an account. The Receipt Amount is used to allocate payment to the unpaid portion of any charges on the account and bring it into balance.
If there are no charges on the account or the Receipt Amount is greater than the total unpaid charges amount on the account the un-allocated portion of the Receipt will become part of the Suspense Receipt Amount.
Suspense Receipt Amounts demonstrate the movements of additional funds that are not yet allocated to a charge anywhere in RMS including Deposits or overpayments.
Future dated Receipts will not be allocated to the Charge Transaction until that date arrives.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.
How to Access
In the side menu of RMS, go to Reports > Accounting > Unpaid Charges.
- Select the Date Range.
- Select the General Ledger Account Codes.
Select the Sort By option. - Select Export to CSV.
Report Options
Tip! Report build screens default to a common use configuration, and selections can be made as required.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Transactions Posted Between | Date range | Yesterday | The date range for the charge transactions included in the export, based on their Posting Date. |
| Sort By | Dropdown | (default) | Sets the order in which the exported rows are sorted. |
| Property | Multi-select | All | For Enterprise (multi-property) databases. Limits the export to the selected properties. |
| GL Code | Multi-select | All | Limits the export to charges allocated to the selected General Ledger Account Codes. |
Column Headers
The Unpaid Charges Report .csv export includes the following information:
| Column | Description |
|---|---|
| Property | The Property associated to the Account the Charge Transaction was created on. |
| Posting Date | The Accounting Date applicable to the Charge Transaction created on the Account in RMS. |
| Created Date | The System Date the Charge Transaction is placed onto the Account in RMS. |
| Trans No | The unique Transaction Number identifying the Charge Transaction throughout RMS. |
| Res No | The Reservation Number associated to the Account the Charge Transaction was created on. |
| Account No | The Account Number the Charge Transaction was created on. |
| Area | The Area assigned to the Reservation associated to the Account the Charge Transaction was created on. |
| Name | The Guest Name associated to the Account the Charge Transaction was created on. |
| Transaction Description | The description of the Charge Transaction as shown on the Account. |
| GL Code | The General Ledger Account Code the Charge Transaction is allocated to. |
| GL Code Description | The description of the General Ledger Account Code the Charge Transaction is allocated to. |
| Remaining Debit | The value of the Charge Transaction where no Receipt Allocation exists. |
Related Reports
- In House Guest Balance Report - outstanding balances for in-house reservations.
- Debtors Ledger Report - account balances owed by debtors.
- Cash Transaction Report - receipts and payments posted in a period.
Related Articles
Comments
0 comments
Please sign in to leave a comment.