CLIENT EXAMPLES

Below are 5 examples of what a client may request to streamline their processes and have professional reporting

Let's look at clients who are interested in outsourced projects.

Mark Smith

Treasury Manager

Client Issue: “We don’t have a consolidated report that can show us our bank account balances throughout the world by currency, entity, that support different lender covenants, can be updated quickly, and is shown net in USD.”

Client Preference: “A Power BI dashboard that we can updated every day with a few steps so I can speak to my CFO and Treasurer about strategic capital planning, currency volatility impacts, and have a report that can be presented professionally.”

5 Stage Solution: Business Intelligence, Reporting, Create, Dashboard, Cash multiple measures

Designing a Solution

Stage 1

BUSINESS INTELLIGENCE

Stage 2

REPORTING

Stage 3

CREATE

Stage 4

DASHBOARD

Stage 5

CASH MULTIPLE MEASURES, POWER BI

Results

THE SOLUTION

BFC Solution: A Power BI dashboard to report cash balances by lender group, currency, silo, entity, and other measures that will increase transparency.

BI.

F

A

S

T

woman photo

Heather Downey

Director of Corporate Finance

Client Issue: “Our business is heavily M&A focused and we call investment capital from our equity partners quarterly. It would be helpful to tie our M&A pipeline with our capital structure to see our needs in an optimized way since it is currently a manual process.”

Client Preference: “Excel based files that can link our M&A price and date data with our 60/40 target debt to equity split on each investment so we know how much equity to call. It would be great to see the output in PowerPoint and refreshed fairly easily.”

5 Stage Solution: Finance, Optimization, Create, Capital Call, Link M&A deals and Treasury capital structure splits in PowerPoint format

Designing a Solution

Stage 1

FINANCE

Stage 2

OPTIMIZATION

Stage 3

CREATE

Stage 4

CAPITAL CALL

Stage 5

DEALS & CAPITAL STRUCTURE, POWERPOINT

Results

THE SOLUTION

BFC Solution: A PowerPoint linked presentation with Excel files that bring M&A deals and Treasury capital structure splits into one view to present to Equity Investors quarterly.

BI.

F

A

S

T

Javier Orozco

Corporate Controller

Client Issue: “Our accounts receivable process is very manual and will be more inefficient as we add 15 customers in the next 3 months. We need to start scaling our processes to record our receipts in much less time.”

Client Preference: “Our Free Consultation with Butler Financial Consulting uncovered a way to record our lockbox receipts in 90% less time using Microsoft Power Query so I’d like to achieve that solution in the next 2 weeks.”

5 Stage Solution: Accounting, Scalability, Create, Power Query, Excel file output to match journal upload layout 

Designing a Solution

Stage 1

ACCOUNTING

Stage 2

SCALABILITY

Stage 3

CREATE

Stage 4

POWER QUERY

Stage 5

EXCEL OUTPUT FOR JOURNAL UPLOAD

Results

THE SOLUTION

BFC Solution: An Excel Power Query that connects bank transactions with preset coding templates to adhere to the format for uploading records to the accounting system.

BI.

F

A

S

T

Bill Richardson

Chief Financial Officer

Client Issue: “We are growing our business very quickly and opening up bank accounts all over the world. It takes months to fill out forms, set up users and tokens, activate the accounts, and still need to log in to multiple bank platforms to enter and release wires. “

Client Preference: “We need a software to handle all of our banking, reporting, payments, and administration needs in one place.”

5 Stage Solution: Software, Scalability, Overhaul, Treasury Management System, assess providers for Bank Data/Reporting/Payments/Administration modules

Designing a Solution

Stage 1

SOFTWARE

Stage 2

SCALABILITY

Stage 3

OVERHAUL

Stage 4

TREASURY MANAGEMENT SYSTEM

Stage 5

CENTRALIZES BANK DATA, REPORTING, AND USER ADMINISTRATION

Results

THE SOLUTION

BFC Solution: A Treasury Management System (TMS) comparison.

Tim Bright

Treasurer

Client Issue: “Our Excel cash forecast is only 4-6 weeks, does not capture activity in buckets that can link to our FP&A reporting, and needs to be updated by our market managers to gather enough pertinent details.”

Client Preference: “I’d like a 13-week rolling Excel cash forecast to feed into the summary format of the FP&A reporting, updated on a weekly basis, and contain tabs for each market.” 

5 Stage Solution: Treasury, Reporting, Replace, Cash Forecast, Consolidated by market in Excel

Designing a Solution

Stage 1

TREASURY

Stage 2

REPORTING

Stage 3

REPLACE

Stage 4

CASH FORECAST

Stage 5

CONSOLIDATED BY MARKET IN EXCEL

Results

THE SOLUTION

BFC Solution: An Excel workbook for each country that is updated by the market managers weekly per the format of FP&A reporting.

BI.

F

A

S

T

CLIENT EXAMPLES

It is time to complete unfinished projects with a kick-start from a trusted and knowledgeable corporate finance professional. Choose Butler Financial Consulting for your outsourced financial projects.