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 theView 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.UAS Billing Invoice
Download PDF
View Billing Invoices - PDF
To see invoices you must have theView 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 theUAS 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 DefinitionsInvoicing - 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.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 DefinitionsInvoicing - 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 DefinitionsInvoicing - 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 DefinitionsInvoicing - Letters
Total letters that were mailed to consumers. Field DefinitionsInvoicing - Misc Charges
All Miscellaneous Charges on your invoice. Field DefinitionsFAQs
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 UASUse 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:- 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.
- Still in uportal under the reports tab go to the type of report you are trying to run
- Invoicing- Transactions
- Invoicing- New Accounts
- Invoicing- Account Summary
- Invoicing- Letters (If the message “No Reports Found” appears then there were no charges for “Letter Found” and “Letter Received”)
- Invoicing- Misc Charges (If the message “No Reports Found” appears then there were no deductions for “Miscellaneous”)
- Select the drop-down menu for the billing period you are verifying (Save as CSV, convert to XLSX if you want)
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.- Sort by Column P (Invoice PMT Detail) to only show “Payments Received”
- Highlight Column J (PMT Amt), summarized amount will match total of payment received
- Further sort by Column Q (AutoPay) - If this field is none, consider this the same as without recurring payment
- None = w/o Rec Pmt
- 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.- Highlight Column D (Acct #) - The summarized amount will match the quantity.
Accounts with Recurring Payments
You will need your Invoicing- Account Summary report.- Sort by Column H (AutoPay Type) not equal to NONE.
- 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.- Sort by Column H (AutoPay Type) equal to NONE.
- 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.- Sort by Column N (Card Type) for Visa, Mastercard, Discover.
- 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.- Sort by Column N ( Card Type) for American Express.
- Highlight Column J (PMT Amt) to see sum of dollars processed by this card type.
Letter Mailed:
You will need your Invoicing- Letters report.- Sort by Column J (Delivery Method) = Stand Alone.
- Count of the Data Sort will show the quantity of letters mailed.
Letter Inserted:
You will need your Invoicing- Letters report.- Sort by Column J (Delivery Method) = Inserted.
- Count of the Data Sort will show the quantity of letters mailed.