Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHello @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:
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.
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!
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.
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.
Prepare your Bills data with the following template
RefNumber | APAccount | Vendor | PrintOnCheckName | TxnDate | DueDate | SalesTerm | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Office Supplies | For Anne | 25.1 | ||||||||||||||||||||
101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Telephone | Phone Cards | 50.25 | ||||||||||||||||||||
101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | MP3 Player | Blue MP3 Player | 2 | 55 | |||||||||||||||||||
185 | Green's Taxi Service | ######### | Net 30 | 1 Main Street | San Diego | CA | 12345 | Transportation | 125.13 |
then utilize an importer tool to proceed
https://get.transactionpro.com/qbo
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.