| The Challenge |
TAK Credit Management needed to get a handle on their cashflow.
In particular they had :-
They faced the following issues:-
-
As their actual activity was on separate tabs for each month, they were unable to see the bigger picture of how their business was performing
-
They were not able to reconcile their actual expenses with that in the plan
-
There was no way of comparing actual with expected activity
-
Their actual activity used two currencies – Sterling and Polish zloty – and they needed to be able to adjust the exchange rates easily
|
 |
|
| The Solution |
Simply Spreadsheets built an Excel interface that allowed both files to be combined into a single Excel workbook. The interface allowed the categorization of the actual expenses into those used in the business plan.
The solution had the following features :-
-
It enabled them to see the actual activity on a single sheet - previously it had been over several pages
-
It was easy to see the reconciliation between the actual and expected activity
-
There were cashflow statements summarising the monthly situation for both the UK and Polish Bank Accounts
- All the information could be seen graphically as well as numerically - enabling quick analysis of trends
|
|
|
| The Benefits |
TAK Credit Management saw the following the benefits in our solution
- It enabled to assess their position at a glance - previously it took up to 2 days to assess their position
- They knew that the numbers were now 100% accurate
- They were able to plan their business more accurately
|
|
|
|
| Company Profile |
TAK Outsourcing specialise in improving a company’s cash flow by providing effective Credit Control and Debt Recovery services.
Their customers range from the small to multi national businesses.
|
 |
|
| Client Testimonial |
|
"Simply Spreadsheets interfaced two spreadsheets, working in different currencies, to give us a cashflow forecasting tool. It used to take us 8 hours to calculate, now it almost instantaneous."
Simon Hampton TAK-Outsourcing
|
|
|
|
TAK Credit Management offer Credit Management and Debt Recovery Services to customers in the UK delivered from an off shore service centre. Simply Spreadsheets streamlined reporting process - so everything feeds through automatically - saving valuable time.
