The Daily Sales and Deposit report is a useful tool in balancing daily. The report shown below is a sample and can be modified to better suit the company’s needs.
To balance with the Daily Sales and Deposit report:
- Enter the Opening A/R Balance from the previous day.
- Enter Total Daily Sales for the day from the sales posting journals.
- Enter Total Payments for the day, from the payment posting journals.
Note: Be sure to take into account any void journals. - Enter the Net Deposit, subtracting Credit Cards and Petty Cash Expenses from Total Payments.
- Enter the Actual Deposit, subtracting Change Fund from Total Cash in Drawer and adding Checks for Deposit.
- Enter the Closing A/R, adding Sales to Opening A/R and subtracting Payments.
| Store: | Date: | |
| Gallons | Amount | |
| Opening A/R Balance | ||
| Residential LP | ||
| Commercial LP | ||
| Agricultural LP | ||
| MF/Other LP | ||
| Drop Ship | ||
| Kerosene | ||
| Diesel | ||
| Fuel Oil | ||
| Gasoline | ||
| Appliances | ||
| Parts | ||
| Service | ||
| Other: | ||
| Other: | ||
| Other: | ||
| Sales Tax | ||
| Total Daily Sales | ||
| Total Payments | ||
| Less: Credit Cards | ||
| Less: Petty Cash Expenses | ||
| Net Deposit | ||
| Total Cash in Drawer | ||
| Less: Change Fund | ||
| Cash for Deposit | ||
| Checks for Deposit | ||
| Actual Deposit | ||
| Over/Short = Actual - Net Deposit | ||
| Closing A/R = Opening + Sales - Payments | ||
Other options for balancing at the end of the day:
- From the Report Menu, select Customer Reports.
- Select Option 2
- Choose #3 – Totals/# of customers. This will print the balance as of today.
- Select Option 7 Age Analysis. Using today’s date and select summary, print and compare both reports. The totals will match if in balance.