SIMCOEXMARKETPLACE
Utilities/Region Calendar Converter
📅
Finance Tools

Region Calendar Converter

Convert Gregorian (TrnDate) columns to Shamsi & Qamari dates, append new columns, summarize TrnAmount by Shamsi month, and generate journal entries — all in one Excel output.

XLSXXLS
1
Upload Excel→
2
Convert Dates→
3
Summary + Journal→
4
Download Result

Drop your Excel file here

or click to browse

xlsxxls

Max file size: 50MB

What gets added

  • Shamsi Date (YYYY/MM/DD)
  • Shamsi Year
  • Shamsi Month No
  • Shamsi Month Name
  • Qamari Date (YYYY/MM/DD)
  • Qamari Year
  • Qamari Month No
  • Qamari Month Name
  • New sheet: Summary & Journal

Input Requirements

  • Excel file (.xlsx or .xls)
  • TrnDate column (Gregorian)
  • Format: YYYY-MM-DD
  • Trn Amount column
  • Debit & Credit Account columns

Journal Entry Format

Shamsi Month | Debit Account

Shamsi Month | Credit Account

Amount = Sum of TrnAmount

Grouped by Shamsi Month