In my GST report is showing a deposit with the amount of 3 invoices overdue, but it also showing this invoice as sales, so it is duplicated in my GST report, what to do?

Hi jewellery_bright,

It sounds like a lump sum amount deposit related to the three invoices has not been matched to the Invoices correctly so it's duplicating the expected figures on your reporting. 

Typically, if you have received the payments either as lump sum or individual transactions in your Bank account, before adding this transaction to QuickBooks the first step is to ensure the Invoices related are recorded with a Receive Payment. This makes sure that the Invoice is to closed and mark it as paid. To do this you can get this done with the below steps:

1. Click the + New at the left panel.
2. Choose Receive Payment.
3. Select the name of the customer from the drop-down menu.
4. From the Outstanding Transactions section, select the invoice that you’d like to apply the payment.
5. Choose the payment method.
6. Enter the Reference no. and Memo if applicable.
7. You can either deposit the money to your transaction account or to the Undeposited funds account.
8. Hit Save and close.

As mentioned, this would close the invoices would change their status from overdue to paid and closed. The second step to avoid duplication, is if you use an active Bank Feed for sales and reconciliations purposes it would best to try and Match the newly create Received Payments to the bank transaction.

By Matching the deposit to the three Received Payments it would then correct the GST report as showing just the single amount received by the bank. Please note if the deposit related to Invoices is already been added to QuickBooks please go to your Reviewed section on the Banking tab, find the transaction then select Undo. This will allow you to then Match it again through the For Review section. To do this please use the steps below:

1. Select one of the bank transactions in the For Review section that is part of the invoice.
2. Select Find Match.
3. You will then be brought to the Match transactions page. Tick the Invoice that you want to match the transaction with. 
4. Select Save.

By following these steps, it will then assign the one deposit to the three Invoice now marked as paid and closed. Your reports will update and no longer show the duplicated amounts. For any assistance with these steps you can always contact us by clicking here.

Hope this helps, 

-Steven