Guides
Home

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"
  • 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"
  • 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"
  • 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"

Updated 2 months ago