Introduction
Balance Sheet Report:

1. Displays the all Actual Payments, Expenses and Branch Balance within specific date range.
   – Branch Balance = Total income – Expenses
2. Data displayed in report Per branch.

 (Balance Sheet) report could be accessed from:

• Analytics >> Financials >> Balance Sheet.

Filtration
– (From) and (To) fields enables user to select the required date range.
– Date filtration depends on the Financial Transaction Date of each of the Patient Payment, Insurance Payment,Payback,Lab Expenses and Expenses.
– Default Selection: Today’s Date.

Note: The number of days between ‘From’ date and ‘To’ date can NOT exceed 31 Days.

Content
Header
At the report’s header the following value is displayed:

– Label (Balance): Displays the total amount (value) of balance for all of the financial transactions “Income & Expenses” listed in the report within the selected date range.

Body
Income and Expenses transactions data are displayed in a grid view whose columns are

• • Date
    – Displays the date and time when the payment (Patient and/or Insurance) and expense transactions has been performed within the selected date range.
  • Type
    – Displays the type of each listed record, that the financial transaction record could be of type:
    • Pay: If it’s a Patient Payment.
    • InsPay: If it’s Insurance Payment.
    • Exp: If it’s Expenses. 
  • Code
    – Displays the value of Receipt Number or Expenses Code.

Note That If The Transaction is:

• 1. Patient Payment then it displays the code (Value) of “Receipt Number” field (This “Receipt Number” field is displayed in the ‘Edit Payment’ page).
  2. Insurance Payment then it displays the code (Value) of “Receipt Number” field (This “Receipt Number” field is displayed in the ‘Edit Payment’ page).
  3. Expenses then it will display the code of each expense item (This “Code” is displayed in the ‘Edit Expense’ page in Settings module).

• Description
  – Displays the name in which the financial transaction is performed for, that:
  • Displays “Patient Name” for both of the Patient and Insurance payment transactions.
  • Displays the “Name” of Expenses Category and Item for the Expenses transactions.
• User
  – Displays the name of user who performed the financial transaction.
• Income
  – This column displays data (Values) only in case the financial transaction is a patient payment or insurance payment.
  – It displays the amount of paid money by patient and/or insurance.
  – At the table’s footer there is label (Total) that displays the total value of all incomes in the (Income) column.
• Expenses
  – This column displays data (Values) only in case the financial transaction is expense.
  – It displays the amount of expended money by the clinic.
  – At the table’s footer there is label (Total) that displays the total value of all expenses in the (Expenses) column.
• Balance
  – Displays the balance of your clinic by adding the income values and subtracting the expenses values. This operation is performed row by row.
  – At the table’s footer there is label (Total) that displays the total value in the (Balance) column.
• Method
  – Displays the method used to pay the money that could be via: Cash, Check, or Credit Card.