1. Introduction

1.1. Attention

cliqo is currently in beta testing and this documentation is still being developed. Please keep this in mind when using on live company data.

1.2. What is cliqo?

cliqo is a command-line program that you can use with QuickBooks Online. With it you can…

Because cliqo is a command-line program, it can be used:

  • For fast and efficient access to your accounting data from a text console

  • For automating list generation, invoicing, and journal entries

  • For automating nightly reports related to one or many QuickBooks accounts

cliqo’s default output format is tab separated value (TSV) so results can be easily loaded into a spreadsheet or evaluated using other command line tools.

1.3. Quick Start

cliqo is available as a stand-alone binary for Windows and Linux. You can download the latest version from the Downloads page.

  1. Download the binary file for your platform (see above)

  2. Move the file somewhere in your search path, such as c:cliqo on Windows or /usr/local/cliqo on Linux.

  3. Execute “cliqo quickstart” to create the cliqo configuration file and authorize access to your QuickBooks data

  4. Try out a command, such as:
    PS c:\cliqo> cliqo select account --max 50
    1       Services        Revenue 0
    2       Retained Earnings       Equity  0
    3       Prepaid Expenses        Asset   0
    4       Undeposited Funds       Asset   2062.52
    5       Fees Billed     Revenue 0
    6       Refunds-Allowances      Revenue 0
    7       Advertising     Expense 0
    8       Bank Charges    Expense 0
    9       Commissions & fees      Expense 0
    10      Dues & Subscriptions    Expense 0
    11      Insurance       Expense 0
    12      Legal & Professional Fees       Expense 0
    13      Meals and Entertainment Expense 0
    14      Miscellaneous   Expense 0
    15      Office Expenses Expense 0
    16      Promotional     Expense 0
    17      Rent or Lease   Expense 0
    19      Stationery & Printing   Expense 0
    20      Supplies        Expense 0
    21      Taxes & Licenses        Expense 0
    22      Travel  Expense 0
    23      Travel Meals    Expense 0
    24      Utilities       Expense 0
    25      Interest Earned Revenue 0
    26      Other Portfolio Income  Revenue 0
    27      Penalties & Settlements Expense 0
    28      Disposal Fees   Expense 0
    29      Equipment Rental        Expense 0
    30      Uncategorized Income    Revenue 0
    31      Uncategorized Expense   Expense 0
    32      Uncategorized Asset     Asset   0
    33      Accounts Payable (A/P)  Liability       -1602.67
    34      Opening Balance Equity  Equity  9097.5
    35      Checking        Asset   1201.0
    36      Savings Asset   800.0
    37      Truck   Asset   13495.0
    38      Truck:Original Cost     Asset   13495.0
    39      Truck:Depreciation      Asset   0
    40      Depreciation    Expense 0
    41      Mastercard      Liability       -157.72
    42      Visa    Liability       0
    43      Loan Payable    Liability       -4000.0
    44      Notes Payable   Liability       -25000.0
    45      Landscaping Services    Revenue 0
    46      Landscaping Services:Job Materials      Revenue 0
    47      Landscaping Services:Job Materials:Decks and Patios     Revenue 0
    48      Landscaping Services:Job Materials:Fountains and Garden Lighting        Revenue 0
    49      Landscaping Services:Job Materials:Plants and Soil      Revenue 0
    50      Landscaping Services:Job Materials:Sprinklers and Drip Systems  Revenue 0
    51      Landscaping Services:Labor      Revenue 0