QuickBooks Company File Requirements
The minimum QuickBooks Company File Requirements to interface effectively with AGILIRON is listed below:
Chart of Accounts
- Bank Account
- Other Current Asset
- Inventory Asset
- Undeposited Funds
- Other Current Liabilities
- Sales Tax Payable
- Income Account
- Merchandise Sales
- Service Sales
- Sales Discounts
- Shipping & Delivery Income
- Uncategorized Income
- COGS
- Cost of Goods Sold
- Purchase Discounts
- Purchase Sales Tax
- Uncategorized Cost
- Expenses
- Uncategorized Expense
- Accounts Receivable
- Accounts Payable
- Credit Card
Ship Via List
- Unspecified
Payment Method List
- Unspecified
- Payment Type - "Other"
Item List
- NOTE:
- Only QuickBooks Desktop Editions support different Item types like "Non-Inventory Part", "Service", "Discount", "Other Charge" etc. as mentioned below.
- For QuickBooks Online, you can just create an Item under Lists > Products & Services with the desired name (e.g. "Merchandise", "Service", "Discount" etc.) for each of the areas outlined below.
- Sales Tax Item(s)
- Type - "Sales Tax Item"
- Out-of-State - 0%
- One for each Stock Location Tax Agency ( & applicable % Tax Rate)
- Wholesale - 0% (if applicable)
- Non-Inventory Part Item
- Type - "Non-Inventory Part"
- Account - Income Account (e.g. "Merchandise Sales")
- e.g. Merchandise
- Service Item
- Type - "Service"
- Account - Income Account (e.g. "Service Sales")
- e.g. Service
- Discount Item
- Type - "Discount"
- Note: This is only for QuickBooks Desktop Editions, QuickBooks Online does not currently support an Item of this Type. User a "Service" type or "Non-Inventory Part" type for QuickBooks Online
- Account - Income Account (e.g. "Sales Discounts")
- e.g. "Discount" or "Coupon"
- Type - "Discount"
- Purchase Discount
- Type - "Non-Inventory Part"
- Account - COGS Account (e.g. "Purchase Discounts")
- e.g. "Purchase Discount"
- Purchase Shipping
- Type - "Other Charge"
- Note: This is only for QuickBooks Desktop Editions, QuickBooks Online does not currently support an Item of this Type. User a "Service" type or "Non-Inventory Part" type for QuickBooks Online
- Account - COGS Account (e.g. "Purchase Shipping" or "COGS")
- e.g. "Purchase Shipping"
- Type - "Other Charge"
- Purchase Sales Tax
- Type - "Other Charge"
- Note: This is only for QuickBooks Desktop Editions, QuickBooks Online does not currently support an Item of this Type. User a "Service" type or "Non-Inventory Part" type for QuickBooks Online
- Account - COGS Account (e.g. "Purchase Sales Tax" or "COGS")
- Tax Code - "Non-Taxable Sales"
- e.g. "Purchase Sales Tax"
- Type - "Other Charge"
- Shipping & Delivery
- Type - "Other Charge"
- Note: This is only for QuickBooks Desktop Editions, QuickBooks Online does not currently support an Item of this Type. User a "Service" type or "Non-Inventory Part" type for QuickBooks Online
- Account - Income Account (e.g. "Shipping & Delivery Income")
- e.g. "Shipping & Delivery"
- Type - "Other Charge"
Updated 10 months ago