Memorial Day Sale 90% OFF QuickBooks for 3 months.* Limited time only

Buy now & save
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.
Q18
Level 1

Accessing invoices from more than 12 months ago

We just migrated from QB Desktop Enterprise to QB Online. We are only seeing our invoices from the last 12 months. How do we access older invoices? Thanks! Q18

4 Comments 4
RoseJillB
QuickBooks Team

Accessing invoices from more than 12 months ago

Hi there, @Q18.

 

Thank you for continuing to choose QuickBooks to help you manage your business. Let me share a way to locate your invoices and possible reasons why they may be missing.

 

To start, we can check your All Sales tab in QuickBooks Online (QBO), where all sales transactions are displayed, to see if your older entries are listed. Here's how:

 

  1. Go to the Sales menu and select All Sales.
  2. Select Invoices from the Type field to limit the results to this transaction type.
  3. Enter Custom Dates or select All to view every invoice migrated to your file.
    All sales.png

     

Aside from this, we can run the Transaction List by Customer Report and filter it to show only invoice transactions. This way, we can easily narrow down the results and verify if you have successfully migrated all your invoice entries or only those from the last twelve months. I'll show you how:

 

  1. Go to the Reports menu and search for the Transaction List by Customer Report.
    transaction list.png
  2. In the report window, let's switch to classic view before customizing.
    switch to classic.png
  3. Modify the Reporting period and click the Customize button.
  4. Drill down into the Filter and check the Transaction Type.
  5. From the dropdown, select Invoice. Then, click the Run report button.
    custimized.png

     

Another reason for missing data during migration to QBO is the application’s file size limit. Each transaction in your file has targets for every related entry, and the total number of targets must be fewer than 1,500,000 for the data to transfer to QuickBooks Online.

 

Additionally, if you condense your data to fit within the file size limit and choose to condense data by removing selected transactions, this can cause certain entries not to be migrated.

 

If you have verified that those invoices are still missing after checking all areas where they could be placed, I suggest manually entering them in QBO or importing them from your backup file prior to migration.

 

Moreover, let's improve your navigational skills now that you're using QuickBooks Online. To begin, you can review this article for complete guidelines: Get started with QuickBooks Online.

 

Furthermore, you can use this resource to record payments from your clients once they have settled their balances in QBO: Record invoice payments in QuickBooks Online.

 

Should you require additional assistance or have any questions managing your data, @Q18, feel free to add them here by clicking the Reply button below. The Community is here to assist you around the clock. Stay safe!

Chrea
Level 8

Accessing invoices from more than 12 months ago

@Q18 

Another option, you can use the trial version of Enterprise to access your historical data for good.

Q18
Level 1

Accessing invoices from more than 12 months ago

Thanks Crea!

Q18
Level 1

Accessing invoices from more than 12 months ago

Appreciate it Jill!

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

Need to get in touch?

Contact us