Skip to main content

Syncing one Bill per receive from Stockroom to QuickBooks Online

Create a separate QuickBooks Bill for each delivery you receive in Stockroom, dated on the supplier's invoice date.

By default, MyWorks keeps one Bill per purchase order, updated as items are received. If your purchase orders arrive in several deliveries - each with its own supplier invoice - set Bills for received purchase orders in Settings > Purchase Orders to One bill per receive. Each receive you record in Stockroom then syncs to QuickBooks as its own Bill, with just the items, quantities and costs from that delivery. This needs the Scale or Soar plan.

What each Bill contains

  • The Bill's number is the Invoice # entered on the receive in Stockroom. If a receive doesn't have one, MyWorks numbers the Bill from the purchase order number and the receive - for example, PO-1003-R81.

  • The Bill is dated on the Invoice date entered on the receive in Stockroom - the date on the supplier's invoice. If the receive has no invoice date, the Bill is dated the day the items were received.

  • QuickBooks fills in the due date from the vendor's default payment terms.

  • A note on the receive syncs as the Bill's memo.

  • The receive's share of the purchase order's shipping and other charges is added to its Bill as separate lines.

Keeping the Bills up to date

While Purchase Orders is switched on under Stockroom > QuickBooks Online in Settings > Automatic Sync, MyWorks keeps each receive's Bill in step with Stockroom:

  • If a receive's charges or invoice date change, its Bill is updated - the same Bill, never a second one.

  • Voiding a receive deletes its Bill in QuickBooks, so correcting a receive (void, then receive again) replaces the old Bill with a new one. If a Bill can't be deleted - for example, it's already been paid - the receive shows a sync error until that Bill is removed in QuickBooks.

With that setting off, changes in Stockroom never change, create or delete these Bills, so edits you make to them in QuickBooks are kept. Use Push again on the purchase order in Stockroom, or Push > Purchase Order in MyWorks, to bring them up to date - this replaces any edits made in QuickBooks.

Good to know

Did this answer your question?