Account Mapping Tool

Loading...

Current Project:

Step 1: Upload Files & Setup

Current Files

📊

Source P&L Workbook

No file loaded

📈

Rolling P&L Workbook

No file loaded

Select new source and rolling P&L files for the target month

Step 1: Select Source P&L File

Step 2: Select Rolling P&L File

Preparing to update files... 0%

Ready to start

Define Excel Ranges

Source Range:

Rolling Range:

Rolling Sheet:

Step 2: Map Accounts

Export as JSON Export as Excel

	Account Description	Source Amount	Mapped Account	Confidence

✓

Project loaded with stored data

Step 3: Generate Monthly P&L Statement

Preview - Rolling P&L Statement

Account Description	Previous Month 2	Previous Month	Current Month

Step 4: Finalize & Export

Processing...

Edit Mapping

Source Account:

Search Rolling Account: Rolling Account:

Range Preview

Map Accounts -

Export JSON Export Excel

	Account Description	Source Amount	Mapped Account	Confidence

Generate Monthly Statement -

Statement Preview

Target Month:

Account Description	Previous Month 2	Previous Month	Current Month

© 2025 by California Private Capital Group, LLC. All rights reserved