United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
hugeflyingcat
Level 1
posted
‎March 27, 2021 04:38 AM
last updated ‎March 27, 2021 4:38 AM

IIF involving foreign currencies

Hi, I'm importing invoices and bills involving foreign currencies. However, the templates in the IIF Sample Kit do not have such columns/ fields.  Does anyone know the field for foreign currency? or how could I resolve this? Many thanks.

Reply Join the conversation
1 Comment 1
Fiat Lux - ASIA
Level 15
‎March 27, 2021 05:38 AM

IIF involving foreign currencies

Prepare the Bills and Invoices data with the following templates

 

Bills

VendorTransaction DateRefNumberBill DueTermsMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableUnit of MeasureAP AccountCurrencyExchange Rate
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone1000Sales Line              
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone500Service Line              
Ajax Lumber01/09/2020400#########Net 30RepairsAjax Lumber200 Smith Street  AnytownNY11111USA Repairs750Front Door              
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA       Part 11Part #120  N    
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25VT Trip ABC CompanyY           
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25CA Trip DEF CompanyN           
Green Taxi Company01/09/2020500#########Net 30Taxi to AirportGreen Taxi Company1 North Street  AnytownNY11111USA Travel25FL Trip              
Parts R Us01/09/20201200#########Net 30 Parts R Us18 South Street  AnytownNY 12345USA       Widget A1Widget A10 John DoeY    
Parts R Us01/09/20201200#########Net 30 Parts R Us18 South Street  AnytownNY 12345USA       Widget B2Widget B15 John DoeY    
Parts R Us01/09/20201200#########Net 30 Parts R Us18 South Street  AnytownNY 12345USA       Widget C2Widget C22.5 John DoeY    

 

Invoices

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non
Main St Bank03/09/2020102    N16/09/2020Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonDoor1Door300              Non
Main St Bank03/09/2020102    N16/09/2020Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonHandles1Handle10              Non
Main St Bank03/09/2020102    N16/09/2020Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonHinges3Hinges5              Non
Main St Bank03/09/2020102    N16/09/2020Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonLock1Lock15              Non
Main St Bank03/09/2020102    N16/09/2020Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonPaint1Paint8              Non

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Reply Join the conversation
Featured
Community Chatter Series: Episode 10 (Common Reconcile Issues within QuickBooks Online)
(view in My Videos) For topics mentioned in this episode, check out the fol...
Read more
Top 5- Payments
Hello Community! We are back with another Top 5, but this time around we wi...
Read more
Quick Help with QuickBooks: Troubleshooting Issues when Moving from Desktop to Online
It's that time of year when many customers are looking into making the move...
Read more

Need to get in touch?

Contact us