cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Level 1

Clarification on the "AS OF (DATE)" field on CSV imports and other questions

Hi everyone.  Right now I'm looking at the contents of the downloadable Import / export CSV kit that explains what fields can be imported into QuickBooks via CSV.  It looks like this:

 

csv-fields.png

 

What is the as of (date) field?  It seems to me that this field can be used with the total value field to a) correct the total value of an item's inventory and b) backdate this change as to correct the avg. COGS value that QuickBooks generates.

 

Am I correct in this assumption?

 

If so, is it the same as going to Inventory > Adjust Quantity / Value on Hand > And adjusting the value for the on-hand inventory with an adjustment date in the past (which indeed forces QuickBooks to generate a new avg. COGS value)?

 

In addition to as of (date) there are fields like type (required) and name (required) - should the parentheses and text therein be removed, or should those column names remain unchanged?

 

Thank you.

Solved
Best answer 04-04-2019

Best Answers
Highlighted
QuickBooks Team

Clarification on the "AS OF (DATE)" field on CSV imports and other questions

Hello there, @Korfyp,

 

I'm here with some clarifications about the "AS OF (DATE)" field.

 

This field indicates the start date of the inventory item.

 

For example, if you have 100 available quantity on hand last March 1, 2019, you need to enter 100 in the Total Value field and March 1, 2019 in the As of (Date) field.

 

That will explain what this field means. Let me know if there's anything I can help you with importing your data in QuickBooks. I'm always around whenever you need help.

View solution in original post

4 Comments
Highlighted
Anonymous
Not applicable

Clarification on the "AS OF (DATE)" field on CSV imports and other questions

The date of the opening balance transactions for your items.

Highlighted
Level 1

Clarification on the "AS OF (DATE)" field on CSV imports and other questions

Thanks for the response.  I must admit though that I'm a scientist, not a finance expert.  Can you elaborate on this at all?

Highlighted
QuickBooks Team

Clarification on the "AS OF (DATE)" field on CSV imports and other questions

Hello there, @Korfyp,

 

I'm here with some clarifications about the "AS OF (DATE)" field.

 

This field indicates the start date of the inventory item.

 

For example, if you have 100 available quantity on hand last March 1, 2019, you need to enter 100 in the Total Value field and March 1, 2019 in the As of (Date) field.

 

That will explain what this field means. Let me know if there's anything I can help you with importing your data in QuickBooks. I'm always around whenever you need help.

View solution in original post

Highlighted
Level 1

Clarification on the "AS OF (DATE)" field on CSV imports and other questions

Hi Mary,

 

Thanks for the explanation.  Doesn't sound like I can do exactly what I want to.  On to another approach then.

Need to get in touch?

Contact us