Can someone help w/offsetting earnings against advances? My new Rec total is correct, but the bills show as outstanding still....?

Hello, @llang1.

I'm happy to help you with offsetting earnings against advances, but I need a bit more detail as to what you're trying to accomplish. 

• Are you trying to setup payroll advances? 
• What are the outstanding bills toward?
• Can you provide a screenshot of what's happening?

By providing additional info and a screenshot, I can help determine what's going on and gather the steps to help you fix it. You may also want to check out this detailed response by my colleague about setting up employee advances and repayments.

I'll keep an eye out for your response.

Thanks for your help.  Further details: 

We have Reps that earn commissions as 1099 independent contractors, so I don't use the "Payroll" function. 

In 2019, this Rep was given two advances against future commissions; then in 2020, given another two advances.  Their "owed to the Firm" total of $5500 is correctly appearing as a receivable on the BS.  

On Feb 10, they earned commissions of $1890, so her "owed" total was reduced to 3610.  Then, on March 10, they earned commissions of 1764.65, leaving a total still owed of 1845.35.  This amount is showing correctly as a receivable on the BS. 

However, when I go to my Dashboard, I see this (attachment):  When I click on the "5 open invoices", four of them are the four advances she was given, that still are showing as outstanding.  Since we've offset earnings against those advances, the four advances should not still be showing as "overdue". 

Thanks for any suggestions how to resolve this.  

Thank you for the detailed information, @llang1.

You can record a barter transaction  for this scenario. First, create a barter account from the Chart of Accounts.

Here's how:

1. Go to the Gear icon, then select Chart of Accounts.
2. Click on the New button to create a new account.
3. Under the Account Type drop-down, select Bank.
4. Select Cash on Hand under the Deta
5. Enter the account name. (ex. Barter Bank Account)
6. Select Save and Close.

Then, create an invoice for the owed amount. When paying the invoice, deposit the amount to the barter account created. For the commissions, enter a bill and deposit the bill payment to the barter account as well.

For your detailed reference about this action, check out this article: Record a barter transaction.

You can also read this blog for additional information about tracking vendor commissions in QuickBooks Online.

Add a comment below if there's anything you need assistance with. I'm a post away to help. Have a good day!