cliqo - command line for QuickBooks Online
cliqo is a command line program for QuickBooks Online. With it, you can:
- Create new and edit/update Quickbooks entities like customers, invoices, vendors, and bills
- Delete, void, inactivate, or (re) activate Quickbooks entities
- Get all information for a specific entity
- List all entities in a tabular form using a SQL like select syntax
- Print (download a PDF) for certain entities including bill, credit memo, estimate, invoice, purchase order, refund receipt, sales receipt, and vendor credit
- Supported entities are:
- Accounts
- Bills
- Credit memos
- Customers
- Employees
- Estimates
- Invoices
- Journal entries
- Payments
- Purchase orders
- Refund receipts
- Sales receipts
- Time activity entries
- Transfers
- Vendors
- Vendor credits
- Run these reports:
- Balance Sheet
- Profit And Loss
- Profit And Loss Detail
- Trial Balance
- Cash Flow
- Inventory Valuation*
- Customer Sales
- Item Sales
- Department Sales
- Class Sales
- Customer Income
- Customer Balance
- Customer Balance Detail
- Aged Receivables
- Aged Receivable Detail
- Vendor Balance
- Vendor Balance Detail
- Aged Payables
- Aged Payable Detail
- Vendor Expenses
- General Ledger Detail
- Tax Summary
- Supported output formats include CSV, JSON, and TSV for easy read/paste into spreadsheets or for further processing
- Output to console, redirect to file, or send to clipboard for easy pasting into Excel or Google Sheets
- cliqo is currently available for both Windows and Linux
Getting Started
To get started, follow these steps:
- Visit the downloads page to obtain cliqo for your operating system
- Extract the cliqo executable from the zip file
- Run "cliqo quickstart" to authorize access to your QuickBooks Online company
- Once authorized, you can use any of the other commands:
- Example 1: ./cliqo get customer 1
- Example 2: ./cliqo select vendor
- Example 3: ./cliqo select invoice --max 5
- Example 4: ./cliqo print invoice 103 invoice_103.pdf
- Example 5: ./cliqo report ar"
- for more usage help, run "cliqo -h" or see the full cliqo documentation