Financials Reports

Cashier Audit (finpayments) - displays all payments that have been posted for the selected business date.

Cashier Shift Bag Report (cashier_shift_bag_bi) - displays the Payment Type (such as Cash and Others), Bag Number, Cashier Name, Cashier ID, Date, and Shift Drop Location. The report can be filtered by Date From and Date To (only for the current and past dates), Cashier ID, and Payments (Cash and Others).

Check Ledgers (check_ledgers) - displays all check ledgers for the selected business date.

Comp Open Balance (comp_open_balance) — sums and accounts for the total open balance of all charges posted to comp windows or comp transaction codes that are not yet settled, for reporting revenue accurately.

Corrections and Cancelled Payment (fincorrectionscalpay) - displays all corrections by cashier ID and can be run by transaction code range. This journal displays all same-day reversals (debits) made to posting slips. Adjustments are made to previous days postings, or claimed revenue.  

Credit Card Rebates (creditcard_rebates) - displays credit card rebate overrides. The date, time, name of the credit card holder, folio number, credit card type, credit card number, amount, override (Y/N), and the cashier who entered the rebate.

Credit Cards Report (check_rep) — displays a report of credit card usage for the selected date.

Currency Exchange Summary (curr_exch_sum) - displays the amount of monies exchanged for the selected date per currency code.

Deposit Ledger (deposit_ledger) - used by the accounting department to determine how much deposit revenue has been posted in the hotel for the date specified.

 Detailed Folio Report (Poland) (folio_details) - developed to meet reporting requirements for properties in Poland.  The intent is to display all amounts posted to a guest folio for the specified date.  A summary of all folios generated.

 Effective Package Allowance (effpkgallowance) - provides a summarized list of all packages that are in use for the current business date. It provides a detailed breakdown of all package charges, including the allowance balance as compared to the actual package debits and credits.

Effective Package Allowance Trial Balance (effpkgallowance) - provides a summarized list of all packages for which the package wrapper has been posted for the current/past business date while the reservation is/was in-house.  

Financial Payment and Revenue (findeptcodes)- displays a sum of all transactions posted for the date specified.

Financial Transaction Summary (fintrxsummary) — provides a summary of all financial transactions for a specified date range, grouped by transaction code, transaction date, transaction group, or transaction subgroup.

Financial Transactions by Block (finjrnl_blk) - allows the property to see the revenues, taxes, and package credits generated by specific blocks and transaction codes.

Financial Transactions by Folio Number (finjrnlbytrans3) — lists transactions per folio created by the selected workstations during the report timeframe. The report shows only transactions that would have been visible on the folio and billing screen and omits internal transactions.

Financial Transactions by Tax Type (finjrnlbytax) - displays each transaction posted for the dates selected.  This report is different from other financial transaction reports in that it is intended to display the taxes posted.  The output groups results by tax transaction codes. If any postings do not have a tax transaction code attached, they are grouped together under a “no tax” heading.

Financial Transactions with Generates (finjrnlbytrans2) - lists each transaction code and the corresponding amounts for the dates specified. Also included is a breakdown of the taxes and package credits attached to each transaction code posted and the user that posted each transaction.  

Folio Tax Revenue (foliotax_revenue) - displays the total of all charges posted to a guest on a particular date. If charges were routed and paid for by another guest, the other guest’s total reflects these charges.

Folio Tax - Style 01 (foliotax_01) - developed to meet reporting requirements for properties in Spain to display the breakdown of VAT Tax that was posted on each reservation for a specified date range.

Folio Tax - Style 02 (foliotax_02.rdf) - developed to meet reporting requirements for properties in Poland. The report displays a breakdown of VAT Tax that was posted on each reservation for a specified date range. To save paper, the report prints only those tax groups (1 to 10) that were used in the requested time frame.

Folio Tax - Style 03 (foliotax_03.rdf) - developed to meet reporting requirements for properties in Portugal. The report displays a breakdown of VAT Tax that was posted on each reservation for a specified date range.

Folio Tax - Style 04 (foliotax_04) - developed to meet reporting requirements for properties in Turkey. The report displays a breakdown of VAT Taxes that were used on each reservation for a specified date range.

Folio Tax - Style 05 (foliotax_05) - developed to meet reporting requirements for properties in India. The report displays a breakdown of Luxury Taxes that were used on each reservation for a specified date range.

Guest Balance Snapshot (guest_balance_snapshot) — provides a summarized snapshot of all current guest balances.

Guest Ledger (guest_ledger) - displays the current balance associated with in-house guests for today.

Guest Trial Balance (gl_trial_balance) - displays all guests in-house and their folio balances for a specific date equal to or less than the current business date.

Invoices of Today's Check Outs by Bill Number (fininvtodaycobybill) - displays all guests who have checked out today by billing/invoice number.

Italian Folio Tax (istat/istat_monthly) - prints statistical information for all bills and is formatted based on the style of the report selected. The report output is grouped by folio types and displays the net, VAT and gross revenue for all bills generated in the property.

Journal by Cashier and Article Code (finjrnl_articles) - displays one line for each posted article for the selected date. Similar to other financial reports, this allows you to see when, to whom, and who posted an article to a reservation or an accounts receivable account.

Journal by Cashier and Transaction Code (finjrnlbytrans) — provides a detailed summary of transactions for a specified date range, grouped by cashier, check number, room number, or transaction code.

Journal by Foreign Currency (finjrnlbyforcurr) - displays all postings for today that were posted in a currency not equal to the property’ base currency.

Lodging Tax Exempt (lodging_tax_exempt) — displays details and summary information about tax exempt revenue for a specified date range.

Open Balances: All (finopbalall) - displays the current balance on reservations or blocks. This includes advance deposits.

Package Ledger Balance (pkgledger_balance) — lists all postings made to the package ledger and runs during the night audit sequence. This report displays total credits and offsetting debits, as well as profit and loss on all packages. Print this report to analyze whether or not hotel packages are making or losing revenue. This detailed report corresponds to the summarized package ledger portion of the trial balance.

Package Ledger Detail (effpkgledgerdtl) — detailed breakdown of all package charges for each room. The report includes all package postings for the current business date. As a cross reference, if the guest has checked out, the debit column will be equal to the credit column. Print this report to obtain a list of internal department charge-back totals.

Package Option (package_option) — displays the guest name, room number, arrival and departure dates, rate code, package name, description, date posted, allowance, posted amount, and overage.

Package Postings (finpkgposting) - displays all posted charges that have been associated with a package. This report provides users with summary information about package postings and serves as an audit trail on cashiers and transaction codes.

Paid Outs (finpaidout) - displays all the paid-out transactions of the day to guests and is generated during the night audit sequence.

Payment Tax Invoices (fin_payment_tax) - developed to comply with legal requirements in Thailand. When generating a payment receipt, the sample_payment_tax must be configured and used.

Room Revenue by Tax (tax_type_details) - displays the amount of room revenue generated within each tax type for a reservation.

Tax Exempt (taxexempt_02) - gives a detailed daily breakdown of room revenue and the taxes that each specific guest is exempt from.

Tax Report (tax_report) - contains the total amounts posted to a company/travel agent/source/group profile. The report output displays the sequence number, tax number, net amount and tax amount posted to a company, travel agents, source, or group profiles.

Trial Balance (trial_balance) - displays a summarized financial status of the property for a specific date. The data displayed includes all transactions posted, and then a breakdown of business within each of the five ledgers. The ledgers are guest, accounts receivable, deposit, package and inter hotel.

Userlog Transfers (finuserlogtransfers) - displays all folios that have been transferred to another guest or account for a specific date or range of dates.

Userlog Transfers Today (nauserlogtodaycheckout) — displays all folios that have been transferred to another guest or account for the current business date.