cancel
Showing results for 
Search instead for 
Did you mean: 
Harry20
Level 1

importing General Ledger with Classes

Good evening everyone,

 

I am new to QBO.  I am trying to find out if it is possible to create an excel or CSV file (and if so what the format looks like) to be able to upload general ledger transactions into QBO.  Specifically, we have to post 44 revenue accrual transactions by class every month. Currently we do it manually as the numbers do change slightly each month.  My preference would be to create a file to import which would have the necessary Debits / Credits, Account Names, Date and most of all Classes that we have established.  Is this even possible in QBO?  It would save us a ton of time each month.

 

If that is possible, can then the second question is we need to do the same thing for our daily bank deposits which would need to be booked at the class level also and could contain a hundred records.  We are again posting all of this manually. 

 

We are a real estate company and use a different software for our tenant tracking.  

 

Thanks.

 

 

2 Comments
Kristine Mae
QuickBooks Team

importing General Ledger with Classes

Let me share the data you can only import to QuickBooks Online, Harry20.

 

These are the list that you can bring in:

  • Bank Data
  • Customers
  • Vendors Chart of Accounts
  • Products and Services
  • Invoices

Concerning the General Ledger transactions, you'll want to enter them manually. Then, ensure to turn on the class tracking feature so you can track income or expenses by segments.

 

Although, you can also look for third-party apps that can help you sync those transactions. You can visit our App store and explore your options. 

 

You can always reply to this thread if you have more questions. We'll get back to you as soon as we can.

Fiat Lux - ASIA
Level 15

importing General Ledger with Classes

@Harry20 

You may prepare the Journal Entries 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 utilize TPImporter to proceed

https:// transactionpro.grsm.io/qbo

 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us