QuickBooks Help - Accounting for Item Returns

QuickBooks Help - Accounting for Item Returns

Member since 2019 · 15 posts · 3 votes

I'm new to QuickBooks and need assistance accounting for item returns. Here's an example of what I'm struggling with:

Let's say that on 5/27 I purchased an item at Home Depot for $10 which I assigned to a COGS category. My total expenses on the "Expenses" screen was $1,000 at that point. The next day, I returned that item to Home Depot. A few days later, I download bank transactions and this return/deposit shows up. I assign the deposit to COGS in order to offset the initial purchase on the P&L. However, this transaction does not show up on the "Expenses" screen. Instead of showing total expenses of $990, I'm still showing expenses of $1,000, which is not an accurate representation of my expenses, even though the P&L DOES balance.

I searched the Web and found that it is possible to assign the bank deposit to Accounts Payable (instead of COGS). Then, create an expense or check on the Expense screen and attach the deposit to it. This creates a credit transaction on the Expense screen. However, when I look at the chart of accounts, the whole thing is done via the Accounts Payable account. The initial $10 I charged to COGS is still sitting there. The Expenses screen balances, but the P&L does not.

What am I missing? Is there a way around this? For those of you who charge your rehab expenses for flips directly to COGS, how do you handle item returns to ensure they are appropriately reflected on the Expenses screen?

Thanks for your help.

0Reply
69 views

4 Replies

Jump to latestLatest
  • Gita FaustBusiness Member
    Accountant · Richboro - Philadelphia, PA · Member since 2008 · 908 posts · 247 votes
    7y
    1. Delete the Accounts Payable Transaction.
    2. Manually enter the credit -by creating a deposit using the name Home Depot and using the same account name you used to post the expense. 

    Are you using QuickBooks Online? 

    We have a love and hate relationship with Bank Feeds. 

  • Member since 2019 · 15 posts · 3 votes
    7y
    Originally posted by @Gita Faust:
    1. Delete the Accounts Payable Transaction.
    2. Manually enter the credit -by creating a deposit using the name Home Depot and using the same account name you used to post the expense. 

    Are you using QuickBooks Online? 

    We have a love and hate relationship with Bank Feeds. 

    Yes, I’m using QBO Plus. I did delete the AP transaction. It’s stupid and didn’t solve my problem. 

    I ended up doing exactly as you stated above. However, although the Bank Deposit posts to the P&L and everything is kosher there, it doesn’t post to the “Expense” screen. So, if I originally purchased something at Home Depot for $100, the Expenses screen shows my expenses for the year as $100. If I return that item and create a bank deposit for $100, the P&L is all good. I have an expense (debit) in, say, account COGS > Bathroom Fixtures for $100 which is then offset by a bank deposit that I indicated should hit COGS for $100 (credit). P&L impact is zero. HOWEVER, this does nothing to the “Expenses” screen. That original $100 expense is still there, it’s not offset by anything. So I’m still showing total expenses for the year as $100, when that’s not actually accurate. Make sense? I don’t think there’s a way around that.

    They should rename the “Expenses” screen to “Transactions” or “Journal” and everything should be posted there—debits and credits. 

    If there’s a workaround I’m missing, by all means let me know. :)

  • Gita FaustBusiness Member
    Accountant · Richboro - Philadelphia, PA · Member since 2008 · 908 posts · 247 votes
    7y

    I would have to look at the transactions to see what is wrong. Send you a message for more details. 

  • Real Estate Consultant · Norfolk, VA · Member since 2017 · 345 posts · 202 votes
    7y

    @Mauricio Duarte Based on how QBO is working right now, there's no way to get the deposit in the Expenses screen since it is limited to the transaction types below. Maybe in the future they will include a type called Vendor Refund, then that might work.

    What kind of information are you exactly looking for why are you running the numbers in the Expenses window instead of P&L details? Maybe there's an alternative way to get the information you need. 

Join the conversationCreate a free account to reply, vote on answers and follow this thread.