Bank Statement Converter

Prerequisites:

• QuickBooks Online or Desktop subscription
• Converted Excel (.xlsx) or CSV file from our converter
• Bank account already set up in QuickBooks chart of accounts

QuickBooks Online - Import Steps:

1. Log in to QuickBooks Online
2. Go to Banking → Upload transactions
3. Click Browse and select your converted file
4. Select the bank account from your chart of accounts
5. QuickBooks auto-maps columns (Date, Description, Amount)
6. Verify the mapping is correct:
   • Date → Transaction date
   • Description → Transaction description/payee
   • Amount → Transaction amount (debits are negative)
7. Click Next to review import preview
8. Click Let's go to complete the import
9. Transactions appear in your bank feed for reconciliation

QuickBooks Desktop - Import Steps:

1. Open QuickBooks Desktop
2. Go to Banking → Import Bank Statements
3. Select your bank account
4. Browse and select the converted file
5. Map columns: Date, Description, Debit, Credit, Balance
6. Set date range for import
7. Review and complete import

Prerequisites:

• Xero organization with standard or advisor role
• CSV file from our converter (Xero format)
• Bank account already set up in Xero

Xero Import Steps:

1. Log in to Xero
2. Navigate to Accounting → Bank accounts
3. Select the bank account you want to import into
4. Click Manage account → Import a statement
5. Select the CSV file from our converter
6. Choose the correct date format (our CSV uses YYYY-MM-DD)
7. Map the columns:
   • Date → Statement date
   • Description → Payee/description
   • Debit → Money out/spending
   • Credit → Money in/income
   • Balance → Running balance (optional)
8. Preview the statement data to verify accuracy
9. Click Import to process the statement
10. Transactions appear in bank reconciliation screen

Basic Excel Workflow:

1. Open the file: Double-click your converted Excel file
2. Review the data: Check for any formatting issues or missing transactions
3. Sort by date: Data → Sort → Sort by Date (oldest first)
4. Add filters: Data → Filter to easily find specific transactions
5. Add categories: Insert a new column and categorize each transaction
6. Create pivot tables: Insert → PivotTable to summarize by category or date

Useful Excel Formulas:

Creating Analysis Reports:

1. Create a Pivot Table: Insert → PivotTable → Select data range
2. Add "Date" to Rows (group by Month)
3. Add "Category" to Columns
4. Add "Amount" to Values
5. Create charts: Insert → Column Chart for spending trends

Universal CSV Compatibility:

Our CSV files work with virtually any accounting software that accepts CSV imports. The format includes standard headers, proper encoding, and data types.

Supported Software:

• FreshBooks: Banking → Upload Statement → Select CSV
• Wave Accounting: Banking → Import Statement → CSV format
• Sage 50: Tasks → Import Records → Bank Statements
• Zoho Books: Banking → Import Transactions
• MYOB: Banking → Import Bank Statement
• Simply Accounting: Import → Bank Statements

General CSV Import Steps:

1. Locate import function (usually under Banking or Transactions)
2. Select CSV as import format
3. Upload our CSV file
4. Verify column mapping (Date, Description, Debit, Credit)
5. Set date format if prompted (YYYY-MM-DD)
6. Preview and import