DocuClipper logo
Troubleshooting

Debits and Credits Are Backwards

If all transactions show the wrong sign after conversion, use Switch credits/debits to flip them in bulk. Common causes explained.

Last updated

When every transaction in a converted statement has the wrong sign (deposits showing as debits and withdrawals as credits), it's usually one of two things:

  • Your statement uses an unusual convention (some credit card or business account statements show payments and charges in reversed columns).
  • The importing system's expectation of "debit = negative" vs "credit = positive" is the opposite of DocuClipper's.

Both are fixable without re-uploading.

Fixing all transactions at once

  1. Open the converted statement.
  2. In the transactions table, select the checkbox in the header row to select every row on the current page.
  3. To extend the selection to every page, click Select all in the bulk-actions toolbar that appears above the table.
  4. Click Switch credits/debits in that toolbar.
  5. The Reconciled totals update automatically. Verify them against the printed statement totals.

The bulk-actions toolbar with Select all and Switch credits/debits

Fixing only specific transactions

If only some rows are flipped (rare, but common with adjustments or fees):

  1. Use the filter row directly under each column header to narrow down (e.g. filter by description or amount).
  2. Check the boxes next to each affected row.
  3. Click Switch credits/debits in the bulk-actions toolbar.

To flip a single transaction, click its Amount cell and use the +/- button to flip the sign in place.

Before exporting

If you're about to import into QuickBooks, Xero, or another accounting system and you're unsure about sign convention, convert a single-month test file first and preview a few transactions in the target system. Flip signs in DocuClipper before re-exporting if needed.

Related