How to apply a payment in dollars to an invoice in colones

QUICKBOOKS ONLINE | MULTICURRENCY AND PAYMENTS

How to apply a payment in dollars to an invoice issued in colones

Learn how to record a partial or full payment received in dollars when the customer's invoice is issued in colones, using a temporary account and verifying the equivalent amounts.

What will you learn?

  • Apply a payment to an invoice in a different currency.
  • Use a temporary account.
  • Record partial payments.
  • Classify a bank deposit in dollars.
  • Verify the exchange rate.
  • Offset the temporary account.
  • Use a journal entry as an alternative.

Before you startCheck that the bill in colones is pending payment and that you have identified the deposit received in dollars. You should also have an appropriate transient account to relate both movements.

Step 1. Verify the temporary account

The tutorial uses an account called Transit to relate the amount applied to the invoice with the bank deposit received in another currency.

In the demonstration it is a cash and equivalents account, set up as a bank account.

If you don't have a suitable account, check with the accounting manager whether you need to create a specific one for this procedure.

Step 2. Open the invoice in colones

  1. Log in to QuickBooks Online.
  2. Find the customer's invoice.
  3. Verify that it is issued in colones.
  4. Check your outstanding balance.
  5. Select Get paid.

Step 3. Apply the equivalent payment

  1. Verify the selected client.
  2. Check that the correct invoice is marked.
  3. Record the amount in colones that equals the payment received in dollars.
  4. Select the actual collection date.
  5. Under Deposit to, select the transitional account.
  6. Verify that the applied amount is correct.
  7. Select Save.

In the example, the payment is partial. Therefore, after saving it, the invoice retains an outstanding balance.

Step 4. Review the record in transit

  1. Enter the Chart of Accounts.
  2. Search for the transitory account.
  3. Open the transaction history.
  4. Identify the newly recorded payment receipt.
  5. Verify its amount in colones.

This amount will be used as a reference to later offset the bank transaction.

Step 5. Classify the deposit in dollars

  1. Go to Banking.
  2. Select the bank account in dollars.
  3. Search for the deposit received from the client.
  4. Open the classification option.
  5. Select the Transit account.
  6. Check the deposit amount.
  7. Check the exchange rate and its equivalent in colones.
  8. Select the tax classification that corresponds to the compensation movement, avoiding duplicating the invoice tax.
  9. Save or post the transaction.

A deposit of $2,900 and an exchange rate of ₡456.63 are used in the video.

Deposit received: USD 2,900

Illustrative exchange rate: ₡456,63

Equivalent: ₡1.324.227

Always verify that the equivalent used corresponds to the actual amounts of the transaction.

Step 6. Check the compensation

  1. Return to the chart of accounts.
  2. Open the temporary account.
  3. Identify the charge applied to the invoice.
  4. Identify the deposit recorded in dollars.
  5. Check both equivalents in colones.
  6. Verify that the movements offset each other.

The goal is for the temporary account not to retain a pending balance attributable to that operation, except for real differences that must be accounted for.

Alternative method: record the movement using an entry

If you do not use Bank Transactions, the video explains how to record the deposit using a journal entry.

  1. Go to + Create → Journal entry.
  2. Select the bank account that received the money.
  3. Select the temporary account as counterpart.
  4. Record the debit to the bank for the corresponding amount.
  5. Record the credit in transit.
  6. Set up the currency and exchange rate, as allowed by QuickBooks.
  7. Verify the equivalents in colones.
  8. Save the entry.
  9. Review the transient account history again.

This procedure is an alternative when the deposit has not been recorded through the bank transaction.

Important: do not duplicate the deposit

If you have already classified the deposit from Bank Transactions, you must not register the same entry again using a journal entry.

Both procedures are performed in the video to explain their differences, but in a real company you should use only the appropriate method.

If there are exchange rate differences, check their origin and do not arbitrarily modify rates to force a zero balance.

Important recommendations

  • Verify the client and the invoice.
  • Apply the correct equivalent in colones.
  • Use an appropriate temporary account.
  • Check the actual dates of the payments.
  • Check the exchange rate of the deposit.
  • Do not re-register revenue or taxes from an invoice already issued.
  • Use only one method to record the money inflow.
  • Verify that the transit movements are reconciled.

Result of the procedure

The payment received in dollars will be linked to the invoice issued in colones. The temporary account will allow verifying the reconciliation of the receipt and its actual posting to the bank account.

Do you need help?

If you need support with payments in different currencies or temporary accounts in QuickBooks Online, our team can help you.

Mondragón & Associates
WhatsApp: 4000-3589