QBO Automation — QBO 自动化

QBO 自动化 技能

Automates QuickBooks Online operations: 图表 of accounts, bank rules, recurring transactions, reconciliation, and journal entries. Backed by accounting domAIn knowledge.

Prerequisites QBO account with admin or accountant 访问 QBO API 凭证s (命令行工具ent ID, 命令行工具ent Secret, Refresh 令牌) stored in 环境: QBO_命令行工具ENT_ID QBO_命令行工具ENT_SECRET QBO_REFRESH_令牌 QBO_REALM_ID (Company ID) Node.js or Python 环境 for API calls (or use QBO's 网页 UI with 图形界面ded steps below)

• 图表 of Accounts 设置up

Standard Account Hierarchy (US Small Business) AS设置S 1000 检查ing Account (Bank) 1010 Savings Account (Bank) 1100 Accounts Receivable (Accounts Receivable) 1200 Inventory As设置 (Other Current As设置) 1500 Computer Equipment (Fixed As设置) 1510 Accumulated Depreciation (Fixed As设置)

LIABILITIES 2000 Accounts Payable (Accounts Payable) 2100 Credit Card (Credit Card) 2200 Payroll Liabilities (Other Current Liability) 2300 Sales Tax Payable (Other Current Liability) 2700 Notes Payable (Long Term Liability)

EQUITY 3000 Owner's Equity (Equity) 3100 Owner's Draw (Equity) 3200 RetAIned Earnings (Equity)

INCOME 4000 服务s Revenue (Income) 4100 Product Sales (Income) 4200 Other Income (Other Income)

COST OF GOODS SOLD 5000 Cost of Goods Sold (Cost of Goods Sold)

EXPENSES 6000 Advertising & Marketing (Expense) 6010 Bank Charges & Fees (Expense) 6020 Dues & Subscriptions (Expense) 6030 Insurance (Expense) 6040 Meals & EntertAInment (Expense) 6050 Office Supplies (Expense) 6060 Professional Fees (Expense) 6070 Rent or Lease (Expense) 6080 Utilities (Expense) 6090 Vehicle Expense (Expense) 6100 Travel (Expense) 6200 Payroll Expenses (Expense) 6300 Depreciation (Expense)

QBO API — 创建 Account (Python/请求s) 导入 请求s, json, base64, os

def 获取_访问_令牌(): """Exchange refresh 令牌 for 访问 令牌.""" 凭证s = base64.b64encode( f"{os.environ['QBO_命令行工具ENT_ID']}:{os.environ['QBO_命令行工具ENT_SECRET']}".encode() ).decode() resp = 请求s.post( "https://oauth.平台.intuit.com/oauth2/v1/令牌s/bearer", headers={ "Authorization": f"Basic {凭证s}", "Content-Type": "应用/x-www-form-urlencoded" }, data={ "grant_type": "refresh_令牌", "refresh_令牌": os.environ["QBO_REFRESH_令牌"] } ) return resp.json()["访问_令牌"]

def 创建_account(访问_令牌, realm_id, name, account_type, account_sub_type, acct_num=None): """创建 a QBO account.""" payload = { "Name": name, "AccountType": account_type, "AccountSubType": account_sub_type } if acct_num: payload["AcctNum"] = acct_num resp = 请求s.post( f"https://quickbooks.API.intuit.com/v3/company/{realm_id}/account", headers={ "Authorization": f"Bearer {访问_令牌}", "Content-Type": "应用/json", "Accept": "应用/json" }, json=payload ) return resp.json()

# Example: 创建 a new expense account 令牌 = 获取_访问_令牌() realm = os.environ["QBO_REALM_ID"] 结果 = 创建_account(令牌, realm, name="Software Subscriptions", account_type="Expense", account_sub_type="OtherMiscellaneousExpense", acct_num="6025" ) print(结果)

Bulk Account 导入 (CSV → QBO)

QBO supports bulk 导入 via Accountant 工具box > 图表 of Accounts > 导入.

CSV 格式化:

Account Name,Type,DetAIl Type,Account Number,Description,Balance 检查ing Account,Bank,检查ing,1000,MAIn operating account,0 Accounts Receivable,Accounts receivable,Accounts Receivable (A/R),1100,,0 Software Subscriptions,Expense,Other Miscellaneous 服务 Cost,6025,SaaS 工具s,,

• Bank Rules Configuration

Bank rules auto-categorize 导入ed bank/credit card transactions.

Rule Types Category Rules — as签名 account + class/location Split Rules — divide transaction across multiple accounts Vendor Rules — auto-as签名 payee name QBO UI Steps (no API — bank rules not in QBO API v3) Go to Banking > Rules > New rule 设置: Rule name: descriptive (e.g., "AWS Monthly Charges") 应用ly to: Money out / Money in Bank account: select account Conditions: Description contAIns AMAZON 网页 服务S Then: Category: Software Subscriptions (6025) Payee: Amazon 网页 服务s Class (if 追踪ing): Operations Save and 运行 rule agAInst unreviewed transactions Common Bank Rule Templates Rule Name Condition Category Notes AWS Charges