| Author |
Message |
L Mehl
Guest
|
 Posted:
Sun Nov 06, 2005 9:01 am Post subject:
Import accounts with beginning balances for a date - QB 2005 |
|
|
Hello --
Can anyone tell me how to write an ACCNT line in an IIF file for import so
that an beginning balance amount (OBAMOUNT ?) will be entered for the
account, as of a specific date (TIMESTAMP ?).
The following lines do not do that.
!ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD BANKNUM
EXTRA HIDDEN DELCOUNT USEID WKPAPERREF
ACCNT Cash:Bank of xxxxxxxxxxxxxxxx 5 1130953965 BANK 108264.12 100198 0
N 0 N
ACCNT Cash:Bank of yyyyyyyyyyyyyyyy 5 0930000000 BANK 108264.12 100199 0
Thanks for any help.
Larry Mehl
|
|
| Back to top |
|
 |
Karl Irvin
Guest
|
| Posted:
Sun Nov 06, 2005 5:01 pm Post subject:
Re: Import accounts with beginning balances for a date - QB |
|
|
Use a Journal Entry IIF to add the beginning balances. Use Invoice and Bill
if you want to enter opening balances by customer and vendor.
"L Mehl" <mehl@cyvest.com> wrote in message
news:5cjbf.10312$7h7.4879@newssvr21.news.prodigy.com...
| Quote: | Hello --
Can anyone tell me how to write an ACCNT line in an IIF file for import so
that an beginning balance amount (OBAMOUNT ?) will be entered for the
account, as of a specific date (TIMESTAMP ?).
The following lines do not do that.
!ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD BANKNUM
EXTRA HIDDEN DELCOUNT USEID WKPAPERREF
ACCNT Cash:Bank of xxxxxxxxxxxxxxxx 5 1130953965 BANK 108264.12 100198 0
N 0 N
ACCNT Cash:Bank of yyyyyyyyyyyyyyyy 5 0930000000 BANK 108264.12 100199 0
Thanks for any help.
Larry Mehl
|
|
|
| Back to top |
|
|
L Mehl
Guest
|
| Posted:
Mon Nov 07, 2005 1:02 am Post subject:
Re: Import accounts with beginning balances for a date - QB |
|
|
Karl --
Thanks.
Can you tell me where to learn how to create a Journal Entry IIF?
QB Help and Support shows me nothing.
I should have stated that the opening balances are for Balance Sheet
accounts.
Can you direct me to information about creating an IIF to do that?
Larry
"Karl Irvin" <88karl3200@comcast.net> wrote in message
news:pvidnYVoXuxRjfPenZ2dnUVZ_tqdnZ2d@comcast.com...
| Quote: | Use a Journal Entry IIF to add the beginning balances. Use Invoice and
Bill
if you want to enter opening balances by customer and vendor.
"L Mehl" <mehl@cyvest.com> wrote in message
news:5cjbf.10312$7h7.4879@newssvr21.news.prodigy.com...
Hello --
Can anyone tell me how to write an ACCNT line in an IIF file for import
so
that an beginning balance amount (OBAMOUNT ?) will be entered for the
account, as of a specific date (TIMESTAMP ?).
The following lines do not do that.
!ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD BANKNUM
EXTRA HIDDEN DELCOUNT USEID WKPAPERREF
ACCNT Cash:Bank of xxxxxxxxxxxxxxxx 5 1130953965 BANK 108264.12 100198
0
N 0 N
ACCNT Cash:Bank of yyyyyyyyyyyyyyyy 5 0930000000 BANK 108264.12 100199
0
Thanks for any help.
Larry Mehl
|
|
|
| Back to top |
|
|
Gary E
Guest
|
| Posted:
Mon Nov 07, 2005 1:02 am Post subject:
Re: Import accounts with beginning balances for a date - QB |
|
|
I don't believe you can put in an opening balance via an IIF file. There are
some definite limitations to the process.
Gary
"L Mehl" <mehl@cyvest.com> wrote in message
news:5cjbf.10312$7h7.4879@newssvr21.news.prodigy.com...
| Quote: | Hello --
Can anyone tell me how to write an ACCNT line in an IIF file for import so
that an beginning balance amount (OBAMOUNT ?) will be entered for the
account, as of a specific date (TIMESTAMP ?).
The following lines do not do that.
!ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD BANKNUM
EXTRA HIDDEN DELCOUNT USEID WKPAPERREF
ACCNT Cash:Bank of xxxxxxxxxxxxxxxx 5 1130953965 BANK 108264.12 100198 0
N 0 N
ACCNT Cash:Bank of yyyyyyyyyyyyyyyy 5 0930000000 BANK 108264.12 100199 0
Thanks for any help.
Larry Mehl
|
|
|
| Back to top |
|
|
Karl Irvin
Guest
|
| Posted:
Mon Nov 07, 2005 5:03 pm Post subject:
Re: Import accounts with beginning balances for a date - QB |
|
|
See http://www.quickbooks.com/support/faqs/qbw2001/117503.html
"L Mehl" <mehl@cyvest.com> wrote in message
news:%Rubf.9386$BZ5.7772@newssvr13.news.prodigy.com...
| Quote: | Karl --
Thanks.
Can you tell me where to learn how to create a Journal Entry IIF?
QB Help and Support shows me nothing.
I should have stated that the opening balances are for Balance Sheet
accounts.
Can you direct me to information about creating an IIF to do that?
Larry
"Karl Irvin" <88karl3200@comcast.net> wrote in message
news:pvidnYVoXuxRjfPenZ2dnUVZ_tqdnZ2d@comcast.com...
Use a Journal Entry IIF to add the beginning balances. Use Invoice and
Bill
if you want to enter opening balances by customer and vendor.
"L Mehl" <mehl@cyvest.com> wrote in message
news:5cjbf.10312$7h7.4879@newssvr21.news.prodigy.com...
Hello --
Can anyone tell me how to write an ACCNT line in an IIF file for import
so
that an beginning balance amount (OBAMOUNT ?) will be entered for the
account, as of a specific date (TIMESTAMP ?).
The following lines do not do that.
!ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD BANKNUM
EXTRA HIDDEN DELCOUNT USEID WKPAPERREF
ACCNT Cash:Bank of xxxxxxxxxxxxxxxx 5 1130953965 BANK 108264.12 100198
0
N 0 N
ACCNT Cash:Bank of yyyyyyyyyyyyyyyy 5 0930000000 BANK 108264.12 100199
0
Thanks for any help.
Larry Mehl
|
|
|
| Back to top |
|
|
L Mehl
Guest
|
| Posted:
Tue Nov 08, 2005 1:02 am Post subject:
Re: Import accounts with beginning balances for a date - QB |
|
|
Thanks Karl.
Larry
"Karl Irvin" <88karl3200@comcast.net> wrote in message
news:4IqdnYEzSun3__LenZ2dnUVZ_sCdnZ2d@comcast.com...
| Quote: | See http://www.quickbooks.com/support/faqs/qbw2001/117503.html
"L Mehl" <mehl@cyvest.com> wrote in message
news:%Rubf.9386$BZ5.7772@newssvr13.news.prodigy.com...
Karl --
Thanks.
Can you tell me where to learn how to create a Journal Entry IIF?
QB Help and Support shows me nothing.
I should have stated that the opening balances are for Balance Sheet
accounts.
Can you direct me to information about creating an IIF to do that?
Larry
"Karl Irvin" <88karl3200@comcast.net> wrote in message
news:pvidnYVoXuxRjfPenZ2dnUVZ_tqdnZ2d@comcast.com...
Use a Journal Entry IIF to add the beginning balances. Use Invoice and
Bill
if you want to enter opening balances by customer and vendor.
"L Mehl" <mehl@cyvest.com> wrote in message
news:5cjbf.10312$7h7.4879@newssvr21.news.prodigy.com...
Hello --
Can anyone tell me how to write an ACCNT line in an IIF file for
import
so
that an beginning balance amount (OBAMOUNT ?) will be entered for the
account, as of a specific date (TIMESTAMP ?).
The following lines do not do that.
!ACCNT NAME REFNUM TIMESTAMP ACCNTTYPE OBAMOUNT DESC ACCNUM SCD
BANKNUM
EXTRA HIDDEN DELCOUNT USEID WKPAPERREF
ACCNT Cash:Bank of xxxxxxxxxxxxxxxx 5 1130953965 BANK 108264.12
100198
0
N 0 N
ACCNT Cash:Bank of yyyyyyyyyyyyyyyy 5 0930000000 BANK 108264.12
100199
0
Thanks for any help.
Larry Mehl
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in