Skip to main content

Sections in a Hospital Sales Report.

This page details the sections of a Hospital sales report provides an in-depth examination of the report's components. Each section serves a crucial role in presenting essential information for effective financial analysis and decision-making within Paperless Hospital.

Header Section

In its default configuration, this section features prominent, bold text that spells out the company’s name and address. There is a system setting which when toggled replaces the default text with a pre-selected image in the header. This header image can either span the full width across the top of each page or be displayed with a limited width within the same section on each page.

Title Section

This section signifies the report type and the time frame it encompasses.

Revenue Summary Table

This section summarises all Revenue resulting from the transactions listed further down in that particular report.

Consider a sales report that details transactions where the total cash revenue amounted to USD $200.00. In such a report, the Revenue Summary Table would feature a row specifically reflecting this cash revenue, in it's specific currency. This row would be labeled as [11110] - Cash (USD). The number 11110, enclosed in square brackets, represents the unique General Ledge Account number for the Cash (USD) General Ledger Account. Technically (in accounting terms and in the Chart of Accounts) this [11110] - Cash (USD) account is classified as an Asset account as opposed to being classified as a Revenue account. Each General Ledger Account has its own distinct account number.

In addition to the cash and electronic (i.e. bank account) forms of revenues, another form of revenue is Accounts Receivable (abbreviated as AR). These debts are considered assets in much the same way that cash and bank account funds are considered as assets. In the chart of accounts, the Accounts Receivable General Ledger Account has four child accounts, each representing a different type of debtor.

  • Corporates (AR)
  • Customers (AR)
  • Patients (AR)
  • Medical Aid Societies (AR)

The Medical Aid Societies (AR) General Ledger Account is subdivided into 30+ sub-accounts, each corresponding to a different medical aid society company. Given that claims constitute a significant revenue stream for medical practices, most reports will feature at least one of these 30+ Medical Aid Society sub-accounts in the Revenue Summary Table.

Consider a sales report that details transactions involving claims from different Cimas patients over a period of time. Consider that these patients treated on different days, also have policies denominated in different currencies. Suppose the total of the USD claim amounts is USD $1,200.00 (for the USD denominated Cimas policies) and the total of the ZIG claim amounts is ZIG $34,500.00 (for the ZIG denominated Cimas policies). In such a case, the Revenue Summary Table would feature two separate rows, each corresponding to the General Ledger Account [11330.09] - (AR) Cimas. In one of the rows corresponding to Cimas, the revenue amount of USD $1,200.00 would be displayed, while in the other row, the ZIG $34,500.00 revenue amount would be shown. Note that rows in the Revenue Summary Table can only detail revenue in just one (1) currency. In the example we just referenced, one (1) medical aid society is responsible for revenue in two (2) different currencies, hence 2 rows in the Revenue Summary Table are necessary to detail revenue due to that society.

Transaction Details Table (exclusive to detailed sales reports)

The Transaction Details Table, exclusive to detailed sales reports, provides a comprehensive breakdown of every service or inventory item sold within the hospital management software. The table boasts several columns, each offering valuable insights into the transactions. Here is a list of the columns in the order they appear from left to right:

  • date
  • time
  • journal entry number : Useful for identifying and potentially reversing specific transactions by referencing their unique entry numbers.
  • line description
  • patient full name
  • quantity sold
  • sales price : This column displays the price at which each item was sold, listed in the default currency of the system. The default currency is typically USD.
  • extended sales price : Calculated by multiplying the sales price by the quantity sold, this column represents the total revenue generated for each item.

Notably, sales prices are consistently listed in the default currency of the system, typically USD, ensuring uniformity across all reports regardless of the currency used in transactions.

The total displayed at the bottom of the Transaction Details Table encapsulates the aggregate sales values recorded within the report period, presenting a consolidated snapshot of the financial transactions. This total encompasses the sum of all sales activities, including any discounts applied during the specified timeframe. It serves as a valuable reference point for evaluating revenue generated from various sales endeavors within the hospital management system. Since the Transaction Details Table only presents prices in the default currency, it follows that the total at the bottom of the Transaction Details Table presents the total of sales expressed in the default currency.

In comparing the total at the bottom of the Transaction Details Table with the information presented in the Revenue Summary Table, it is imperative to consider currency conversion. While the Transaction Details Table lists sales prices in the default currency, the Revenue Summary Table offers a breakdown of sales revenue by the different transaction currencies. To facilitate an accurate comparison, all currency values in the Revenue Summary Table must be converted into the default currency using the exchange rates as at the time of processing the transaction. This meticulous conversion process enables users to conduct a thorough analysis of sales revenue across different currencies and gain insights into the overall financial performance of the hospital.

Ultimately, the Transaction Details Table and the Revenue Summary Table complement each other in providing a comprehensive understanding of sales revenue. While the Transaction Details Table furnishes detailed transactional information, the Revenue Summary Table offers a consolidated view of sales revenue by currency. By reconciling these two sources of data, users can derive actionable insights, identify trends, and make informed decisions to drive operational efficiency and financial success within the hospital.

Back to top