If your email says this below, please see instructions attached:



The DSTAT Income Audit was attempted for 'Test Hotel ZZ999' for##/##/2018 with the following result:


There is a non-zero Balance Check in Section # on ##/##/18.

You will need to access DSTAT to fix the Out-Of-Balance.
This must be fixed in DSTAT so that data will be complete and balanced.



Please review the instructions below on correcting this issue or you may open a ticket by sending an email to support@ciasoft.com .



There are several reasons for that would cause DSTAT Sections to be out of balance. The primary TAB's in DSTAT are:


Section 1 = Room Statistics

Section 2 = Room Revenue

Section 3 = Transactions


Possible Out of Balance issues by Section:


Section 1 Room Statistics - It is not very common that Section 1 is out of balance on its own, but if both Section 1 & 2 are both out of balance it is usually a sign that there is a Rate Plan that has not been mapped to its proper Market Segment, if this is the case see "There are Rate Plans in the PMS that are not mapped to Market Segments"


Section 2 Room Revenue - As noted above if both Section 2 and Section 1 are out of balance see link above.

    Other possibilities:

  1.  There was a misposting with respect to complimentary rooms.  If the user added a rate code to the reservation but neglected to zero out the rate, there is a possibility that the Comp room ran with a rate attached.  See Images below, this image shows the amounts in the "For Out of Balance  Reference Only" section at the bottom by the "Balance Check" and that the JE Total = -79.00 (see bottom left of image below)


    If the revenue is correct and was not supposed to be classified as Comp, you can make an adjustment in the center column above, placing it in the proper Market Segment.  If the revenue is an overstatement and should not have been posted, you will want to make an adjustment in the center column above, placing it into a Market Segment, then make the correction in PMS to reverse the overstatement.  If you leave it Out of Balance, you will not be able to generate a balanced Journal entry. (See example below).
  2. If NoShow is posted using the "RM" transaction code, instead of the "NS" co, it will create an out of balance situation.  These images shows the amounts in the "For Out of Balance  Reference Only" section at the bottom by the "Balance Check" and that the JE Total = -25.00 (see bottom left of image below).  To correct this, go to the Transaction section, using the Adjustment Column, credit the Room Revenue "RM" transaction and move it to the NoShow "NS" transaction code, this will balance the Room Revenue Section (See image on the Right).
    Section 3 Transaction - The most common cause of an Out of Balance in the Transactions Section is the use of or the addition of a new Transaction Code.  In this case or of there is another cause that is not apparent, please email Support@ciasoft.com and we can add it to you setup or assist in finding the issue.