Invoice voided + refund receipt issued, now I've a messed up number that doesn't tally, please help

if it is any helpful, I can find the 50% "unapplied" payment moved into the "Trade & Other Receivables" chart of accounts. 

Hello there,

Voiding the invoice detached your original 50% payment, creating an Unapplied Payment (credit). When you issued the Refund Receipt, it was recorded as a separate cash outflow (debit), resulting in a negative balance.

Link these two transactions to reset the customer balance to zero.

Here's how:

1. Click the + New button and select Receive payment.
2. Choose the Customer from the drop-down menu.
3. Ensure the Payment date matches the date you issued the refund to keep your reports accurate.
4. Locate the Outstanding Transactions section, where you will find the Refund Receipt you created.
5. Click the checkbox Refund Receipt.
6. Scroll down to the Credits section, where you will see the original 50% Unapplied Payment. Tap the checkbox for that to apply it against the refund.
7. Confirm that the Amount received field at the top now shows 0.00, as you are simply offsetting two existing entries.
8. Finish by clicking Save and close at the bottom right.

After saving, the balance will be $0.00, and both the unapplied payment and the refund receipt in their transaction list will display a status of "closed."

The Community is always here if you need anything else. 

Hi,

I can see the Unapplied payment in Credit Section.

But there's nothing in the Outstanding transaction that matches the customer name. And I confirmed I can see the refund receipt that I issued to the customer's name, the interesting observation this is the first refund receipt but it just continue from the original invoice, (e.g. the invoice was 1001, the refund receipt was 1002 for an example)

just attaching this specific customer transaction screenshot for clearly depicting my challenge.

Item is 8,900, he paid 4,450 which is being shown as "Unapplied", I issued a refund invoice of the paid 4,450 but now things do not tally.

Hi there, @uniqfidelity-gma. Thanks for keeping us updated.

The invoice that you voided will not appear in the "Refund Receipt" section because voiding an invoice removes its financial impact and sets its balance to zero. 

The "Outstanding Transactions" section displays only transactions with open balances, such as unpaid invoices or unapplied credits tied to the customer. 

Regarding the numbering of your customer's transactions, QuickBooks assigns transaction numbers in sequence. Transactions for a specific customer follow a consistent numbering pattern, regardless of the transaction type.

If you have any other questions or concerns, please reach out! I will monitor this thread for any updates you share.

Thanks, then can you show me how can I tally back the "unapplied" and my "refund" so the customer is reset to "zero"

I use the quickbooks test drive link to test out my scenario.

The situation of what I faced:

- Create invoice, record payment received

- Void invoice, then refund receipt issued

- This caused the problem of not tally the number

The other scenario I tested using the quickbooks test drive:

- Create invoice, record payment received

- Issue refund receipt, then only void invoice

- This do not cause issue to the customer account and all tally well

What can I salvage from the issue I am facing? or should I delete everything (though it left an undesirable audit trails which need explanation).

Hello, uniqfidelity-gma.

I appreciate you getting back on this thread. Let's work together to resolve this.

To ensure your customer has a zero balance, you can use the Journal Entry (JE) where you debit Accounts Receivable and credit the account from which you receive the cash payment from your customer. Please see the sample screenshot below for reference:

After creating the journal entry, delete the refund receipt to prevent double deductions from your bank, as we use the journal entry to record the refund receipt.

Then, link the Journal Entry to the Unapplied payment. This ensures your bank balance is accurate and updates the transaction status from unapplied and open to paid. Here's how:

1. Navigate to the + Create and choose Receive payment.
2. Select the Customer, then a Payment Method.
   
   
3. In the Deposit to field, choose the Account you credited in the journal entry (JE).
4. Under Outstanding Transactions, select the JE, then choose the Unapplied Payment in the Credit section.
   
   
5. Once done, click Record and close.

When creating a journal entry, I recommend consulting with your accountant for guidance and advice. They can ensure it is accurate and complies with accounting rules to avoid errors in your books.

Please let us know in the comments below if you have any additional questions. We're here to help.