Hi All,
I am trying to create a spreadsheet for a bar selling alcohol which has the GPP, VAT and cost prices for opening, closing stock and introduction of new stock. There is also an end-of-week stock check element This is the simple part. I had thought to run it for the whole year so it reduced the introduction of errors.
The auditing aspects are broken into four quarters starting on the first day of June. The way the company has set things up means that some months overlap, yes confusing I know.
The complicated part is with the recording of the stock. I have to show an archived copy of the stock levels at the end of each week both as a hard copy and within a spreadsheet, including the formulas. Is this possible?
Any feedback and pointers would be great.
Thanks in advance
I am trying to create a spreadsheet for a bar selling alcohol which has the GPP, VAT and cost prices for opening, closing stock and introduction of new stock. There is also an end-of-week stock check element This is the simple part. I had thought to run it for the whole year so it reduced the introduction of errors.
The auditing aspects are broken into four quarters starting on the first day of June. The way the company has set things up means that some months overlap, yes confusing I know.
The complicated part is with the recording of the stock. I have to show an archived copy of the stock levels at the end of each week both as a hard copy and within a spreadsheet, including the formulas. Is this possible?
Any feedback and pointers would be great.
Thanks in advance
