The payments report allows franchisors to export a list of payments received (by payment date) across all of their locations.
Running the report
Note: this feature is only available to Franchisors (parent franchise orgs).
Your payments report will live on your reporting tab. Click into the report tab in your top navigation bar, and then payments on the left side of the page.
Once on the page, you can select the date range for the report by selecting the drop down titled 'Global date range', located directly under the title of the report. The date range that you select filters the data in the report export based on the payment date. You can select up to one month of payments at a time. If you'd like to include today in the data pull, be sure to set your date range to end tomorrow.
Viewing the report output
After you select the blue GENERATE REPORT option, an export of the data will be sent via email to the email address associated with your account. This may take up to an hour based on the size of the data being pulled.
The email will include two files:
Summary file
The summary file displays the sum of payments received by payment type, by child org.
Fields in the summary file:
Child org name: name of the location associated with the payments (f you receive payments in your parent account, the parent account name will show here)
Payment type: method of payment used by the child org
Revenue: sum of the payment value associated with the payment type
Invoice count: count of the invoices associated with the payment type
Payment details file
The payment details file displays each of the payments received by your child accounts for the time period specified. This file allows you to view all of the details behind the summary file.
Fields in the details file:
Parent franchise ID: the unique ID associated with your parent organization (Note: will be blank if the payment line is associated with your parent org)
Child Org ID: the unique ID associated with the child organization that collected the payment
Child Org Name: name of the child organization that collected the payment
Job ID: the unique ID associated with the job that payment was collected against (Note: the same Job ID may be repeated in the file if multiple payments were collected on the job)
Payment Received Date: date and time the payment was received by the child organization
Job Created Date: date and time the job was created that payment was collected against
Job Completed Date: date and time the job was completed that payment was collected against (If the job hasn't been completed yet, this field will be blank)
Customer ID: the unique ID associated with the customer that made the payment
Customer Name: name of the customer that made the payment
Invoice Number: invoice number associated with the payment collected. Note that the same invoice number may be repeated in the file if multiple payments were collected on the job
Job Duration: total job time (from on my way to finish) of the job (Note: will be blank if no time was tracked on the job)
Job Description: description of the first line item on the job
Invoice Payment: status of the total invoice balance (Note: if the invoice is completely paid, it will show as paid)
Assigned Employee Name: name of employee assigned to the job (Note: if multiple employees are assigned, the first will show)
Job Status: status of the job associated with the payment
Payment Amount: total amount of payment received (Note: Includes taxes and tips)
Payment Type: type of payment method used
Job Location Longitude: longitude associated with the address of job
Job Location Latitude: latitude associated with the address of job
Job Location Zip Code: zip code associated with the address of job