# 47. Daily Deposit Report

The [Daily Deposit Report](https://autosoftware.company/daily_deposit_report.php) is the closing reconciliation for one day, laid out as seven tabs that follow the money from the day's sales to the bank deposit and end in a journal entry for the accountant. Tab A sums what was sold and refunded, B what was received by each payment method, C the cash left after the day's cash expenses, D what goes to the bank, E the earlier deposits applied to today's invoices, F the check that deposits and adjustments add back up to gross sales, and G the debits and credits that book the day. The same journal is what the Export to QuickBooks screen posts, and the report is also one of the PDFs the End of Day Report opens. Use it every evening to count the drawer and prepare the deposit, and to hand the accountant a balanced entry for the day.

## How do I run the Daily Deposit Report?

1. From the Home Screen, click Reports → Management & Operational Reports → Daily Deposit Report.
2. Click the Date box or its calendar icon and pick the day; the report opens on today and reloads as soon as a date is chosen. Only one day is reported at a time, and days before the store's beginning date cannot be picked. The × clears the date.
3. Click Search if you typed the date rather than picking it.
4. Click the tabs A-DAILY SALES SUMMARY, B-DAILY RECEIPTS SUMMARY, C- CASH RECONCILIATION, D-DEPOSITS TO THE BANK, E-PRIOR DEPOSIT APPLIED, F-DEPOSIT/SALES RECONCIL. and G-JOURNAL ENTRY (ACCOUNTANT) to move between the sections; all seven are calculated together, so switching tabs does not reload the page.
5. Click [Print](https://autosoftware.company/mpdf/daily_deposit_report_pdf.php) for a PDF of all seven sections in a new tab. Tick Print The Daily Invoice Notification Report After This Report is Printed first if you also want the day's [Detailed invoice Log Report](https://autosoftware.company/mpdf/invoice_modification_report_pdf.php), the list of invoices whose value was reduced before finalizing, added after the journal entry.
6. Click [Export to Excel](https://autosoftware.company/daily_deposit_report_excel.php) to download the day as a spreadsheet with one sheet per tab, named Daily_Deposit_Report_ followed by the date.

![Daily Deposit Report with date filter and A-Daily Sales Summary](/images/s194_fd4f0860.png)
*Daily Deposit Report with date filter and A-Daily Sales Summary*

![Daily Deposit Report – B-Daily Receipts Summary](/images/s194_ab65e3e9.png)
*Daily Deposit Report – B-Daily Receipts Summary*

![Daily Deposit Report – C-Cash Reconciliation](/images/s194_5b76d431.png)
*Daily Deposit Report – C-Cash Reconciliation*

![Daily Deposit Report – D-Deposits to the Bank](/images/s194_8201ba5b.png)
*Daily Deposit Report – D-Deposits to the Bank*

![Daily Deposit Report – E-Prior Deposit Applied](/images/s194_eb659959.png)
*Daily Deposit Report – E-Prior Deposit Applied*

![Daily Deposit Report – F-Deposit and Sales Reconciliation](/images/s194_e72f4b8b.png)
*Daily Deposit Report – F-Deposit and Sales Reconciliation*

![Daily Deposit Report – G-Journal Entry (Accountant)](/images/s194_62441f04.png)
*Daily Deposit Report – G-Journal Entry (Accountant)*

## How do I follow the day from receipts to the bank deposit?

1. From the Home Screen, click Reports → Management & Operational Reports → Daily Deposit Report, and pick the Date.
2. On A-DAILY SALES SUMMARY, note Total Gross Sales in the TOTAL column. Example: $6,124.89, with Total Net Sales $5,779.40.
3. On B-DAILY RECEIPTS SUMMARY, read Total Receipts: $5,699.89 taken on the day's finalized invoices, $550.00 of deposits on open invoices and $2,000.00 received on fleet accounts, $8,249.89 in all.
4. On C- CASH RECONCILIATION, take the cash received, $1,475.00, less the cash spent from the drawer, $210.00 of outside parts and $85.00 of paid-outs, so $295.00 used and Total Cash Left for Deposit $1,180.00.
5. On D-DEPOSITS TO THE BANK, add that cash to the checks ($1,840.00), credit cards ($2,880.39), debit cards ($454.00) and others ($1,300.50), and take off the $75.00 of gift cards redeemed: Total Deposits to the Bank $7,579.89.
6. On E-PRIOR DEPOSIT APPLIED, note the earlier payments on today's invoices: $500.00.
7. On F-DEPOSIT/SALES RECONCIL., work A+B-C+D-E+F: $7,579.89 + $295.00 − $550.00 + $500.00 − $2,000.00 + $300.00 = $6,124.89. It equals Total Gross Sales from step 2, so the day balances; if it does not, look for a payment entered with the wrong date or method, or a cash expense not yet entered.
8. On G-JOURNAL ENTRY (ACCOUNTANT), check that the TOTAL debit and credit agree, $9,572.79 each in the example, and click Print for the accountant.

## How do I prepare the bank deposit for the day?

1. From the Home Screen, click Reports → Management & Operational Reports → Daily Deposit Report, and pick the Date.
2. Count the drawer and compare it with Total Cash Left for Deposit on C- CASH RECONCILIATION; a difference is cash short or over.
3. Read Total Deposits to the Bank on D-DEPOSITS TO THE BANK for the deposit slip; the cash, check and card lines above it give the split.
4. Click Print and file the PDF with the deposit slip.

## About this screen

A-DAILY SALES SUMMARY has three columns, DAILY SALES SUMMARY for the invoices finalized on the day, DAILY REFUND SUMMARY for the invoices refunded on the day, and TOTAL, which is the sales figure less the refund figure. The lettered list on the left names the lines: Total Labor (A) and Total Parts (B) after discounts, then the fees and certificates Total Haz. Waste Fee and Total Oil Surcharge Fee (both C), Total Elec. Trans. Fee (D), Total State Tire Fee (E), Total Tire Disposal Fee (F), Total State Battery Fee (G), Total Battery Disposal Fee (H), Total Shop Supply Fee (I), Total Smog. Certificates (J), Total Veh. Insp. Cert Fee (K), Total Brake/Lamp Cert Fee (L), Total Veh. State Safety Insp. Cert Fee (M) and Total Sales Tax (N). Total Gross Sales is marked O=SUM(A-N) and Total Net Sales is marked P = (O-E-G-J-K-L-M-N), gross sales less the state fees, certificates and sales tax that the shop only collects; both are the figures stored on the invoices. Gift Card sold is the value of gift cards sold that day, listed separately because a gift card is not a sale until it is used.

B-DAILY RECEIPTS SUMMARY lists every payment method the store has, one Total … line each, such as Total Cash and Total VISA, with Gift Cards Redeemed for payments made with a gift card. Finalized Invoices is the money taken that day on invoices finalized that day, including gift cards sold that day; Deposits From Open Invoices is money taken that day on invoices not finalized that day, such as a deposit on an estimate; Fleet Charge Payments Received is money received on fleet accounts rather than on an invoice; Refunded Payments is what was given back that day; and Totals is the first three less the refunds. Total Receipts at the foot adds each column.

C- CASH RECONCILIATION works out the cash that should be in hand. Total Cash Received from Customers less cash used for (A) is the cash taken that day before any refund. The cash spent from the drawer follows: Total Cash OPP (B1) for outside part purchases, Total Cash Shop Paid Outs of & Recurring Expenses (B2), Total Cash Paid for Oil (B3), Total Cash Paid for Stock Parts (B4), all from the expenses paid in cash that day, and Total Cash Refund (B5). Total Cash Used is B = B1+B2+B3+B4+B5 and Total Cash Left for Deposit is C = A - B.

D-DEPOSITS TO THE BANK groups the day's receipts by how they reach the bank: Total Cash Left for Deposit from tab C (shown as zero if the cash used was more than the cash taken), Total Checks, Total Credit Cards, Total Debit Card(ATM) and Total Others, which holds every payment method not in the first groups, including store-added methods and gift cards. Gift card Redeemed is shown again and taken off, because a redeemed gift card brings no new money, so Total Deposits to the Bank = Total - Gift Card Redeemed.

E-PRIOR DEPOSIT APPLIED lists the payments taken on earlier days on the invoices finalized today, one line per payment with the Invoice Number, Payment Date, Payment Amount and Payment Method, and their sum at the foot. This money was banked when it was taken, so it has to be added back when today's deposits are compared with today's sales.

F-DEPOSIT/SALES RECONCIL. is the proof. Total Deposit to the Bank (A) from tab D, Plus Cash Used from Sales (B) from tab C, Less Future Deposits Received (C) from tab B, Plus Prior Deposit Applied (D) from tab E, Less Fleet Charge Payments Received (E) from tab B and Plus Paid By Fleet (F), the invoices charged to fleet accounts, combine as A+B-C+D-E+F into Amount Should Equal Gross Sales. When that figure matches Total Gross Sales on tab A, every dollar of the day is accounted for.

G-JOURNAL ENTRY (ACCOUNTANT) turns the day into debits and credits with an ACCOUNT DESCRIPTION, ACCOUNT TYPE, DEBIT and CREDIT for each line. The debits are the deposits by payment method, CASH DEPOSIT (the cash left for deposit from tab C) and one … DEPOSIT line per other method, then PRIOR DEPOSITS APPLIED, OPP PAID FROM CASH FROM SALES and SHOP PAID OUT PAID BY CASH FROM SALES. The credits are NET SALES, SALES TAX, GIFT CARD SOLD, SMOG CERTIFICATES USED, STATE BATTERY TAX FEE, STATE TIRE TAX FEE, BRAKE / LAMP TEST CERT USED, STATE VEHICLE INSPECTION CERT USED, FUTURE DEPOSITS RECEIVED and PRIOR FLEET CHARGE RECEIVED. COST OF INVENTORY PARTS USED (debit) and INVENTORY USED (credit) carry the stock cost of the parts used on the day's invoices, and COGS OPP PAID FROM OTHER PAYMENT METHOD (debit) with an OPP CREDIT FROM … line per purchase method (credit) record the outside parts bought for those invoices with a card or account. When the day's cash count has been saved from the End of Day form on the Home Screen, the lines CASH DEPOSIT (the difference between the counted bank deposit and the cash ARM expected), CASH DRAWER INCREASE or CASH DRAWER DECREASE, and CASH SHORT or CASH OVER follow. A negative amount is shown on the opposite side. The TOTAL row adds each column; the two totals agree when tab F balances.

The Add To Favorites switch beside the heading saves the report under Favorites on the Reports page. The report also opens as DAILY DEPOSIT REPORT from the End of Day Report. Which reports you see depends on your admin group permissions.