The Tally Customer Sheet provides the customer segment and the sales and payment performance of individual customers. The results are provided in a spreadsheet format that can be easily searched, sorted, filtered, and pivoted. The Tally Customer Sheet is available with a paid subscription.
You can receive an Excel spreadsheet and automatically sync customer insights between Tally St and Google Sheets. Our integration with Google Sheets directly publishes the Tally Customer Sheet to your Google Drive — and keeps it updated! Simply log into your Tally Street dashboard, go to Connected Platforms, and Connect to Google.
The customer named on a sales invoice or sales receipt.
The parent company is included if the customer is recorded as a subsidiary of another customer, or as a department or location inside a larger customer organization.
Numeric value identifying the specific customer’s place in a parent/sub hierarchy: 0 = parent or highest level, 1 = sub-customer, 2 = sub-sub-customer.
The full customer address.
The primary phone number for the customer.
The customer’s status in the accounting system.
This grouping of four columns summarizes the current and previous segments (or groups) for customers who purchased within the most recent 36 months. The Customer Segment is their current segment and Segment Score helps sort ana analyze customers.
When a customers change segments because of changing behaviors, then the Previous Segment reporting their most recent segment and Segment Transition records the reporting date of the change.
Read more in our article on Better Insights with Improved Segmentation.
The date of the first sale to the customer. This is often used as the customer acquisition date, and grouping customers by the week, month or year they were acquired is a common technique for cohort analysis.
The date of the last or most recent sale to the customer. For businesses that relay on repeat sales, this is especially useful for studying customer and revenue retention.
The lifetime value (LTV) of each customer is computed by summing all invoices and receipts.
Total sales to each customer over the trailing 12 months. The sales totals include transactions through the reporting data and going back 365 days.
Total sales to the customer over the previous trailing 12 months. The sales totals include transactions from two years ago (730 days) through one year ago (365 days).
Simple ranking of that customer based on the TTM sales total compared to other customers.
Simple ranking of that customer based on the previous TTM sales total compared to other customers.
Total sales for the current year and the previous four calendar years. The starting date of January 1 is used for each year.
Total balance across all transactions, including invoices, credit memos, refunds, overpayments, advances, etc.
Total amount outstanding on unpaid invoices.
The number of invoices with some amount still outstanding.
The date on the oldest invoice with some amount still outstanding.
Total amount overdue (or late) on unpaid invoices.
The number of invoices with an amount that is overdue.
The date on the oldest invoice with some amount still overdue.
Customers whose payment performance has significantly worsened are identified as being unusually late. These customers may present a higher credit and payment risk.
The current balance of credit memos issued to the customer.
Payment Term is the average number of days credit has been extended to the customer. The Most Recent Term is payment term on the most recent invoice.
The number of payments that have been made on or before the invoice due date.
The number of payments that were made after the invoice due date.
Days Sales Outstanding (DSO) is the sales-weighted, average number of days after the invoice date that payments were received from this customer. We made an improvement to True DSO is that is more accurate and handles partial payments. All payments are included in the calculation, whether they were early, on-time or late.
The True DSO for the customer calculated using payment history over just the last 12 months. Comparing this number the customer’s lifetime Tally DSO shows if payment performance is trending up or down.
The number of times each customer paid an invoice 30, 60, 90, or over 90 days late. This type of reporting is often requested by asset-based lenders, banks, etc.
The highest credit balance the customer reached over the trailing twelve months and the date it was recorded.
The number of credit memos issued to the customer.
The sum of all credit memos issued to the customer.
The date on the oldest credit memo with some amount still remaining.
Subscribers who all connected Tally Street to HubSpot, Salesforce and other CRMs will see additional columns for each platform. The columns will note which customers were matched between your accounting and CRM platforms and how they were matched.
The second tab in the Tally Customer Sheet lists all customers who were retained over the last 12 months. As customer is considered to be retained if they made a purchase 13 to 24 months ago, and made at least one more purchase in the trailing 12 months. The lifetime value, last sale date, and the change in sales over the two reporting periods are also included. When calculating revenue retention, an increase in sales is classified as revenue expansion. A decrease in sales is classified as revenue contraction.
The third tab in the Tally Customer Sheet lists all customers who were lost, or churned, over the last 12 months. As customer is considered to have churned if they made a purchase 13 to 24 months ago, then did NOT many any purchases in the trailing 12 months. The lifetime value, last sale date, and the total sales in the prior trailing 12 months are also included.