Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
I'm having trouble recording transactions that I need for my business. I have set up customers (these are people that rent a booth in my store). I need to show the following transactions:
1. Booth rental that they owe me.
2. Payout to the customers for sales they made in the store.
I typically subtract their booth rent from the sales they made and then either pay them the difference or they owe me the difference if they didn't make sales to cover the booth rent. I don't have an issue when the customer owes me. I create an invoice and it's pretty straightforward.
My problem is when I owe the customer for sales after I've taken out their rent. I cannot find a way to show these transactions so that I can reconcile my bank account for the payment against the customer transaction. I tried using a credit memo, but then I can't match the bank payment to that credit memo to zero it out. I need to show that this payment transaction goes to my COGS account as it is money I have collected for the customer and am now just paying him out from those sales.
I hope this isn't too complicated. It seems like I should be able to do something like this in QBO, but I've spent many days on this, trying different things and I can't get it to work out.
Thanks,
Rhonda
It’s nice to see you in the Community, @Craftygal75.
I appreciate the detailed information about your concern. Based on the scenario, you’ll have to record a refund to your customer using Check and use the COGs account. This way, it will properly be recorded and reduce your bank's balance, and offsets/ paying the customer's prepayment. Let me show you how.
Step 2: Link the refund to the customer's credit.
For detailed steps, click this article: Record a customer refund in QuickBooks Online.
Once done, you can now record a bank deposit, so you can match it in the bank register. For more information, check out these resources:
When you're ready to assess your business financials, you may consider checking out this article: Reconcile an account in QuickBooks Online. This contains a video tutorial and tips on how to fix any issues during the reconciliation process.
In addition, you can run the Transactions List by Customer report in QuickBooks Online. This will show you the list of income and expense transactions grouped by customers. Just go to Reports and open the Transactions List by Customer report.
Please don't hesitate to tag my name in the comment section below if you need further assistance. I'd be happy to help you succeed. Take care and have a blessed day!
@JoesemM thanks for trying to help me! I think I need to start at the beginning. Not sure I'm using the accounts correctly.
1. The deposit from the store comes through in my checking account - where should I categorize this deposit?
2. When adding the category to the first line of the check, you say to use an A/R account, but the A/R account doesn't show up as a choice that I can use. Is this because I'm not linking the deposit correctly in my checking account?
I actually have no idea if I have any of my accounts set up right! I'm so confused!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here