Contact and financial reports

A reference for the reports in two categories: Contacts and Financial. For how to open, read and export a report, see Run a report.

Contacts#

Contact Growth#

New contacts added over time, and how many went on to be quoted.

• Figures: Contacts, Added, Reached a quote, Went nowhere.
• Lists behind the figures:
  • Added: contacts created in the period.
  • Reached a quote: contacts created in the period that went on to be quoted.
  • Went nowhere: contacts created in the period with no quote raised for them since.
• Chart and breakdown: contacts added per month against the period before; contacts by contact group.
• Table: recently added contacts, with group, lead source, email and status.
• Counts by: the date the contact was created.

Interaction Coverage#

Which contacts you've been in touch with in the last year, and which have gone quiet. Use it to plan outreach.

• Figures: Contacts covered, Gone quiet, Never engaged, Dormant customers.
• Lists behind the figures:
  • Contacts covered: contacts with a quote, job or booking in the last 12 months.
  • Gone quiet: contacts whose last quote, job or booking was more than 12 months ago.
  • Never engaged: contacts with no quote, job or booking ever recorded.
  • Dormant customers: contacts that have gone quiet and have spent money with you before. The highest priority for outreach.
• Chart and breakdown: contacts by months since their last interaction; what that last interaction was.
• Table: contacts worth chasing, with their historic value and a priority.
• Counts by: how things stand today. The reporting period isn't used.

Customer Overview#

Who bought from you in the period, and how often.

• Figures: Buying customers, Average spend, Repeat buyers, One and done.
• Lists behind the figures:
  • Buying customers: customers invoiced in the period.
  • Repeat buyers: customers invoiced more than once in the period.
  • One and done: customers invoiced exactly once in the period.
• Chart and breakdown: buying customers per month; customers by contact group.
• Table: customers by spend.
• Counts by: invoice date.

Lifetime Value#

What each customer has been worth to you over all time.

• Figures: Customers, Average lifetime value, Top 10% share, Relationships over a year.
• Lists behind the figures:
  • Customers: every customer that has ever been invoiced.
  • Top 10% share opens Top 10% by lifetime value: the tenth of customers that bring in the most revenue.
  • Relationships over a year: customers whose first and latest invoices are more than a year apart.
• Chart and breakdown: customers and value by lifetime band; value by band.
• Table: customers by lifetime value.
• Counts by: every invoice ever raised. The reporting period isn't used.

Type Analysis#

Your contacts broken down by contact group.

• Figures: Contacts, Ungrouped, Largest group, Most valuable.
• Chart and breakdown: contacts and value by group; each group's share.
• Table: each contact group with contacts, share, invoiced value and value per contact.
• Counts by: all contacts. The reporting period isn't used.
• Needs: contacts assigned to a contact group.

Geo Distribution#

Where your contacts and your work are, by town.

• Figures: Towns, Largest, Best per contact, No address.
• Chart and breakdown: contacts and value by town; each town's share of contacts.
• Table: each town with contacts, share, invoiced value and value per contact.
• Counts by: all contacts. The reporting period isn't used.
• Needs: contact addresses with a town.

Repeat Business#

How many customers come back, and how often.

• Figures: Repeat rate, Repeat revenue, Average orders, Typical gap.
• Lists behind the figures:
  • Repeat rate opens Repeat buyers: customers who have bought more than once.
  • Average orders opens Bought once: customers who have bought exactly once and not come back.
• Chart and breakdown: new against returning customers, by month; how often customers buy.
• Table: customers by number of orders, with their first and latest invoices and average gap.
• Counts by: every invoice ever raised. Only the chart uses the reporting period.
• Needs: invoices attached to a contact.

Financial#

Cash Position#

Your bank balances and the money moving in and out.

• Figures: Bank balance, Money in, Money out, Unreconciled.
• Chart and breakdown: money in against money out; balance by account.
• Table: recent bank statement lines, with their status and what they're matched to.
• Counts by: the bank transaction date. The balance is as at today.
• Needs: bank accounts and statement lines recorded in Systemise. Without them, the report shows Not tracked in Systemise.

GST Return#

Period totals to help you prepare a GST return.

• Figures: GST to pay, GST collected, GST claimed, Invoices without GST.
• Chart and breakdown: GST collected against claimed, by month; the parts of the return.
• Table: one line each for sales, credit notes, purchases and net GST.
• Counts by: invoice date for sales, and bill date for purchases.

Chart of Accounts Activity#

Postings to each account in your chart of accounts.

• Figures: Accounts posting, Postings, Largest account, Suspense.
• Chart and breakdown: postings by month; activity by account type.
• Table: each account with its code, type, number of postings and value.
• Counts by: the ledger transaction date.
• Needs: a chart of accounts with postings in Systemise. Without them, the report shows Not tracked in Systemise.

P&L Summary#

Revenue against costs for the period.

• Figures: Revenue, Direct costs, Supplier bills, Net.
• Chart and breakdown: revenue against cost, by month; where the money goes.
• Table: one line each for sales, credit notes, materials, labour, supplier bills and net.
• Counts by: invoice date for revenue, the date the job was completed for direct costs, and bill date for supplier bills. Revenue is shown excluding GST.

Purchase Summary#

Supplier bills in the period.

• Figures: Purchases, Suppliers, Average bill, Not job-costed.
• Chart and breakdown: supplier spend by month against the period before; spend by supplier.
• Table: each supplier bill, with supplier, date, due date, value and whether it's attached to a job.
• Counts by: bill date.
• Not job-costed is bills not attached to a job.

Revenue vs Costs#

Income against direct cost, month by month.

• Figures: Revenue, Cost, Gap, Tightest month.
• Chart and breakdown: revenue against cost, by month; what the cost is made up of.
• Table: month by month, with revenue, materials, labour, bills and what was retained.
• Counts by: invoice date, bill date and the date jobs were completed.

Outstanding Balances#

What customers owe you against what you owe suppliers.

• Figures: Owed to us, Overdue, Owed by us, Net position.
• Chart and breakdown: receivable against payable; the customers who owe the most.
• Table: outstanding invoices, with days overdue and status.
• Counts by: how things stand today. The reporting period isn't used. Owed by us is supplier bills past their due date.
• Needs: invoices with an amount still owing. If invoice balances aren't recorded in Systemise, the report shows Not tracked in Systemise.