Cash Reconciliation Summary- Sample Report
From Wiki-eostar.com
The following is a sample report that is viewable from the Review and Post tab on the Daily Route Settlement.
********************RECONCILIATION SUMMARY REPORT ****************************
DRIVER Route 07 M. McBride
TRUCK Route 07
DATE 01/03/2006
BY administrator
WHEN 04/21/2006 @ 2:13 PM
NOTE Here is a little note that you can record along with your
reconciliation ... it becomes part of the summary and is saved along
with all of the other reconciliation data
*** Reconciliation charge to driver of $4.42 ***
CASH ROOM RECEIPTS DRIVER EXPENSES
------------------ ---------------
157.00 Cash 7.50 Food
2055.73 Check 45.00 Fuel
50.00 Voucher 12.00 Toll
24.00 Coupon 0.00 Room
-------- 12.00 Other
2286.73 --------
76.50
CREDITS RECORDED CREDIT USED REMAINING
---------------- ----------- ---------
770.70 EFT 770.70 0.00
309.42 Cash 289.42 20.00
2165.73 Check 1811.74 353.99
50.00 Voucher 50.00 0.00
24.00 Coupon 24.00 0.00
0.00 Credit card 0.00 0.00
181.50 Credit invoices 181.50 0.00
------------------------- ----------- ---------
3501.35 2945.86 373.99
3739.05 Total invoiced ... excluding credit invoices
2945.86 Total applied ... excluding refunded amounts
0.05 Total write-off
--------
793.14 Total open due ... assumes EFT as collected
RECONCILED PAYMENT DETAIL **************************************************
DESCRIPTION CUSTOMER NAME [#] AMOUNT APPLIED REMAINING
----------- ----------------- ------ ------- ---------
Cash SHOOTER'S LOUNGE [#1303] 128.70 128.70 0.00
Cash PHARM PHRESH GROCERY #268 [#287] 160.72 160.72 0.00
Cash BILLY BOB'S CROSSROADS [#949] 20.00 0.00 20.00
Chk 12341 CHUNKY'S TRUCK STOP [#71] 11.80 11.80 0.00
Chk 542 CHEESY GOLF COURSE [#86] 97.80 97.80 0.00
Chk 3223 BILLY BOB'S HUNTING & FISHING 64.61 64.61 0.00
[#315]
Chk 55432 JC'S GRILL [#1183] 200.00 155.87 44.13
Chk 3323 LAVERNE'S PLACE [#579] 100.00 63.89 36.11
Chk 1212 BUBBA'S PLACE [#1522] 110.00 110.00 0.00
Chk 3241 WOODCHUCK GAS [#96] 50.00 50.00 0.00
Chk 2214 BOYSENBERRY PATCH [#502] 47.20 47.20 0.00
Chk 4432 TRIPOLI MART [#1187] 47.92 47.92 0.00
Chk 1143 PHARM PHRESH GROCERY #268 [#287] 100.00 100.00 0.00
Chk 14423 ESA #39 - CHEESY [#1328] 312.60 312.60 0.00
Chk 1143 MONTECRISTO EZ MART [#1184] 139.11 139.11 0.00
Chk 1121 VAL U TOWN #2606 [#979] 143.04 143.04 0.00
Chk 142 PHARM PHRESH GROCERY #521 390.00 390.00 0.00
[#1077]
Chk 1132 RED BARN X-PRESS [#320] 77.90 77.90 0.00
Chk 2502 CHUNKY'S TRUCK STOP [#71] 250.00 0.00 250.00
Chk 443 MARMALADE'S BAR & GRILL [#25] 23.75 0.00 23.75
Vch 4434 VAL U TOWN #2606 [#979] 50.00 50.00 0.00
Coupon WOODCHUCK GAS [#96] 4.00 4.00 0.00
Coupon VAL U TOWN #2606 [#979] 20.00 20.00 0.00
------ ------- ---------
2549.15 2175.16 373.99
VOIDED PAYMENT DETAIL ********************************************************
DESCRIPTION CUSTOMER NAME [#] AMOUNT
----------- ----------------- ------
Chk 1121 CHEESY GOLF COURSE [#86] 50.00
------
50.00
CUSTOMER REFUNDS FOR CREDIT INVOICES *****************************************
ORDER CUSTOMER NAME [#] REFUNDED
----- ----------------- --------
123135 CONJUNCTION JUNCTION 181.50
--------
181.50
RECONCILED INVOICE DETAIL ****************************************************
ORDER CUSTOMER NAME [#] INVOICED APPLIED
----- ----------------- -------- -------
9355 BLACKSHEEP COMMUNITY 0.00 0.00
GROCERY [#1300] --------
0.00 Due
9357 CHUNKY'S TRUCK STOP [#71] 11.80 11.80 Check 12341
--------
0.00 Due
9358 CHEESY GOLF COURSE [#86] 97.80 97.80 Check 542
--------
0.00 Due
9359 BILLY BOB'S HUNTING & 64.61 64.61 Check 3223
FISHING [#315] --------
0.00 Due
9366 JC'S GRILL [#1183] 155.87 155.87 Check 55432
--------
0.00 Due
9372 LAVERNE'S PLACE [#579] 63.89 63.89 Check 3323
--------
0.00 Due
9377 BUBBA'S PLACE [#1522] 111.50 110.00 Check 1212
--------
1.50 Due
9387 SHOOTER'S LOUNGE [#1303] 128.75 128.70 Cash
0.05 Ticket correctio...
--------
0.00 Due
1505711 L'IL GENERAL #127 [#807] 322.15 0.00
--------
322.15 Due
9368 VILLAGE POOL ROOM [#551] 70.80 0.00
--------
70.80 Due
9376 WOODCHUCK GAS [#96] 54.44 50.00 Check 3241
4.00 Coupon
--------
0.44 Due
1505713 BAH-HUMBUG MINI SHOP #6 131.59 0.00
[#1349] --------
131.59 EFT expected
1505714 BOYSENBERRY PATCH [#502] 47.20 47.20 Check 2214
--------
0.00 Due
1505715 TRIPOLI MART [#1187] 47.92 47.92 Check 4432
--------
0.00 Due
1505716 KOB GROCERY #0928 [#747] 307.99 0.00
--------
307.99 Due
1505717 PHARM PHRESH GROCERY #268 260.72 100.00 Check 1143
[#287] 160.72 Cash
--------
0.00 Due
1505718 ESA #39 - CHEESY [#1328] 312.60 312.60 Check 14423
--------
0.00 Due
1505719 GOLDEN GALLON #444 [#465] 440.34 0.00
--------
440.34 EFT expected
1505720 MONTECRISTO EZ MART [#1184] 139.11 139.11 Check 1143
--------
0.00 Due
1505721 TIL MIDNIGHT [#1186] 90.26 0.00
--------
90.26 Due
1505722 GOLDEN GALLON #530 [#830] 86.29 0.00
--------
86.29 EFT expected
1505724 VAL U TOWN #2606 [#979] 213.04 50.00 Voucher 4434
20.00 Coupon
143.04 Check 1121
--------
0.00 Due
1505725 PHARM PHRESH GROCERY #521 390.00 390.00 Check 142
[#1077] --------
0.00 Due
1505726 GOLDEN GALLON #550 [#427] 112.48 0.00
--------
112.48 EFT expected
1505727 RED BARN X-PRESS [#320] 77.90 77.90 Check 1132
--------
0.00 Due
123135 CONJUNCTION JUNCTION -181.50 181.50 Refunded
[#1157] --------
