Bank transaction categorizer.

Export the Excel workbook with "Business transactions only" ticked and the tax year selected. The first two tabs are what an accountant actually needs: an "All Transactions" ledger with the business, refund and notes columns, and a "Tax Summary" tab that rolls your categories up by tax-form line and shows what was spent, the recoverable sales tax, and the claimable amount. The PDF report carries the same summary if they prefer a document.

Every transaction has a business checkbox in the table, and bulk edit can set it for a whole selection at once. Once any row is flagged, the Tax Summary defaults to business rows only and says so in its scope note. The Reports tab has a matching scope toggle, and the export has a "Business transactions only" checkbox.

On the Categories tab you can map each category to a line on the CRA T2125 or the IRS Schedule C. The Tax Summary then totals your spending by that line instead of by your own category names, which is the form your accountant transcribes from. It is optional: anything you leave unmapped is listed in an "Unmapped" section rather than being dropped, so nothing disappears quietly.

Yes. Each category can carry a claimable percentage, so meals can be set to 50 percent. For home and vehicle costs you set a business-use percentage once in Deduction settings and every category on those lines inherits it. Categories flagged as capital assets are listed separately rather than expensed, because they belong to capital cost allowance or depreciation.

If you are registered and claim input tax credits, tick "includes tax" on the categories whose amounts are tax-inclusive and pick your rate in Deduction settings. The Tax Summary then splits each amount into its pre-tax base and the recoverable tax, and computes the claimable figure from the pre-tax base so you are not deducting tax you already recovered. If you are not registered, leave the flag off and the full amount is used.

The importer detects the layout automatically for RBC, TD, Scotiabank, BMO, CIBC and Tangerine exports, and for most other banks by reading the column headers or the shape of the data. Before anything is saved it shows you the columns it picked and a preview of the parsed rows, so you can correct the mapping if a file is unusual. Credit-card exports where every charge is positive are detected too.

Duplicates are skipped. A row is considered already imported when the date, description and amount all match something you have, and the upload message tells you how many were skipped. Two genuinely identical transactions on the same day still both import when neither is already stored.

No. This tool organizes your own numbers and totals them the way the forms are laid out. The line numbers, percentages and tax rates are yours to confirm against the current CRA or IRS guide, and your accountant should review the result before you file.

The Bank Transaction Categorizer is a powerful financial tool designed to help individuals and businesses organize their bank transactions. It allows you to upload CSV statements, automatically categorizes transactions using AI and keyword matching, and generates detailed spending reports.

Yes, the core features of the Bank Transaction Categorizer are utilizing the free tier of our platform. We may introduce premium features for advanced reporting or team collaboration in the future, but the essential categorization functionalities remain accessible.

Yes, an account is required to use this tool. This ensures that your transaction data, categories, and settings are securely saved and accessible across your devices whenever you log in.

Security is our top priority. Your transaction data is stored in our secure database using industry-standard encryption. We verify all requests with strict authentication protocols to ensure only you can access your financial information.

Only you have access to your specific transaction data. We do not sell, rent, or share your personal financial data with third parties. Our administrative access is strictly limited and audited for maintenance purposes only.

We use advanced AI models to analyze transaction descriptions and suggest appropriate categories. This process is automated, and the AI processes anonymized text snippets solely for the purpose of categorization. Your financial identity is inextricably linked to your secure account and is not used to train public models.

We support most standard CSV exports from major banks. The tool intelligently identifies columns for "Date", "Description", and "Amount". If your file has a different structure, you can manually map the columns during the upload process.

Absolutely. You can create, rename, and delete custom categories to match your specific budgeting needs. You can also organize them into parent and child categories for more granular tracking.

Yes! You can export your categorized transactions at any time. We support exporting to Excel (.xlsx) formats, which allows you to take your organized data into other accounting software like QuickBooks or Xero.

Currently, the tool treats all numbers as raw values. While you can upload transactions in different currencies, we recommend keeping separate workspaces or using a consistent currency for accurate reporting totals.

By using this tool, you agree to use it only for lawful purposes. You represent that you are the owner of the financial data you upload or have explicit permission to manage it. Uploading malicious files or attempting to exploit the system is strictly prohibited.

The Bank Transaction Categorizer is provided "as is" without any guarantees. While we strive for accuracy, we are not responsible for any financial decisions made based on the categorization or reports provided by this tool. Always consult with a qualified accountant for professional financial advice.

To the maximum extent permitted by law, Creative Brain Inc. and its affiliates shall not be liable for any indirect, incidental, or consequential damages arising from the use or inability to use this tool, including but not limited to loss of data or financial loss.

We retain your data as long as your account is active to provide you with historical reporting. You can request the deletion of your account and all associated data at any time by contacting support. Once deleted, data cannot be recovered.