Portfolio Risk & CECL Investment Accounting

Park National Bank builds a trusted investment accounting process with TPG Software

Asset size

$12 billion

Product

TPG Software

Location

Ohio

Park National Bank relies on TPG Software to support its investment accounting processes. By automating nightly entries, centralizing information, and feeding data into the bank’s asset/liability management software, TPG Software helps the bank maintain daily visibility into the portfolio without relying on large spreadsheets or repetitive manual entry. The result is a more efficient process, greater confidence in the accuracy of the data, and a reliable record of transactions that supports audit and compliance needs.

Download the full case study

The challenge: Maintaining visibility as the bank grows

Park National Bank had already used TPG Software for several years when treasury and investment analyst Amy Adams joined the organization twenty years ago. Over time, she built all of her investment accounting processes around the software and came to rely on its consistency as the bank’s portfolio and operations evolved.

That consistency has become increasingly important as Park National Bank continues to grow. Adams’ priority is to keep investment and accounting information current while ensuring that data remains accurate, traceable, and readily available. She recognizes that viewing information across large spreadsheets and entering the same data into multiple systems would consume time, delay visibility, and introduce more opportunities for human error.

Rather than waiting until month-end to post interest and related activity, Adams prefers to record information as close to real time as possible so that she has a complete picture of the portfolio throughout the month.

“Maintaining up-to-date entries lets us track our portfolio in real time rather than waiting until the end of the month. I do it daily, so that is a real time-saver for me. Plus, it keeps our numbers at our fingertips anytime we need them.”

Amy Adams, Treasury and Investment Analyst

The solution: Daily automation and a single source of truth

Park National Bank uses TPG Software to automate investment accounting activity and maintain key portfolio information in one system. Nightly processing supports entries related to interest, accretion, amortization, and other investment activity, allowing Adams to review activity and keep reconciliations current throughout the month.

“Everything runs nightly, so I can keep up with my reconciliations,” Adams said. “If something goes awry during the month, I can identify it then instead of waiting until month-end.”

Adams also uses automated extracts from TPG Software to feed investment data into the bank’s asset/liability management software. This integration reduces the need to manually rekey information and helps the bank use consistent data across its processes.

“The extracts feed into our ALM software, and that is an automatic process,” Adams said. “It is a big time-saver compared with manually keying the information into another system.”

Beyond investments, TPG Software can support other types of instruments and funding sources, including borrowings and brokered certificates of deposit. Keeping this information within the software helps reduce the bank’s dependence on separate spreadsheets. And instead of hunting through large files or maintaining single-entry data in multiple places, Adams and her team can work from one reliable source.

“I have complete confidence in the data inputs,” Adams said. “It is a single source of truth for our group.”

The results: Efficiency, confidence, and stronger controls

TPG Software has become an established part of Park National Bank’s investment accounting process. Adams said the bank has built a workflow around the software that would be difficult to replace.

The primary benefits include:

Daily efficiency: Automated nightly processing reduces manual work and gives Adams current information throughout the month.

Faster reconciliations: Daily entries allow the team to reconcile activity regularly and address discrepancies before month-end.

Trusted calculations: Adams can rely on the system’s accounting calculations without independently recreating or repeatedly validating them in spreadsheets.

Consistent data: Automated extracts provide the bank’s asset/liability management software with information from the same trusted source.

Reduced spreadsheet risk: Investments, borrowings, and related activity can be maintained within TPG Software rather than across separate spreadsheets that may be vulnerable to manual errors.

Audit support: System-generated calculations and transaction histories give auditors greater confidence than information maintained solely in Excel.

Compliance confidence: The software preserves a track record of data and transactions, helping Adams demonstrate how activity was calculated and recorded.

“Our auditors appreciate that the investments and borrowings are calculated in TPG Software instead of being maintained on an Excel spreadsheet, where there could be room for human error,” Adams said.

For Adams, those benefits extend beyond individual features. The software provides the consistency and confidence she needs to manage an important and increasingly complex function efficiently.

2026 state of loan review: Benchmark survey findings and emerging trends

This webinar will cover the key findings from the 2026 Loan Review Benchmark Survey, with a focus on why many teams are holding steady as staffing changes, technology adoption, and uncertainty reshape loan review. Presenters will also discuss signs of progress, including a renewed focus on loan review independence and its role in grading decisions.