Client Request 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
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.
