BlackLine Product LookBook

A practical guide to revolutionizing your record-to-report process with financial close automation 

There are a ton of automation solutions out there in the market today. And even more claims about how automation can change your financial close processes beyond your wildest dreams. But what you really need is a clear picture of what these claims practically look like with the financial close processes you execute day in, day out. 

That’s the key to achieving the outcomes you want. 

A practical guide to revolutionizing your record-to-report process with financial close automation

WHAT’S INSIDE?

In this LookBook, we’ll give you those answers by unpacking one example workflow within financial close in all its pragmatic details:

The end-to-end, record-to-report process for a
cash account.

Is this all that BlackLine does? Absolutely not. 

Customers choose BlackLine because it can help them orchestrate future-ready processes across all of their financial operations—from reconciliation to consolidation and financial analysis.

But in this piece, we want to get into the weeds of one example process so you can see how our solution impacts each stage. We aim to give you a deep understanding of what completeness and accuracy of cash accounts could look like with BlackLine’s end-to-end R2R solution. 

And whether you choose us as your financial operations partner or not, we hope it gives you a clear idea of what’s possible, so you can benchmark any other partner’s solutions against it. 

Because harnessing the full power of any solution is how you stop it becoming just another system for your overstretched finance and accounting teams to navigate. Let’s do this.

Is this all that BlackLine does? Absolutely not.

What does the traditional record-to-report process for a cash account look like?

Download the data or details from your bank, fire up your online banking portal, pull the statement you need, dump the data into a spreadsheet. 

Then do the same thing on the general ledger (GL) side of your process. 

Then format all the data. Match the transactions between the bank and GL.

Then figure out if there are timing items or adjustments needed. 

Post the adjusting entries into the ERP and upload supporting documentation.

Manually compare variance and fluctuations across periods.

BlackLine’s automation can improve the R2R process for a cash account

If used correctly, an automation solution can help you turn the R2R process for a cash account into something a little more like this:

Step One

Close orchestration & operations


Before you get started with your bank reconciliation workflow, you need a way to get visibility into each stage of the process. Let’s say you’re a controller. To do your job most effectively, you need an easy way to see what’s left to be completed in each of your financial close processes. And that’s a pretty major task because those critical accounting activities are often slow, manual processes, with little coordination—especially bank reconciliations. You need a clear line of sight. What you often get is an endless checklist and a bunch of inconsistencies. 

BlackLine attacks this problem with Task Management. It’s a configurable, cloud-based command center where you can seamlessly manage and automate your finance and accounting tasks. Task Management also includes cloud-based dashboards. These provide real-time visibility into status, timeliness, content, and quality of each task—so you can ensure nothing falls through the cracks. Not just in your bank reconciliations but across all the workflows in your financial close process. 

The result? You can orchestrate the order of operations for financial reporting which reduces productivity redundancy. And you get visibility into the data you need to create mission critical insight during the close period—not retrospectively. Including the status of controls certification. 

Close orchestration & operations


“Since BlackLine, we have seen 100% on-time completion rates for all  month-end reconciliations. With Task Management, managers and employees know what needs to be done and on what timeline. That increased visibility drives accountability.”


SANTO AHMED, GROUP FINANCIAL CONTROLLER—RESIMAC

Step TWO

Data integration & connectivity


To maintain accurate and complete cash accounts, you need to be able to connect your data sources and ingest mission-critical data without errors. To do that successfully, you need to break up with spreadsheets which are error-prone and lack the controls to ensure accuracy. 

In a traditional bank reconciliation workflow, you’d likely take a bank file and put it into a spreadsheet, and then take a general ledger file and do the same. This heavily manual process leaves you vulnerable to data-handling errors, version control issues, lack of audit trail, and even fraud. 

To help you overcome these, BlackLine’s connectors enable you to simultaneously ingest data from all your financial data sources into one secure source with ease. That includes general ledger systems, banks, and of course your ERPs.

When it comes to ERPs, there’s a variety in use in the market. So we’d strongly recommend that whatever solution you choose for your financial close activities, make sure it’s ERP and system agnostic. 

Data integration & connectivity


“BlackLine has opened up a whole new world for us. It’s so much easier for accounting to put data into a format that finance can easily use. It also enables us to give our CFO more up-to-date information, which in turn helps him make better decisions for BCU.”

CHARLOTTE O’NEILL, ACCOUNTING MANAGER—BAXTER CREDIT UNION

Taking accuracy to the next level

To help you entrench this accuracy even further, BlackLine adds out-of-the-box Reconciliation Templates into the mix. These structured templates give your teams a best practice approach to ensuring the accuracy, quality, and completeness of your bank reconciliation data. The result? It’s easy to align your records with your main financial systems and correct discrepancies.

Can I use spreadsheets with BlackLine?

In short, yes. We connect to any system you need. But to get the full power out of BlackLine, we recommend making the most of our two-way ERP connectors. 

Step THREE

Transaction-level reconciliation 


Reconciling a high-volume of transaction-level data involves a lot of tedious manual processes. This is typically a lose-lose for you and your business. As a finance and accounting expert, you’re most valuable to your business when you’re dealing with anomalies, exceptions, and opportunities.  

But the more bogged down you are with manually matching all transactions regardless of their importance, the less time you have to focus on those exceptions and anomalies. And if you’re doing this from a spreadsheet base, you’ll be juggling v-lookups and color coding when you should be focusing on high-value tasks. To allow you to be at your most valuable and make your job a lot less tedious, we developed Transaction Matching. 

It works a little like this. Using the connectors we mentioned earlier, we ingest your detailed data from your different sources (bank data from your bank file and GL data from your GL file). BlackLine then automatically matches these transactions so when you log in, all you need to do is focus on the anomalies and exceptions. But we also know that there are a bunch of recurring exceptions with bank reconciliations that can become a point of frustration over time, for example: 

  • Bank fees that haven’t been posted to the general ledger

  • Timing items like deposits in transit

  • Outstanding checks

Beyond bank reconciliations, BlackLine gives you the ability to take logic and automatically identify repeat exceptions across all your financial close operations. You can even automatically record a journal entry for them (more on this in the next step). The impact of Transaction Matching? You can raise the bar for anomalies—letting you focus on the highest of the high-value exceptions. 

Transaction-level reconciliation


“BlackLine has given us a greater amount of efficiency in terms of workflow. It replaced all our manual processes, so we have everything in a one-stop shop.”

SHAY CARROLL, ACCOUNTING DIRECTOR—GLOBAL SETTLEMENT & ACCOUNTING SOLUTION

Step Four

Automated journal entries


Move fast and break things doesn’t work in finance and accounting. If your R2R solution leverages Artificial Intelligence or Machine Learning, you need to trust it does so in a way that strengthens your compliance posture. A big part of that? Your journal entries. 

The high number of manual touches with journals makes them a breeding ground for errors. BlackLine helps eradicate this by automatically creating your journal entry and posting it directly to your ERP. And depending on the dollar value of the journal, this can either be posted using a touchless process or filled out ready for a team member to check over and post to the ERP. 

Aside from being a huge breeding ground for errors, journals are also a gigantic waste of time. Especially when you consider the impact across all of your financial close processes. Your business likely books hundreds, if not thousands, of journal entries every month. When you consider the manual handling of each one, including the reviewing and approval, each of those 15 minute tasks adds up. 

Using Automated Journal Entry, you can realize some serious efficiency gains. For example, one BlackLine customer saved 900 hours per month across just one account. 

Automated journal entries

Example: Bank fees 

There are hundreds of different types of automated journal entries that BlackLine can post—but here, we’re focusing on bank fees. 

1

Auto-posting

Your bank fees will be automatically posted by your bank to your account. 

2

Auto-detection

BlackLine’s automated journal feature will detect these line items in your statement.

3

Auto-journal entry

It will then create and post an automated journal entry to record that in the general ledger. 

Step FIve

Adjusting journal entries


There are always going to be journal entries that are outside ‘business as usual.’ For example, say there’s an incorrect posting to a bank account in the general ledger and you identify it as requiring adjustment. If executing that adjustment involves you leaving your platform or solution, that’s going to increase the time and strain it takes to handle each one. 

To alleviate such lengthy platform workarounds, BlackLine Journal Entry allows you to:

  • Identify individual transactions (or a group of them) when going through the unmatched transactions using Transaction Matching.

  • Attach that to a journal entry or create a journal from it.

  • Post it in the general  ledger account. 

This means you identified the adjustment in BlackLine, analyzed it, and cleared it directly from the unmatched transaction list without ever leaving the platform. It’s the kind of end-to-end transparency your teams need to make auditing more robust and your bank reconciliation workflows as waste-free as possible. 

Adjusting journal entries


“We’re completing our reconciliations two days faster than before. The gap between when the reconciliations are finished and the close has narrowed. That has been huge for us.”

MICHAEL KING, CONTROLLER—BERKSHIRE BANK

Step Six

Automated notifications


In fast moving markets, the speed of insight matters. Which is why anyone relying on accurate financial data needs to know about unexpected fluctuations—fast. BlackLine helps you achieve this using AI and rules-based logic.

For example:
Imagine one of the balance sheets (cash accounts) is coming back with a 10% difference month over month that you didn’t expect. BlackLine’s Variance Analysis and generative AI insight will help you by flagging this as an anomaly. And then provide you with transaction-level details explaining why the variance occurred.

Our generative AI capabilities will also draw the entity-level details and provide you with variance explanations at the consolidated level across multiple accounts. All of which is viewable in a centralized workspace including purpose-built dashboards and reports, so you get a near real time view of fluctuations. 

Automated notifications

Does the use of Generative AI described here increase risk?

In short, no. Our approach to AI is that it’s always used in a way that makes the most of human expertise. As such, insights delivered from our AI solutions are always treated as suggested recommendations.

Your accountants are always in control.

The final analysis, approval, and documentation is always in human hands.

Spotlight on:

Journals Risk Analyser


Beyond bank reconciliations, BlackLine deploys AI across your entire R2R operations through a broad range of cutting-edge features. One that gets our customers particularly excited is our AI-powered Journals Risk Analyser. 

This solution captures and evaluates all your journal entries—across all your ERPs and systems. It then gives you visibility into journal entries and provides you with easy-to-use dashboards so you can assess the findings and view KPIs. 

Examples:

  • Analyze by Journal Entry Type gives you visibility into risky transactions. It also gives you AI-powered insights into where you can start eliminating manual journal entries to improve your processes.

  • Analyze by Journal Entry Amount highlights any larger amounts for further review so you can ensure compliance. But it can also highlight small journal entry amounts that might be wasting your employees’ time.  

It’s all about providing you with the transparency and assistance you need to reduce risk and make better decisions. 

Journals Risk Analyser


JOURNALS RISK ANALYSER IN ACTION:

Let’s say your policy is journal entries less than $250 do not need to be posted because they're a time drain. But some employees are still posting journal entries for amounts under $250. The Journals Risk Analyser can highlight how many of these journal entries are being posted so you can eradicate them.

Step SEVEN

Balance sheet substantiation


Balance sheet substantiation is where you feel the cumulative impact of a unified solution. Gaining the confidence to substantiate the balance is a lot easier when you know you’re reducing the amount of manual handling errors entering your reconciliation in the first place. And when you have visibility over all the data you need, in one place. 

To help you gain this trust in your numbers, BlackLine Account Reconciliations allows you to drill down to the data without having to juggle a host of different systems. And that speed-to-detail goes right to the very end of the downstream side of things too. 

When you need to review supporting documentation or formal certifications, you’re able to view and share them with ease. Hit something you can’t substantiate? You’ve got a full list of explanations and the audit trail you need to understand how the handler came to this conclusion. Full traceability, full accountability. 

Balance sheet substantiation


“With BlackLine, I’m not spending my whole day looking for documentation
 or reviewing reconciliations. I finally have the time to focus on our initiatives and engage in more strategic work.”

MICHAEL KING, CONTROLLER—BERKSHIRE BANK

Step EIGHT

Internal control validation


For most businesses, the end-to-end account reconciliation process for a cash account is a key internal control. It allows businesses to validate that the cash on their balance sheet is accurate and to detect fraud.

The cumulative effect of using BlackLine Financial Close Solutions is that you’re able to reconcile and substantiate your cash account balances continuously. This will result in greater efficiencies and strengthen internal controls around cash. That’s because internal and external auditors have access to underlying supporting evidence and documentation. This reduces the manual resource burden of gathering evidence for an audit and means less time responding to requests. 

Internal control validation


“We knew BlackLine would help us achieve a number of key things—transparency, efficiency, better controls. We’ve also found it’s been an enabler and a catalyst for change.”

LISA BIRD, LEAD SPECIALIST, INTERNAL FINANCIAL CONTROL—LIBERTY GROUP

And that’s it. 

We hope this has shown you the way forward for the end-to-end R2R process for your cash accounts. If you want to see how we’re helping businesses like yours orchestrate better automation across other workflows, be sure to stay tuned for other eBooks in this series. If you’re ready to see the platform in action, let’s talk about a personalized demo.