cliqo - command line for QuickBooks Online
cliqo is a command line (CLI) program for QuickBooks Online. With it, you can:
Features and Benefits
- Create and update QuickBooks records like customers, invoices, vendors, and bills
- Delete, void, inactivate, or (re) activate QuickBooks records
- Get all information for a specific record
- List all records in a tabular form using a SQL like select syntax
- Print (download a PDF) for certain records including bill, credit memo, estimate, invoice, purchase order, refund receipt, sales receipt, and vendor credit
- Supported records 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 22 standard QuickBooks reports - see Standard Reports below
- 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 available for both Windows and Linux
Standard Reports
cliqo can generate these reports in text, CSV, or TSV format:
- 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
Pricing
cliqo pricing is based on the number of QuickBooks Online companies you intend to access.
- 1 company - free
- 2-5 Companies - $399/year
- More than 5 companies - Please call for pricing
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
Got Questions, We've Got Answers
For pre-sales questions or support, phone us at (904) 900-2690 Monday through Friday from 9 am to 4 pm ET. You may also e-mail us at support@bhent.com or initiate a chat below.