Standard Chartered Monthly Average Balance Calculator

Add Your Data

Upload CSV File

Select Standard Chartered account statement CSV file:

Paste from SCB Website

Paste HTML from SCB Account History (table or larger page section):

Copy HTML from Account History in SCB online banking. Paste each page and click Merge — new transactions are added, duplicates are updated. Include the account dropdown so your account number is detected. Use cmd + option + j to toggle Chrome DevTools in dev mode to find the HTML.

How to Add Your Data

• CSV upload: Export your Standard Chartered account statement as CSV

• SCB website paste: On Account History, right-click the page → Inspect → copy the outer HTML (or at least the section with the account dropdown and transaction table). Paste and click Merge. Repeat for each page of transactions.

• File / table should contain columns: Date, Transaction, Currency, Deposit, Withdrawal, Running Balance

• Date format: DD/MM/YYYY

• Running Balance should include "CR" suffix for credit balances

• Multi-account: Each account is stored separately. Add data for different accounts and switch between them using the account tabs above.

• Manual amendments: Edit any day's end-of-day balance in the daily breakdown. Changes are saved automatically and preserved when you upload an updated CSV or merge new HTML.

• VALUE DATE support: Transactions with "VALUE DATE" in description will use the value date for calculations

How to Use

Add your data via CSV upload or by pasting HTML from SCB Account History. For HTML, paste each page and click Merge to build up your full transaction history.
The calculator will automatically parse all transactions and calculate monthly average balances for each month (current month appears first)
Review the results showing daily balances and running monthly averages. Click the edit icon on any day to manually amend the end-of-day balance — the monthly average will recalculate automatically.
Your data and manual amendments are saved automatically in your browser, per account. Merging new HTML or uploading a new CSV for the same account refreshes its transaction data but keeps your saved balance amendments.
Use the Balance Planning Tool to set a planned balance for remaining days and see how it affects your monthly average

Forward/Backfill Logic: For days without transactions, the calculator uses the previous day's balance (forward fill). For the first days of the month without transactions, it uses the next available day's balance (backfill) however this often leads to inaccurate monthly average balance.

VALUE DATE Processing: When transactions contain "VALUE DATE" in the description, the calculator moves them to their effective date and recalculates the balance using the previous day's balance + transaction amount. This ensures accurate monthly averages when deposits/withdrawals have different effective dates. Transactions with value dates are marked with a blue badge, and balances that were recalculated due to VALUE DATE processing are marked with an orange badge.