Skip to main content

How Programa syncs with QuickBooks

Understand what syncs, how it works, and what to expect when using the QuickBooks integration.

Written by Mariana Moraes
Updated over a week ago

Programa's QuickBooks integration keeps your accounting records aligned with your billing activity without manual data entry. This guide explains what syncs, how it works, and what stays in Programa only.

Important: This is a one-way sync from Programa to QuickBooks. Updates made directly in QuickBooks won't be reflected back in Programa.


What Data Gets Synced

Invoices

When you create an invoice in Programa, these details are sent to QuickBooks:

  • Invoice number

  • Transaction date (when the invoice was created)

  • Due date (set in Programa)

  • Linked customer in QuickBooks

  • Tax settings (based on your project setup)

  • Project address- becomes the shipping address on the invoice in quickbooks

Tax details vary by region:

  • US: Total tax + a single tax code per project

  • Outside US: Total tax + detailed breakdown by rate

Line Items

Each item on the invoice includes:

  • Description (up to 100 characters)

  • Quantity and unit price (excluding tax)

  • Total amount (excluding tax)

  • Standard Programa category in QuickBooks (based on item type - see Products & Services below)

  • Tax code (e.g., 'TAX', 'NON', or country-specific codes)

Note: For tax-inclusive invoices, tax is removed before syncing to show the base amount.

Client Details

If the customer doesn't exist in QuickBooks, Programa creates them using information from your Address Book:

  • Company name (with "Customer - " prefix if the company is also a vendor)

  • Contact name, email, and phone number

Programa checks for existing customers by company name before creating new ones.

Products & Services

Rather than creating an individual named product in QuickBooks for each line item, Programa maps each item to one of four standard categories based on its type:

  • Programa Sales of Product Income — product line items from schedules

  • Programa Income from services — service and time entry line items (time entries are automatically categorised here)

  • Programa Generic Income — custom line items

  • Programa Discount Income — discounts applied to invoices

The income accounts configured in your QuickBooks settings are assigned to each category by default. To use a different account for a specific line item, you can override it directly on that line when creating your invoice in Programa.


What Doesn't Sync

Some information stays in Programa only:

  • Payments and payment terms (only due date syncs)

  • Notes, custom fields, or attachments

  • Project details beyond tax information

  • Programa-specific features like pinboards or tasks


How the Sync Works

The integration operates automatically in the background:

  • Source: Stripe (Programa's billing system)

  • Trigger: Stripe sends a signal when invoices are created or updated

  • Direction: One-way only (Programa → QuickBooks)

  • Actions: Creates, updates, and deletes invoices

Troubleshooting tip: If a customer reports sync issues, check the invoice's sync error messages in Programa for specific details.


Key Takeaways

  • The sync is one-way only from Programa to QuickBooks

  • Invoices, line items, customers, and products sync automatically

  • Payments, custom fields, and attachments don't sync

  • Syncing happens automatically via Stripe webhooks (background processing)


Need more help with the QuickBooks integration? Contact our support team via live chat for personalized assistance.

Did this answer your question?