> ## Documentation Index > Fetch the complete documentation index at: https://knowledge.uportal360.com/llms.txt > Use this file to discover all available pages before exploring further. # UAS Billing Invoice ## UAS Billing Invoice UAS delivers a detailed billing invoice every month for merchants that have a finance program that provides servicing for billing programs. Not all merchants will have billing programs, some merchants have purchasing-only programs and will not have billing invoices. UAS strives to collect on the total accounts in service. Our rates are a reflection of the amounts collected less our servicing fees. The result is deposited into your bank account. Invoices will be available on the **7th business day** of the month. Deposits will be made within 24-48 hours after invoicing is complete. Once the process is complete the invoices are made available via the uPortal360 platform. ### Accessing Billing Invoices To view invoices you must have the `View Invoices` permission, and to run detailed invoicing reports you will need the `UAS Invoices` report set. Permissions and report sets can be assigned by a user with the `User Management` permission. Please contact this user to assign the permissions and reports needed. ### How to Read Billing Invoices We created an invoice example, How to Read your Billing Invoice (below). This example provides a high-level review on the first page. The second page provides detailed descriptions/definitions and equations used for calculating invoice amounts. Download PDF *** ## View Billing Invoices - PDF To see invoices you must have the `View Invoices` Permission. When you log in to uPortal360, you will see an option called `Invoices` in the navigation menu. ## UAS Billing Invoice Reports To run detailed invoicing reports, you will need the `UAS Invoices` report set. When you log in to uPortal360, you will see a list of reports that start with "Invoicing - (*Report Name*)." Report Use Guide Scroll down to "Use Reports to Substantiate Your Billing Invoice" for a complete guide on using and configuring your invoice reports. ### Invoicing - Summary Report This report details all fields found on your invoice. **Field Definitions** | Column Name | Definition | Example | | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------ | | # Accts w Autopay | Number of accounts with autopay for this client Invoice. | - | | # Accts w-out Autopay | Number of accounts WITHOUT autopay for this client invoice. | - | | # New Accts | Number of new accounts loaded on this client invoice. | - | | # of Insert Letters | Number of letters with Insert on this client invoice. | - | | # of Letters | number of letters | - | | # Return PMTs | Number of returned payments for this client invoice. | - | | Accts w AutoPay % Coll Fee | Fee based on cash collected from serviced accounts with recurring payment agreements | - | | Accts w Autopay Coll Amt | Total cash collected with recurring payments minus NSFs, refunds, and amounts to applied to late charges. | - | | Accts w AutoPay Fee | Fee for servicing account WITH recurring payments | - | | Accts w-out AutoPay % Coll Fee | Fee based on cash collected from serviced accounts WITHOUT recurring payment agreements. | - | | Accts w-out Autopay Coll Amt | Total cash collected without recurring payments minus NSFs, refunds, and amounts to applied to late charges. Does NOT include merchant payments. | - | | # Accts w-out Autopay | Number of accounts WITHOUT autopay for this client invoice. | - | | Accts w-out AutoPay Fee | Fee for servicing accounts WITHOUT recurring payments | - | | Amt Due to Merchant | Total amount that is due to you from this client invoice. | - | | Amt Paid to UAS | Amount paid to Universal Account Servicing from this client Invoice | - | | Billing Period | Billing period that this client invoice covers. | - | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | Insert Letter Fee | Fee for adding an insert with a letter | - | | Letter Fee | Fee for mailing a letter. | - | | Merch Process % | Fee for processing credit cards. | - | | Merch Process Amt | Amount processed by the merchant for this client invoice. | - | | Merch Process Total | Merch Process Amt \* Merch Process % | - | | Client Account | Account Name | - | | New Acct Load Fee | Fee for loading new accounts. | - | | Other Deductions Total | Other deductions from this client invoice | - | | Pass Through Fee Total | Total fees passed through for this client invoice | - | | Previous Amt Due | Carryover balance form the previous invoice that has not been settled | - | | Program | Name of your program | Open-End Contracts | | Return PMT Fee | Fee for any returned payment. | - | | Subtotal | Total cash (paid to UAS) - fees | - | | Total Accts w Autopay | Accts w AutoPay Fee \* # Accts w Autopay | - | | Total Accts w Autopay Coll Fee | Accts w Autopay Coll Amt \* Accts w AutoPay % Coll Fee | - | | Total Accts w-out Autopay | Accts w-out AutoPay Fee \* # Accts w-out Autopay | - | | Total Accts w-out Autopay Coll Fee | Accts w-out Autopay Coll Amt \* Accts w-out AutoPay % Coll Fee | - | | Total Fees | Merchant Processing Credit and AMEX fees + Consumer Payment Method Returned + Letter Mailed Fees + Letter Inserted Fees | - | | Total Insert Letter Fee | Insert Letter Fee \* # of Insert Letters | - | | Total Letter Fee | Letter Fee \* # of Letters | - | | Total Load Fee | # New Accts \* New Account Load Fee | - | | Total Return PMTs | Return PMT Fee \* # Return PMTs | - | | UAS Billing Charge Total | Total billing charge from UAS for this client Invoice | - | ### Invoicing - New Accounts This report shows newly added accounts to your portfolio. This report represents the number of accounts on your invoice for the "New Account Load" fee. | Column Name | Definition | Example | | --------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------- | | Acct # | Seven character random account number uniquely assigned by our system. Accounts can contain multiple contracts, subscriptions and POS transactions | ABC1234 | | Active Date | Date the contract was activated in our system and we started to service the account - Create statements, accrue interest, etc. | 10/11/17 | | Applicant | Name of the primary applicant / account holder | John Doe | | Contract # | Accounts can have multiple contracts, the contract number is a build on the account number (ACCT#LOA##) | ABC1234LOA01 | | Location | Location where account was originated | Kansas Citry | | Merchant Ext ID | Unique ID assigned by you and given to us during the origination process or via a data update. This is critical when linking data back to other systems like Accounting Software or Fulfillment/ERP systems | Student Number, Patient Number, Merchant Number as some examples and length and type can vary widely by merchant. | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | Program | Name of your program | Open-End Contracts | ### Invoicing - Transactions This report will show you transactions for an invoice period. The transactions are used to represent collections and returns/NSF and late fees collected. **Field Definitions** | Column Name | Definition | Example | | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------- | | Acct # | Seven character random account number uniquely assigned by our system. Accounts can contain multiple contracts, subscriptions and POS transactions | ABC1234 | | Applicant | Name of the primary applicant / account holder | John Doe | | Card Type | Specific card type - (VISA, MASTERCARD, DISCOVER, AMEX) | VISA | | Fees | Amount of the payment applied to fees | 0.00 | | Interest | Amount of the Payment applied to Interest | 10.00 | | Loan # | Accounts can have multiple loans. The loan number is a build on the account number (ACCT#LOA##) | | | Location | Location where account was originated | Kansas City | | Merchant Ext ID | Unique ID assigned by you and given to us during the origination process, or via a data update. This is critical when linking data back to other systems like Accounting Software or Fulfillment/ERP systems | Student Number, Patient Number, Merchant Number as some examples and length and type can vary widely by the merchant. | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | PMT Amt | Amount of payment made | 198.00 | | PMT Processed | Date Payment was Processed - Counted towards balance | 11/10/2017 | | Principal | Amount of the Payment applied to Principal | 180.00 | | Program | Name of your program | Open-End Contracts | | Transaction ID | Unique ID for this Transaction | 1234567 | | Type | Various types to further define payment types or adjustments | PMT - ACH | ### Invoicing - Transactions - Pct of Collections This report will show you transactions for an invoice period. The transactions are used to represent collections and returns/NSF and late fees collected, with additional servicing portfolio information. **Field Definitions** | Column Name | Definition | Example | | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------- | | Acct # | Seven character random account number uniquely assigned by our system. Accounts can contain multiple contracts, subscriptions and POS transactions | ABC1234 | | Applicant | Name of the primary applicant / account holder | John Doe | | Card Type | Specific card type - (VISA, MASTERCARD, DISCOVER, AMEX) | VISA | | Fees | Amount of the payment applied to fees | 0.00 | | Interest | Amount of the Payment applied to Interest | 10.00 | | Loan # | Accounts can have multiple loans. The loan number is a build on the account number (ACCT#LOA##) | | | Location | Location where account was originated | Kansas City | | Merchant Ext ID | Unique ID assigned by you and given to us during the origination process, or via a data update. This is critical when linking data back to other systems like Accounting Software or Fulfillment/ERP systems | Student Number, Patient Number, Merchant Number as some examples and length and type can vary widely by the merchant. | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | PMT after Servicing Fee | Payment amount - UAS Servicing Fee - UAS Merchant Fee for completed payments if the ToT SAS for the payment has a servicing fee percent. | 0.00 | | PMT Amt | Amount of payment made | 198.00 | | PMT Processed | Date Payment was Processed - Counted towards balance | 11/10/2017 | | Principal | Amount of the Payment applied to Principal | 180.00 | | Program | Name of your program | Open-End Contracts | | Servicing Fee % | Servicing Fee % on the ToT - SAS when the transaction was processed. | 0% | | Servicing Fee Amt | Payment amount times UAS Servicing Fee % for complete payments with a servicing fee percent on the time of transaction service and assignment setting. | 0 | | Transaction ID | Unique ID for this Transaction | 1234567 | | Type | Various types to further define payment types or adjustments | PMT - ACH | ### Invoicing - Account Summary This report shows you all accounts in your servicing portfolio for an invoice period. The AutoPay Type will inform you if the account had or did not have a recurring payment. **Field Definitions** | Column Name | Definition | Example | | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------- | | Acct # | Seven character random account number uniquely assigned by our system. Accounts can contain multiple contracts, subscriptions, and POS transactions | ABC1234 | | Applicant | Name of the primary applicant / account Holder | John Doe | | AutoPay Type | If enrolled in autopay it will be (CHECKING, SAVINGS, VISA, MASTERCARD, DISCOVER). If not enrolled, then the type will be (NONE) | NONE | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | Loan# | Accounts can have multiple Loans, the Loan number is a build on the Account Number (ACCT#LOA##) | ABC1234LOA01 | | Location | Location where the account was originated | Kansas City | | Merchant Ext ID | Unique ID assigned by you and given to us during the origination process, or via a data update. This is critical when linking data back to other systems like Accounting Software or Fulfillment/ERP systems | Student Number, Patient Number, Merchant Number as some examples and length and type can vary widely by the merchant. | ### Invoicing - Letters Total letters that were mailed to consumers. **Field Definitions** | Column Name | Definition | Example | | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------- | | Acct # | Seven character random account number uniquely assigned by our system. Accounts can contain multiple contracts, subscriptions, and POS transactions | ABC1234 | | Applicant | Name of the Primary Applicant / Account Holder | John Doe | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | Contract # | Accounts can have multiple Contracts, the Contract number is a build on the Account Number (ACCT#LOA##) | | | Delivery Method | Letters can be sent either Stand-Alone or Insert. Stand alone is a letter sent individually and an inserted letter is sent along with a statement or other document. | Stand alone | | Letter | Combination of contract number, type of letter and date specific to request | ABC1234LOA01-ppl-2017 | | Location | Location where the account was originated | Kansas City | | ABC1234LOA01 | | | | Merchant Ext ID | Unique ID assigned by you and given to us during the origination process, or via a data update. This is critical when linking data back to other systems like Accounting Software or Fulfillment/ERP systems | Student Number, Patient Number, Merchant Number as some examples and length and type can vary widely by the merchant. | | Program | Name of your program | Open-End Contracts | | Requested Date | Date the letter was Requested | 2017-10-11 | | Type | Type of letter requested | Privacy Notice | ### Invoicing - Misc Charges All Miscellaneous Charges on your invoice. **Field Definitions** | Column Name | Definition | Example | | -------------- | ------------------------------------------------------------------------------ | ------------------ | | Amount | Amount of charge applied to invoice | 300.00 | | Client Invoice | Set of letters and numbers generated to uniquely identify the merchant invoice | 521C-6E8X4-1017 | | Program | Name of your program | Open-End Contracts | | Type of Charge | Description of charge applied to invoice | Buyback | ## FAQs ### How do I obtain more than six months of invoices? We make the last six months of invoices available in our portal. However, if you need access to older invoices, please contact Client Success :888-842-2461. ### Why is my first invoice negative? There is a **New Account Load** fee for all new accounts added to UAS for servicing. We also have a monthly minimum servicing fee. When you first start, you are originating new contracts that will not be due for payments for at least 30 days. UAS will have servicing fees for the new accounts but no payments will have been collected from consumers resulting in a negative balance. Please do not worry about remitting payment for your first month. We will deduct the fees from the next month's payments collected. ### What do each of the line items mean on the invoice? Please refer to the "How to Read Billing Invoice" PDF that is available at the start of this article. ### Why am I paying for servicing and load fees on new contracts? Load fees cover the use of our platform and the cost to process credit applications and electronic signatures. Servicing fees cover sending statements, notices, and taking/making calls. We do not have a monthly license or individual license fee, rather we assess fees based on usage. ### Why is there a minimum monthly payment? All accounts have a standard monthly payment that is due to UAS. That is what it costs for us to maintain your account every month. Once you have a few loans serviced you will be over that minimum amount. ### Merchant Payments Received You will need your **Invoicing- Transactions** report. Use Column I (Type) to sort for only PMT types that contain the word "Merchant". Highlight Column J (PMT Amt), summarized amount will match the total of payments reported to UAS ## Use Reports for Details of Billing Invoices ### Access Invoice PDF and Reports To balance fields on a merchant's invoice and to ensure all charges and amounts are correct, you must first access your invoice. Finding any of the fields below will start the same way: 1. Go to uportal and select “Invoices” and download the invoice that matches the invoice you are searching for with the invoice under the “Name” column. 2. Still in uportal under the reports tab go to the type of report you are trying to run 3. Invoicing- Transactions 4. Invoicing- New Accounts 5. Invoicing- Account Summary 6. Invoicing- Letters (If the message "No Reports Found" appears then there were no charges for "Letter Found" and "Letter Received") 7. Invoicing- Misc Charges (If the message "No Reports Found" appears then there were no deductions for "Miscellaneous") 8. Select the drop-down menu for the billing period you are verifying (Save as CSV, convert to XLSX if you want) Multiple Invoices Reports provide details for all invoices. If you have multiple programs, your reports will contain details for multiple invoices. Use the first column "Merchant Invoice" #### Excel Tips & Tricks To verify your invoices, it's helpful to know a few tools in Excel. These features will be a reference in the verification details. **Apply Data Filter to Sheet** - An easy way to sort data is to apply a data filter to the entire sheet. Use "ctrl + a" or click on the arrow between Column A and Row 1 to select the entire sheet. Then go to the **Data** tab and select **Filter**. Now every column in the sheet will have a drop-down arrow that will allow you to sort by that column or apply quick filters. #### Summarize Data * If you filter a row, as you apply a filter it will count the rows * If you highlight an entire column (click on "A" as an example) excel will count rows and if the field is numeric it will summarize the values. This is easy want to see totals without having to add a summary formula * Please note, this will provide a total count for any cell with a value entered, including the header. For example, if you are attempting to confirm the total *number* of transactions, the count will include the header of the column into the total count provided. * Pivot Tables - a bit more advanced, but provides an easy way to summarize data by group and subgroups ### Verify UAS Payment Details #### Payments Received You will need your **Invoicing- Transactions** report. 1. Sort by Column P (Invoice PMT Detail) to only show "Payments Received" 2. Highlight Column J (PMT Amt), summarized amount will match total of payment received 3. Further sort by Column Q (AutoPay) - If this field is none, consider this the same as without recurring payment 4. None = w/o Rec Pmt 5. Any other value = Rec Pmt #### Return Payment: Follow the same steps for Payment Received, but select to sort Column P (Invoice PMT Detail) to show "Returned Payment (NSF)", “Refund” and “Invalid”. #### Late Charges- On Merchant Payments Received or Late Charges- On UAS Payments Received Remove all other data sorts. Sort Column K (Fees) for any value not equal to \$0.00. Use Column I (Type) to determine if payment was received by the merchant or UAS. If the type contains "Merchant" then it will be counted in the merchant payment received category. #### Refund: Follow the same steps for Payment Received, but select to sort Column P (Invoice PMT Detail) to only show "Refund" ### Verify Billing Charges #### New Account Load You will need your **Invoicing- New Accounts** report. 1. Highlight Column D (Acct #) - The summarized amount will match the quantity. Likely you will not need to download this report to see the total. You can see it in the count on the report in uPortal360. #### Accounts with Recurring Payments You will need your **Invoicing- Account Summary** report. 1. Sort by Column H (AutoPay Type) **not equal** to NONE. 2. The sort amount in the bottom left of Excel will display the quantity. #### Accounts without Recurring payments You will need your **Invoicing- Account Summary** report. 1. Sort by Column H (AutoPay Type) **equal** to NONE. 2. The sort amount in the bottom left of Excel will display the quantity. #### Recurring Payment % of Collections Using the values from above - Payments Received / Rec PMT - multiplied by the % collection fee per item will give you the total due. #### Without Recurring Payment % of Collections Using the values from above - Payments Received / w/o Rec PMT - multiplied by the % collection fee per item will give you the total due. ### Verify Pass-Through Fees Deducted #### Merchant Processing Fees- Credit You will need your **Invoicing- Transactions** report. 1. Sort by Column N (Card Type) for Visa, Mastercard, Discover. 2. Highlight Column J (PMT Amt) to see sum of dollars processed by these card types. #### Merchant Process Fees- Amex You will need your **Invoicing- Transactions** report. 1. Sort by Column N ( Card Type) for American Express. 2. Highlight Column J (PMT Amt) to see sum of dollars processed by this card type. Special Merchant Account Needed to Process AMEX - Not a Standard Offering #### Letter Mailed: You will need your **Invoicing- Letters** report. 1. Sort by Column J (Delivery Method) = Stand Alone. 2. Count of the Data Sort will show the quantity of letters mailed. #### Letter Inserted: You will need your **Invoicing- Letters** report. 1. Sort by Column J (Delivery Method) = Inserted. 2. Count of the Data Sort will show the quantity of letters mailed. #### Average Portfolio Billing Average Portfolio Billing is similar to an investment management fee which is defined as an annual percentage in your agreement. UAS billing is done monthly. To calculate your monthly portfolio fee, we first take the annual percent and divide by 12 months to find the monthly percentage. We then multiply that value by the average principal balance of your portfolio (which is the average between the beginning balance and ending balance for the invoice month). ### Additional Deductions (if applicable) #### Miscellaneous You will need your **Invoicing- Misc Charges** report. #### Buybacks Buybacks are the result of contract balances that are cancelled, adjusted, or when a condition within the Merchant’s repurchase obligation occurs. Buybacks are required to be repurchased by the Merchant within ten (10) days of notice from UAS, and no later than three (3) days upon receipt of invoice from UAS unless alternate arrangements are agreed to. The buyback lifecycle is managed by the Merchant Performance and Financial Program Services teams. The performance of buyer and merchant portfolios is dependent upon the ability to identify and resolve all unpaid buybacks in a timely manner. #### Total Monthly Advances **Code Logic - How Data is Summarized** | Client Payments Received | Paid to Client | Returned to Client | Additional Details | | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------ | | Payments Reported to UAS | The sum of related transactions to the invoice where the type begins with `PMT - To Client` and the amount is **greater**than zero | The sum of related transactions to the invoice where the type begins with `PMT - To Client` and the amount is **less**than zero | | | Down Payments Reported to UAS | The sum of related transactions to the invoice where the type begins with `Down Payment - To Client` and the amount is **greater**than zero | The sum of related transactions to the invoice where the type begins with `Down Payment - To Client - Refund` and the amount is **less**than zero | | | UAS Payment Details | | Additional Details | | --------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Payments Received | The sum of related transactions to the invoice where the type begins with `PMT -`, `Down Payment` and the amount is **greater**than zero | This row **EXCLUDES**transactions where types:`PMT - To Client` ,`Down Payment - To Client` , `PMT - NSF`, `PMT - ACH - Invalid Trans`, `PMT - Check - Not Deposited`, `PMT - Charge Back`, `PMT - Pre-Charge Back` , `PMT - ACH - Invalid Trans` , `PMT - Refund`, `PMT - Partial Refund` , `PMT - Mass Refund`, `Down Payment - Refund` and `Down Payment - Charge Back` | | Returns / Refunds / Invalid | The sum of related transactions to the invoice where the type begins with `PMT -` , `Down Payment` and the amount is **less**than zero | This row **INCLUDES**transactions where types: `PMT - To Client` ,`Down Payment - To Client` , `PMT - NSF`, `PMT - ACH - Invalid Trans`, `PMT - Check - Not Deposited`, `PMT - Charge Back`, `PMT - Pre-Charge Back` , `PMT - ACH - Invalid Trans` , `PMT - Refund`, `PMT - Partial Refund` , `PMT - Mass Refund`, `Down Payment - Refund` and `Down Payment - Charge Back` | | Staged Amounts | | Additional Details | | ---------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Staged Payout | The sum of the field `Staged_Payout_Payment__c` on assignment transactions related to the invoice | | | Staged Payout Interest | The sum of the field `Staged_Interest_Merchant_AT__c` OR `Staged_Interest_Buyer_AT__c` on assignment transactions related to the invoice | If the invoice is a **merchant**invoice, the code will use the field `Staged_Interest_Merchant_AT__c`. If the invoice is a **buyer**invoice, the code will use the field `Staged_Interest_Buyer_AT__c`. The invoice is considered a **merchant**invoice if the SAS on the `Client Invoice Merchant` record related to the assignment transaction is the same as the SAS on the invoice for which the data is being summarized.The invoice is considered a **buyer**invoice if the ToT - SAS on the consumer transaction related to the assignment transaction is the same as the one on the invoice for which the data is being summarized. | | Billing Charges | Quantity | Fee Per Item | Additional Details | | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- | | New Account Load | The number of contracts related to the client invoice `ci.Loans__r.size()` | `Fee_New_Account_Load__c` | | | Accounts with Recurring Payments | The number of Statements related to the invoice with the field `EOM - AutoPay Type` not equal to null OR not equal to “NONE”The number of Subscription Invoices related to the invoice with the field `EOM - AutoPay Type` not equal to null OR not equal to “NONE” | `Fee_Accts_with_Recurring_PMTs__c` | The logic counts STMTs and Subscription Invoices. In the case of a subscription invoice, there will not be statements related to the Client Invoice. | | Accounts without Recurring Payments | The number of Statements related to the invoice with the field `EOM - AutoPay Type` equal to null OR equal to “NONE”The number of Subscription Invoices related to the invoice with the field `EOM - AutoPay Type` not equal to null OR not equal to “NONE” | `Fee_Accts_without_Recurring_PMTs__c` | The logic counts STMTs and Subscription Invoices. In the case of a subscription invoice, there will not be statements related to the Client Invoice. | | Recurring Payment % of Collections | The total amount for all transactions that have they field `AutoPay_Type__c` populated | `Fee_Recurring_PMT_Pct_of_Collections__c` | The logic **EXCLUDES**payment types `PMT - To Client`, `Down Payment - To Client`, `Down Payment - To Client - Refund` | | Without Recurring Payment % of Collections | The total amount for all transactions that have they field AutoPay\_Type\_\_c **NOT**populated or equals to `NONE` | `Fee_WO_Recurring_PMT_Pct_of_Collections__c` | The logic **EXCLUDES**payment types `PMT - To Client`, `Down Payment - To Client`, `Down Payment - To Client - Refund` | | Average Portfolio % (Annual) % (Monthly) | (Sum of the field EOM Principal Balance from the STMTs related to the invoice **PLUS**Sum of the field EOM Principal Balance from the STMTs related to the previous invoice) divided by 2 | `Fee_Avg_Portfolio_Pct__c` / 12 | | | Late Fees | Sum of all payments applied to fees | \`Fee\_Late\_Fee\_Retained\_by\_ | | | Pass Through Fees Deducted | Quantity | Fee Per Item | Additional Details | | ------------------------------- | ------------------------------------------------ | ------------------------------------------ | -------------------------------------- | | Processing Fees - Credit Cards | The sum of all credit card transactions | `Fee_Merchant_Processing__c` | This row **EXCLUDES**AMEX transactions | | Processing Fees - AMEX | The sum of all **AMEX** credit card transactions | `Fee_Merchant_Processing_AMEX__c` | | | Processing Fees - Check and ACH | The sum of all ACH and Check transactions | `Fee_Merchant_Processing_Check_and_ACH__c` | | | Letter Mailed | Total number of letters mailed | `Fee_Letter_Mailed__c` | | | Letter Inserted | Total number of letters inserted | `Fee_Letter_Insert__c` | | | ACH and Return Payment | Number of checks and ACH returns | `Fee_Return_Check_or_ACH_Per_Item__c` | | | Chargeback | Number of chargebacks transactions | Fee\_Chargeback\_Per\_Item\_\_c | |