Category : Lotus and other Spreadsheets
Archive   : WORDPLAN.ZIP
Filename : DEMO3.WP

 
Output of file : DEMO3.WP contained in archive : WORDPLAN.ZIP

\clscreen
\equation @[email protected] = 0.0
\lspacing 2
\mask @[email protected] = ##,###.##
\pad @[email protected]
\wrline Daily Summary of Sales and Cash Receipts
\wrline CASH RECEIPTS
\rdnumber @A1 : Cash sales ?
\rdnumber @A2 : Collections on account ?
\rdnumber @A3 : Miscellaneous receipts ?
\equation @A4 = sum(@[email protected]) Total Receipts
\wrline CASH ON HAND
\wrline Cash in register
\rdnumber @A5 : Coins ?
\rdnumber @A6 : Bills (currency) ?
\rdnumber @A7 : Checks ?
\equation @A8 = sum(@[email protected]) Total cash in register
\rdnumber @A9 : Petty-cash slips ?
\equation @A10 = @A8 + @A9 Total Cash Accounted For
\wrline Less change and petty-cash fund:
\rdnumber @A11 : Petty-cash slips ?
\rdnumber @A12 : Coins and bills ?
\equation @A13 = @A11 + @A12 Change and petty-cash fund
\equation @A14 = @A10 - @A13 Total Cash Deposit
\wrline Deciding if Cash Short or Cash Over
\if @A4 > @A14
\equation @A15 = @A4 - @A14 Cash Short
\if @A4 < @A14

\equation @A16 = @A14 - @A4 Cash Over
\wrline TOTAL SALES
\rdnumber @A17 : Charge sales ?
\equation @A18 = @A1 + @A17 TOTAL SALES
\rdtext @B1 : enter todays date ?
\rdtext @B2 : enter your name ?
\nfill
\center
DAILY SUMMARY OF SALES AND CASH RECEIPTS
\tindent 48
Date @B1
\center
C A S H R E C E I P T S
1. Cash sales ......................................... @A1
2. Collections on account ............................. @A2
3. Miscellaneous receipts ............................. @A3
4. TOTAL RECEIPTS TO BE ACCOUNTED FOR ................. @A4
\center
C A S H O N H A N D
5. Cash in register or till:
Coins ......................................... @A5
Bills (currency) .............................. @A6
Checks ........................................ @A7
Total cash in register or till ............ @A8
6. Petty-cash slips .................................. @A9
7. TOTAL CASH ACCOUNTED FOR .......................... @A10
8. Less change and petty-cash fund:
Petty-cash slips .............................. @A11
Coins and bills ............................... @A12
Change and petty-cash fund ................ @A13
9. TOTAL CASH DEPOSIT ................................ @A14
10. CASH SHORT (Item 4 less item 9 if item 4 is larger) @A15
11. CASH OVER (Item 9 less item 4 if item 9 is larger). @A16
\center
T O T A L S A L E S
12. Cash sales ........................................ @A1
13. Charge sales ...................................... @A17
14. TOTAL SALES ....................................... @A18
\SPACE
\tindent 50
By @B2