Saved and Scheduled Reports
Save any report with its filters and columns, then have Cooledge email it to your owners and admins every day, week, fortnight, month or quarter with the headline figures, a link and the PDF and CSV.
Saved and Scheduled Reports
Save the reports you check every week and get them by email.
- Save any report with its range, filters, grouping, sort and columns
- Saved reports appear at the top of the Reports page for every owner and admin
- Owners can email a saved report every day, weekday, week, fortnight, month or quarter
- Send it to up to 10 owners and admins at a time you pick, in your business's timezone
- Owners get the PDF and CSV. Admins get the figures and a link unless you send them the files too
- Reports > Scheduled emails shows every schedule and who got each email
Saved and scheduled reports work with every report: the Job Profitability Report, the Money reports, Quote performance and Lead sources, Technician workload and Call history.
Save a Report
- Open any report from Reports and set it up the way you want it: the range, filters, Group by, sort and columns
- Click Save at the top right, next to Export
- Give it a name such as "Monday cash" or "Monthly profitability" and click Save
Each name can be used once. The title of the report then shows the saved name, such as Job profitability ยท Monthly profitability.
A saved report keeps a range like Last month as a range, not as dates. Every time you open it, the range is worked out again, so Last month always shows the month just gone.
Change or Delete a Saved Report
Open the saved report, change what you need, then click Save:
- Save changes updates the saved report
- Save as new saves what's on screen under a new name and leaves the original alone
- Delete saved report removes it for everyone. If it has a schedule, the schedule and its send history are deleted too
The columns you saved show while the saved report is open. When you open the report on its own again, you get your usual columns back.
The Saved Section
Saved reports appear under Saved at the top of the Reports page, above Money. Each card shows the report and its range and, if it's scheduled, when it sends. A paused schedule shows a Paused badge. Click a card to open the report exactly as it was saved.
Saved reports are shared. Every owner and admin sees the same list.
Schedule an Email
Owners can have a saved report emailed on a schedule. Open the report and click Schedule email next to Export. If the report isn't saved yet, Cooledge asks you for a name first. On a report that already has a schedule, the button reads Edit schedule.
Repeats
| Choice | When it sends |
|---|---|
| Every day | Every day, weekends included |
| Every weekday | Monday to Friday |
| Every week on | The days you tick, such as Monday or Monday and Thursday |
| Every fortnight on | One day, every second week. The fortnights count from the first email |
| Every month on | A day from the 1st to the 28th, the Last day, or a weekday such as the first Monday or the last Friday |
| Every quarter on | The same choices as monthly, in January, April, July and October |
Time
Pick a time in 15-minute steps. Times are in your business's timezone, shown next to the list (for example Sydney time). The email goes out within a few minutes of that time.
Send To
Tick the owners and admins who should get it, up to 10 people. Anyone who hasn't signed in to Cooledge yet is listed but can't be ticked: they show Hasn't signed in yet.
Members and restricted members can't get scheduled reports, because they can't see reports in Cooledge.
Attach
PDF and CSV are both ticked to start with. Untick either one to leave it off.
The files go to owners only. Admins get the same email with the headline figures and the link, plus a line saying the files go to owners. If you tick an admin, a switch appears: turn on Send the files to admins too to send them the files as well.
Check the Next Email
The blue line at the bottom tells you when the next email goes and what it covers, such as "Next email Tuesday 1 December at 8:00am, covering Last month (1 to 30 November)".
Click Save schedule to turn it on.
Ranges You Can Schedule
A scheduled report needs a range that moves with time, such as Yesterday, Last week, Last month or This financial year. A custom range with fixed dates would cover the same dates every time, so the dialog asks you to choose a range like Last month first.
Every report with a range has these: Yesterday, This week, Last week, This month, Last month, This quarter, Last quarter, This financial year, Last financial year, Last 7 days, Last 30 days, Last 90 days and Last 12 months. Weeks run Monday to Sunday.
The range is worked out for the time the email is due. An email due at 7:00am on Monday 23 November with Last week covers 16 to 22 November.
Receivables and Work to invoice have no range. Their email shows the report as of the moment it was sent.
Send Me a Test
Once the schedule is saved, Send me a test emails it to you straight away, with the files you've ticked, so you can check how it looks. You can send 5 tests a day.
What the Email Shows
The email comes from Cooledge, with the subject set to the saved name and the period, such as Monthly profitability: Last month, 1 to 31 October.
- The headline figures: the same figures as the top of the report
- The report's notes, such as whether figures are inc or ex GST
- Open in Cooledge: opens the report for the same dates the email covered. Figures can differ if something in that period changed after the email went, such as a payment recorded late. For Receivables and Work to invoice, it opens the report as of today, with a note saying the date the email showed
- The PDF and CSV, for owners (and for admins when the switch is on). They use the columns you saved. A CSV over 20,000 rows or too large to attach is left off and the email tells you to download it from the report
- The footer names the owner who set it up and links to Manage scheduled reports
Scheduled Emails
Reports > Scheduled emails lists every schedule in your business. Open it from the Scheduled emails button at the top of the Reports page.
Each row shows the saved report, how often it repeats, who gets it, when the next email goes and how the last one went. Click the saved report's name to open it.
Owners can:
- Edit the schedule
- Pause it and Resume it later. Resuming starts again from the next send time. Emails missed while it was paused aren't sent
- Delete the schedule. The saved report stays, but the schedule's send history is deleted
Click the arrow next to a name to see its send history: the date and time, whether it was a Scheduled email or a Test, its status, the range it covered, how many rows the report had and each recipient with Sent or the reason they didn't get it. Show older emails loads more.
Stop Getting an Email
Admins see every schedule but can't change them. On a schedule you receive, click Stop sending to me. If nobody is left to receive it, the schedule pauses until an owner edits it.
When a Schedule Pauses
A paused schedule shows why on the Scheduled emails page.
| Reason | What happened | What to do |
|---|---|---|
| Paused | An owner paused it | Click Resume |
| Paused after 3 failed sends | Cooledge couldn't send it 3 times in a row. The owner who set it up gets an email | Check the saved report, then click Resume |
| Paused because the owner who set it up is no longer an owner | The owner who set it up was changed to another role or deactivated | Any owner can click Resume. They take it over and the footer names them |
| Paused while your subscription is inactive | Your subscription isn't active | Nothing. It restarts by itself once billing is sorted |
| Paused because this report is turned off for your business | The report is no longer available, for example rebates were turned off | Turn the report back on, then click Resume |
| Paused because nobody is set to receive it | The last person on it chose Stop sending to me | Click Edit and choose who gets it |
When a schedule pauses after failed sends, a change of owner or because of your subscription, a banner on the Reports page and the Scheduled emails page tells you. Editing a paused schedule and saving it resumes it.
If an email can't go out within 12 hours of its time, it's marked Missed and not sent late. The next one goes as normal.
People are checked every time an email sends. Anyone who is no longer an owner or admin is skipped. If nobody on the list can get it, that email isn't sent and the send history shows why next to each person. The schedule stays on. An admin who becomes an owner starts getting the files.
Limits
| Limit | Amount |
|---|---|
| Saved reports | 50 per business |
| Scheduled reports | 20 per business |
| People per schedule | 10 |
| Test emails | 5 per owner per day |
| Most often | Once a day |
Who Can Do What
| Owners | Admins | Members | |
|---|---|---|---|
| See saved reports | Yes | Yes | No |
| Save a report | Yes | Yes | No |
| Change or delete a saved report | Yes | Only their own, while it has no schedule | No |
| Schedule, edit, pause, resume or delete a schedule | Yes | No | No |
| Receive a scheduled report | Yes, with the files | Yes, files only if the owner turns them on | No |
| Stop getting a scheduled report | Yes, by editing it | Stop sending to me | No |
Reports and scheduled emails are on Starter, Growth and Scale.
Common Questions
Can I send a report to my accountant? Not yet. Scheduled reports go to owners and admins of your business only.
Can a technician get their own figures? Not yet. Members can't see reports, so they can't receive them either.
Why can't I schedule this report? It probably has a custom range. Choose a range like Last month or Last week, then click Schedule email again.
Why can't I change a saved report an owner scheduled? Once a saved report has a schedule, only owners can change it, so what the owner set up to send stays the same.
Why didn't an admin get the PDF? Files go to owners only. To send them to admins too, an owner turns on Send the files to admins too in the schedule.
Do I need to stay signed in for the email to send? No. Cooledge sends it at the time you picked, whether anyone is signed in or not.
Related
- Job Profitability Report: Revenue, costs and margin for every job
- Money Reports: Receivables, cash collected, work to invoice and rebates
- Quote Performance and Lead Sources: Your win rate and where your leads come from
- Technician Workload: Booked hours against timesheet hours
Was this article helpful?
Let us know if you found this information useful.
Still need help? Contact support
In this article
Use your browser's search (Ctrl+F) to quickly find specific topics within this article.
Browse all help articles โRelated Articles
Creating Invoices
Learn how to create job-linked and standalone invoices, with automatic deposit deductions
Editing Invoice Line Items
Add, edit and remove line items on invoices including quantities, prices and tax calculations
Energy Rebates
Track the energy rebates you claim from a provider company. Put the rebate on the quote, see what you keep, invoice the provider and record what they pay.