QuickBooks for promotional products shops: what syncs and what does not

Most decorating shops end up entering the same order twice: once in whatever runs the shop floor, and again in QuickBooks so the accountant is happy. It is the most common piece of duplicate work in the industry, and it is the reason "does it sync with QuickBooks" is usually the second question a shop owner asks about any system.

The honest answer for any integration — ours included — is that some of it syncs. This page sets out which parts.

What actually syncs

• Customers. A customer created in your order system appears in QuickBooks, matched on name and email so you do not end up with "Riverbend Apparel" and "Riverbend Apparel LLC" as two records.
• Invoices. When you invoice an order, the invoice is created in QuickBooks with its line items, so revenue lands in the right accounts without rekeying.
• Payments. Payments recorded against an order post against the matching QuickBooks invoice, so your receivables reflect reality rather than yesterday's reality.

That covers the loop most shops care about: an order becomes an invoice, the invoice gets paid, the books show it. No re-entry.

What does not sync, and why

This is the part worth reading before you commit to any system.

• Production data does not go to QuickBooks. Screens, stitch counts, press schedules and proof approvals stay in the shop system. QuickBooks has nowhere sensible to put them and no reason to.
• Blank inventory is not a QuickBooks inventory item. Decorated apparel inventory is a genuinely awkward fit for accounting-software inventory: a shirt is a different SKU per colour and size, and it changes identity once it is printed. Shops that force this end up maintaining thousands of QuickBooks items that nobody reconciles.
• Purchase orders to blank suppliers stay in the shop system. You can post the resulting bill to QuickBooks, but the PO workflow — what is on order, what arrived short, what is backordered — belongs where the receiving happens.
• It is one-way for invoices. Editing an invoice inside QuickBooks after it has synced does not push the change back. Change it in the order system and let it flow, or the two will disagree.

Any vendor telling you their integration syncs everything either means something narrower than you do, or has not run it in a real shop.

What it costs

The QuickBooks connection carries a one-time setup fee, because it is a configured integration rather than a switch. Your chart of accounts, tax codes and item mapping are specific to your business and someone has to map them correctly the first time — getting that wrong is worse than not connecting at all, because the errors are quiet and land in your books.

There is no per-month charge for the connection itself, and no per-transaction fee. On the prepaid annual plan the setup fee is included.

QuickBooks Online or Desktop?

The integration connects to QuickBooks Online. Connection is by OAuth, so you authorise it from inside QuickBooks and no credentials are stored in the shop system.

If you are on QuickBooks Desktop, you are not stuck, but the path is different — either migrate to Online, or continue exporting. Plenty of shops run Desktop happily; it just is not the connected path.

Before you connect anything

Three things save most of the pain, whichever system you pick:

• Clean your customer list first. Duplicates in QuickBooks become duplicates everywhere the moment you sync. Merge them before, not after.
• Decide where invoices are created — and only create them there. Two people making invoices in two systems produces a reconciliation problem that grows every month.
• Agree the account mapping with whoever does your books. Ten minutes with your bookkeeper up front beats a quarter-end spent working out why decoration revenue landed in the wrong account.

Do you even need it?

A one-person shop invoicing twenty jobs a month probably does not. The re-entry is ten minutes a week, and the setup and mapping work is not free.

It starts paying at the point where invoicing is somebody's actual job, or where the gap between "we shipped it" and "the books know we shipped it" is long enough that you cannot tell what you are owed. That is usually somewhere north of a hundred invoices a month, or the moment you hire a bookkeeper.

Setting it up in PromoSoft

Connection is under the admin panel's QuickBooks settings. You authorise through Intuit's own consent screen, confirm the account mapping, and run a test invoice before switching it on for real work. Our team does the mapping with you as part of the setup fee.

Related: invoicing and getting paid · ACH vs credit card payments.