Each account requires their LCLB licence number before you can create a delivery order. Customer type determines pricing (LIC = Retail price, LRS/GRC/MOS = Wholesale price).
Nechako Pub
123 abc, Nechako, BC ยท Licence: 123456
Steve ยท 778-675-1212
LIC2 orders
Tavern
2233 bbav, Mackenzie, BC ยท Licence: 1515151
Mike ยท 997-6931
MOS1 order
ABC of BEER
BC ยท Licence: โ
MOS1 order
dsfsdf
BC ยท Licence: โ
MOS0 orders
Delivery Orders
Invoice #1004 โ ABC of BEER
2026-06-04 ยท 2 lines ยท own
delivered$440.97
Invoice #1002 โ Nechako Pub
2026-05-26 ยท 1 line ยท own
confirmed$68.60
Invoice #1003 โ Tavern
2026-05-26 ยท 1 line ยท pickup
delivered$292.50
Invoice #1001 โ Nechako Pub
2026-05-25 ยท 1 line ยท own
delivered$331.80
Customer Returns
Returns reference the original delivery invoice number. Reason codes follow LDB Form 55 categories.
โฉNo returns recorded yet.
Internal Transfers
This is not a sale. A transfer moves finished beer from production to one of your own storefront locations. The beer stays in your inventory โ only its location (QBO Class) changes. Transfers are never reported to DSWR and never create a customer invoice; the reportable sale happens later when that location's POS rings it to a customer. Register your locations in Setup first.
๐ชNo locations registered yet. Add your storefront(s) in Setup โ Our Locations before recording a transfer.
Active accounts
2
registered
Total orders
3
0 draft
Delivered (all time)
2
Staged for QBO
1
not yet exported
2026-05-25 โ 2026-06-01
DSWR packaged sales โ this week
Beer / SKUCases deliveredValue (ex-GST)
Mackenzie Gold SKU-00110$300.00
Staged for QBO import Delivered orders not yet exported
#1003 Tavern 2026-05-26
$292.50
On-premise sales (MOS) โ this week
Mackenzie Gold1 cases$250.00
Changes apply immediately. Customer records cannot be deleted once orders exist against them.
Company Profile Shared with POS & Brew Log
Set up POS first if all tools are on the same device โ the fields below will auto-populate from that setup. If this is a standalone device, fill them in here.
Container Formats
DescriptionSize (mL)Units/caseDeposit $CRF $
Our Locations
Register your own storefront(s) here โ not in the customer register. Moving beer to one of these is an internal transfer (Class change in QBO), never a DSWR sale. The MOS store number is used later when that location reports its own sales to consumers.
Location nameQBO ClassMOS store no.
No locations yet. Add your storefront with the button above.
Pricing by Customer Type
Prices are set by LDB. Enter the current LDB-established price per selling unit for each customer type. Retail price applies to LIC (Hospitality). Wholesale price applies to LRS, GRC, MOS.
Inventory move only โ Inventory Asset stays the same account in QBO; the Class changes from Production to the destination location. Excluded from DSWR.
Beer (SKU)ContainerQty (cases)
Add Account
Export
DSWR โ packaged sales CSV
Upload-ready format (all delivered orders + returns). Filename auto-generated to LDB spec.
QBO โ invoice import CSV
QBO โ internal transfer journal CSV
Inventory-location moves (Class changes). Amounts left blank to fill at cost in QBO. Not a sale; excluded from DSWR.
Customer register CSV
Delete order?
This permanently removes the order. Delivered orders should be cancelled instead to preserve the audit trail.