DocuClipper logo
Docs/Help Center
Bank Statements

How To Assign Transactions To Multiple Accounts

When processing a statement with multiple accounts or months, DocuClipper might assign all the transactions to a single account. This guide will help you correctly assign transactions.

Last updated

When a PDF contains statements for multiple accounts (e.g., checking and savings) or multiple months, DocuClipper may initially group all transactions under a single account or period. This guide shows how to assign them correctly.

Step 1: Identify the issue

Open the converted project's Transactions tab and use the Account selector (labeled Account (N available)) to switch between accounts. If all transactions appear under a single account when your PDF has multiple, you'll need to re-assign them. The Accounts tab lists the accounts DocuClipper detected automatically, but assignment itself happens here on Transactions.

The Account (N available) selector in the Transactions view, used to switch between the accounts detected in the statement

Step 2: Assign transactions to the correct account and period

  1. In the transactions table, check the boxes next to the transactions you want to move.
  2. In the bulk-actions toolbar, click Assign To Account/Period.
  3. If the target account doesn't exist yet, click Add Account/Period and fill in the new-account form: Account Name (e.g., "Checking" or "Savings"), Start Date and End Date (typed as YYYY-MM-DD), and the Start Balance and End Balance. Click Add New Account.
  4. Select the target account/period and confirm.

The Assign To Account/Period modal with an Account/Period selector and the Add Account/Period link for creating a new account

Step 3: Reconcile the period

After assigning, check the Summary panel for the period:

  1. Set the Start Balance and End Balance to match the printed values on the original statement.
  2. Set the From and To dates if they're missing.
  3. Confirm the period shows the Reconciled badge. If it shows Not Reconciled, review for missing or incorrect transactions and fix them. See Fixing missing or wrong transactions.

The Add New Account form with fields for Account Name, Start Date, End Date, Start Balance, and End Balance, and the Add New Account button

Step 4: Repeat for remaining accounts/periods

Follow the same steps for each additional account or period in the document until all periods are reconciled.

To follow money between accounts once they're assigned — transfers and flow of funds — use the Flow of Funds view under Advanced Analysis (Business and Enterprise plans).

Related