Genie understands how important it is for practices to easily report on their banking. The Billing vs Income Report will allow you to see an overview of what you've billed in a period and what you've receipted, as well as detailed reports for both. This is the main report in Genie and is the one that should be used for determining providers’ pays and dividends.
Before you begin
- Before running any financial reports it is recommended that you first complete a Check Integrity. If any issues present in this check, then these will need to be resolved before continuing with your reports. If you need any help with dealing with problems in your Check Integrity, please contact our Support team
- It is important that all ECLIPSE claims with a remittance available or a partial payment have been receipted before the Billing vs Income report is generated. If not, the receipts total may change when the report is reprinted.
- Providers from the Address Book will appear on this report with (Assist.) if they have been added to an invoice, using the "Include Asst's Fee" button. Assistant items billed through "Invoice as Asst" will appear within that provider's totals. Caveat to this is ECLIPSE invoices where the servicing provider type has been manually set to "Assistant"; these will appear in the Billing vs Income without "(Assist.)", or if the Provider name matches a Genie User, will appear within the provider's totals, under the Site of Service of the principal provider.
To access the Billing vs Income report, navigate to File > Maintenance and Reports > Practice Analysis. Select the Billing vs Income option and you will be presented with the following settings window.
Enter the appropriate settings for your search including the date range and provider and select OK. You will then be presented with the following window:
Provider: List of Months/ Providers within the selected period. This will depend on how you chose to sort the report in your initial settings window.
Billing: Combined total value of invoices (fees) including GST. This includes all invoices for the period.
GST: The value of GST charged as part of invoiced fees. This is the GST charged in Billing, not what has actually been receipted.
Credits: Refers to the Credits column of the Account History. Any value applied to "write off" or otherwise signify that an invoiced amount is no longer required/expected to be paid.
Discounts: Refers to the sum of all discounts applied to items billed under this provider. Discounts are applied to the total price (including GST, if applicable).
Net Billing: Equals gross billing less GST less credits and discounts, and is therefore the real, actual billing for the practice that this provider has performed.
Receipts: This column shows the total amount that has been receipted to this provider for the time period selected and includes any GST.
GST Collected: The total value of GST which has been receipted as part of a cash payment. The "Cash" notation is in relation to Cash vs Accruals accounting, indicating that this value should be used if cash-based accounting is the preferred method. This also means that this value relates to the Print Receipts, not the Sales.
Difference: This figure is the difference between the Billing amount and the sum of the Receipts.
Inv: This shows the number of invoices billed to this provider for the selected period. Remember that this is not necessarily the number of patient contacts.
Above the Billing vs Income Report columns are the options for Print Breakdown, Print Sales, Print Receipts and Summary Records. These will all print a particular report based on the selected provider.
Print Breakdown
This will print a more detailed breakdown of invoices and receipts, including a breakdown between bulk-billed Medicare and DVA, private and other organisation billing and receipting.
Term | Explanation |
Other | Any account holder that does not fall under the Individual (patient or person), Medicare, or DVA. This will include Health Funds and Insurers, as well as custom account holders such as Hospitals, Law Firms and other businesses. |
Total amount invoiced where GST was applied | Total value of the invoices where a GST component was applied or included. |
GST Input (Accruals) | The value of the GST included in the above invoices. |
Actual Receipts | The full value of receipts processed within this period, based on receipt date. This will include deposits which have been applied to a receipt. |
Amount Received where GST was applied | The total value of receipts which have been paid again an item where GST was included. For example, Invoice 1 is a total of $100 which includes $10 GST. Invoice 2 has a total of $90 with no GST charged. Both invoices have been paid in full, but this section will reflect only Invoice 1. This is because no GST was included on Invoice 2 or the payment for it. |
GST Input (Cash) | This is the total amount of GST that has been receipted from actual payments. |
Print/Export Sales
Lists all the items invoiced during the selected time period. You will be prompted to choose whether you would like these subtotalled by item number, and subsequently whether you would like to print this or export the information to an Excel spreadsheet.
Term | Explanation |
Amount | Should be equal to the Billing on the main page of the Billing vs Income Report. |
GST | This should be equivalent to the Billing vs Income main page. If this total is different please contact Genie Support to investigate. |
Payment | The payments refer directly to the invoices raised within that date range, so it will not account for items receipted from a previous period. For example, if a patient receives a payment for an invoice that was created outside of the current search period, it will not be included here. |
Credit | Credits applied to invoices raised in this month |
Discount | Discounts applied to invoices raised this month |
Balance | Balance is equal to Billing - (Payments + Credits + Discounts) |
Print/Export Receipts
Lists all the receipts for the selected time period, whether the actual invoice was created during this time period or not. You will be prompted to choose whether you would like to print this or export it to an Excel spreadsheet.
Term | Explanation |
Date | Receipt Date - not the date of the invoice |
Charged | Total value should be equivalent to the Billing total in the main Billing vs Income screen |
Receipted | Total value should match the Receipt value on the main Billing vs Income |
Summary Records
Displays the Summary Records for each provider. These are updated during a Check Integrity.
Icons
Use the Excel icon to export the Billing Vs Income report as an Excel spreadsheet, as it appears on-screen.
Use the Graph icon to graph the Billing Vs Income report.
Use the Printer icon to print the report as it appears on-screen.
How can I view the billing by provider for each site of service?
To display the billing by Site of Service click the black arrow next to the doctor's name.
Why does the GST in my Billing vs Income differ from my GST in other reports?
The GST amount indicated in the Billing vs Income report may vary when compared to GST amounts in other reports in Genie over the same period (i.e. the GST in banking report). This is due to the fact that if an account which includes GST is deleted, and the Banking batch in which it is contained is sealed, then the Banking report GST amount is not updated to reflect this deletion, whereas the GST reported in the Billing vs Income report is.
Why do my Billing and Receipts not equal even though all my invoices for the period have been paid?
The Billing vs Income report will show the amounts for invoices created and payments receipted between for selected time period. If an invoice has been raised in one period, but not receipted until the next, you may not see both amounts in the same report.
Why is my Billing vs Income Report not including all my invoices and receipts for the period?
Invoices with a backdated service date will still appear in the Billing vs Income based on the invoice-date. E.g. Raise an invoice in March for a service performed in February, will appear in the Billing vs Income for March.
Backdated receipts (where the date on the receipt is changed manually) will appear in the Billing vs Income which included the entered date. e.g. During March, backdate a receipt to 2nd of Feb - It will appear in the Billing vs Income for February.
Why does my Receipts total in the Billing vs Income change when I reprint it at a later date?
The receipts total records anything with a receipt date of that month, the service date of the actual item is irrelevant. If a receipt is manually backdated, it will appear in the backdated month. Similarly, if an Eclipse claim with a remittance (e.g. January) is receipted in a later month (e.g. February), it will automatically backdate to the date of the remittance (i.e. January).