Skip to main content
K
Korfyp
April 4, 2019
Solved

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

  • April 4, 2019
  • 1 reply
  • 0 views

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.

Best answer by MaryLandT

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.

1 reply

A
Anonymous
April 4, 2019

The date of the opening balance transactions for your items.

K
KorfypAuthor
April 4, 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
MaryLandTAnswer
April 4, 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.

Terms & ConditionsAccessibility statement