Streamlining Supplier Payout Process in QBO
I want to be able to streamline how I post supplier bill and/or expenses (i.e., "pay outs") that consist entirely of deposits collected from customers/payors each month. Is that possible from the banking downloads screen? Or is this a rule I need to set up and somehow get it configured that QBO will let me post bills to specific suppliers that total the amount of the deposit transaction (for which there is no posted transaction such as an invoice or sales receipt to match to)?
More background:
I have a situation where I receive multiple deposits from various customers/"payors" that are booked as revenue in the aggregate but then also broken out and paid to individual suppliers/"T4A independent contractors" whose bills to me effectively total the deposit from each customer.
Process (in real life):
- Contractor sells something to third party and earns a commission ((interchangeablly referred to as payouts, amounts, commissions, etc).
- My customer/payor calculates calculates total commissions on a monthly basis to be paid out.
- My customer/payer sends ME the money as a single deposit
- I receive the deposit in my bank and via downloads post these deposits from each customer/payor to a revenue account
- I then use information provided to me by the contractors to reconcile against the customers/payors deposits how much of each deposit belongs to each contractor (i.e., gross payout) LESS a % that I deduct to arrive at a net payout
- I import into QBO a journal entry that each contractors' net payout for the month, debiting an expense account and crediting QBO's catch-all A/P account.
- Those contractors who have reached a certain threshold I write cheques for and payout, while those that haven't I hold until they have OR to the end of a calendar quarter when I clear out all contractor accounts (to avoid carrying the liabilities too far into the future).
So I'm in the middle essentially, if that makes it easier. , as I take a "cut" of each deposit for corporate expenses I bear for the group of individual suppliers on their behalf.
I get the feeling I'm either overcomplicating in my mind how I could streamline this (so as much as possible is automated via entry directly into QBO) or QBO simply can't do this -> post a deposit that's revenue from a customer while simultaneously supplier posting bills (or expenses) which each is a % of the deposit amounts (either %A or %B depending on what was sold to generate the amount paid out to me from the customer - information that has a bit of a delay before I find it out; from one week to 1-2 months). I'm aware of (although not super comfortable) with double-sided items but thinking about it now it might also work, since it's simply a flip of the process; I find out the expenses/bills' breakdown first, upload them at end of month, but mark them as billable to a customer with the amount matching the deposit amounts... maybe. I'd need a more advanced QBO user/expert to walk me through how that would work if it even can!).
Thanks for taking the time to read, review and (hopefully) respond! Definitely appreciated!
