Hotel360 Hotel360User Guide

Financial Reports

Introduction

Financial Reports is one page with seven tabs. Together they answer the questions an owner or accountant asks every day: who sold what, how much was billed, how much money actually came in, who cleared it, who still owes us, and what profit was made. Every report is read-only. Nothing you do here changes a bill or a payment.

Opening the Reports

  1. Open Reports > Financial Reports in the side menu.
  2. Pick a tab: Daily Sales, Sales & Collections, Cashier Collections, Outstanding Bills, Receivables, Profit & Loss or Accommodation. The page opens on Daily Sales.
  3. Set the dates (and the department, where the tab has one). The figures update by themselves a moment after you change a field.

Note

You need the See all reports permission. Without it the Reports group does not show Financial Reports. Ask your administrator (see Users, Roles and Settings).

How Dates and Business Days Work

Most tabs have From Date, From Time, To Date and To Time. When you open a tab, both dates start on today's business date.

Plain calendar days. If your business has not set a day rollover, a day runs from 00:00 to 23:59. From Time and To Time let you narrow the window, for example 18:00 to 23:59 for the evening shift.

Business days with a rollover. A bar or restaurant that trades past midnight does not want the 1 a.m. sales to land on the next day. If a rollover time has been set, every report uses it as the edge of the day:

Rollover The report for the 9th covers
00:00 (none) 9th 00:00 to 9th 23:59
04:00 9th 04:00 to 10th 03:59
23:59 8th 23:59 to 9th 23:58

A rollover before midday closes the previous day's trade. A rollover from midday onward (for example the 23:59 an automatic End of Day runs at) closes the same day, so the day is counted back from it.

Warning

When a rollover is in force, From Time and To Time are ignored. The boxes stay on screen but the day always runs from one rollover to the next. Do not expect a 6 p.m. filter to work then.

  • A bill belongs to the day it was created, not the day it was paid. A bill rung up on Monday and paid on Tuesday is Monday's sale and Tuesday's collection.
  • "Today" is the business date. At 02:30 with a 04:00 rollover, "today" is still yesterday's date, so a report you open then shows the day still in progress.
  • The rollover is read for the department you are currently working in. Reports that mix departments (Sales & Collections, for example) still use that one department's rollover.

Setting the Day Rollover

The rollover comes from your End of Day set-up, in this order:

  1. A rollover saved when someone closed a day by hand on Reports > Stock Reports > End of Day (see Stock Reports). This is per department.
  2. Otherwise, the time under Automatic End of Day in the general settings, when Automatically close End of Day is switched on. This is either one shared time or one time per department.
  3. Otherwise, midnight.

Warning

On the End of Day screen the Day rolls over at box starts at the rollover now in force (the saved one, else the automatic End of Day time, else 00:00). Closing a day without touching it changes nothing. Only a time you type there is saved as a manual rollover for the department.

Daily Sales

Who sold what. One row per staff member who raised bills in the period.

Filters: From Date, From Time, To Date, To Time and Department (all departments by default).

Column Meaning
Staff The person who raised the bill. Bills with no staff show as "Unknown".
Total Bills How many bills they raised.
Gross Sales (Ksh) The total of those bills.
Comp (Ksh) The value given away as complimentary. Shows a dash when none.
Net Sales (Ksh) Gross less comp.

Below the table, Summary Totals shows Total Bills, Gross Sales, Complimentary, Net Sales and, when there is any, Inclusive (Room).

How the figures are worked out:

  • A sale is a bill raised in the period, whether or not it has been paid. Cancelled bills never count.
  • Complimentary is the sum of the bill's receipts paid as complimentary. A bill that was part-paid and then comped for the rest counts only the comped part.
  • Inclusive (Room) is food or drinks that were already paid for in a room package. They were billed but not charged at the till.
  • Net = Gross − Complimentary − Inclusive (Room). The Net Sales column in the table subtracts only comps. The inclusive amount is taken off in the Summary Totals.
  • Amounts are shown in whole shillings.

To see what one person sold, click ⋯ > View Details on their row. The Staff Sales Details window lists each item with Quantity, Price (Ksh) and Total (Ksh), and a Grand Total. ⋯ > Print Receipt (or Print Report in the window) sends a short sales slip to the bill printer of the computer you are using.

If no bill printer is set for your computer in your department, you see "No bill printer configured for this computer." When it works you see "Staff sales report sent to printer".

Note

Bills on hold count as sales in Daily Sales, Sales & Collections and Outstanding Bills alike. Only cancelled bills are left out everywhere.

Sales & Collections

The master tie-out. It sets what was billed in the period (sales) against what was received in the period (collections), by department and by payment mode. It covers POS bills, service orders, accommodation (lodge) bookings and corporate account payments. Filters are the same four date and time boxes. There is no department filter, because the table already splits by department.

End of Day Status

At the top, End of Day status (as of …) lists every department as closed (with the time) or open. The badge reads All departments closed, or Some days still open — figures provisional. A department counts as closed when a stock closure exists for the date at the end of your range. See Stock Reports.

Note

With an early-morning rollover the end of your range falls on the next calendar date. The badge still checks the business day your range ends in, using each department's own rollover.

Reading the Reconciliation

The Collections Reconciliation box is a small sum that has to balance:

Line What it is
Opening outstanding (before period) Everything billed before your start time, less everything collected before it. In plain words: what customers still owed when the period began.
+ Sales billed this period Total sales in the period.
− Collections this period All money received in the period.
↳ for this period's bills Part of that money that paid bills raised inside the period.
↳ settling earlier days' bills Part that paid bills raised before the period began.
= Closing outstanding Opening + sales − collections.

So collections = this period's bills + earlier days' bills. Money that settles an old bill is counted here as a collection, never as a new sale. That is why collections on a quiet day can be bigger than sales.

Lodge deposits. When the period has deposit activity, a note under the box shows the deposit cash received (already inside collections), the value of nights charged against deposits (already inside sales), and any Unused deposit refunded (taken off collections). A guest's deposit is cash today but is only earned as sales night by night, so the two figures differ. See Payments, Deposits and Checkout.

The Department Table

One row per department, plus Accommodation (Lodge) and any corporate account that paid with nothing billed yet. The columns are:

  • Sales (Ksh): bills, service orders and bookings created in the period, less anything given away as complimentary. Cancelled bills are left out; bills on hold are counted. A lodge booking counts its whole total on the day it was created. A deposit booking is counted night by night instead.
  • One column per payment mode used (Cash, M-Pesa, Card, Account, Bank and so on). The names are tidied, so "mpesa" and "M-Pesa" are one column.
  • Total Collected: all money received in the period for that department.
  • Prior-day Settled: the part of Total Collected that paid bills created before the period began. Shown in an amber badge.
  • Outstanding: Sales less the part collected for this period's own bills. It is what is still unpaid from this period.

The totals under the table show Total Sales, Total Collected, This period's bills, Prior-day settled and Outstanding (period).

  • Complimentary is never money. It is taken off the department's sales and never appears as a collection or a payment-mode column.
  • Corporate account payments are counted once, as a payment spread across the departments of the bills they settle. The original charges were already counted as sales when they were raised.
  • Inclusive (Room) settlements appear as their own payment mode.

Expenses and Cash in the Till

Expenses Paid Out lists expenses by category and payment mode, with the total in red. Only expenses that are marked paid count, matched on their paid date. An expense that has only been recorded and not yet paid has not left the till, so it is not here. See Expenses.

The three boxes at the bottom work out the drawer:

  • Cash collected: the Cash column total.
  • − Cash expenses: expenses paid in cash.
  • = Expected cash in till: the difference. Card, M-Pesa and other modes do not touch the physical drawer, so they are not in this sum.

Cashier Collections

Till reconciliation. Each row is a cashier. Each column is a payment mode. Use it to check that what a cashier says they took in matches what the system recorded against their name.

Filters: the four date and time boxes, and Department. The department list also has Accommodation (Lodge) and Account Settlements, so you can look at one source alone.

  • The cashier is the person who cleared the payment, not the person who raised the bill. Lodge receipts are credited to the staff record linked to the user who recorded them. Anything with no staff shows under Unknown.
  • When all sources are showing, a small line under each name splits their total by source, for example "Bar 12,000.00 · Accommodation (Lodge) 4,500.00".
  • The All Cashiers row at the bottom adds everything up. With no department chosen, this grand total ties to Total Collected on the Sales & Collections tab.
  • Complimentary tenders are never counted.
  • Picking one POS department shows a blue note: "Showing POS and service collections for … only." Accommodation and account settlements are not per-department.

Click ⋯ > View bills on a row to open a side window called Cleared by …. It lists every payment behind that row, grouped by source with a subtotal each. Columns: Time, Bill (for example "Bill #1042", "Receipt …" or "Service order #…"), Mode and Amount. Long lists are paged. The lines add up to the cashier's total.

Note

This tab has no Export PDF button.

Outstanding Bills

Who owes us right now. It lists POS bills, service orders and lodge bookings that were opened in your range and were still unpaid at the close of its last day, grouped by department.

Fields:

  • From (opened on or after): starts on the first of the current month.
  • To (day close): the last business day. The report looks at the position at the close of that day, using your business-day rollover (midnight if none is set).

There are no time boxes on this tab.

The four tiles show Outstanding (opened in period), Open Documents, All Outstanding at close and Departments. Each department has a table:

Column Meaning
Ref Bill number, "SO-" service order number, or "#" booking number, with the customer or guest under it.
Type POS, Service or Lodge.
Opened When it was created.
Age (days) Days from opening to the close. Turns red above 30.
Total, Paid, Balance The amount, what had been paid by the close, and the difference.
Settled since A green date if it was paid after the close. Otherwise a red Unpaid.

The Reconciliation (all open documents at close, any age) box explains the grand total. It starts from Unpaid documents (all dates), takes off Settled on account (corporate payments that cleared invoices rather than the bills themselves) and, if there is one, an amber Overpayments / duplicate receipts line. The result is Total outstanding (ties to Sales & Collections). An overpayment line means some bill was paid more than its total, which is usually a duplicate receipt and worth investigating.

Note

The list only shows documents opened inside your range, but All Outstanding at close counts everything open at that close, whatever its age. Move From back to the start of the year to list every old debt.

Receivables

Aged debt on credit accounts. It looks at customers who have an account with invoices that are not fully paid. Pick As of (it starts on today). Each customer's unpaid invoice balances are put into buckets by how many days have passed since the invoice was issued: Current (0–30), 31–60, 61–90 and 90+. Total Due is the sum. The 90+ amounts show in red. The totals box repeats the five figures.

An invoice that is paid or void, or has no issue date, is left out. This tab only sees invoices on accounts. A walk-in bill left unpaid shows on Outstanding Bills but not here. See Customers and Accounts.

Profit & Loss

Product margins. It reads the items on POS bills in the period (cancelled bills excluded) and works out profit per product.

Filters: the four date and time boxes and Department.

Column Meaning
SKU, Product Name The product.
Buying Price What it cost when sold. The same product bought at two prices shows as two rows.
Quantity Units sold.
Total Buying (Ksh) Quantity × buying price.
Total Selling (Ksh) Quantity × selling price.
Profit / Loss Selling less buying. Green with + or red with −.

The GRAND TOTAL row adds the columns. When stock was written off as spoiled in the same period and department, two more rows appear: Spoilage (loss) and NET PROFIT (after spoilage).

  • A fully complimentary bill earns nothing, but its goods still count as cost. A part-comped bill earns only the share that was charged.
  • Only goods sold through the POS appear. Rent, wages and other overheads are not included.
  • Services and accommodation are not in this report.

Accommodation

Lodge register. One row per booking created in the period, newest first. Filters: the four date and time boxes, Status (Pending, Active, Checked Out, Cancelled) and Payment Status (Unpaid, Partial, Paid).

Columns: Booking #, Guest, Room, Check In, Check Out, Booked By, Total (Ksh), Paid (Ksh), Balance (Ksh) and Status. A balance above zero is shown in red. The box at the bottom gives Total Bookings, Total Amount, Total Paid and Total Balance for the filtered rows.

A booking that was paid with a lump-sum deposit has a green Deposit badge under Paid, with left and the unused amount. The row keeps the full stay total, so the Balance stays honest. How much of the deposit has been earned as sales each night is on the Sales & Collections tab.

Note

This tab lists cancelled bookings too, and its totals include them, unless you pick a different Status. For room-by-room figures see Accommodation Reports.

Exporting to PDF

Where a tab has an Export PDF button (Daily Sales, Sales & Collections, Outstanding Bills, Profit & Loss), clicking it opens a PDF preview of what is on screen, using the same dates and filters. Use the viewer's own save or print buttons from there. Cashier Collections, Receivables and Accommodation have no PDF button.