QBooks Office Accounts, Budgets, etc.

Accounts
Budgets
Classes
Terms

Back to QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
45-	nKey	Long	PKey	REFNUM	Unique account record identifier
45-	sAcctType	S12	Req	ACCNTTYPE	Account type. One of: "Bank", "AcctRec", "OthCurrAsset", "FixedAsset", "OthAsset", "AcctPay", "CredCard", "OthCurrLiab", "LongTermLiab", "Equity", "Income", "COGS", "Expense", "OthIncome", "OthExpense", "NonPosting".
45-	sAcctSort	S8	Req	-	String that can be used to sort accounts in same order QB does. Mainly useful for reports. Examples: Bank type accounts = "11+", Other Asset type accounts = "19+", Income type accounts = "53-". Always 2 decimal digits, followed by a + or -. The + indicates that the account normally has a debit balance, - indicates normally credit balance. In the future, additional characters will be added in the 4th through 8th positions to aid in account classification for ratio reports. Currently, only 3 of the 8 possible character positions are used.
45-	sSpecAcct	S16	Opt	EXTRA	Predesignated special account Special accounts are 'marked' accounts QB uses for processing - such as where to debit / credit accounts receivable. One of: "AcctRec", "UndepFunds", "InvtAsset", "AcctPay", "PayrollLiab", "SalesTaxPay", "OpeningBalEquity", "RetEarnings", "UncatIncome", "COGS", "PayrollExp", "UncatExpense", "PurchOrd", or "Estimates".
45-	sName	S31	Req	-	Short account name. Does not include colon separators or names of parent accounts.
45-	sFullName	S159	Req	NAME	Full name with colon separators and name(s) of parents - if any. Field sName and sFullName will always have the same value if the account is not nested.
45-	nNestLevel	Long	OptDft0	-	Depth of nesting. If missing, this is a root (has no parent) account.
45-	kParent	Long	FKeyOpt	-	Key of parent account - which is in this set of records
45-	sDescr	S29	Opt	DESC	Brief description of account
45-	sAcctNum	S7	Opt	ACCNUM	Account number - optional There is a settings flag to indicate if account numbers are being used (bAcctNumbers). If account numbers are not being used, there is no guarantee that each account will have a number. Any numbers that exist are returned, even if not used - however there is no enforced scheme for what the user entered numbers are.
45-	mBalance	Curr	OptDft0	OBAMOUNT	Current balance of account Current balance of this account - the sum of all debits and credits to this account for all transactions posted to it. In the QB import / export (IIF) help file documentation, this is mistakenly listed as the opening balance of the account. QBooks Office also exports the current balance of income and expense accounts - even though they are never displayed by QB.
45-	sNote	S25	Opt	BANKNUM	Miscellaneous, such as bank number
45-	nTaxLine	Long	Opt	SCD	US income tax form line assigned to account. See Intuit file BUSTAX.SCD (supplied with QB) to associate this number with the specific tax form and line number.
45-	sLastDocNum	S11	Opt	-	Last doc created, such as last check number. Only used with accounts that automatically sequence transaction document numbers - such as checking accounts, invoices, and purchase orders.
-5-	dLastOnline	Date	Opt	-	Date of last online connection to bank. Applies to online accounts only.
-5-	bInactive	Bool	OptDftF	HIDDEN	T if currently inactive. (Inactive checkbox is checked)

Contents of this page
QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
-45	nKey	Long	PKey	-	Unique budget item identifier - never externally referenced
-45	kAcct	Long	FKeyReq	ACCNT	Key of account these budget amounts are for.
-45	nYear	Long	Req	STARTDATE?	Year
-45	kCustJob	Long	FKeyOpt	CUSTOMER	Key of customer or job
-45	kClass	Long	FKeyOpt	CLASS	Key of class these budget amounts apply to.
-45	mPeriod1	Curr	Opt	AMOUNT	Budgeted dollar amount - 1st period
-45	mPeriod2	Curr	Opt	AMOUNT	Budgeted dollar amount - 2nd period
-45	mPeriod3	Curr	Opt	AMOUNT	Budgeted dollar amount - 3rd period
-45	mPeriod4	Curr	Opt	AMOUNT	Budgeted dollar amount - 4th period
-45	mPeriod5	Curr	Opt	AMOUNT	Budgeted dollar amount - 5th period
-45	mPeriod6	Curr	Opt	AMOUNT	Budgeted dollar amount - 6th period
-45	mPeriod7	Curr	Opt	AMOUNT	Budgeted dollar amount - 7th period
-45	mPeriod8	Curr	Opt	AMOUNT	Budgeted dollar amount - 8th period
-45	mPeriod9	Curr	Opt	AMOUNT	Budgeted dollar amount - 9th period
-45	mPeriod10	Curr	Opt	AMOUNT	Budgeted dollar amount - 10th period
-45	mPeriod11	Curr	Opt	AMOUNT	Budgeted dollar amount - 11th period
-45	mPeriod12	Curr	Opt	AMOUNT	Budgeted dollar amount - 12th period

Contents of this page
QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
-45	nKey	Long	PKey	REFNUM	Unique class record identifier
-45	sName	S31	Req	-	Short name of this class. Does not include colon separators or names of parent classes.
-45	sFullName	S159	Req	NAME	Full name with colon separators - w/ name(s) of parents if any
-45	nNestLevel	Long	OptDft0	-	Depth of nesting. Parent (root) if missing
-45	kParent	Long	FKeyOpt	-	Key of parent in this set of records
--5	bInactive	Bool	OptDftF	HIDDEN	T if currently inactive (Inactive checkbox is checked)

Contents of this page
QBooks Office Overview

Ver	Field Name	Type	Prop	IIF Name	Description
-45	nKey	Long	PKey	REFNUM	Unique terms (for customer or vendor) record identifier
-45	sName	S31	Req	NAME	Name used for terms
-45	bDateDriven	Bool	Opt	TERMSTYPE	T if for date driven terms where payment to be made by a certain date of the month. Otherwise, payment is to be made within a specific number of days.
-45	nDueDays	Long	Opt	DUEDAYS	Number of days in which payment is due. If bDateDriven = T, this is the day of the month on which payment is due.
-45	rDiscPercent	Curr	Opt	DISCPER	Discount percentage for early payment
-45	nDiscDays	Long	Opt	DISCDAYS	Number of days by which early payment gets the qDiscPercent discount
-45	nMinDays	Long	Opt	MINDAYS	Applies to date driven only
--5	bInactive	Bool	OptDftF	HIDDEN	T if currently inactive (Inactive checkbox is checked)

Contents of this page
QBooks Office Overview