cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
Radha Rao
Level 1

Currency in journal entry import file for Quickbooks Online

Can someone share the template for the journal entry import file for Quickbooks Online ?  How do we include the currency in the import file ? Thank you. 

2 Comments 2
Adrian_A
Moderator

Currency in journal entry import file for Quickbooks Online

Hello there, Radha Rao.

 

The currency isn't included as one of the columns when importing journal entries. Thus, you'll have to enter them manually.

 

With QBO’s import feature, you can easily transfer/copy your accounting data. Just make sure to fill in the required columns such as DateAccount numberJournal codeDebit, and Credit to successfully execute the process. Here's how to import:

 

  1. From the Gear icon.
  2. Select Import Data.
  3. Choose Journal Entries.
  4. On the Download page, select Browse.
  5. Select your CSV or Excel file. Select Open, then Next.
  6. Map your information. Your Field represents the headers on your spreadsheet. From each small arrow icon, select the one that matches a field in QuickBooks Online.
  7. Select Next.
  8. Click Start import. If there’s an error, select Download and correct. Then, edit the file and try again.
  9. Select Done.

 

You can also check out this article for more info: Common questions about importing data.

 

You can swing by anytime you need more help with importing your data into QuickBooks Online. I'd be glad to assist.

Fiat Lux - ASIA
Level 15

Currency in journal entry import file for Quickbooks Online

@Radha Rao 

Prepare your JE data 

RefNumberTxnDatePrivateNoteIsAdjustmentCurrencyExchangeRateAccountLineAmountLineDescEntityClassLocation
10101/10/2020Wire TransferFALSE  Savings-50.00Credit Savings   
10101/10/2020Wire TransferFALSE  Checking50.00Debit Checking   
10201/10/2020Wire TransferFALSE  Savings200.00Debit Savings   
10201/10/2020Wire TransferFALSE  Checking-200.00Credit Checking   

 

then utilize an importer tool to proceed.

https://get.transactionpro.com/qbo

 

As an additional option, use a backup restore app if required.

https://partnerwithus.rewind.com/quickbooks