The Saskatchewan Craft Producers Report is a tax report that also collects and reports other metrics from local breweries.
BrewNinja contains this report which will populate the amounts required to report for each line item in the actual report. You can get further details on the transactions involved with the calculation of each line, by clicking the details link.
Saskatchewan Craft Producers Report Line Numbers
Line1
The value for this line is derived by counting all Product SKU inventory as of beginning of starting range date. Eg; If you are running the report for February 01 - February 28, this line will include all SKU inventory as of the beginning of February 01.
Line2
The value for this line is derived from counting the litres of finished (bottled) product that were produced during the date range, including any contract manufactured product. Both the contractor and the contractee must include contract manufactured product on their monthly production.
This value includes only production values that affected inventory, such as packaging, sales, that have been FINALIZED within the date range. Eg: If a Sales Order was created in January, but wasn’t delivered or finalized until February, the quantity is included in February's report, and would not be reported for January’s report.
Line3
The value for this line is derived from the litres of bulk product destroyed this month. These numbers represent transfers from a tank to the Discard Tank.
Line 4
This value is derived from beer Product SKUs on Sales Orders that are to a separate province than your own billing province, and have been finalized during the reporting period.
Line 5
This value is derived from litres of finished (bottled) product that were sold directly in Saskatchewan (consumers, all retailers including SLGA retail stores, commercial permittees, manufacturer on-site tasting room), finalized within the reporting period.
Line 6
This value is derived from the liters of finished products that were sold to SLGA and finalized during the reporting period, provided that your SLGA business partners are in the Government category.
Line 7
This value is derived from the liters of finished products on sales orders, finalized in the reporting period, with negative quantities listed.
Line 8
This is the result of calculating Line 1 + Line 2, minus the sum of Line 3-6, for all transactions finalized during the reporting period. Note: this is a statistical number only; due to transaction dates described above, this line does not necessarily match Line 1 of next month’s report.
Line 9
Just the amount reported on Line 5; finished goods sold directly in Saskatchewan are applicable to levy.
Other fields
Are products produced outside of the province during the month included?
if you have a secondary warehouse not located in Saskatchewan, and you produced product for sale in that province, or for import into this province, you must say yes here.
Did you send unfinished product outside of the province during the month?
If you sent wort or other unfinished product to any partners, or your secondary warehouses, for contract brewing or otherwise, outside of the province, you must say yes here.
Did you contract manufacture any products during the month?
If you produced packaged product from wort received from another company, or used your own materials to produce packaged product on behalf of another company, or another company produced product for you, you must say yes here, and indicate how much (in litres) you produced for someone else, or someone else produced for you. Notes on the definition of Contract Brewing can be seen on the actual report
Other Notes:
The report takes inventory from start of the reporting range, and applies volume adjustments that happened during the month, and reports the number as of the end of the reporting range.
Subsequent months where transactions were ‘OPEN’ in the previous month, are reported on this month’s report (eg, the date the transaction is finalized), and not reported on last months’ report. This is normal, and inconsistencies between the ending inventory of last month's report, and the value of inventory coming into this month are anticipated.
Depending on transactions status, report numbers may show different than what is expected, based on the date the transaction was finalized and a History log entry generated, and not the date the transaction was posted for. (Eg, if you create a sales order on February 27th, which was for a transaction that occurred on January 29th, then finalize that transaction, the inventory will still have been deducted when the sale was finalized, eg, February 27th, and will not show up on January's Craft Producers Report).
If you are late in logging transactions (packaging, sales, etc), and these late entries are not on the previous month's report, you can always resubmit a new report for that month, or those values will be reflected on the current month’s report.
The numbers reported here are for used statistical purposes only (at present); the levy amount reported here is still the same calculation as before.