Select Primary Account

Destination Account

@for (acc of filteredAccounts(); track acc.id) { {{ acc.name }} }

Upload Excel or CSV Statement

Select Sheet

Sheet Name

@for (sheet of availableSheets(); track sheet) { {{ sheet }} }

Column Mappings

Date Column

@for (h of currentHeaders(); track h) { {{ h }} }

Other Account Column

-- None -- @for (h of currentHeaders(); track h) { {{ h }} }

Narration / Description

-- None -- @for (h of currentHeaders(); track h) { {{ h }} }

Amount Mapping

Amount Column (Single)

-- None -- @for (h of currentHeaders(); track h) { {{ h }} }

Use this if amount is one column (+/-)

OR

Debit Column

-- None -- @for (h of currentHeaders(); track h) { {{ h }} }

Credit Column

-- None -- @for (h of currentHeaders(); track h) { {{ h }} }

Fallback Account

Default Account (if unmapped)

-- None -- @for (acc of accounts(); track acc.id) { {{ acc.name }} }

Selected: {{ totalSelected() }}

Total Debit: {{ totalDebit() | number: '1.2-2' }}

Total Credit: {{ totalCredit() | number: '1.2-2' }}

		Date	{{ row.date_ \| date: 'mediumDate' }}	Other Account	@for (acc of filteredAccounts(); track acc.id) { {{ acc.name }} } @if (!row.account_id) { Not Mapped }	Narration	{{ row.narration }}	Debit	{{ row.debit \| number: '1.2-2' }}	Credit	{{ row.credit \| number: '1.2-2' }}	Status	@if (row.is_valid) { check_circle } @else { error }