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

Korfyp · ‎April 04, 2019

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:

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.

MaryLandT · ‎April 04, 2019

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

Anonymous · ‎April 04, 2019

The date of the opening balance transactions for your items.

Korfyp · ‎April 04, 2019

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

MaryLandT · ‎April 04, 2019

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.

Korfyp · ‎April 04, 2019

Hi Mary,

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

Topics

Training

Community

Resources

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