Thanks for the prompt reply, @Car1Dan1.

You can manually calculate the collection commissions, interest, and fees, and enter them as line items on your invoices in QuickBooks Online (QBO). Let me elaborate on how to achieve this below.

Currently, there's no feature in QBO that automates the calculation of your pay overs to clients. As a workaround, let's use a service item to track them properly and record your income accurately. Here's how:

1. Go to the Gear icon and select Products & services.
2. Click New, then select Service.
3. In the Name field, enter the item name.
4. Specify the account to track it. If you're unsure what to choose, reach out to your accountant for further guidance.
5. Leave the Sales price/rate field blank, as the calculations may vary each time you record an income. Then fill out the rest of the fields.
6. Select Save and close.
   
   

Repeat the same steps for interest and fees. Once done, add them to your invoices, and be sure to input a negative amount for the collection commission, as it is a deduction from your income. Here's a sample screenshot below of how it appears on the invoice:

Regarding your concern about importing your current clients, yes, you can seamlessly import them using an Excel (XLS/XLSX) format. However, before importing, please review the guidelines in the Things to know before you import contacts from Outlook, Excel, or Gmail section of this article to ensure that your file is formatted correctly: Import customers or suppliers from email contacts to QuickBooks Online. If your Excel file is already accurate, follow the steps in the Import your contacts section.

You can also refer to these articles for more information about importing data in QBO:

• Which contact fields are imported from Excel?
• Common questions about importing data to QuickBooks Online

Moreover, you can visit these articles that outline how to personalise the look of your invoices to match the branding of your company and record invoice payments to keep correct financial records:

• Customise invoices, quotes, and sales receipts in QuickBooks Online
• Record invoice payments in QuickBooks Online

Should you require further assistance recording your income transactions, please notify me by dropping a comment below. I'll be right here to help you at any time.