Embedded Files
Done to provide better information on SOH (done for both BC & BQ).
SOH how to available here,
Data to update here
In Xero do a manual journal entry - see below. Debit SOH increases / Credit decreases.
Entering end of month sales for Beer Cartel (Beer Subscription)
Entering end of month sales for Beer Cartel (Beer Subscription)
Click New Sales Invoice
Select Beer Cartel.
Month enter the last day of the month for which the data is for.
Invoice # Beer Club MONTH 2023
Enter sales numbers from Shopify. Should be listed as Tax Inclusive.
Should go to 41100 Beer Club Sales and Offset against Taking Clearing Account.
Charging Brewquets for expenses incurred by Beer Cartel
Charging Brewquets for expenses incurred by Beer Cartel
Find most recent Australia Post invoice
In Xero go to Reports > Payroll Employee Summary
Choose Last Month.
Save in G:\Shared drives\Accounts\Brewquets\Brewquets Suppliers\Brewquets Kitting Costs owed to Beer Cartel
Delete employees that did not work for BQ for last month.
Create column that is sum of Earnings + Super.
Create new invoice in Xero
Do due date as last day of the past month.
Invoice # can be Brewquets [MONTH] Costs
Add first line: Staff Costs [MONTH] - account BQ income
Add next line: Australia Post [MONTH] Invoice
Once completed choose Send via Xero Network
When received by Brewquets the line items can be coded as follows:
AusPost : Freight
Staff: Labour Hire
Page updated
Report abuse