Questions? We have answers.

Convert negative credit values into positives

Article author
Jonathon Plowman-Samson
  • Updated

Summary 

The following article articulates how to convert negative credit values into positive values.


Overview

If the data contains separate Debit and Credit columns, all numbers in the file must appear using a positive balance before the file is imported into MindBridge.

Because MindBridge automatically converts the "credit" column into negative values, importing a credit column with negative values will result in a double negative.

Note: If the data file contains a single "Amount" column, debits will be displayed as positive and credits will be displayed as negative. 

Convert negative credit values into positives

  1. Select the entire column you want to convert.
  2. Copy the column by pressing Ctrl+C on PC or ⌘C on Mac.
  3. Right-click within the first cell in any blank column and select Paste Special.
  4. Select Subtract under the section called Operation.
  5. Select OK.
  6. Rename your old and new columns as needed.
  7. Save your file. 


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related articles

Share this article on

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.