REFUND

Thanks for reaching out, Sandy. I can provide information that will help you with the refund process and handling of VAT for unfulfilled orders in QuickBooks Desktop for Mac. Let's get into the details below.

Regarding the credit memo you've created, it would help to know more about how you recorded it in your account. If it's only recorded in QuickBooks and no physical transaction was made (like issuing a check or processing a bank transfer), then this would explain why your bank balance remains unchanged. Alternatively, if the refund has already been processed externally, you can create a corresponding check or expense in QBDT.

On the matter of the original invoices, it is generally not advisable to do so. Deleting invoices can cause payments to become unapplied, leading to discrepancies in your accounting records. It removes any audit trail and does not accurately represent your business transactions, even for unfulfilled orders.

Instead, it is recommended to adjust the invoices to show 'No VAT'. This modification will ensure you are not required to pay VAT on products you never supplied, accurately reflecting that no taxable sale occurred. This method keeps your financial records intact while correctly addressing the VAT concern.

Since the invoice from February was already reconciled, issuing refunds will affect this previously closed period. New transactions, like refunds, will introduce changes into months already finalized.

To manage this, we can do a mini-reconciliation for the affected months of February and March. Carefully review these months again during your reconciliation process, ensuring that all new transactions and adjustments, such as refunds and credit notes, are included and correctly accounted for. This will help maintain the accuracy and integrity of your financial records.

Here's how you can do it:

1. Click the Banking menu and select Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. In the Statement Date, enter an off-cycle date between your last reconciliation and the next scheduled one.
4. In the Ending Balance field, input the balance from your previous successful reconciliation, then click Continue.
5. From the Reconcile window, check off the transactions you are fixing and re-reconciling.
6. Make sure the Difference field shows $0.00.
7. When everything looks good, select Reconcile Now.

For more details about the process, refer to this article: Reconcile previously deleted and re-entered checking or credit card transactions.

You can also consider consulting with your accountant before making any adjustments. They can provide personalized advice ensuring compliance with accounting standards and help you accurately address any discrepancies this situation may have caused in your financial reporting.

Lastly, you can use this article for reference to generate reports for your previously reconciled accounts in QBDT: Create reports in QuickBooks Desktop for Mac.

Feel free to return here if you have additional questions about refunding customers in QBDT for Mac. We'll ensure to help you right away. Take care, and have a good one.

Hello @SandyAfrica , below would be an simplified way to handle this situation for you.  

1.  Create a Credit Memo identical to your invoice (this will reverse your invoice)

2.  After recording the Credit Memo, go back to it to bring it up on screen

3.  In the top of the Credit Memo select the button for Refund

4.  This will open a Check for you offsetting against Accounts Receivable for your Customer creating the 'Refund' being paid back to them

5.  After you record the check, now go to Receive Payments

6.  When you select your customer you'll see the Check in there, plus a Credit amount from the Credit Memo

7.  Click the button to Apply Existing Credits and then save the Payment

8.  This will link the Credit Memo to the Check zeroing out Accounts Receivable balance and clear up everything for you.

Hope this helps.