Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?

Importing and Exporting Data

Importing and Exporting Data

  • 422 Topics
  • 733 Replies
422 Topics
U
usercwt-sa
 Importing and Exporting Data
uservazquez
uservazquez
 Importing and Exporting Data
E
earthlyessential
 Importing and Exporting Data
S
sidebrake
 Importing and Exporting Data
F
floorsweeper
 Importing and Exporting Data
Issues in the way employees are identified when importing time data

There is a business which regularly downloads employees' work hour data in IIF files from the time tracking system, and imports into QuickBooks.   The version of QuickBooks is Desktop version Enterprise 18. What has been troublesome is that it seems QuickBooks can only identify employees by their names, and, thus, when there are employees with same names, the names had to be modified in some way to make them distinguishable such as by adding some special characters or numbers to the names.  Having to use such naming convention led to frequent troubles for the person who handled the data.  If the employees could be identified simply by their employee numbers, such troubles could be avoided.  So, here my question is whether there is a way to import employee time data into QuickBooks in which employees are identified by their employee numbers rather than their names. 

01
R
C
claudia-escriban
 Importing and Exporting Data
A
Anonymous
 Importing and Exporting Data
U
userjoan-lee
 Importing and Exporting Data
B
bero
 Importing and Exporting Data
M
mohamed-hasan-fo
 Importing and Exporting Data
B
bonnuqui
 Importing and Exporting Data
J
joe-tiptopvi-com
 Importing and Exporting Data
L
liquidbermuda
 Importing and Exporting Data
A
accounts-aij-ae
 Importing and Exporting Data
A
accounts-aij-ae
 Importing and Exporting Data
A
ajindas
 Importing and Exporting Data
M
mdpodlug-gmail-c
 Importing and Exporting Data
I
info-barefootacc
 Importing and Exporting Data
P
patdrd
 Importing and Exporting Data
How can we ensure QuickBooks Online calculates the ExchangeRate?

Hello, The company I work for deploys Dispatching and Trucking software that exports invoices into QuickBooks Online for our mutual clients. Recently, we've expanded to support multiple currencies, but herein lies the issue. When an invoice is exported from our software into QuickBooks Online, the exchange rate seems to be defaulting to 1. Several of our mutual customers deals with Canadian and American clients and this throws off their profits significantly.  We've noticed that after we've posted our invoices, we receive a JSON response the indicates the ExchangeRate is 1. We currently do not send ExchangeRate with our posts because we were under the impression that QuickBooks Online would calculate the ExchangeRate on it's own as it does with invoices that are created from within QuickBooks Online, but this is not the case. As such, we are at an impasse.  When we export invoices (we do not send the ExchangeRate) the invoice defaults to a 1:1 Ex

11
G
F
faissal
 Importing and Exporting Data
K
kevin-ochieng
 Importing and Exporting Data
M
mai2
 Importing and Exporting Data
J
Joanna C
 Importing and Exporting Data
A
alfred-hoefinger
 Importing and Exporting Data
M
m-lyons
 Importing and Exporting Data
Show more activity
Start a discussion
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement