Skip to main content

Payments Export

Export a list of payments.

J
Written by James N
Updated over 2 weeks ago

How to Run a Payments Report

The payments export report allows you to export a list of payments received (by payment date) across all payment types.

To export your payments report:

  • Select the 'Reporting' tab in your top navigation bar.

  • Select 'Payments' on the left menu of the page.

  • Select the date range for the report.

  • Click 'Generate report.'

The date range you select filters the data in the report export based on the payment date.

Viewing the Report Output

After you select 'GENERATE REPORT' located under the select date range, an export of the data will be sent via email to the email address associated with the account viewing the report.

The email will include two files:

  • Summary File

  • Payment Details File

Note: This may take up to an hour based on the size of the data being pulled.

Summary File

The summary file displays the sum of payments received by payment type.

Fields in the summary file:

  • Payment type: the method of payment used.

  • 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 for the time period specified. This file allows you to view all of the details behind the summary file.

Fields in the Details File:

  • Job ID: The unique ID associated with the job that payment was collected against. Note that the same Job ID may be repeated in the file if multiple payments were collected on the job.

  • Payment Received Date: The date and time that the payment was received by the child organization.

  • Job Created Date: The date and time that the job was created that payment was collected against.

  • Job Completed Date: The date and time that 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: The name of the customer that made the payment.

  • Invoice Number: The 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: The total job time (from on my way to finish) of the job. Will be blank if no time was tracked on the job.

  • Job Description: The description of the first line item on the job.

  • Invoice Payment: The status of the total invoice balance. If the invoice is completely paid, it will show as paid.

  • Assigned Employee Name: Name of the employee assigned to the job. If multiple employees are assigned, the first will show.

  • Job Status: The status of the job that is associated with the payment.

  • Payment Amount: The total amount of the payment received. Includes taxes and tips. If the payment is a refund, it will show as a negative value.

  • Payment Type: The type of payment method that was used.

  • Job Location Longitude: Longitude associated with the address of the job.

  • Job Location Latitude: Latitude associated with the address of the job.

  • Job Location Zip Code: Zip code associated with the address of the job.

  • Fee Amount: The exact amount deducted as a payment processing fee

  • Fee Type: Specifies the type of fee applied to the payment

Please Note: The Fee Amount and Fee Type columns are currently in Alpha and have not yet been released to all Pros.


Payment Fees Added to Payments Report

This feature is currently in Alpha and has not yet been released to all Pros.

What's New in Payments Export?

We've added clear visibility into specific payment fees within the Payments Export report. Payment fees refer to the expenses incurred by using Housecall Pro payment solutions, including:

  • Credit Card Fees: Charges associated with processing credit card payments.

  • ACH Fees: Costs related to processing Automated Clearing House (ACH) bank transfers.

  • Merchant Discount Fees: Fees deducted by payment processors as part of handling transactions.

How to Access Payment Fees Reporting

  • Navigate to your Reporting tab within Housecall Pro and select the Payments report from the menu on the left side of the page.

  • Easily view two new columns: Fee Amount and Fee Type, which will provide you with insight into your payment fees, detailing credit card, ACH, and merchant discount fees associated with any transaction.

  • Use these insights to manage costs effectively and gain insight into additional overhead expenses.

Fee Type Correlations

When you pull your payments export, you’ll now see a fee type column added to the export. Here’s how the fee types align with different payment methods and how they appear in an export:

  • Card-Present Payment (when a customer pays by a card that is swiped, tapped, or chipped through a card reader):

    • Fee type will be “Card Present.”

  • Card-Not-Present Payment (when card details are manually entered or scanned):

    • Fee type will be “Card Not Present.”

  • Invoice Percent Payment (when the customer pays online via an emailed invoice):

    • Fee type will be “Invoice Percent Payment.”

  • ACH Payment (when payment is made via a bank transfer):

    • Fee type will be “ACH Payment.”

  • Instant Payout Fee (if you’re utilizing the Instant Payout feature, this fee type may be applied to any of the above payment types):

    • Fee type will be “Instant Payout Fee.”

    • This fee can be applied in addition to the regular payment fees and will show under the fee type.

For more information on the percentages associated with our payment processing options, simply reference this help article: Housecall Pro Payment Processing Options.

How Fees Are Recorded for Batch Payments

If you’ve processed a batch payment (a single payment covering multiple jobs), the way fees appear in your export is designed to keep things clear and accurate:

  • The payment fee amount is recorded only on the first job in the batch.

  • The fee type for the first job will be labeled as “Batch Payment,” followed by the applicable Fee types (e.g., “Card Present,” “Card Not Present,” “Invoice Payment,” etc.).

  • The fee type for any subsequent jobs will simply be labeled as Batch Payment.

  • All other jobs included in the batch will not show a fee amount.

  • This ensures that the total processing fee is only recorded once and avoids duplicate fees appearing across multiple jobs.


Having trouble finding what you need?

For further assistance, please reach out to our Chat Support team

via the Blue Chat Bubble in your Housecall Pro account, or

contact our Phone Support team at (858) 842-5746.

Did this answer your question?