PHPackages                             excelle-insights/quickbooks - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [API Development](/categories/api)
4. /
5. excelle-insights/quickbooks

ActiveLibrary[API Development](/categories/api)

excelle-insights/quickbooks
===========================

QuickBooks Online integration package

090PHP

Since Mar 11Pushed 1mo agoCompare

[ Source](https://github.com/excelle-insights/quickbooks)[ Packagist](https://packagist.org/packages/excelle-insights/quickbooks)[ RSS](/packages/excelle-insights-quickbooks/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependenciesVersions (18)Used By (0)

Excelle Insights QuickBooks Integration
=======================================

[](#excelle-insights-quickbooks-integration)

A PHP package to integrate with **QuickBooks Online (QBO)**, including authentication, customer management, and local synchronization.

---

Installation
------------

[](#installation)

You can install the package via Composer:

```
composer require excelle-insights/quickbooks:dev-main
```

Environment Setup
-----------------

[](#environment-setup)

Create a .env file in your project root (or rely on the package .env):

```
# QuickBooks API
QBO_BASE_URL=https://quickbooks.api.intuit.com
QBO_CLIENT_ID=YOUR_CLIENT_ID
QBO_CLIENT_SECRET=YOUR_CLIENT_SECRET
QBO_REALM_ID=YOUR_COMPANY_ID
QBO_REDIRECT_URI=http://gimco.local/admin/debug_scripts/qbo-auth-callback.php
QBO_TABLE_PREFIX=qbo_beta

# Database connection
DB_DSN=mysql:host=127.0.0.1;dbname=myapp
DB_USER=root
DB_PASSWORD=secret

```

The package automatically loads its own .env if present.

Running Migrations
------------------

[](#running-migrations)

This package uses Phinx for database migrations.

1. Run the migrations:

```
php vendor/excelle-insights/quickbooks/migrate.php
```

For testing while developing the package, use the following command

```
php migrate.php --debug=true
```

Tables created include:

- api\_access\_tokens
- qbo\_invoice\_items
- http\_request\_logs
- qbo\_accounts
- qbo\_companies
- qbo\_customers
- qbo\_invoices
- qbo\_invoice\_items
- qbo\_journal\_entries
- qbo\_journal\_entry\_lines
- qbo\_payments
- qbo\_payment\_items
- qbo\_vendors
- qbo\_bills
- qbo\_bill\_items

Quick Start
-----------

[](#quick-start)

1. Get the OAuth Authorization URL

This script generates a link for the user to authorize your app in QuickBooks:

```