Excel Formulas
K R News Pty Ltd
daily sales/daily sales
lotto settlement
K & R NEWS - TILL RECONCILIATION v LOTTO REPORT
18-September-2017
19-September-2017
20-September-2017
21-September-2017
22-September-2017
23-September-2017
24-September-2017
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
SUNDAY
LOTTO REPORT
Total Lotto Sales as per report
Sales
Product sales
Auto sold shares (from settlement)
commission (ex gst)
Lotto sales
Instant sales
(enter as neg)
- Lotto payouts
-Instant payouts
Total payouts
-Auto prizes paid
-FREE instants
$2,153.16
$2,153.16
$0.00
$200.84
$2,354.00
$2,354.00
-$730.70
-$87.00
-$817.70
$0.00
-$5.00
-$822.70
$2,822.13
$0.00 $2,822.13
$0.00
$0.00
$263.86
$0.00 $3,085.99
$0.00
$0.00
$0.00
$0.00 $3,085.99
$0.00 -$254.82
-$273.00
-$527.82
$0.00
-$10.00
$0.00 -$537.82
$0.00
18-September-2017
POS 1
TILL REPORTS
POS 2
$265.60
$0.00 $3,110.84
$0.00
$0.00
$0.00
$0.00 $3,110.84
$0.00 -$417.70
-$113.00
-$530.70
$0.00
-$5.00
$0.00 -$535.70
$0.00
19-September-2017
MAIN
POS 1
MONDAY
POS 2
$0.00
$0.00
$0.00 $6,601.15
$0.00 -$475.22
-$203.00
-$678.22
$0.00
-$1.00
$0.00 -$679.22
$0.00
POS 1
POS 2
$0.00
$0.00
$0.00 $1,277.02
$0.00 -$674.48
-$133.00
-$807.48
$0.00
-$4.00
$0.00 -$811.48
$0.00
POS 1
POS 2
$290.42
$0.00 $3,400.00
$0.00
$0.00
$0.00
$0.00 $3,400.00
$0.00 -$982.50
-$123.00
-$1,105.50
$0.00
-$9.00
$0.00 -$1,114.50
$0.00
22-September-2017
MAIN
POS 1
THURSDAY
POS 2
POS 1
$0.00 $1,755.22
$0.02
$87.02
$0.00
$0.00 $4,089.10
$0.03
$52.77
$0.00
TOTAL SALES (INC)
enter as negative amounts
ACTUAL CASH/CHEQUES
EFTPOS PURCHASES
EFTPOS CASH OUT
ACCOUNTS
ACCOUNTS PAID (enter as positive)
AUTO SOLD SHARES
AUTO PRIZES PAID
SUB TOTAL
till surplus/shortage
GRAND TOTAL
$2,160.97
$0.00
$0.00 $3,419.38
$0.00
$0.00 $3,319.39
$0.00
$0.00 $6,830.55
$0.00
$0.00 $1,842.26
$0.00
$0.00 $4,141.90
-$1,362.00
-$793.57
-$20.00
$0.00
$0.00
$0.00
$0.00
-$2,175.57
$14.60
-$2,160.97
$0.00
$0.00
$0.00
$0.00
$0.00
-$1,316.70
-$2,103.36
$0.00
$0.00
$0.00
$0.00
$0.00
-$3,420.06
$0.68
-$3,419.38
$0.00
$0.00
$0.00
$0.00
$0.00
-$969.95
-$1,994.24
-$340.00
-$16.95
$0.00
$0.00
$0.00
-$3,321.14
$1.75
-$3,319.39
$0.00
$0.00
$0.00
$0.00
$0.00
-$3,202.20
-$3,381.95
-$230.00
-$6.75
$0.00
$0.00
$0.00
-$6,820.90
-$9.65
-$6,830.55
$0.00
$0.00
$0.00
$0.00
$0.00
-$907.69
-$949.80
-$20.00
-$453.14
$481.79
$0.00
$0.00
-$1,848.84
$6.58
-$1,842.26
$0.00
$0.00
$0.00
$0.00
$0.00
-$2,333.80
-$1,810.65
$0.00
-$7.60
$0.00
$0.00
$0.00
-$4,152.05
$10.15
-$4,141.90
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$48.11
$91.79
$0.00
$0.00
$2.27
$2.27
$0.00
$0.00
$7.50
$1.36
$14.05
$45.80
$31.32
$25.59
$12.27
$7.25
$33.59
$0.82
$40.00
$20.00
$64.66
$21.26
$9.97
$11.14
$3.64
$7.50
$108.95
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$828.96
$854.46
$0.00
$25.50
$77.75
$932.21
$932.21
-$450.84
-$69.00
-$519.84
$0.00
-$6.00
-$525.84
$0.00 $2,666.51
$3,400.15
$0.00
-$0.15
$0.00
$0.00
$381.01
$0.00 $3,781.01
-$982.50
$0.00
$0.00
$0.00
$0.00
-$132.00
$0.00
$0.00
$0.00 -$1,114.50
$0.00
$422.78
$342.85
$79.93
$0.00
$33.56
$31.81
$0.59
$4.77
$2.27
$2.50
$19.08
$20.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
POS 1
POS 2
MAIN
WEEKLY
TOTAL
SUNDAY
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 $1,300.09
$0.08
$62.57
$0.00
$0.00
$0.00
$0.00 $1,362.74
$0.00
$0.00
$23,077.19
$0.00
$0.00
$0.00
$0.00
$0.00
-$581.25
-$635.19
-$100.00
-$13.96
$0.00
-$32.45
$0.00
-$1,362.85
$0.11
-$1,362.74
$0.00
$0.00
$0.00
$0.00
$0.00
-$10,673.59
-$11,668.76
-$710.00
-$498.40
$481.79
-$32.45
$0.00
-$23,101.41
$24.22
-$23,077.19
$0.00
$0.00
$674.32
$906.71
$0.00
$32.45
$261.00
$1,200.16
-$450.84
-$0.00
$0.00
-$75.00
$0.00
-$525.84
$484.25
$414.82
$69.43
$19.96
$61.25
$1.82
$2.27
$2.27
$36.74
$19.48
$13.36
$41.95
$40.00
$90.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$409.22
$18.95
$130.00
$0.00
$0.00
$0.00
$0.00
$0.00
$870.00
$20.00
$0.00
$0.00
$0.00
$0.00
$0.00
$18,980.86
$10.00
$25.50
$1,770.35
$20,761.21
$0.00
$20,761.21
-$3,986.26
-$1,001.00
-$4,987.26
$0.00
-$40.00
-$5,027.26
24-September-2017
MAIN
SATURDAY
$0.00
$0.00
$8.15
$5.68
$5.68
$0.00
$0.00
POS 2
$0.00 $6,788.65
$0.13
$41.77
$58.95
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 $3,279.74
$0.04
$39.61
$0.00
$33.58
$59.98
$1.82
$7.50
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
-
$43.57
$2.86
$1.14
$1.82
$1.82
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 $3,379.42
$0.10
$39.86
-
$0.00
$0.00
$0.00
$0.00
$0.00
$728.56
$1,277.02
$0.00
$0.00
$263.02
$1,540.04
-$674.48
$0.00
$0.00
-$137.00
$0.00
-$811.48
$239.15
$126.27
$112.88
$0.00
$0.00
1-2025
$0.00
$0.00
$0.00
$0.00
$0.00
23-September-2017
MAIN
FRIDAY
$0.00
$0.00
$2,129.27
$0.00
$31.70
1-2020
$0.00
$0.00
$0.00 $6,350.94
$6,656.95
$0.00
-$55.80
$0.00
$0.00
$429.01
$0.00 $7,030.16
-$475.22
$0.00
$0.00
$0.00
$0.00
-$204.00
$0.00
$0.00
$0.00 -$679.22
$0.00
$233.88
$103.36
$130.52
$3,109.58
$0.00 $3,109.58
$0.00
$0.00
DAILY TOTAL
Rounding
GST
1-2010
$0.00
$0.00
$0.00
$109.24
$0.00 $1,277.02
$0.00
21-September-2017
MAIN
WEDNESDAY
$0.00 $2,841.17
$3,125.04
$0.00
-$14.20
$0.00
$0.00
$266.03
$0.00 $3,376.87
-$417.70
$0.00
-$0.00
$0.00
$0.00
-$118.00
$0.00
$0.00
$0.00 -$535.70
$0.00
$256.61
$161.91
$94.70
$1,167.78
$0.00 $1,167.78
$0.00
$0.00
$1,772.31
$2,354.00
$0.00
$0.00
$241.01
$2,595.01
-$730.70
$0.00
$0.00
-$92.00
$0.00
-$822.70
$210.21
$103.45
$106.76
-
$0.00
$562.64
$0.00 $6,601.15
$0.00
20-September-2017
MAIN
TUESDAY
$0.00 $2,933.21
$3,085.04
$0.00
$0.95
$0.00
$0.00
$385.04
$0.00 $3,471.03
-$268.77
$0.00
$13.95
$0.00
$0.00
-$283.00
$0.00
$0.00
$0.00 -$537.82
$0.00
$207.53
$117.18
$90.35
$6,038.51
$0.00 $6,038.51
$0.00
$0.00
GOLDEN CASKET SALES
Lotto sales
Lotto adjustments
Auto sold shares
Instant sales
SUBTOT SALES
- lotto payouts
- adjustment
- auto prizes
- instant payouts
- adjustment
SUBTOT PAYOUTS
NEWSPAPERS/MAGAZINES
Newspapers
Magazines
Books
Cards/Wrapping
Cigarettes/Tobacco
Confectionery
DRINKS
Drinks - GST
Drinks - FREE
Gifts/Toys
Stationery
Services
Postage Stamps
Incidentals
Drycleaning
Translink (go cards)
Delivery Fees
SubAgent sales
Ladbrokes
Phone cards
ACCOUNTS
$0.00
$2,845.24
$0.00 $2,835.24
$10.00
$0.00
weekly
report
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$17,967.02
$20,804.91
-$69.20
$32.45
$2,226.12
$22,994.28
-$4,000.21
$13.95
$0.00
-$1,041.00
$0.00
-$5,027.26
$2,054.41
$1,369.84
$684.57
$0.00
$302.39
$268.95
$23.49
$35.45
$17.95
$17.50
$204.70
$158.51
$26.45
$0.00
$0.00
$41.95
$0.00
$0.00
$409.22
$888.95
$340.00
$0.00
$22,721.49
$0.40
$355.30
$20,768.16
$23,077.19
23/01/2020
© Vicki Crawford 2015