Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I post the daily sales invoices from Clover into QBO and have a product called discounts. This posts to a contra income account. I must have the discount on the invoice so that sales tax will be accurate. So, the sales are reduced by the amount of the discount.
Then when the merchant bankcard service withdraws funds from my checking account to cover the discount, I am forced to once again post this to the discount given account, thus duplicating the reduction in revenue.
How do I solve this problem? A journal entry between discount revenue and sales cannot happen because a debit to the discount revenue increases it's balance, not reduce it. I need to post a credit to sales, obviously. It's like a one-sided entry is needed. I'm stumped with this one.
What should be able to happen is that I can match the payment out of my checking account to a sales invoice, but of course nothing comes up because QBO is looking for a bill or expense.
Thanks for your help with this.
Hello, KSW2022.
I appreciate the detailed scope of the issue at hand. I'll ensure you'll be able to record your sales invoices with the discounts properly in QuickBooks.
Given that the daily sales invoice is recorded correctly with the discount, let's create an expense entry to account for the discount coverage. Simply click on the + New button then select Expense.
Select the account where you want to track the discount coverage under CATEGORY. Then, enter the coverage amount under AMOUNT.
If you're unsure what account you need to select, I would recommend consulting an accountant. This way, they'll ensure your books are accurate and correct.
Then, match the payment with the expense entry in the Banking page.
Although, another option would be is to exclude the discount coverage (the merchant bankcard service withdrawal) from the Banking page. Then, manually clear the sales transaction in the bank register within QuickBooks.
To exclude the transaction from the Banking page, simply check the payment record, then click Exclude.
Then, let's clear the sales transaction entry in the bank register:
After ensuring all of your entries are correct, you can reconcile your bank account. If ever you need help in the future, check out this article for a guide: Reconcile an account in QuickBooks Online.
If you have any other concerns regarding your sales transactions, let me know and I'll gladly help you out. I'll also cover topics such as reports, entering other records, and managing your lists.
Thank you for the reply.
Your suggestion, if I am understanding it correctly, would add an additional expense, which is what I don't want to do. I need to be able to match the payment to merchant bank with the invoice that has the discount on it.
because the payment can only be matched to an expense, that won't work. I cannot exclude the payment as I need it to balance my cash, so there is my issue. how do i record the payment without creating a duplicate expense?
Good afternoon, @KSW2022.
Thanks for coming back and asking more questions about your problem.
If you don't want to create a new expense, I'd recommend consulting with your accountant to be sure what would be best for your business. They'll be able to give you some advice on what you'll need to create to record these details successfully and correct for your books.
Keep us updated on how the conversation goes with your accountant. It's my priority that you're able to put this in your QuickBooks account properly. Take care!
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