Daily Collections
Overview
The Daily Collections page is your end-of-day command center for tracking every payment that flows through your garage. Think of it as your digital cash register tape -- it shows you exactly how much money came in, broken down by payment method, payment type, and transaction detail.
Why this matters:
At the end of each day, someone needs to count the cash drawer, check the card terminal totals, and make sure everything adds up. Without a clear report, this process is slow, error-prone, and frustrating. Daily Collections gives you all the numbers in one place so you can reconcile in minutes, not hours.
What you can do here:
- See every payment collected for any date or date range
- View totals broken down by payment method (cash, card, bank transfer, etc.)
- View totals broken down by payment type (deposit, work-in-progress, final payment)
- Export to Excel or CSV for your records or accountant
- Quickly jump to today or yesterday with one click
How to Access Daily Collections
- Log in to your autoGMS dashboard.
- From the sidebar, click Finance.
- Select Collections.
You will land on the Daily Collections page, which defaults to showing today's payments.
Good to know: Daily Collections is available to garage owners, garage admins, managers, and staff members with finance permissions. Technicians cannot access this page.
Understanding the Page Layout
When you open Daily Collections, you will see four areas stacked vertically.
Date Selector (Top)
A date range picker at the top of the page lets you select which period to view. You can pick a single day or a multi-day range.
Two quick-select buttons sit next to the date picker:
- Today -- Jumps to today's collections (highlighted when active)
- Yesterday -- Jumps to yesterday's collections (highlighted when active)
There is also a Refresh button to reload the current data.
Summary Cards
Four cards give you the period's totals at a glance:
| Card | What it shows |
|---|---|
| Total Collected | The combined total of all payments in the selected period |
| Payments | The number of individual payment events recorded |
| Invoices | The number of distinct invoices that had collections |
| Average Payment | The average amount per payment event |
Payment Breakdowns (Two Side-by-Side Cards)
Below the summary cards, two breakdown cards sit side by side:
Payment Methods (left card): Shows each payment method (Cash, Card, Bank Transfer, Online, Cheque, etc.) with the total amount collected and a count of payments for that method. A subtotal row at the bottom shows the grand total and how many distinct methods were used.
Payment Types (right card): Shows each payment classification (Deposit, Work-in-Progress Payment, Final Payment, etc.) with the same total and count format. This tells you what stage of the billing cycle each payment relates to.
If there are no collections for the selected period, both cards show an empty state message.
Transactions Table
Below the breakdowns is a table listing every individual payment.
Reading the Transactions Table
What Each Column Shows
| Column | What it shows |
|---|---|
| Payment date | The date and time the payment was recorded (for example, "Jan 5, 2026, 3:45 PM") |
| Invoice | The invoice number (bold) with the invoice type shown below in smaller text |
| Customer | The customer's name (bold) with their email address below if available |
| Method | A colour-coded pill showing the payment method (Cash, Card, Online, Bank Transfer, Cheque, etc.) |
| Type | A colour-coded pill showing the payment type (Deposit, WIP Payment, Final Payment, etc.) |
| Reference | A reference string for the payment, or a dash if none was provided |
| Amount | The payment amount in your garage's currency, right-aligned |
Sorting the Table
Click on any column header to sort the table by that column. Click again to reverse the sort order.
Pagination
If there are many payments, the table is paginated. Use the controls at the bottom to move between pages.
Exporting Collections Data
You can export the period's collections for record-keeping or to share with your accountant.
How to Export
- Make sure you have selected the correct date or date range.
- Click the Export Excel button to download an Excel (.xlsx) file.
- For CSV format, click the small dropdown arrow next to the Export button and select Export CSV.
The export includes all payments for the selected period, along with the summary totals and breakdowns.
Step-by-Step: End-of-Day Reconciliation
Step 1: Select Today's Date
Open Daily Collections. Click the Today button if it is not already selected.
Step 2: Review the Summary Cards
Look at the four summary cards for a quick health check:
- Total Collected tells you the day's total intake
- Payments shows how many transactions occurred
- Average Payment helps you spot anomalies (an unusually high or low average might mean a recording error)
Step 3: Review the Payment Methods Breakdown
The Payment Methods card on the left shows totals per method:
- Cash total -- Should match the cash in your physical drawer (minus your opening float)
- Card total -- Should match the total shown on your card terminal's end-of-day report
- Bank Transfer total -- Cross-check against bank transfer confirmations
- Online total -- Stripe-processed payments
Step 4: Investigate Any Discrepancies
If the numbers do not match:
- Review each transaction in the table for the problem payment method.
- Check for missing payments -- did a transaction get recorded under the wrong method?
- Check for duplicate entries -- was a payment recorded twice?
- Check for refunds -- refunds reduce the total and may explain a shortfall.
Step 5: Export and Close
Once everything matches, click Export Excel to save the day's report for your records. Count your physical cash, set aside the opening float for tomorrow, and secure or deposit the remainder.
Viewing Historical Collections
Daily Collections is not just for today. You can view any past day's collections or a range of days.
How to Select a Past Date
- Click on the date picker at the top of the page.
- A calendar opens. Click on the date you want to view, or select a range.
- The page refreshes to show that period's payments.
Use the Today and Yesterday buttons for quick access to the most common views.
Viewing a Date Range
Select a start date and end date in the date picker to view collections across multiple days. The summary cards, breakdowns, and table will aggregate data across the entire range.
Understanding Payment Methods
Cash
Physical cash handed over by the customer. Your system records the amount, but you must physically handle and secure the cash.
Reconciliation tip: Count your drawer at close of business and compare against the Cash total. Remember to subtract your opening float.
Card
Credit card, debit card, or contactless payment processed through your card terminal.
Reconciliation tip: Run an end-of-day (settlement) report on your card terminal and compare it to the Card total in Daily Collections.
Bank Transfer
A payment made by the customer directly to your bank account. This might be used for larger invoices or business accounts.
Reconciliation tip: Check your bank statement or online banking portal for incoming transfers.
Online
Payment made through Stripe or another online payment processor, typically via a payment link on an invoice.
Understanding Payment Types
The Payment Types breakdown shows what stage of the billing cycle each payment relates to:
| Type | What it means |
|---|---|
| Deposit | An advance payment collected before work begins |
| WIP Payment | A work-in-progress payment collected during an ongoing job |
| Final Payment | The final payment collected when a job is complete |
This breakdown is useful for understanding your cash flow -- it tells you how much money is coming in as deposits (future work), how much is mid-job, and how much is closing out completed work.
Tips and Best Practices
-
Reconcile daily. Do not let days pile up. Reconciling every day keeps problems small and easy to fix.
-
Reconcile at a consistent time. Pick a time (for example, 30 minutes before closing) and do it at the same time every day.
-
Use the Payment Methods breakdown. Match each method against its physical source (cash drawer, card terminal, bank statement) for a clean reconciliation.
-
Investigate discrepancies immediately. It is much easier to remember what happened earlier today than to figure it out a week later.
-
Export for your records. Keep Excel exports as backup documentation. They are easy to store and share with your accountant.
-
Use date ranges for month-end. Select the full month in the date picker to see aggregated collections across all days.
Frequently Asked Questions
Can I edit or delete a payment from this page?
No. Daily Collections is a read-only view for reconciliation purposes. To modify or void a payment, go to the original invoice and make the change there. The update will be reflected in Daily Collections.
Why is a payment showing on a different date than the invoice?
Payments are listed on the date they were recorded, not the date the invoice was created. If an invoice was created on Monday but paid on Wednesday, the payment appears in Wednesday's collections.
What if a customer pays part of an invoice?
Partial payments are recorded as individual transactions. You might see the same invoice number appear multiple times if the customer made more than one payment.
Can I see payments from all my garages in one view?
No. Daily Collections shows payments for one garage at a time. If you manage multiple garages, switch to each garage individually to view its collections.
How far back can I view historical data?
You can view collections data for any date since your garage started using autoGMS. There is no cutoff.
What happens if a payment is refunded after I reconcile?
The refund will appear as a separate transaction on the day it is processed. It will show as a negative amount and will reduce the totals for that day.
Who can access Daily Collections?
Garage owners, garage admins, managers, and any staff member with finance permissions can access Daily Collections. Technicians cannot access this page.
Does this page show online payments?
Yes. Payments made through Stripe or other online payment processors appear here with the Online payment method.
Quick Reference
| I want to... | Go here | Do this |
|---|---|---|
| View today's collections | Sidebar → Collections | Click Today button |
| View yesterday | Yesterday button | One-click quick select |
| View a specific date | Date picker at top | Select date from calendar |
| View a date range | Date picker at top | Select start and end dates |
| See total collected | Summary card → Total Collected | Shows combined total |
| See payment count | Summary card → Payments | Shows number of payment events |
| See method breakdown | Payment Methods card (left) | Cash, Card, Online, Bank Transfer totals |
| See type breakdown | Payment Types card (right) | Deposit, WIP, Final Payment totals |
| Export to Excel | Export Excel button | Downloads .xlsx file |
| Export to CSV | Export dropdown → Export CSV | Downloads .csv file |
| Refresh data | Refresh button (top) | Reloads current period's data |