cancel
Showing results for 
Search instead for 
Did you mean: 
rayg-chatlabs-co
Level 1

Can I add multiple expenses in a foreign currency with the "Batch Transactions" function?

We have a foreign currency bank account but it can't link to Quickbooks, so we have to import transactions happened through that account. We tried use the "Batch transactions" from the " New" button, but can't find the bank account.
4 Comments 4
AlcaeusF
Moderator

Can I add multiple expenses in a foreign currency with the "Batch Transactions" function?

Hello @rayg-chatlabs-co,

 

Welcome to the Community. I can share some clarification about your question regarding the Batch transactions function.

 

Currently, an option or ability to batch add expenses in foreign currency is unavailable. As a workaround, I recommend using the WebConnect feature to upload your transactions.

 

Here's how:

 

  1. Go to the Banking menu or Transactions menu.
  2. Select Upload transactions.
  3. Press Browse,then select the file you downloaded from your bank. 
  4. Hit Next.
  5. In the QuickBooks account ▼  dropdown, select the account you want to upload the transactions into, then select Next.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks.
  7. Click Next.
  8. Choose the transactions you would like to import and select Next.
  9. Press Yes.
  10. When you're ready, select Let's go.

 

Though, it would be beneficial to have this ability in the Batch Actions section. Our engineers might be working to bring this feature over to this platform in the future. You can check our QuickBooks Blog for product updates. 

 

Also, I've attached an article you can use to learn how to duplicate the same expense form using the Batch transactions feature in QuickBooks: Create multiple bills or expenses in QuickBooks Online Advanced.

 

Drop me a comment below if you have any other questions regarding bringing over expenses to QuickBooks. I'll be more than happy to help. Wishing you a good one.

Asssitant Controller
Level 1

Can I add multiple expenses in a foreign currency with the "Batch Transactions" function?

We would also like to add batch transactions in foreign currency from vendors who invoice us monthly.  This was our impetus for adding the multi-currency feature.  Now we will have to enter each invoice in Quickbooks manually.  We aren't saving any time by doing so.  Please consider adding this feature!

JonpriL
Moderator

Can I add multiple expenses in a foreign currency with the "Batch Transactions" function?

Hello @Asssitant Controller,

 

The option to add foreign currency transactions in a batch is unavailable. Saying you've been adding each foreign invoice manually and it is a lot of work, I recommend letting your voice be heard throughout the entire platform by sending your experience via feedback. I'll walk you through the steps to accomplish this.

 

  1. Go to the Gear icon.
  2. Under PROFILE, select Feedback.
  3. Describe how you wish to accomplish a such goal and how it is helping you work efficiently in QuickBooks.
  4. Select Next.
  5. Click Skip and send message.

 

I'm including our Customer Feedback for QuickBooks Online page to track the status of your request and get the latest updates from our developers. Updates such as how the recent enhancement made to QBO helps our business owners, like you.

 

It'll always be my pleasure to help if you've got other questions aside from working with your company in QuickBooks. I'll be here to help.

Fiat Lux - ASIA
Level 15

Can I add multiple expenses in a foreign currency with the "Batch Transactions" function?

@Asssitant Controller 

Prepare your Bills data with the following template

 

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use        MP3 PlayerBlue MP3 Player255    
185 Green's Taxi Service ######### Net 30 1 Main Street   San DiegoCA12345    Transportation 125.13           

 

then utilize an importer tool to proceed

https://get.transactionpro.com/qbo

 

Need to get in touch?

Contact us