Importing Disbursements

Edited

Easily bring your disbursement data into Campaign Deputy by following the steps below. This article covers where to find the import tool, how to prepare your file, required fields and formatting rules, and troubleshooting tips.

1. Overview

The Disbursements Import tool lets you bulk-upload reimbursements, vendor payments, or any out-of-pocket expenses directly into your Campaign Deputy account. This helps you:

  • Reduce manual data entry errors

  • Sync disbursement data across your team in seconds


2. Preparing Your File

The import tool accepts CSV, XLS, XLSX files. Before uploading, ensure your file meets these formatting requirements:

  • Separate Required Columns:

    • Person First Name

    • Person Last Name

    • Organization Name

    • Date

    • Amount

    • Disbursement Code

  • Required Columns:

    • Date

    • Amount

    • Disbursement Code

  • Date Format: Use a full four-digit year (e.g., 06/30/2025).

  • Organization vs. Person: Organization Name must be in its own column, not combined with first or last name.

Sample CSV Layout

First Name

Last Name

Organization

Date

Amount

Disbursement Code
EXAMPLE

Alex

Doe

06/15/2025

125.00

Overhead Expenses

Campaign Deputy

06/02/2025

200.50

Polling Expenses


4. Finding Your Disbursement Codes

To view or verify your available disbursement codes:

  1. In the right-hand menu, go to Actions → Disbursement Codes.

  2. You will receive an excel file with a list of your Disbursement Codes for your account. These are different for each account.

Keep this list handy when preparing your file to ensure you use valid codes.


5. Importing Your File

  1. On the People → Import page, Click Import, click Choose File.

  2. Select your prepared file.

  3. Click Import.

  4. Campaign Deputy will validate your file:

    • Missing required columns

    • Incorrect date formats

    • Invalid disbursement codes

  5. If validation passes, you’ll see a preview of the first few rows. Review for accuracy, then click Confirm Import.


6. Post-Import Review

  • Success Message: A summary of imported rows and any skipped entries.

  • Error Log: If any rows failed, download the error log to see which lines need correction.


8. Troubleshooting

Issue

Solution

“Missing required column: Date”

Ensure you map a Disbursement Date column.

“Invalid date format”

Convert all dates to MM/DD/YYYY. Two digit years are not accepted.

“Unknown disbursement code”

Confirm the code against Actions → Disbursement Codes; correct any typos.

“Failed rows in import log”

Download the error log, fix the issues in your file, and re-upload only the failed rows.