Transcription
Michael J BrennanAjera Report Wish Book8 customized reportsReports that MAKE SENSE. Access the financial performance of a project while it’s in progress Convert accrual basis income statement results to cash basis fortax planning and filing purposes Produce client invoice backup after the client invoice has beenfinalized Dissect and analyze the company income statement by project orany rollup of a project Provide management with a single-page document that analyzestheir company performance including key performanceindicators for any period of time within a fiscal year
Introduction . . .Page 2Ajera Report Wish Book is a collection of reports designed to improveand advance the functionality of the Ajera software and end-user-workflowefficiency. These are REPORTS. They are not widgets nor inquiries. Thecomplexity of the data that is required to generate certain information oftenrequires more than a widget or inquiry. It requires a customized report.There are three forms of outputs (reports) present in the Ajera system.They are reports, widgets, and inquiries. Planes, Trains, and Automobiles canbe used as an analogy to explain the reporting options in Ajera. For instance, if you are traveling from Los Angeles to New York, then your bestmode of transportation would be via airplane; New York to Boston, a train orcar would be viable options; a quick trip to the grocery store, then an automobile is a likely choice. The same applies to reporting in Ajera whether youshould be using a report, widget, or inquiry. Often, Ajera users attempt tosolve all their reporting needs with a widget or inquiry. Unfortunately, thatsimply does not work.There is no “Google Maps” for Ajera reporting and the average Ajerauser cannot always effectively “judge the distance to be traveled.” Let’s lookat this way personally, a three-hour car ride is typically my threshold fordetermining my mode of transportation. If it is determined, I will fly, I haveto accept the fact I will not fly myself to the destination. I will have to booka flight on a commercial airline. This would be the equivalent of a customreport. Driving would equate to a widget or an inquiry.To purchase any of the reports in this book or for additional information,please email: mbrennan@unlockthedata.comIndicate the report(s) you are interested in.I will contact you to discuss installation options and payment.
Table of Contents. . .Page 38 Powerful Customized Reports . . .Gross Margin Performance Report . . . 4The primary purpose of this report is to relate project performance to companyperformance. In other words, it will enable you to dissect and analyze thecompany income statement by project or any rollup of a project (PM, PIC, client,client type, project type, etc.).Project Performance Report . 5The primary purpose of this report is to assist Ajera users withaccessing the financial performance of a project while it is in progress.Accrual to Cash Tax Preparation Assistant . . 6The primary purpose of this report is to assist Ajera users with convertingaccrual basis income statement results to cash basis for tax planning andfiling purposes.Outsourced Payroll Processing Assistant . . 7The primary purpose of this report is to assist with the processing ofpayroll within the Ajera system.Billing Buddy . . 8The primary purpose of this report is to assist with the processing ofclient invoices within the Ajera system. However, the main feature is theability to produce client invoice backup after the client invoice has beenfinalized.Billings and WIP Analysis . . 9The primary purpose of this report is to inform the reader of the dollaramount that is removed from the revenue stream (written off) in theGeneral Ledger (GL) for the period specific on the report.Ajera Dashboard . . . 10The primary purpose of this report is to provide management with asingle-page document that analyzes their company performance includingkey performance indicators for any period of time within a fiscal year.Vendor Pay When Paid Report . . . 11The primary purpose of this report is to inform the reader of invoiceamounts currently due and payable to their subcontract / consultantvendors based on payment received from their client(s).
Gross Margin Performance ReportPrice: 1400Page 4The primary purpose of this report is to relate project performance to companyperformance. In other words, it will enable you to dissect and analyze the companyincome statement by project or any rollup of a project (PM, PIC, client, client type, projecttype, etc.).Standard Report Equivalent: NoneBackground: An issue that has plagued the A&E industry has been determiningwhat projects have affected the bottom line and by how much on the company income statement. This report solves that issue. Ajera users can now view the sameresults of their income statement broken down by project. Gross margin, gross margin percentage, net margin (based on net service revenue), net margin percentage,and net labor multiplier are all available on this report.Report attributes include:Views: SummaryDetailed ProjectDepartmentCompanyAdditional Filters Available ClientProjectProject ManagerPrincipal in ChargeBilling TypeClient TypeProject TypeCompanyCustom Sorts Available (A performing or employee sort option is available)Filters:Sorts:View a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Gross Margin Performance Report.mp4
Project Performance ReportPrice: 1600Page 5The primary purpose of this report is to assist Ajera users with accessing the financialperformance of a project while it is in progress.Standard Report Equivalent: NoneWorkflow Requirements: This report requires Reported Percent Complete (RPC)values to be loaded into the Command Center of the Ajera system to function properly.Background: The standard reports present in the Command Center lack advancedfunctionality and KPI metrics sought after by many firms using Ajera. This reportwas designed to fulfill that void. Further, many firms that use Ajera are successfulwith maintaining RPC values in their system. However, the standard reports in theCommand Center include all the activity types in the results. This can cause false results when subcontractor invoices have not been received or not entered into theAjera system in a timely manner. This report solves that issue with an option to runon labor activity only.Report attributes include: Earned ValuePlanned ValueProjected Variance from Budget at Completion (an alternative toCost to Complete)Schedule Performance IndexCost Performance IndexThis report is a bundled package that includes a Command Center version and acustom report version that will run for multiple projects at once.View a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Project Performance Report.mp4
Accrual to Cash Tax Preparation AssistantPrice:Page 6 1000Installed*The primary purpose of this report is to assist Ajera users with converting accrual basisincome statement results to cash basis for tax planning and filing purposes.Standard Report Equivalent: NoneBackground: Maintaining both accrual and basis books in Ajera can be a time-consumingand frustrating experience for many Ajera Gatekeepers. Ajera does not always handlethe cash basis side of a transaction in the correct manner. Identifying and correctingthese errors can be challenging and a futile exercise if your Ajera Gatekeeper does nothave formal accounting training. As a result, the decision is often made to forgo themaintenance of the cash books. That leads to accrual to cash conversion multiple timesper year for tax planning and filing.Also, it is very common for A&E firms to segregate their payroll and other transactionsinto multiple accounts. This can present challenges for their tax preparers to consolidatethe results for tax filing purposes. This report was designed to streamline and simplifythe accrual to cash conversion and tax filing process.Report attributes include: Accounts Receivable balance detailed by G/L account Accounts Payable balance detailed by G/L account WIP balance detailed by G/L account Salaries Payable balance detailed by G/L account Income Statement results grouped and totaled by common line items present on IRS forms 1120S and 1065. Clean Export to Excel*Installed and Configured Price: 1,000Self-Installation and Configuration Price: 750View a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Accrual to Cash Tax Preparation Assistant.mp4
Outsourced Payroll Processing AssistantPrice:Page 7 900The primary purpose of this report is to assist with the processing of payroll within theAjera system. The report has functionality to identify common issues encountered whenprocessing payroll. It will also display a list of staff, along with their gross pay, that willagree to the related payroll vendor invoice amount.Standard Report Equivalent: NoneBackground: Processing payroll using the outsourced model in Ajera is often shrouded inuncertainty. The main issue at play is there is not a standard report or inquiry that will detail the payroll service invoice by employee. Therefore, reconciliation with the outsourcedpayroll journal can be very challenging. The Outsourced Payroll Processing Assistant willnot only detail this information by employee, but it will calculate and display the “expectedpayroll variance”.Report attributes include:Highlight Common Issues: Identify active employees with no time in the system for the period defined Identify time entries within the defined date range that are not included onthe payroll service invoice. These are typically late timesheet entries.Primary Sorts: Department Employee Employee ID Secondary Sorts: Employee Employee IDReport Restrictions: This report is not intended for Ajera users that encounter multiplerates of pay per employee per pay cycle. Please contact me to discuss your specific situation. Customization are available to resolve challenging environments.View a demonstration of the report in action d Payroll Processing Assistant.mp4
Billing BuddyPrice:Page 8 1000The purpose of this report is to assist with the processing of client invoices within the Ajerasystem. What separates it from any standard report or invoice format in the system is itenables the user to produce client invoice backup after the client invoice has been finalized.This can be accomplished weeks, months, and even years after the original invoice wasfinalized and issued to the client.Standard Report Equivalent: NoneBackground: There are many scenarios in the A&E industry in which invoice backup isneeded to be produced after the client invoice has been finalized in the system. Most Ajerausers know this cannot be done via the original invoice interface. The invoice status has tobe changed back to Draft and the invoice is Final printed a second time. Even then, makingmodifications to the related invoice format can be challenging in order to produce theneeded information.Billing Buddy has several built-in sub reports that will replicate the most commonly requested invoice backup. Full timesheets, partial timesheets, labor details, expense details, in-house expense log data, etc. Additional detailed backup can be added. Just ask!Report attributes include:Backup reports including: Full Timesheets Partial Timesheets Labor Details Expense details In-house expense logSorts: Project Client Cutoff DateFilters: Date Range Project ClientView a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Billing Buddy.mp4
Billings and WIP AnalysisPrice:Page 9 1000The primary purpose of this report is to inform the reader of the dollar amount that isremoved from the revenue stream (written off) in the General Ledger (GL) for the periodspecified on the report.Standard Report Equivalent: NoneBackground: There are several methods in Ajera to remove work in progress (WIP) from theBalance Sheet and the related revenue stream in the GL. Of those methods, only one results ina write off in the Ajera system (The Ajera system collectively includes the Income Statement,General Ledger, and all standard projects reports, widgets, and inquiries). As a result, theamount displayed throughout the system represents only a fraction of the true write off on aproject or for a period of time.The above statement is contingent on the workflow procedures followed by staff responsible for processing client invoices. In our experience, few companies that use Ajera follow therequired workflow procedure in such a manner that results in accurate write offs throughoutthe system. Hence, this report was developed.Report attributes include:Views: Summary DetailedFilters: Project Department Company Additional Filters AvailableSorts: Client Project Project Manager Principal in Charge Billing Type Client Type Project Type Company Custom Sorts AvailableView a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Billings and WIP Analysis.mp4
Ajera DashboardPrice:Page 10 1600The primary purpose of this report is to provide management with a single-page documentthat analyzes their company performance including key performance indicators for anyperiod of time within a fiscal year.Standard Report Equivalent: NoneBackground: The need for a report that provides all the key performance indicators on a singlepage in an easy-to-read and printable format, has eluded many Ajera users for years. If yourcompany has been lucky enough to employ one, chances are, it is created offline in Excel orother separate program from Ajera. This report will run directly out of your Ajera system. In afew minutes or less, the user can have their one-page report ready for the company meeting todiscuss financial results.Report attributes include:Views:Summary onlyFilters:CompanySorts:NoneKPI’s Included: Net Service Revenue Net Labor Multiplier Utilization Billability Marketing Labor as a percent of Total Labor Breakeven Overhead Rate Accounts Receivable Turnover Gross Margin and Gross Margin Percentage Net Income and Net Income Percentage Looking for another KPI? Just ask! Customizations available.View a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Ajera Dashboard.mp4
Vendor Paid When PaidPrice: 1400Page 11The primary purpose of this report is to inform the reader of invoice amounts currently due andpayable to their subcontract / consultant vendors based on payment received from their client(s).Standard Report Equivalent: NoneBackground: Reasons why this report was created and shortcomings with the standard report from both apresentation and a work flow standpoint.From a presentation standpoint:The reader no longer must sort through both positive and negative returns in order to compile a list ofInvoices that need to be paid, which can be time-consuming and cause errors. The standard report doesnot include Control totals to balance with or to provide confirmation totals of the invoices selected forpayment. This report does.From a workflow standpoint:The standard report fails to serve many users due to situation referred to as “trailing costs.” Trailingcosts are the consultant invoices that are received after the client invoice have been sent to the client.The consultant invoices relate to the same period of performance as the client invoice. However, sincethey were received after the client invoice was finalized in Ajera, they are not physically associated withthe client invoice in the Ajera system. As a result, the standard report fails to provide the reader the correct timing information in order to pay the consultants.1. The standard report will only work with vendors identified as consultants in the system.Many firms utilizing Ajera have vendor invoices with an Expense activity type they want to payon a pay when paid basis.2. The standard report will not recognize these expenses because they do not have a consultanttag in the system.3. The standard report does not include vendor invoices that have a WIP status of “Deferred”.Therefore, a separate report (Vendor Invoice Aging) needs to be run in order to get a completebalance due and outstanding to a vendor.Highlights of this custom Vendor Pay When Paid report: The presentation is far superior to the standard report, and control totals are provided. SQL code has been programmed to recognize a custom workflow scenario. When the WIP associatedwith trailing costs is cleared with same cutoff date as the client invoice is related to, the custom reportwill merge the data together. That will allow the trailing costs to be tracked and paid like they are received prior to finalizing the client invoice. There is an option to include selected expenses in a separate report. All unpaid vendor invoices are included on the custom report. A complete vendor or project invoice history of both paid and unpaid invoices is available to assist thereader in assessing the status of an invoice or group of invoices.View a demonstration of the report in action here:http://www.unlockthedata.com/Videos/Vendor Pay When Paid Demo.mp4
Ajera Report Wish Book is a collection of reports designed to improve . mobile is a likely choice. The same applies to reporting in Ajera whether you should be using a report, widget, or inquiry. Often, Ajera users attempt to . Full timesheets, partial ti
