Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
chic316860
Level 3

I need to build 3 years of history into a new quickbooks implementation and then start doing current transactions. can i use journal entries to build the history?

the past 3 years were on another system. if i got the balance sheet and p&l for each past month could i enter just the net amount booked to each account each month via journal entries. i know i would not have the detailed transaction but i should have the net amount booked into each account each month. this would allow me to make trend reports and historical reports. i would then start entering the current detailed transaction starting at the first of the year.
5 Comments 5
Fiat Lux - ASIA
Level 15

I need to build 3 years of history into a new quickbooks implementation and then start doing current transactions. can i use journal entries to build the history?

Which another system? You can buy a 3rd party conversion service if you need transaction details. Alternatively, you will need to prepare a trial balance report annually to migrate as JE.

chic316860
Level 3

I need to build 3 years of history into a new quickbooks implementation and then start doing current transactions. can i use journal entries to build the history?

we are a small non-profit organization. the other system is the quickbooks desktop version that is owned by a local accounting firm that is going out of business. we have no access to the data on their system. i also thought about asking for a trial balance report for each month. this would show the debit and credit amounts booked to each account by month. i should be able to take this info and create a journal entry for each account by month with the debit and credit amounts from the trial balance and post them to the new system. i would need to do a year end close after posting each year. i would not have to do a bank reconciliation each month as there would be no bank transactions. i believe this would allow me to build the history so i can do historical reporting and trending etc. so do i ask them for a trial balance by each month? is there anything wrong with this approach? thanks for your help!!!!!

Fiat Lux - ASIA
Level 15

I need to build 3 years of history into a new quickbooks implementation and then start doing current transactions. can i use journal entries to build the history?

If you don't currently have any data and still need to check with your former accountant, you should request the backup file (QBB) from them instead. You can use the trial version for QB Desktop to restore the file and convert them to QB Online later. You don't need to spend time importing trial balance data as JE manually. Signup for a new QBO account with TechSoup if you are eligible. Otherwise, you have to prepare your QBO account with regular rate.

https:// quickbooks.grsm.io/US

https:// quickbooks.grsm.io/us-promo

 

TirzahC
QuickBooks Team

I need to build 3 years of history into a new quickbooks implementation and then start doing current transactions. can i use journal entries to build the history?

Hi, chic.

 

I agree with Fiat Lux - ASIA. We can get the file from QBDT and be able to bring them to QBO. 

 

you'll have to first restore your company data through a trial version of the QuickBooks Desktop (QBDT) program (applicable only if you don't have the QBDT program). Just make sure your computer meets the minimum requirements to successfully execute the installation process.

 

When you're ready, select the version you want to install through this article: Download a trial of QuickBooks Desktop. Once done, restore the backup company file (.qbb) to create new data (.qbw). Here's how:

 

  1. Go to the File menu.
  2. Select Open or Restore Company.
  3. Choose Restore a backup copy.
  4. Click Next.
  5. Select Local Backup and then Next.
  6. Browse your computer for your backup company file. It should look like this: [Your company name].qbb.
  7. Select a folder where to save your restored company file. Then, select Open.
  8. When you're ready, select Save.

 

After restoring your QBB file to a new company data (.qbw), you're now ready to import the file to your new QBO account. Just go to the Company menu on your QBDT trial program, then select the Export Company File to QuickBooks Online. For the step-by-step guide, kindly check out this article: Move your QuickBooks Desktop file to QuickBooks Online.

 

Additionally, the following articles are good references to learn more ways of handling your QuickBooks data:

 

 

Let me share these quick guides with you about managing opening balances in QuickBooks Online: 

 

 

I'll be around to help you if you have other questions about moving your data to QBO.

caramgarza
Level 1

I need to build 3 years of history into a new quickbooks implementation and then start doing current transactions. can i use journal entries to build the history?

Hello! How did you decide to handle this? I have a similar situation and am contemplating making journal entries as well.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us