In my last LinkedIn Post (Cash Position Report), I talked about the strategic importance of Cash on hand for a Professional Services Organization. In this post, I want to talk about the importance of the Overdue Accounts Receivable (AR) Report. As a Professional Services firm, most of our revenue comes from Project based delivery of Services. We have some top-line revenue from the subscription services we sell like Dynamics 365, but it’s not significant. So, our primary source of revenue is Services. We needed to ensure we bill on time, get paid on time. So we developed our Power BI AR Report as shown below – So let’s dive in! A few things to note in the above Report – It is a PowerBI Report embedded in our Leadership Team in our Microsoft Teams platform. We call it the PSA AR Report, as the reporting comes from our invoicing in Dynamics 365 PSA. Dynamics 365 PSA is our ‘single source of truth‘ for all our Project based billing. The bottom of the Report has two tabs – Services and Licensing/Commission Invoices. More on that shortly. Dynamics 365 PSA is our the single source of truth for all Customer Invoicing. We run all our Project based Services Invoicing from the Invoicing and Contract Milestone Schedule in Dynamics 365 PSA. This means our Allocations, Contract Milestones and our Time entries are always up-to-date, otherwise our invoicing schedule would be incorrect. This ensures good Project Management practices. Now PSA does not handle taxation, so you have to either setup your taxation customization or use an off the shelf tax add on that is available on the Microsoft AppSource. If none of these options are possible, then you can decide to create your invoices in your Accounting system and integrate those into Dynamics 365 PSA. We do that for our Licensing invoices to our Customers and integrate those from our QuickBooks Online Accounting system into Dynamics 365 PSA. We also ensure that invoices are only emailed to customers from Dynamics 365 so we can track these emails. Further, we update Invoice Statuses from Draft to Sent to Paid. Now let’s get into the Report. Basically, we have color coded our Report based on the following simple rules – Red for anything that is overdue by 30 days or more, yellow for anything that is between 1-30 days overdue and no color coding for current invoices. The visual impact of color coding can’t be emphasized enough. On the top left corner of the Report, we have an option to search by Customer, so we can quickly get all invoices for a specific customer in the AR Report. This becomes very useful when you want to just share a snapshot with your customer for overdue invoices.  Handling Multiple Legal Entities: We have three legal entities – India, USA and Singapore. We have three separate QuickBooks Online Accounts for each legal entity, but we use a single Dynamics 365 CRM platform. We have made customizations on our Invoice entity to ensure we capture the correct legal entity. In the example below, you can see we classify our Invoices by legal entity in our Report – You can see there is column called ‘link’ in the above reports. Clicking on any invoice in this link directly takes us to the Invoice record in Dynamics 365.  Overdue Reminders Alerts- We automated the Overdue Reminders so that our system automatically sends out a reminder for all overdue invoices every Monday.  After all this effort, you still need to ensure regular and rigorous review of this report to ensure you can take action on overdue invoices. This is done through our scheduled Monday morning Management Status Meetings. The agenda for this meeting is recurring and hence set in advance, but this Management meeting always starts with AR Report Review. Our Accounts Manager is invited for the first 15 minutes and we go through all Overdue Invoices (especially the Red color coded ones!) and decide if we need to take further steps like setting up a meeting with the customer.  If you are a small or mid sized Services organization, it is of utmost importance to get paid on time. By ensuring you have such a report and reviewing and planning action items for overdue invoices, you will run an efficient Services organization. In addition, there is another strategic benefit here – this report is like a Quality Check on your services. If your customer is paying on time and suddenly does not, your proactive action to talk with the customer can help you understand if there are any issues in your Services and you can take corrective action. Our PSA AR Report is available to our Management team (this includes our Delivery Heads and Practice Leads as well) through Microsoft Teams and they can view it any time they want, planning action items as needed. If it is hidden away only with the Accounts Team and available through some weekly PDF report, it is not efficient for your organization. This Report will help your organization achieve it’s Objective – ‘bill on time, get paid on time.’ If you are keen on understanding more about our Internal Systems that keep us running and growing, our Internal Systems page is a wonderful resource – https://www.cloudfronts.com/our-internal-systems/ or reach out to me at ashah@cloudfronts.com.

In this post, I will talk about the importance of the Cash Position Report for any Professional Services Organization.  The Cash Position is your current and forecasted ‘Cash in Hand’. The importance of having Cash in your bank account cannot be emphasized enough. It is important to understand the difference between Cash Flow and Cash in Hand as they are not the same. An organization can have a solid cash flow (which is revenue tied up in Receivables), but without money in the bank, it cannot operate. Let me go into this further as it’s the foundation of our conversation here.  For any Professional Services organization, anywhere from 60 to 80% of the Monthly expenses are tied to Employee salaries. Paying salaries on time, every month is key to the organization’s credibility. Salaries need to happen on time, month after month, irrespective of your cash flow. They require cash on hand. In addition, any business planning, from HR Activities (a team lunch, an offsite meet) to Investing in the organization’s growth (new areas of business, developing expertise) also requires cash on hand.  One more topic that I need to mention is the current pandemic. Many Projects are delayed, cancelled or on hold. From a business standpoint, this kind of unforeseen event can put a tremendous strain on its ability to continue operations. But while the current pandemic is an extreme scenario, businesses constantly face challenges as we operate on a global level (2004 Tsunami, 2008 Financial Meltdown are some recently examples). Cash on Hand can mean the difference between survival and going out of business.  So we see that Cash on Hand is a Key Metric and hence should be reviewed regularly, ideally during a scheduled Management meeting on a recurring basis. At CloudFronts, we do this review every Monday morning. Our two and a half hour Monday morning Management meetings are literally run by numbers. Some of the Key Reports we review are Project Overview Report, Team Billable & Non-Billable Allocation Report, Support Metrics, Sales Pipeline, Outstanding Accounts Receivable Report, Forecasted AR Report, Cash Position Report. Each one of these is a PowerBI Report embedded into our Microsoft Teams Leadership Team Group.  So what is the Cash Position Report? I will start with a simple equation and then delve into the details –   Cash Position = Cash + AR – AP + Projected AR Now let’s walk through each of the Items in there and how we get that data – Cash on Hand – This is what is in your Bank Account when you run this Report (our report is updated every Monday morning before our weekly Management Meeting). We manually enter this data into the Report.  AR – AR is your Accounts Receivable which includes all Customer Invoices that are due this month and have not yet been paid. This includes overdue invoices carried forward from the previous month as well. If an Invoice is Paid, then it goes into Cash on Hand. Our AR data comes from Dynamics 365 PSA Contract Invoicing Schedule for both Fixed Bid and Time & Materials Projects. Our Contract Invoicing Schedule is the Single source of truth for all our Project Services Invoicing.  AP – AP is all Payables this month, including Salaries. It comes from our Accounting System which is currently QuickBooks Online.  Projected AR – Projected Accounts Receivable are any Invoices that we will generate this month and that will be due this month. This data also becomes from our Contract Invoicing Schedule. For Fixed Bid, this is based on the Contract Billing Milestones and for Time & Materials, this data comes from the Team Member Allocations.  At the top of the Report, you will see that the report is month wise. Hence as you move into the future months, you have less visibility into AR data, but rely on your Projected AR data. As you move into a month, the Projected AR starts becoming AR, which then becomes cash on hand and typically by the end of the month, Projected AR should be zero.  This Report gives the Management Team a clear visibility of the company’s Cash Position over a period of time. For us, we are looking at six months into the future, but organizations can easily set this up for longer periods. By reviewing it regularly, in a scheduled meeting, you ensure there are no surprises and you have time to react well in advance.  The benefits of such a report are further amplified when you consider its impact on our behaviour. During the pandemic, our No.1 priority has been to ensure we are a stable organization with the ability to operate through this pandemic. This report can give you that stability and allow you to stay productive and impact your team with a positive state of mind.  If you are keen on understanding more about our Internal Systems that keep us running and growing, our Internal Systems page is a wonderful resource – https://www.cloudfronts.com/our-internal-systems/ CloudFronts is one of the leading Microsoft Partners globally on implementing Professional Services Automation on the Microsoft Dynamics 365 Platform. You can reach me on LinkedIn for any questions/queries or email me at ashah@cloudfronts.com

Introduction: In the current 8.2 version of D365 PSA, we can only Hard Book a Resource from the Project Team Member View whereas in the v9.0, we can Soft Book from the Project Team Member View from with a few extra clicks. v8.2 – Current There is a button called Hard Book which lets you Hard Book the resource selected as shown below Then, you can plainly Hard Book the resource. v9.0 There is a generic option called as Book in the Project Team Member Associated View On clicking the same, a separate window opens with the selected Resource to Book them Conclusion Soft Booking from Project Team Members Associated View is not possible in v8.2 but is possible in the v9.0 version.