📊CSV Import Templates

Bank Statement Format

Standard bank statement CSV export format for reconciliation.

Explanation

Common format used by banks for statement exports and accounting software imports.

Examples

Bank Statement CSV

Output

date,description,debit,credit,balance
2024-12-01,Opening Balance,,,5000.00
2024-12-02,Check #1234,150.00,,4850.00
2024-12-03,Deposit,250.00,5100.00
2024-12-05,ATM Withdrawal,100.00,,5000.00

Code Examples

JavaScript

// Parse bank statement and calculate balances
function parseBankStatement(csv) {
  const lines = csv.split('\n').slice(1);
  let runningBalance = 0;
  
  return lines.map(line => {
    const [date, description, debit, credit, balance] = parseCSVLine(line);
    
    const transaction = {
      date: new Date(date),
      description,
      debit: debit ? parseFloat(debit) : 0,
      credit: credit ? parseFloat(credit) : 0,
      balance: parseFloat(balance)
    };
    
    // Verify balance calculation
    runningBalance += transaction.credit - transaction.debit;
    if (Math.abs(runningBalance - transaction.balance) > 0.01) {
      console.warn('Balance mismatch at', date);
    }
    
    return transaction;
  });
}

Try it Now

Open in CSV/JSON Converter

💡 Tips

Separate columns for debit and credit
Include running balance for verification
Use consistent decimal places (2 for currency)
Sort by date ascending
Include opening balance row

⚠️ Common Pitfalls

Balance rounding errors can accumulate
Missing transactions break reconciliation
Different banks use different formats
Pending transactions may not appear