- This topic is empty.
January 24, 2020 at 9:48 am #999989
I’ve had my service business for just under two years now and I record all transactions in a turnover excel sheet. My problem is, when I calculate pays, my pay week is Friday to Thursday. HOWEVER, When I calculate months endings I tend to calculate turnover and expenses from the 1st – 31st. This information often overlaps as I have to calculate two seperate sheets, one for turnover for the month and the other for the work week only.
Just say, that the 1st begins on a Wednesday. Do I include Wednesday in Last months profits because technically the new work week has not begun yet? And start the turnover from Friday the 3rd? or do I start it on the 1st regardless?
What do you guys do? I am a bit confused by this. When I calculate everything from 1st to 31st regardless of the day, it does not match up with my wages. My spreadsheets are broken down by months.
Just say the 31st of January is a Tuesday. Do I include this in January spreadsheet or February?January 26, 2020 at 5:32 am #1222196Dave – FS ConciergeModerator
- Total posts: 2,523
I have no idea, but I guess it depends how important it is for the numbers to match.
If using the weekly/monthly for different purposes they may not have to match exactly (say you use weekly for wages, and monthly numbers to track business performance).
Hopefully some of our members can share what they do.
DaveJanuary 26, 2020 at 5:43 am #1222197
Thanks! I do use the 1st to 31st for turnover. I guess I have to remember to use the wage calculations from the 1st to 31st as well.January 26, 2020 at 9:24 am #1222198LucasArthurParticipant
- Total posts: 3,158
Not sure i understand the full depth of the query, as it appears to be only for your own records as such and not lodgements of anything overly important?
If this is the case, technically if you want to run your monthly sheet, you would need to do daily wages for the same days so no overlapping occurs.. If you pul from the week before or the week after, your figures will be out.. In my opinion, it does sound like you need a daily calculation to do this..
For my figures, i tend to do a quick (non official) tabulation every Friday after i send accounts off etc etc which coincides with wages as well..
JasonJanuary 26, 2020 at 9:35 am #1222199
Daily sounds great! That will make it easier. Then I can use two formulas in excel, one for 1st to 7th and one from.start of pay week to end.January 26, 2020 at 11:07 am #1222200bb1Participant
- Total posts: 4,472
Must admit I’m confused what you are after. If you want to treat wages on that basis, you also need to treat debtors, but do you include them when you invoice them, or when they pay you.
Personally I think you are overthinking it, and should just take it at what has being paid at the end of the month, and not worry about that overlap period.January 26, 2020 at 11:17 am #1222201
Thanks yes I think I am overthinking it
- You must be logged in to reply to this topic.