cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
reporting-tvminc
Level 1

Where is the payment column, wherein we could apply partial payment to a bill when we click find match then foreign currency?

 
1 Comment 1
MelroseV
QuickBooks Team

Where is the payment column, wherein we could apply partial payment to a bill when we click find match then foreign currency?

Welcome to the Community, @Reporting.

 

Let me share some insight about how you can match your partial payment to your bill and your foreign currency.

 

Before we can see the payment column, let's make a dummy bank account to facilitate the movement between the two different foreign currencies. Here's how to do it:

 

  1. Go to the Gear icon, then select Chart of Accounts.
  2. Click New.
  3. Under the Account Type column, choose Cash and cash equivalent. In the Detail Type column, select Cash on hand. Lastly, in the Name column, type in the dummy bank account you created.

 

Once done, let's proceed to record your payment.

 

In the Pay bills page, set the Payment account field to Dummy Bank. Before saving the transaction, take note of the home currency (SGD) amount displayed at the bottom right. For example, I received USD 1000 payment for the bill, and this gives me CA 1382. Next, we’ll have to transfer this CA 1382 from EUR bank account to the Dummy Bank.

  1. Select + New.
  2. Select Transfer.
  3. Under Transfer Funds From column, select EUR Bank from the drop-down arrow.
  4. Under Transfer Funds To, select Dummy Bank from the drop-down arrow.
  5. Under the Currency column, select SGD from the drop-down arrow.
  6. Under the Transfer amount column, type in 1382
  7. Under the Exchange rate, the exchange rate will automatically appear. You can manually change the rate.

 

Then, here's how to match your partial payment to your bill and foreign currency. Please follow these steps:

 

  1. Go to the Banking menu and select the tile for the account you want to review.
  2. Go to the For Review tab, then find and select the downloaded transaction you want to match.
  3. Click the Find other matches button.
  4. Toggle between the Home currency and Foreign currency buttons to find the four other bills.
  5. Once found, select the boxes beside the bills, then click Save.

 

I'll drop this article for more details on how to reconcile your accounts: Reconcile an account in QuickBooks Online.

 

You can always ask your question here by hitting the Reply button or starting a new thread. Stay safe!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up