Streamlined Payment Process: New CSV Summary Report for Agent Payments
To streamline the process of managing agent payments and reduce the need for manual entry, we propose creating a CSV summary report by deposit. This report should include the following details:
- Deposit Number
- Agent Name
- Address
- Agent Net Amount
- Outside Referrals
- Deductions
- To be Paid/Paid
By consolidating this information into one document, it will significantly expedite the AE entries and ACH payments. An additional benefit would be the ability to import this type of file directly into AE, bypassing the need for manual data entry.
This summary report will serve as a comprehensive reference, allowing for quick verification and processing of agent payments, ensuring accuracy and efficiency in financial management.

-
Allyson Matlock commented
Being able to move our commission funds into multiple accounts is very important and aligns with the KW teachings. We need to walk the walk if we're going to talk the talk as a major brokerage!
-
Jennifer Goetz commented
There needs to be a change to way deposits are made with the current accounting software. The way the current software works makes practicing the concept profit first difficult. Our MC is no longer allowing commission checks to be deposited into more than one bank account. Mainly because the software doesn't allow more than one account to be stored at a time. Although, this is new software, this is an antiquated practice. I've never met accounting software or payroll software that did not allow for multiple bank accounts. We need a minimum of 2 for business and tax, but I do not believe it should be limited.
-
There needs to be a change to way deposits are made with the current accounting software. I have heard the Gary and others speak about the Profit First method of running your real estate business. However the way the current software works makes practicing that concept impossible. Our MC is no longer allowing commission checks to be deposited into more than one bank account. Mainly because the software doesn't allow more than one account to be stored at a time.
-
Danielle Buchbinder commented
My MC is no longer permitting agents to split commission into multiple direct deposit amounts due to the extra steps needed to enter this info manually. Although I have voted for this existing idea, I actually feel that more than a CSV file, a software change is in order. For each agent, the system should allow administrators to enter more than one bank account & specify the amount distribution amount for each account (flat or %). There should not just be a single field that needs to be manually, or even automatically changed. This would save time for admins & ensure accurate info.
-
Michael O'Brien commented
We absolutely need to have a list of the to be paid amounts for agents. This used to be in the the DPXXXXACH file that saved from winmore and uploading payroll has become much more tedious without it.
-
Clarinda Etheridge commented
Oh PLEASE!
-
Aimee Ventress commented
Definitely need this!
-
[Deleted User] commented
We would like a CSV summary report by deposit that lists out agents that need to be paid or have been paid. This should include the DA #, Agent Name, Address, Agent Net Amount, outside referrals, and deductions. Having to refer to one document instead of each DA would be a huge time saver with AE entries and ACH payments. A huge bonus would be to import this type of file in AE, bypassing manual entry.