cancel
Showing results for 
Search instead for 
Did you mean: 
lmancini220
Level 3

How do I import journal entries into Quickbooks Online?

I tried it and its super easy. Would also recomend. Saved me several hours of uploaded resturant sales JEs for the month!

Sue R
Level 1

How do I import journal entries into Quickbooks Online?

I have a 3rd party vendor between our QBO and POS system. I was able to download the journal entry from the POS as a QB import/export file. How do I upload this into QBO? Our bookkeeper left so I am feeling my way through some of this. Thanks

Fiat Lux - ASIA
Level 15

How do I import journal entries into Quickbooks Online?

@Sue R 

Why do you need to import JE, not Sales Receipt from POS into QBO?

creed1
Level 3

How do I import journal entries into Quickbooks Online?

If you're in America, you can't.  Quickbooks is aware that people have been asking for it but haven't set it up.  Were you in Canada or the UK, then yes.  
So you have to go with a third party vendor. Quickbooks has allowed developers to do it, but they won't.  I use Business Importer and am pleased with their site and their affordability.  But there are others, too.  You'll have to research them to find out if they are what you're looking for.

Sue R
Level 1

How do I import journal entries into Quickbooks Online?

Good question. I hate to use the answer "because that's the way it's been done", but....

Our entry is broken down into about 20 line items and the POS generates (thru Shogo) a journal entry. Of course by the time I figure this out, we will hopefully be changing our POS to a new company. In the meantime, I need to know how to do this upload.

Sue R
Level 1

How do I import journal entries into Quickbooks Online?

I have a 3rd party and the file that downloaded is a QB import/export file

Fiat Lux - ASIA
Level 15

How do I import journal entries into Quickbooks Online?

@Sue R 

Prepare your JE data with the following template

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 use an importer tool to proceed

https://get.transactionpro.com/qbo

 

As an additional option, use a backup restore app before doing anything to lower any risk.

https://partnerwithus.rewind.com/quickbooks

 

3021
Level 1

How do I import journal entries into Quickbooks Online?

Why isn't this function available in the US? What is keeping QuickBooks from creating the functionality? If its available in the UK and Canada what keeps it from being created in the US? From conversation threads I see people have been asking for this for, at least, the last couple of years. It would be a very beneficial function. Thank you. 

Dawn Scranton CQA
Level 1

How do I import journal entries into Quickbooks Online?

"Spreadsheet Sync" (QBO Advanced Feature) allows you to import transactions, including:

> Customer Invoices, Sales Receipts and Estimates

> Journal Entries

> Expenses, Vendor Bills and Purchase Orders

>Time Activities

 

Learn more here:

https://quickbooks.intuit.com/learn-support/en-us/accounting-and-bookkeeping/what-s-spreadsheet-sync...

 

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us