Hi all,
I hate to do this but I believe we have some smart people here that can aid me with this hopefully.
I've tried the quickbooks community, my accountant and a friend that does auditing with no luck. The best answer I get is to do this as a journal entry. I do not want to do this everytime as a journal entry.
I'm currently moving an insurance agency I bought from a old book and general ledger system to quickbooks. It's been working great till now.
Here is my problem.
View attachment 2044
this is an image of my excel statement for the month of September.
In most cases I need to shoot a premium check to the insurance company and I just list the account/amount/ and customer job on the check till I get the total due.
The income shows up on the invoice I send to the customer, no problem.
The problem I have on this statement is that I have a check of $739 going back to Dean. And a premium check coming to me for $270.96 from the company.
The problem is I'm not currently writing a check of $214.64, $38.70 or $140.80 to the insurance company now, so I don't know how to balance Pauls account, Toms account and Calebs account.
I can always issue a credit memo which reflects the money going back to me and going out to the customer.
I very much appreciate the help.
I hate to do this but I believe we have some smart people here that can aid me with this hopefully.
I've tried the quickbooks community, my accountant and a friend that does auditing with no luck. The best answer I get is to do this as a journal entry. I do not want to do this everytime as a journal entry.
I'm currently moving an insurance agency I bought from a old book and general ledger system to quickbooks. It's been working great till now.
Here is my problem.
View attachment 2044
this is an image of my excel statement for the month of September.
In most cases I need to shoot a premium check to the insurance company and I just list the account/amount/ and customer job on the check till I get the total due.
The income shows up on the invoice I send to the customer, no problem.
The problem I have on this statement is that I have a check of $739 going back to Dean. And a premium check coming to me for $270.96 from the company.
The problem is I'm not currently writing a check of $214.64, $38.70 or $140.80 to the insurance company now, so I don't know how to balance Pauls account, Toms account and Calebs account.
I can always issue a credit memo which reflects the money going back to me and going out to the customer.
I very much appreciate the help.
Dislike ads? Become a Fastlane member:
Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)
Membership Required: Upgrade to Expose Nearly 1,000,000 Posts
Ready to Unleash the Millionaire Entrepreneur in You?
Become a member of the Fastlane Forum, the private community founded by best-selling author and multi-millionaire entrepreneur MJ DeMarco. Since 2007, MJ DeMarco has poured his heart and soul into the Fastlane Forum, helping entrepreneurs reclaim their time, win their financial freedom, and live their best life.
With more than 39,000 posts packed with insights, strategies, and advice, you’re not just a member—you’re stepping into MJ’s inner-circle, a place where you’ll never be left alone.
Become a member and gain immediate access to...
- Active Community: Ever join a community only to find it DEAD? Not at Fastlane! As you can see from our home page, life-changing content is posted dozens of times daily.
- Exclusive Insights: Direct access to MJ DeMarco’s daily contributions and wisdom.
- Powerful Networking Opportunities: Connect with a diverse group of successful entrepreneurs who can offer mentorship, collaboration, and opportunities.
- Proven Strategies: Learn from the best in the business, with actionable advice and strategies that can accelerate your success.
"You are the average of the five people you surround yourself with the most..."
Who are you surrounding yourself with? Surround yourself with millionaire success. Join Fastlane today!
Join Today