5. Matching Daily Sales against Monthly Totals

Check Within Xero - that all days for the month have been entered

Daily Check

To confirm that the daily sales have been entered correctly in Xero the Monthly Totals are matched.

1. To do this go to Xero > Invoices > Paid > Search

2. Enter the start date and end date for the month you want to look at

3. Click Export

4. Save in Dropbox\Geoff and Rich Private Folder\Banking\Xero\Beer Cartel RSA with the respective month

5. Open File and apply Filter - sort on Column W "UnitAmount" Sort Lowest to Highest

6. Delete all negative values, keep any 0 values as they may be for a public holiday

7. Sort on Column M "InvoiceDate" Newest to Oldest

8. Create a new column to the left of Cell W which is the sum of Cell W "UnitAmount" and Cell AB "TaxAmount" this equal the Sales+GST in the Daily Z Department Report

9. Go through Daily reports and check these have all been entered in Xero correctly.

Also check that the Eftpos Settlement (Total Eft) matches the Eftpos amount on the Daily Z report.

Monthly Check

To confirm that the daily sales have been entered correctly in Xero the Monthly Totals are matched.

1. To do this go to Xero > Invoices > Paid > Search

2. Enter the start date and end date for the month you want to look at

3. Click Export

4. Save in Dropbox\Geoff and Rich Private Folder\Banking\Xero\Beer Cartel RSA with the respective month

5. Open File and apply Filter - sort on Column W "UnitAmount" Sort Lowest to Highest

6. Delete all negative values, keep any 0 values as they may be for a public holiday

7. Sort on Column M "InvoiceDate" Newest to Oldest

8. Sum Column W "UnitAmount" this should hopefully equal the "Sales" figure in the Monthly Z Department Report

9. Sum Column AB "TaxAmount" this should hopefully equal the "GST" figure in the Monthly Z Department Report

10 Savefile as Excel Workbook

Issues

1. If there is an issue check that there is an entry for each day in the month in column M "Invoice Date"

2. Then check that amount entered match the sales amount in each Daily Z Department Report