Troly lets you process orders from many channels, all via one platform. This really simplifies reporting, since reports include all facets of your business. From the Reports page the End of Period Report allows to:
- review all cash and stock movements.
- have a breakdown of your sales by products, categories, channels and payment methods.
- filter your revenues, expenses and profits for any given period.
Using Troly to Analyse Your Sales With the End of Period Report
Revenue Breakdown and Reconciliation
The End of Period Report provides an overview of your sales based on different breakdowns that allow you to assess how the different aspects of your business perform. It gives you the flexibility to filter the data to any period or time frame (e.g. day, week, month, quarter) of interest.
The Period Takings Report the statistics of revenue for each payment type processed by Troly and outside of Troly. The credit cards transactions, known as “online payment methods” include Visa, MasterCard, and Amex, and are processed directly with our applications. The transactions made with cash, EFTPOS, bank transfers and cheques, known as “offline payment methods”, are processed with your own machine and logged in the Troly platform for reconciliation purposes only. Please note that you can find a breakdown of the bank transfers by generating a Transaction report.
Revenues by Source
The Revenues by Source provides the statistics for the different online sales channels offered by Troly which are the Troly webapp, your website, your club runs, the PoS, the Tasting Experience and Staff-created sales (where a sales person is assigned to an order). It also shows the revenue based on guest customers. This allows you to assess the performance of each channel used in your business.
Revenue by Staff
The Revenues by Staff shows which of your staff member sells the most and may assist you to assess this aspect of their performance.
Revenue by Product Category
The Revenues by Category is associated to the product categories that you have defined in the Product Information page under the Category section. The categories defining your products (e.g. Reds, Whites, Sparkling, Fortified, etc.) give an overview of the related products grouped. The products that haven’t been set with a category fall under the “Sales of uncategorised”.
The Revenue for Services includes the sum of the shipping cost and the credit card surcharge paid by your customers.
- The Shipping Revenue is set in the Shipping Configuration Add-on to establish if your customers assume the partial or full delivery costs. All the deliveries that are not exempt of shipping charges are added up in this sections
- The Card Surcharge Revenue is configured in the Credit Card Surcharge Add-on to set the merchant fee that you charge your customers when accepting credit card purchases.
- The Additional Discounts Applied includes the discounts given to your customers when assuming the cost of credit card surcharges or free shipping for customers living in the ‘metro’ area.
In addition of your revenues, the report displays a summary of your expenses for you to see where you have or can save spend money.
- The Merchant Banking Fees stands for transactions processed using the Standard or Advanced Troly payment gateways. To process credit card payments, the bank charges a 1.5% fee to us and we pass this 1.5% fee on to you which is reflected in the report. If you use your own payment gateway (e.g. Braintree, eWay, Stripe or MyGate), you need to reconcile this information separately as it won’t show on the report.
- The report divides the Shipping Fees according to your shipping provider(s). If you use Troly shipping agreements, the expense is identified as Community Shipping Fees (combines Australia Post (Troly's Shipping Account), Fastway and CouriersPlease (Troly's Shipping Account) sources) and appears in the ‘Withheld for provider payment’ section. If you use your own agreement, your accounts are listed in the ‘Invoiced to you by providers’ section and the subtotal value matches the separate invoices received from those providers.
- Australia Post - Mishandled Parcel Fee are fees charged by AusPost when a label generated via Troly's AusPost account has been used but the corresponding order was not dispatched in Troly. Please read here for details.
- The Troly Platform Usage Fees is the monthly Troly platform usage fee, of $40 + 2% of sales recorded for access of all features, tools and configurations available. The Premium Support is billed separately on the Troly invoice.
- The SMS Fees are applied when the SMS add-on is installed and automated SMS messages enabled. The cost of 10¢ for each SMS is charged to your account for awaiting payment confirmations, order pick-up reminders, successful or declined credit card payments notifications and birthday messages.
For more information regarding Troly fees and pricing appearing on your invoice, please refer to the dedicated article.
Interim Profit Summary
The first half of the Interim Profit Summary provides the summary of the Revenues by Product Category(refer to above section for details). The second half breaks down all the additional costs, taxes and expenses incurred to provide the business total net profit before wages:
- The Expenses is the total Expenses by Source combined (Merchant banking fees, shipping provider fees, Troly platform usages fees and SMS fees).
- The Product Cost is a feature under development that will allow you to deduct your product cost to your sales and provide you an accurate total profit.
- The Wine Equalisation Tax (WET) Component (Australia only) is the 29% of the wholesale value of wine that Troly calculates into your Xero account. The products affected by the WET should be labelled as such in the ‘Business Attributes’ section of your Product Information page with the Wine Tax Applicable tag.
- The Goods and Services Tax (GST) Component (Australia only) is the 10% value added tax on most goods and services. The products that are exempt from the tax (e.g. water) should be labelled as such in the ‘Business Attributes’ section of your Product Information page with the Tax Exempt tag.
The Stock Movement report lists all individual products sold over the period. They are grouped in their respective categories set in Xero and a subtotal is given for each category. This list allows you to review your product sales in more details and assess how each product compete with others.
For more information regarding the financial flow of funds, please refer to our Bank settlements and revenue reconciliation article.
A list of bank transfers is available at all time in your Troly account going to Operations - Reports - Transaction Reports. Please note that the report will show you the transactions processed within the timeframe you've selected before generating the report. To read more about the transaction report, please click our Understanding Transactions Report article.
Missing bank transfer
Troly remits funds over to you daily but please note that funds should arrive to you within 2 business days depending on your bank. If you notice any major delay, please see our Troubleshooting Payments article for help and guidance.
Expected external deposits
If you are using your own Payment Gateway (e.g. Stripe, eWay, Braintree, MyGate) and the Offline Payment methods (e.g. Cash, external EFTPOS terminal, Bank Transfer, Cheque) and expect funds processed outside of Troly, they are listed in the Expected External Deposits section according to the payment date.
Wholesales that are reported as 'On Account' payments also appear in this section of the report and must be reconciled like other offline payment methods.