Budgeting - Revision history

Cienna: Blanked the page

2024-12-02T02:24:36Z

Blanked the page

Cienna at 02:24, 2 December 2024

2024-12-02T02:24:04Z

← Older revision		Revision as of 02:24, 2 December 2024
Line 232:		Line 232:
	<br>		<br>
	[[File:R009-report.png\|900px]]		[[File:R009-report.png\|900px]]

			=Sales vs. Wages=
			Logging your incoming sales or gross profit (GP) and comparing it to your outgoing wages can be a fantastic way to achieve a properly forecasted roster, actively track sales for reports, and find discrepancies between your projections and what actually happened that week/fortnight.
			<br>
			To aid in ensuring full visibility of your data, you can also highlight when a wage percentage exceeds a certain amount, and even the option to track per department.
			<br><br>
			This information is different to Budgets but equally as beneficial, and will be coming soon in a future article.<br>
			You can also grab the Sales vs. Wages data from [[Reports#Sales.2FWages\|Reports]] for previous roster/pay periods, which can be exported into Excel.
			<br><Br>
			To get the best out of the Sales vs. Wages report, Projected Sales/GP data must be entered; this can be completed as you're creating the roster, or can be backdated.<br>
			Actual Sales/GP data is manually entered either in the timesheet or backdated in the roster for the same period. If you're lucky enough and use one of the [[Point of Sale]] systems that we integrate with, we may be able to pull your data automatically.
			<br><br>
			Before we get to the fancy stuff, let's enable the tool and have a look at the difference between Sales and Gross Profit, and how Sales vs. Wages works.<br><br>

			==Difference between Sales and Gross Profit==
			Sales is incoming revenue stream into the business, based off selling your goods and services.<br>
			Gross profit is the incoming revenue stream minus production/manufacturing costs and any overheads.<br>
			Depending on which you would prefer tracking, it can change the wage percentage and calculations for this tool and report.
			<br><br>

			==Enabling Sales/GP Tracking==
			* Open up Wageloch and sign in.
			* Click on the Settings cog in the top right and select General.
			<Br>[[File:2.0 Settings and General.png\|300px]]

			* Tick the box for Track wage percentages
			** Choose to track by Sales or Gross Profit.
			** Opt for highlighting % or if you'd like to track per department.
			* Click Done to save.

			<br>[[File:2.0 Track Wage Percentages.png\|300px]]<br>

			==How does it work?==
			When creating your roster and inputting data in the Sales area, the only two fields you can enter values into are the Projected Sales/GP and the Actual Sales/GP.
			Ideally when in the setup stages, only input the Projected Sales/GP values; if you're backdating data, you can input the Actual Sales/GP values.<br>

			To generate the wage percentage and reports correctly, the calculations work off '''four (4)''' fields:
			* Projected Sales or Gross Profit
			* Actual Sales or Gross Profit
			* Projected Wages (based off the rostered hours)
			* Actual Wages (based off the timesheet)
			<br>
			When viewing your Wage Percentage, for most industries anything sitting around '''20% - 25%''' is average and ideal; the lower the better.
			If you're finding your wage percentage is creeping up and over 30%, you may need to review your revenue or your rosters to be more cost effective.<br>

			{\| class="wikitable"
			! style="color:black; background-color:#e49cc5" \| '''Figures to include for accurate data:'''
			\|-
			\|
			*Projected Sales or Gross Profit
			*Actual Sales or Gross Profit
			*Projected Wages (based off the rostered hours)
			*Actual Wages (based off the timesheet)
			\|}<br>

			{\|class="wikitable" style="text-align:center;"
			! style="color:black; background-color:#e49cc5" \| '''Value 1'''
			! style="color:black; background-color:#e49cc5" \| '''Value 2'''
			! style="color:black; background-color:#e49cc5" \| '''Result'''
			! style="color:black; background-color:#e49cc5" \| '''Notes'''
			\|-
			\| Projected Sales/GP \|\| Actual Sales/GP \|\| Sales/GP Variance \|\| Are you up, down or break even?
			\|-
			\| Projected Wages \|\| Actual Wages \|\| Wages Variance \|\| Did you spend more/less on wages than you earned?
			\|-
			\| Projected Wage % \|\| Actual Wage % \|\| Wage Percentage Variance \|\| What is the variance between the % of money you spent on wages?
			\|-
			\| Roster Hours \|\| Actual Paid Hours \|\| Hours Variance \|\| Was there a difference between your roster and timesheet hours?
			\|-
			\| Projected Sales/GP \|\| Projected Wages \|\| Projected Wage % \|\| How much of your Sales/GP will you anticipate spending on wages?
			\|-
			\| Actual Sales/GP \|\| Actual Wages \|\| Actual Wage % \|\| How much of your Sales /GP have you spent on Wages?
			\|}
			<br>
			</center>

			==Format: Roster vs Report ==

			When looking at the difference between the two report formats, one key difference is that when running the Sales vs Wages report from the [[Reports]] menu, this is able to be exported as a .csv or .xlsx spreadsheet format to work with in programs such as Microsoft Excel or even Google Sheets.

			Click on the thumbnails to open a larger view of the images.
			<center>
			[[File:Salesvwages.PNG\|400px\|Sales vs Wages via Roster]] [[File:Sales report r002.PNG\|400px\|Sales vs Wages via Reports]]
			</center>
			<br>
			<br>
			<br>
			[[File:Back-button-new.png\|link=Budgeting]] [[File:Home-button-new.png\|link=Main Page]] [[File:Next-button-new.png\|link=Grid View]]

Cienna at 05:16, 15 September 2023

2023-09-15T05:16:29Z

← Older revision		Revision as of 05:16, 15 September 2023
Line 232:		Line 232:
	<br>		<br>
	[[File:R009-report.png\|900px]]		[[File:R009-report.png\|900px]]




			[[File:Back-button-new.png\|link=Rotation Templates]] [[File:Home-button-new.png\|link=Main Page]] [[File:Next-button-new.png\|link=Sales Vs. Wages]]

Cienna: /* Budget Reports */

2023-05-25T05:54:52Z

Budget Reports

← Older revision		Revision as of 05:54, 25 May 2023
Line 198:		Line 198:
	* Roster Budget Report (R008)		* Roster Budget Report (R008)
	* Roster Budget by Timesheet Columns (R009)		* Roster Budget by Timesheet Columns (R009)

	===Roster Budget Report===		===Roster Budget Report===
	[[File:Roster-budget-r008.png\|right\|400px]]		[[File:Roster-budget-r008.png\|right\|400px]]
Line 213:		Line 214:
	<br>		<br>
	[[File:R008-report.png\|900px]]		[[File:R008-report.png\|900px]]
			<br>
	==Roster Budget by Timesheet Columns==		===Roster Budget by Timesheet Columns===
	[[File:Roster-budget-r009.png\|right\|400px]]		[[File:Roster-budget-r009.png\|right\|400px]]
	* Click the Reports tab from the top menu.		* Click the Reports tab from the top menu.

Cienna: /* Roster Budget Report */

2023-05-25T05:54:35Z

Roster Budget Report

← Older revision		Revision as of 05:54, 25 May 2023
Line 198:		Line 198:
	* Roster Budget Report (R008)		* Roster Budget Report (R008)
	* Roster Budget by Timesheet Columns (R009)		* Roster Budget by Timesheet Columns (R009)
	==Roster Budget Report==		===Roster Budget Report===
	[[File:Roster-budget-r008.png\|right\|400px]]		[[File:Roster-budget-r008.png\|right\|400px]]
	* Click the Reports tab from the top menu.		* Click the Reports tab from the top menu.

Cienna: /* Budget Reports */

2023-05-25T05:54:22Z

Budget Reports

← Older revision		Revision as of 05:54, 25 May 2023
Line 198:		Line 198:
	* Roster Budget Report (R008)		* Roster Budget Report (R008)
	* Roster Budget by Timesheet Columns (R009)		* Roster Budget by Timesheet Columns (R009)
	~~<br>~~
	~~<br>~~
	==Roster Budget Report==		==Roster Budget Report==
	[[File:Roster-budget-r008.png\|right\|400px]]		[[File:Roster-budget-r008.png\|right\|400px]]

Cienna at 05:53, 25 May 2023

2023-05-25T05:53:28Z

← Older revision		Revision as of 05:53, 25 May 2023
Line 128:		Line 128:

	==Maximum Wage Budget by Department==		==Maximum Wage Budget by Department==
	~~==Maximum Wage Budget==~~
	Setting a maximum wage budget by department allows you to keep track of your wage spending per department (team, area, job, etc.), which is useful if you're trying to ensure certain areas of your business are not costing too much (or too little!).		Setting a maximum wage budget by department allows you to keep track of your wage spending per department (team, area, job, etc.), which is useful if you're trying to ensure certain areas of your business are not costing too much (or too little!).
	Being able to have a visual flag to indicate your wages are higher than desired will help understand where your departments may need attention, or gain insight into rostering habits should your department heads be completing rosters on your behalf.		Being able to have a visual flag to indicate your wages are higher than desired will help understand where your departments may need attention, or gain insight into rostering habits should your department heads be completing rosters on your behalf.

Cienna: /* Maximum Wage Budget */

2023-05-25T05:52:32Z

Maximum Wage Budget

← Older revision		Revision as of 05:52, 25 May 2023
Line 156:		Line 156:
	<br>		<br>
	<br>		<br>
	[[File:Max-budget-warning.png]]		[[File:Max-budget-warning.png\|750px]]

	==Maximum Hours by Department==		==Maximum Hours by Department==

Cienna: /* Maximum Hours by Department */

2023-05-25T05:52:05Z

Maximum Hours by Department

← Older revision		Revision as of 05:52, 25 May 2023
Line 186:		Line 186:
	** This option is useful if users have [[Users & Security\|departmental restriction]] and are taking care of their own team's rosters.		** This option is useful if users have [[Users & Security\|departmental restriction]] and are taking care of their own team's rosters.
	<br>		<br>
	[[File:Max-hours-reached-roster.png]]		[[File:Max-hours-reached-roster.png\|750px]]
	<br><br>		<br><br>
	When finalizing your timesheets:		When finalizing your timesheets:
Line 192:		Line 192:
	* This gives you an opportunity to discover why so many hours have been used, or if any staff need to be reallocated between departments.		* This gives you an opportunity to discover why so many hours have been used, or if any staff need to be reallocated between departments.
	<br>		<br>
	[[File:Max-hours-reached-timesheet.png]]		[[File:Max-hours-reached-timesheet.png\|750px]]

	=Budget Reports=		=Budget Reports=

Cienna: /* Budget Reports */

2023-05-25T05:49:35Z

Budget Reports

← Older revision		Revision as of 05:49, 25 May 2023
Line 216:		Line 216:
	<br>		<br>
	[[File:R008-report.png\|900px]]		[[File:R008-report.png\|900px]]

			==Roster Budget by Timesheet Columns==
			[[File:Roster-budget-r009.png\|right\|400px]]
			* Click the Reports tab from the top menu.
			* Select the Rostered Hours category.
			* Click Roster Budget by Timesheet Columns (R009)
			<Br>
			* <b>Select Period:</b> Pick the roster period or date range to run the report for.
			* <b>Display Preferences:</b> Options for showing or hiding information and sorting by name type is available.
			* <b>Staff Filter:</b> You can enable Filter by Staff if you're wanting this report for particular employees.
			* <b>Timesheet Display Preferences:</b> Additional options for showing/hiding information, the ability to use days that have been finalized in the timesheet, grouping by department and including paid values or data from incomplete timesheets that have yet to be paid.
			* <b>The Report:</b> Will break down the roster information according to your award information, including penalty rates, overtime, leave, etc.
			** On the sample below, Show Paid Values on the Timesheet Display Preferences tab has been enabled.
			<br>
			Use the Export button at the bottom left to download a spreadsheet.
			<br>
			<br>
			[[File:R009-report.png\|900px]]