Industry Insights
Escape Marketing Excel Hell
Do you still manage your spend on marketing campaigns using excel sheets? Then this is for you…
August 10, 2021
Let’s look at some facts:
- Digital marketing spend is increasing and is going to reach US $640B by 2027, growing at CAGR of 10.3%
- During COVID digital marketing is the main lead generation channel (source)
This means that the companies must get better at tracking the impact of their marketing spend and empowering their marketing teams with the right tools/workflows. So what are the problems marketing teams are facing today?
Problem 1: How much do I have left to spend?
With many finance workflows happening at the end of the month, teams usually don’t have real-time reporting on their spending. This means that your marketing team most likely does the following:
What makes this worse is that, from interviews with marketing specialists, the marketing teams are forced to assign one of their colleagues on expense tracking duty. This usually takes up a lot of their time and clearly isn’t the most exciting activity of their day.
Problem 2: Reconciling expenses with T&E expense workflows
One job that a marketing specialist should not do, is reconcile expenses – that’s the role of the finance team. Yet, some marketing teams are forced to use T&E-like workflows from Concur, Intact, etc. which were designed to capture diverse expenses that occur on a sales trip.
Current workflow:
- Create an expense report
- Write out charges as line items for each campaign
- Attach invoices
- Categorize transactions
- Match expense to transaction from the bank statement
This workflow is extremely inefficient and clearly wasn’t designed for marketing expenses. Oh and by the way, online advertising platforms charge you on daily basis, so you have to do this EVERY DAY just to keep up with your spending. Not great… 😢
Possible solutions
Excel sheet
Marketing needs to keep their own books: an excel sheet that you need to update every day with daily campaign spend from all accounts across the entire team. This will require someone to spend hours every day collecting spend from all accounts and will cost a fortune in inefficient use of labour. Excel sheet is more like a flex tape.
Virtual cards 🌈
A much better approach is to use technology that was designed to solve this problem. Virtual cards have been built for the trucking industry to get visibility over trucker’s cashflows. Similarly, in marketing virtual cards can offer a lot of benefits:
- Real-time spend visibility – you are always in the know how much you’ve spent
- Set and forget – label a virtual card with accounting tags once and all transactions will be automatically tagged for you
- Spend control – assign cards with limits to employees, campaigns or channels to always be aware of where the money is going
- and more… flexible limits, easy receipt capture, secure payments, easy card sharing
So the virtual cards can automate all of the accounting for your marketing team and relief the pressure off the finance team’s reporting function!
Written by
All the resources
Float News
New! Bill Pay and Reimbursements
Float is the first business finance platform in Canada to offer an end-to-end solution that simplifies all non-payroll spending.
Read MoreCase Studies
How BenchSci Saved 40+ Hours a Month Streamlining Spend Management with Float
Trailblazing AI firm, BenchSci shares why they chose Float for secure spend management at scale.
Read MoreCase Studies
Health and Wellness SaaS Company Practice Better Closes the Books 6x Faster with Float
How the growing startup Practice Better leveraged Float to bring their spend management and bookkeeping in-house.
Read More