Skip to content
  • There are no suggestions because the search field is empty.

Financial Reports

Generate detailed financial reports in Zanda for sales, invoicing, and payments.

You can generate a range of reports relating to your sales. To access them, go to Reports > Financial. Click on the report you wish to generate, select the date range you are interested in and then run the report. All reports can be printed, export to Excel for further analysis and custom sorting, or exported as a PDF.

Financial reports require the Access Financial Reports permission. If the account is in Storage Mode, use Tools > Data Export to export historical account data instead of relying on Reports > Financial. 

In this article:

Activity Summary

  • This report gives an overview of all appointment, invoicing and payment activity for the period.
  • Produces four sections:
    • Appointments: Includes appointments booked during the reporting period. Useful for checking which appointments have been invoiced (which can be seen by which appointment have an invoice number listed), and which have been paid.
    • Sales Without Appointments: Shows all invoices produced that are not associated with an appointment. Typically for product sales.
    • Payments: Shows all payments received in the period, along with details of which invoice the payment is allocated to (if allocated).
    • Payments Reconciliation: Gross sales for all appointments that have services assigned to them.

Appointments are displayed if their start date is within the specified date range. Therefore, you can also use this report to predict future sales. The total outstanding payments figure displays the value for all appointments that haven't been received.



Invoices & Payments

  • Displays all service and product sales & payments based on appointment or payment date. Can be used for GST Sales for BAS. 
  • Report on Invoice Date or Payment Date. 
  • Includes invoice number, date of invoice, client name and client ID number, calendar/practitioner, location name, description (name of service/product), invoice total, tax amount, date paid, payment method, amount paid, amount owing, internal invoice notes, File Under entries from Client Profile > Details page. 



Sales

  • Breakdown of how many products and services were sold over a date range for each employee.
  • Group by Type and then Item to see the total quantity of each service, product, or session pack sold in that period of time.
  • Includes invoice number, date of sale, client name, client number ( to allow for exporting the data without including identifying client details), calendar/practitioner, Location, appointment date (if the invoice is associated to an appointment), type of sale (service, product, session pack), item sold (either service or product name), time/duration (relevant for services), total invoices amount, tax included.

NDIS Bulk Upload (AUS-only)

This report is only available in Zanda accounts that have 'Australia' set up as the country in User Menu > Account Settings > Practice > Business Info.
This report generates a list of invoiced services for NDIA-managed clients that can be exported to CSV and then uploaded to the NDIS myplace portal to bulk request payments.

 

Accounts Receivables

  • Shows all outstanding invoices for clients as of a particular date. 
  • For example, a report on what invoices were outstanding as of the last financial year for tax purposes. 
  • Includes the entity payable by, and the total amount owing by each. The sum of the outstanding amount is listed at the bottom of the report.


Aged Receivables

  • Shows which account are in arrears as at the current point in time or at the date that you selected. Use this to an accurate list of what is owed at the date used to run this report. 
  • Includes the entity payable by and a summary of the outstanding amount based on periods of 0-30 days, 31-60 days, 61-90 days, 90+days, and a total sum of owed payments.

💡Pro Tip You can use grouping and filtering to further refine report results. Learn how in this article.

Frequently Asked Questions

❓ Why is a partial payment not appearing in Invoices & Payments?

To report on partial payments in Invoices & Payments, set Search On to Payment Date, and choose Paid and Unpaid Invoices in the Payment Status filter. Partially paid invoices may not appear under Paid Invoices Only until the invoice is fully paid, so use Paid and Unpaid Invoices to include invoices with a remaining balance. In the report results, review How Paid, Amount Paid, and Owing to check the payment method, paid amount, and amount still owing.

❓ How do I report on revenue for an inactive practitioner?

The Practitioner filter in Invoices & Payments lists active practitioners. To report on revenue for a practitioner who is currently inactive, temporarily reactivate their practitioner profile, run the report, and then deactivate the practitioner again when you have finished.

  1. Go to User Menu > Account Settings > Team > Practitioners.
  2. Turn on Show Inactive, then open the inactive practitioner profile.
  3. Turn on the Active toggle and click Save.
  4. Go to Reports > Financial > Invoices & Payments.
  5. Set the Start Date and End Date for the financial year you want to report on.
  6. Select the practitioner from the Practitioner filter.
  7. Use Search On and Payment Status to match the revenue view you need, then run or export the report.
  8. Return to the practitioner profile, turn off the Active toggle, and click Save.

For detailed reactivation steps, see Adding and Editing Practitioners.

❓ How do I exclude the card processing fee from the Invoices & Payments report?

The Invoices & Payments report does not have a filter to remove the Stripe card processing fee. The fee is recorded on the invoice as its own line item, Card Processing Fee, so the report counts it in the totals like any other service or product, and there is no setting to hide or subtract it inside the report.

Because the fee sits on its own line, you can separate it after exporting:

  1. Go to Reports > Financial > Invoices & Payments and set your date range and filters. For example, set Search On to Payment Date if you are working out pay based on payments received.
  2. Use Choose Columns to include the Description column so the Card Processing Fee lines are visible.
  3. Click Excel (or CSV) to export the results.
  4. In the spreadsheet, filter or remove the rows where the Description is Card Processing Fee , then re-total the remaining amounts to get the figure without the fee.

This gives you a sales or payment total that excludes the card processing fee — useful when a practitioner's pay should not include the fee, since the practice retains the fee to cover the transaction cost.

If you would like a built-in option to exclude the card processing fee from this report, you can submit the request through the Customer Ideas Portal.

❓ Can I search for invoices by amount?

Yes. For a quick lookup, use the Quick Search bar, select Invoices, and enter the invoice total you want to find. Quick Search matches invoice totals, invoice numbers, and client details.

For reporting, go to Reports > Financial > Invoices & Payments, run the report for the date range and filters you need, and then use the column filter menu on Invoice Total, Amount Paid, or Owing to refine the results by amount. You can use this when you need to find invoices with a specific total, check payments of a certain amount, or review invoices with an amount still owing.

❓ Why do prepayments look different in Billing > Payments and financial reports?

Use Billing > Payments when you need a payment-level list that can include unallocated prepayments. Turn on Include All Prepayments to include payments that have been recorded but not allocated to an invoice yet.

Use Reports > Financial > Invoices & Payments or Reports > Financial > Sales when you need invoice-based reporting. These reports show invoices and payments allocated to invoices, so an unallocated prepayment appears after it has been allocated to an invoice. To review allocated payments by payment date, set Search On to Payment Date and use Paid and Unpaid Invoices when you need to include partially paid invoices.

❓ How do I find each practitioner's average session fee and average weekly sessions?

You can work out both averages from the Sales report, which lists every service sale with its practitioner, amount, and duration. Zanda does not show them as a single figure, so you calculate them from that report.

  1. Go to Reports > Financial > Sales and set the Date Range you want to measure.
  2. Filter or group the report by calendar/practitioner so each practitioner's service sales sit together. To group, drag the Practitioner column into the grouping area (see Grouping Reports). Export to Excel or CSV if you would like to total and divide the figures in a spreadsheet.
  3. Average session fee: divide the practitioner's total service sales by their number of service lines for the period. Each booked service is one line, so where an appointment has a single service, the line count is the session count. If your appointments often carry more than one billed service, count appointments instead using the Activity Summary report.
  4. Average weekly sessions: take that same session count and divide it by the number of weeks in your date range.

For booked time rather than fees, the Practitioner Utilisation Report shows each practitioner's booked hours against their available hours over the period.

 

Related Articles