Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need a template or idea to track daily sales for a restaurant and bar
|
#2
![]() |
|||
|
|||
![]()
Hi
That should be quite easy to setup? Decide what info you want to log, jot them down in Column A, starting in Row 2. In Row 1, starting in Col B, enter the dates, and you'r halfway there. Add formulae to sum each days info, and you have daily totals. Add formulae to sum each row, at the end of the month, and you have monthly totals per item. Add this column, and you have monthly grand total. For a bar, for example, you would want to track sales of liquor, so you could jot down things like Brandy, Cane, Whisky, Gin, Vodka and what not, sort them alphabetically, decide whether you want to log quantities or value, and insert daily totals in each column. "sleepyeye" wrote: I need a template or idea to track daily sales for a restaurant and bar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
templates on network drive | Excel Discussion (Misc queries) | |||
E-mailing excel templates? | Excel Discussion (Misc queries) | |||
how do i add excel templates to spreadsheet solution | Excel Discussion (Misc queries) | |||
finding templates | New Users to Excel | |||
Paste Link and Templates | Excel Worksheet Functions |