USD bank account won't reconcile but all transaction are posted. How do I resolve this?

Hello robyn-godfrey-4c

Thanks for joining the Community.

Please perform a currency revaluation to check for any discrepancies being caused by this. To do this, click the Cog > Currencies > Select the drop-down beside the currency > Revalue currency. A journal entry will be created by the system for this; if that doesn’t fix the balance on your reconciliation report, you can then delete the journal entry.

Thank you! I've given this a go and nothing seems to have changed. I can't see that a journal has been created either. 

Thanks robyn-godfrey-4c, what amount is the discrepancy different on your reconciliation report? To double-check if the journal entry was created, please view the Exchange Gain or Loss account in your Chart of Account (select Run report in the action column to view recent entries). :)

The discrepancy is over $10K. Doesn't look like a journal entry has been created.

Thanks so much.

Thanks robyn-godfrey-4c, in this case, please double-check that the opening balance has been posted correctly for the USD bank account. To do this:

1. Go to Bookkeeping and select Chart of accounts (Take me there).
2. Find the account and select Account history from the Action column.
3. Search for an opening balance entry. In the Payee Account column, it should say Opening Balance Equity or Retained profit balance forward, and in the Memo column, it should say Opening Balance.

If you see an opening balance entry, take note of the date and amount then use your bank statements to make sure this is correct. The status of the opening balance should should as 'R' in the tick column. If this doesn't show as R (reconciled), click the transaction to expand and then select the box in the tick column until you see an R and then save. 

If you don't have an opening balance for the account and need to enter one, you can follow the steps listed here to create a journal entry that will post this.