Viewing Small Business and Referral Data in the Hub

Admin users can view data about their small business customers (including referral data).

Small business data (including referral data) is accessible by users with Admin role types. This information is more robust than a simple list of customers that were referred to use Autobooks technology.

All data is available for download to a .CSV format. Click the download button in the upper right corner of the data table to download an export. NOTE: exports are limited to no more than 10,000 rows (or your ability to download a certain file size). To create a smaller download file, filter column views to show only the desired meaningful data you need.

Admins can take advantage of the data in a number of meaningful ways, including:

  • Create employee referral leaderboards for internal competition;
  • Identify customers that are (or aren't) generating TPV dollars for follow-up;
  • Schedule customer communications (using our provided email copy or call scripts!) to:
    • Encourage enrollments. Send a note to referred customers that have not yet enrolled in Autobooks;
    • Get SMBs approved for payment processing: Let enrolled customers that have not provided required Missing Info to log in and do so;
    • Encourage usage: Reach out to approved customers that can process payments, but haven't yet;
    • Thank your valuable customers: Congratulate your customers on using Autobooks to get paid, and gain feedback on their experience;

You are also able to drill into a specific customer record (click here to jump to the instructions).

Accessing Small Business Data

To view your small business data, log into the Hub and navigate to the Data menu item at left. Expand the Data section, then click on Small Business.

Within the Small Business section, each line item represents a customer that has begun the enrollment process with Autobooks, been referred, or both. You'll see the following information for each small business customer in your list, along with a Search bar at the top to locate a specific item:

  1. Business Info:
    1. SMB ID - Autobooks unique customer identifier.
    2. Integration ID - this is the Autobooks unique identifier for your financial institution. You may have multiple Integration IDs if you have a parent company with affiliated banks, for example.
    3. Company Name - name of the customer's business.
    4. External ID - customer's unique identifier from your data core information.
    5. Email - the email address for the customer that was referred.
    6. Admin Name - first and last name of the primary admin of the Autobooks account.
    7. Status - the most recent event in the customer's milestones of their Autobooks journey.
    8. Business Structure - the type of business structure (ex: Sole Proprietor, LLC).
    9. Onboard Date - the date the customer accepted Autobooks' terms and conditions.
    10. Credit Card Limit - the dollar limit the customer has been approved to accept digitally through Autobooks via credit/debit card.
    11. Subscription Type - this column will indicate if the customer is using the payment modules (Freemium) or the full Autobooks subscription.
    12. Deboard date - the date a customer has deboarded from Autobooks.
    13. Deboard reason - the reason a customer has been deboarded from Autobooks. Reasons include:
      1. Criminal History - uncovered during our initial risk assessment regarding the primary owner, customer cannot be approved to process payments.
      2. Negative Financial Background - uncovered during our initial risk assessment regarding an owner, customer cannot be approved to process payments.
      3. Prohibited Business
      4. Suspected/Confirmed Fraud
      5. Other - Allow Reboard
      6. Negative Business Reputation - uncovered during our initial risk assessment regarding the business, customer cannot be approved to process payments.
      7. SMB Requested - the customer requested that their Autobooks account be closed.
      8. Other - Do Not Allow Reboard
      9. Account Closed - the account was closed, usually due to inactivity.
    1. CC Application Info
      1. CC Application Status - the status of the customer's approval to process credit card payments.
      2. CC Application Submitted Date - the date/time the customer applied for credit card payment approval through Autobooks.
      3. CC Application Approved Date - the date/time the customer was approved to process credit card payments through Autobooks.
    2. ACH Application Info (note: ACH approval dates may differ slightly from credit card processing approval dates)
      1. ACH Application Status - the status of the customer's approval to process ACH payments.
      2. ACH Application Submitted Date - the date/time the customer applied for ACH payment approval through Autobooks.
      3. ACH Application Approved Date - the date/time the customer was approved to process ACH payments through Autobooks.
    3. Tap to Pay info
      1. TTP Status - this status indicates if the customer has enabled Tap to Pay within your online banking.
      2. TTP application date - this is the date/time the customer applied to process payments using Tap to Pay through Autobooks.
    4. Payment info
      1. First Payment Date - the date the customer processed their first payment using Autobooks.
      2. First Payment Amount - the dollar amount of the customer's first payment processed using Autobooks.
      3. Most Recent Payment Date - the date of the customer's most recent payment processed using Autobooks.
      4. Most Recent Payment Amount - the dollar amount of the customer's most recent payment processed using Autobooks.
      5. Total Payment Count - the number of times an Autobooks payment deposit has been made to the customer's account.
      6. Total Payment Amount - the total dollar amount the customer has processed in payments through Autobooks.
    5. Referral info
      1. Referral ID - this is the Autobooks-assigned number for the referral submitted.
      2. Referred By - the name of the employee that referred the customer.
      3. Employee Email - your employee's email address that referred the customer.
      4. Referral date - the date the employee submitted the referral through the Autobooks Hub.

    Sorting and Viewing Small Business Data

    Small business data may be sorted and filtered in a number of ways. You can:

    1. Sort and filter data per column - each column within the small business data table can be sorted and filtered as needed. Simply click the icon in a column header, and a dropdown of sort/filter options will appear.
    2. Select data from default options - you may also view various pre-canned views from a list of default view options. Click the Table Settings icon to the left of the search bar, and a list of views will appear to choose from.



    Default Options Include:

    • All referrals - shows all customers that were referred by an employee.
    • Most deposits - customers with deposit activity, sorted from most to least number of deposits.
    • Highest deposits (dollars) - customers with the highest dollar deposit activity, sorted from most to least in dollars.
    • Referral leaderboard - referral activity per employee, sorted from employee with the most referrals to least.

     

    Viewing a customer's Company record

    You can drill into any Company Name within the Small Business Data or in the Progress Center to see more detail about that customer's Autobooks journey. To access more detail:

    1. Click the Company Name. NOTE: There will be no link to click if the customer has not yet accepted Autobooks' terms and conditions.
    2. The first two sections of information that appear are Status and Contacts.
      1. Status - lists all of milestones that have occurred within the customer's Autobooks progress including date terms were accepted, when the customer's data was submitted for payment enablement approval, when the application was approved, and when the customer processed their first payment.
      2. Contacts - lists all contacts Autobooks has for that business record. The contact email and phone numbers will be listed, including their user roles.
    3. The next two sections that appear are Basic Info and Processing Limits.
      1. Basic Info - lists the SMB ID, Company Name, Business Structure, NAICS code, Zip code, and what Autobooks' plan the customer is currently enrolled in (full or free).
      2. Processing Limits - lists the processing limits for credit card and ACH transactions.
        1. Credit Card Single Transaction Limit (Review) - this limit indicates the dollar threshold in which a customer's payment will be held for review. For example, if the limit indicates $3,000 Autobooks will hold and review any payments exceeding that amount.
        2. Credit Card Single Transaction Limit - this limit indicates the maximum dollar amount the customer can process through Autobooks in a single transaction.
        3. ACH Single Transaction Amount - this limit indicates the maximum dollar amount a customer can process in a single transaction via ACH.
        4. ACH Single Day Transaction Amount - this limit indicates the maximum dollar amount a customer can process in a single DAY via ACH.
        5. ACH Single Day Transaction Count - this limit indicates the maximum number of ACH transactions the customer can accept in a single day.

    4. The last two sections of information are Payment Sources and Payment Table.
      1. Payment Sources - this list will show the number of payments taken through each Autobooks payment tool and the total dollar amount of those transactions.
      2. Payment Table - this table breaks down each payment taken by the customer and its attributes.