#1   Report Post  
sleepyeye
 
Posts: n/a
Default templates

I need a template or idea to track daily sales for a restaurant and bar

  #2   Report Post  
Kassie
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
templates on network drive maryj Excel Discussion (Misc queries) 15 June 27th 05 10:28 PM
E-mailing excel templates? StevePMB Excel Discussion (Misc queries) 1 March 2nd 05 04:25 PM
how do i add excel templates to spreadsheet solution ocjoe Excel Discussion (Misc queries) 2 February 4th 05 02:25 PM
finding templates Jlo New Users to Excel 1 November 29th 04 11:46 PM
Paste Link and Templates Emerald MR Excel Worksheet Functions 0 November 9th 04 07:22 PM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"