importing General Ledger with Classes

Harry20 · ‎September 28, 2020

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.

Kristine Mae · ‎September 28, 2020

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 · ‎September 28, 2020

@Harry20

You may prepare the Journal Entries data with the following template

RefNumber	TxnDate	PrivateNote	IsAdjustment	Currency	ExchangeRate	Account	LineAmount	LineDesc	Entity	Class	Location
101	01/10/2020	Wire Transfer	FALSE			Savings	-50.00	Credit Savings
101	01/10/2020	Wire Transfer	FALSE			Checking	50.00	Debit Checking
102	01/10/2020	Wire Transfer	FALSE			Savings	200.00	Debit Savings
102	01/10/2020	Wire Transfer	FALSE			Checking	-200.00	Credit Checking

then utilize TPImporter to proceed

https:// transactionpro.grsm.io/qbo

Topics

Training

Community

Resources

importing General Ledger with Classes

importing General Ledger with Classes

importing General Ledger with Classes

Need to get in touch?