cancel
Showing results for 
Search instead for 
Did you mean: 
kyosho
Level 2

Import Inventory results from Excel. Backdate to 12-31-2023. Error: Quantity as-of Date - The date is prior to your company's closing date. Please change to a later date.

I am now at 6Jan2024. What is my company's closing date and how is last week prior to it?
Solved
Best answer January 06, 2024

Best Answers
Ethel_A
QuickBooks Team

Import Inventory results from Excel. Backdate to 12-31-2023. Error: Quantity as-of Date - The date is prior to your company's closing date. Please change to a later date.

Hello there, @kyosho.

 

I'll show you how to check the closing date of your books in QuickBooks Online.

 

When importing inventory results from Excel to QuickBooks Online, make sure to check the as-of date of each item. They should be after the closing date. 

 

I'll show you how to check the closing date of your books in QuickBooks Online.

 

Here's how:

 

  1. Go to Settings ⚙ and then select Accounts and settings.
  2. Select the Advanced tab.
  3. You will see the closing date in the Accounting section.

 

Here is an article you can read to guide you if you want to review your closed books: Close your books in QuickBooks Online.


I'm also adding this article to guide you if you want to edit your closed books: Edit your closed books in QuickBooks Online.


Let me know if you have questions about importing inventory in QuickBooks Online. I'm always here to help. Have a great day.

View solution in original post

1 Comment 1
Ethel_A
QuickBooks Team

Import Inventory results from Excel. Backdate to 12-31-2023. Error: Quantity as-of Date - The date is prior to your company's closing date. Please change to a later date.

Hello there, @kyosho.

 

I'll show you how to check the closing date of your books in QuickBooks Online.

 

When importing inventory results from Excel to QuickBooks Online, make sure to check the as-of date of each item. They should be after the closing date. 

 

I'll show you how to check the closing date of your books in QuickBooks Online.

 

Here's how:

 

  1. Go to Settings ⚙ and then select Accounts and settings.
  2. Select the Advanced tab.
  3. You will see the closing date in the Accounting section.

 

Here is an article you can read to guide you if you want to review your closed books: Close your books in QuickBooks Online.


I'm also adding this article to guide you if you want to edit your closed books: Edit your closed books in QuickBooks Online.


Let me know if you have questions about importing inventory in QuickBooks Online. I'm always here to help. Have a great day.

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

Need to get in touch?

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