Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.kwentra.com/llms.txt

Use this file to discover all available pages before exploring further.

Report Business Value:

Balance Sheet is the financial statement of a hotel that includes assets, liabilities, equity capital at a point in time.

Balance sheet includes assets in one tab, and liabilities on another tab.

For the balance sheet to reflect the true picture, both heads (liabilities & assets) should be equal (Assets = Liabilities + Equity).

A balance sheet is more like a snapshot of the financial position of a hotel at a specified time, usually calculated after every quarter, six months or one year.

Before you run the Balance Sheet Report, you need to make sure of the following points:
  1. All your Journal Vouchers are reviewed and posted properly.
  2. All your transfers & usages are reviewed and submitted.
  3. All your receiving orders are reviewed and submitted.
How it works? Reports → BO → GL → Balance Sheet
  1. Select the month you would like to run the balance sheet for.
  2. Optional: choose whether to show the accounts with zero balance or no.
  3. Optional: choose to present last year’s numbers for comparison purposes.
  4. Choose the Export option you desire i.e., Excel “XLS / XLSX / ODS” or PDF.
Report Column Outcome: This report is divided into 2 tabs, the first one is for assets the other is for liabilities & equity. Assets Tab: Asset accounts are grouped as per the group they are under in your chart of accounts i.e. Fixed assets, current assets, stores etc. At the end of each Accounts Group is the total for all accounts under it.
  • First Column: reflects all accounts from your chart of accounts with the type Assets.
  • Current: Shows the balance of each account for the month you are running the report on.
  • YTD: shows the balance of each account from the start of the year till the month you are running the report on.
At the end of the table, there will be a total to sum up Total Assets. Liabilities Tab: Liabilities and Equity accounts are grouped according to the group they fall under in your chart of accounts, i.e., Taxes, Trade Payable, etc. At the end of each Accounts Group is the total for all accounts under it.
  • First Column: Reflects all accounts for your chart of accounts, categorized by types of Liabilities & Equity.
  • Current: Shows the balance of each account for the month you are running the report on.
  • YTD: shows the balance of each account from the start of the year till the month you are running the report on.
At the end of the table, there will be a total for summing up Total Liabilities. N.B.: The default currency for this report would follow the base currency of your system; currency conversion would happen automatically if needed.

Update: 21st of August, 2025

View your balance sheet using either the Georgian or Hijri calendar, with date and period calculations fully aligned.

How It Works

  • A new Calendar parameter appears if Hijri support is enabled for your instance.
  • Calendar:
    • Dropdown menu with: • Georgian (ميلادي) • Hijri (هجري)
  • Date Parameter:
    • Month chooser works with the selected calendar, allowing you to pick the month based on either calendar.
  • Calculations:
    • All period-based calculations (“Current” = closing balance for the selected month - previous month) are performed using the calendar you selected.
    • If you select “Hijri”, all cut-off dates, months, and periods use Hijri logic.

Example

  • If you select August 1447 in the Hijri calendar, the report compares balances between this month and the previous Hijri month for all main accounts.
  • The “Current” column will be calculated as: Closing Balance (Hijri August 1447) - Closing Balance (Hijri July 1447)