jagomart
digital resources
picture1_Sales Template Excel Free Download 32440 | Pc Ex 04 Daily Takings Sheet


 187x       Filetype XLSX       File size 0.04 MB       Source: education.qld.gov.au


File: Sales Template Excel Free Download 32440 | Pc Ex 04 Daily Takings Sheet
sheet 1 guide purpose this template is used when collecting cash and cheques where cash registers are not available the daily takings sheet will help to track the sales and ...

icon picture XLSX Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Guide





Purpose



This template is used when collecting cash and cheques, where cash registers are not available.


The Daily Takings sheet will help to track the sales and check takings.





Requirements



When money is collected and brought to the Treasurer, whether it is from a commercial activity or ongoing collections during the course of a fundraising activity:

Record the names of people authorised to collect money.

Ensure two independent people collect and count money daily. This is to ensure a segregation of duties.

Maintain a daily takings register/collection sheet for trading activities.

The register must be certified by two people.

Check that money received is the same amount shown on the receipt that has been signed by the collectors.

Provide a receipt to the people who have collected the money for the amount handed over.






Create one cash sales sheet for each sales point.





Sheet 2: Example


ABC State School P&C Association Daily Takings Sheet






DATE: Sunday, June 30, 2019





Type of Activity

Bookshop


Fundraising Activity Fete burger stand

Other Activity


Tuckshop


Uniform Shop






Approved Float of: $100.00

Do not add Float to Cash Takings

The float is removed before counting the money





CASH TAKINGS

NOTES

$100.00


$50.00 2

$20.00 1

$10.00 1

$5.00 2

TOTAL NOTES $140.00

COINS

$2.00 3

$1.00 3

$0.50 1

$0.20 1

$0.10 3

$0.05


TOTAL COINS $10.00





BANKING SUMMARY

CHEQUES TOTAL
(see attached documentation)
$20.00

TOTAL CASH $150.00

TOTAL BANK DEPOSIT $170.00

Date Banked


Banking Receipt No.






COUNTED BY

Name


Date


Signature


CHECKED BY

Name


Date


Signature


BANKED BY

Name


Date


Signature






Ensure a copy of the bank processed deposit slip is filed in chronological order with your end of month bank reconciliation


The words contained in this file might help you see if this file matches what you are looking for:

...Sheet guide purpose this template is used when collecting cash and cheques where registers are not available the daily takings will help to track sales check requirements money collected brought treasurer whether it from a commercial activity or ongoing collections during course of fundraising bull record names people authorised collect ensure two independent count segregation duties maintain registercollection for trading activities register must be certified by that received same amount shown on receipt has been signed collectors provide who have handed over create one each point example abc state school p amp c association date sunday june type bookshop fete burger stand other tuckshop uniform shop approved float do add removed before counting notes total coins banking summary see attached documentation bank deposit banked no counted name signature checked copy processed slip filed in chronological order with your end month reconciliation...

no reviews yet
Please Login to review.