Invoice is in USD. Payment received in INR in bank. ank account is reconciled. Still QBO showing amt overdue in clients tab. How can we link amount in USD with amt in INR

Hi there, @bhagyashree-adma.

I'd be glad to help you fix the outstanding amount that's showing in your Sales tab.

Base on the scenario you've shared, I can see that you need to correct the process from receiving the invoice payment to depositing it to your bank.

You'll need to create a clearing account. This will hold the A/R or A/P foreign currency transactions before depositing it into your bank account. Since you have already reconciled your bank, you'll need to unreconcile it. In this process, you may need to ask for assistance from your accountant. They will ensure that the account that has been assigned is correct.

Here are the highlights of the things you need to do to zero out the outstanding balances of your clients. I've added some screenshots to see how it should look like.

1. Redo the reconciliation- Undo and remove transactions from reconciliations in QuickBooks Online. Please refer toStep 2: Unreconcile a transaction.
2. Create a Clearing Account for the transactions with the USD amount on the Chart of Accounts page.
3. Redo the Invoice payment transaction. In the Deposit to field, assign it to the Clearing account you've made.
4. Transfer the funds from the Clearing Account to your actual bank. Don't forget to enter the amount you want to transfer.

Once done, you can proceed to match the transactions, please refer to the steps to this article: Categorise and match online bank transactions in QuickBooks Online.

I've also added this article for your future reference whenever you're ready to assess your business finances in QuickBooks: Reconcile an account in QuickBooks Online.

You can always tag my name in the comment section below if you need further assistance or questions. I'd be happy to lend a helping hand. Take care.