Understanding The Different Financial Reports in Facility

In Faclity, there are three primary financial report types: Revenue, Payments, and Sales, all of which can be found in Reporting. 

These reports offer similar data about your company's financial performance but have subtle differences that make each report more suitable than the others based on what results you are looking for and how you want to analyze your company's performance.

Revenue Report

The Revenue report uses an invoice's line Items as its underlying data source with any invoice's pro-rated discount applied. The date on each individual line Item will be taken into account and the invoice's date will not be considered.

The revenue report does not include taxes or tips.

Revenue reports offer the option to Download Source Data, which will show each line of raw data used in each revenue report.

Payment Report

There are six different Payment reports that can be used. 

The Credits report uses the date recorded on the payment for the supplied date range, not the date of the invoice the payment is applied to. Credits are manually applied and redeemed to client accounts: Facility: Applying Credits & Open Payments.

The Payments - All report provides a tabular representation of payments for the supplied date range. Unlike the “Applied Payments” report, this report’s results do not consider whether or not the payment has been applied to an invoice. This report also does not take into account which invoices the payment has or has not been applied to. 

The Payments - Applied report provides a tabular representation of payments for the supplied date range as they have been applied to invoices. This report also includes a sum of the total applied, the pro-rated tax amount, and the amount of tips collected.

For example, if you have a payment of $100 from March 2021, but only $80 of the payment is applied to an invoice, the Payments - Applied report will only show $80 on the report. 

For pro-rated tax amount, this is based on the applied payments share of the invoice's total. For example, let's say an invoice total is $100, and $10 of the total is tax. You have applied a $40 to the invoice. The pro-rated tax amount will be $4. This is $40 divided by $100 times $10 = $4. (40/100*10=4) 

The Payments - Open report uses the date recorded on the payment for the supplied date range, not the date of the invoice the payment is applied to. Open Payments are essentially overpayments or payments that have not been applied to invoices. Please see our help article on Facility: Understanding Credits & Open Payments for more information. 

The Refunds report provides a tabular representation of refunds that were issued to clients. For more information on refunds see Refunds In Time To Pet.

Sales Report

The Sales report considers invoices as a whole and will take into account either the Invoice Date or the Invoice Due Date (you are given the choice when generating the report). You can also choose to only include invoices that are completely paid or all invoices in this report.

The sales report will report on Taxes, Tips, Discounts, and Paid Amount.

Wrapping It All Up

To bring it all together, let's consider an example invoice.

Invoice #1

Due Date: May 1, 2018

April 29th, 2018 - Dog Sitting - $20

April 30th, 2018 - Dog Sitting - $20

May 1, 2018      - Dog Sitting - $20

Discount: 10%

Total Due: $54.00

Payment applied on May 1, 2018 in amount of $54.00

• Revenue Report for April 2018 will be $36 ($40 minus 10% discount)
• Revenue Report for May 2018 will be $18 ($20 minus 10% discount)
• Payment Report for April 2018 will be $0
• Payment Report for May 2018 will be $54
• Sales Report for April 2018 will not include Invoice #1
• Sales Report for May 2018 will include Invoice #1.