Summary
The following article details how to convert negative numerical credit values into positive numerical values.
Overview
If the data contains separate Debit and Credit columns, all numbers in said columns must be default positive balance (excluding reverse entries) 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 need to be positive and credits negative.
Convert negative credit values into positives
- Select the entire column you want to convert.
- Copy the column by pressing Ctrl+C on PC or ⌘C on Mac.
- Right-click within the first cell in any blank column and select Paste Special.
- Select Subtract under the section called Operation.
- Select OK.
- Rename your old and new columns as needed.
- Save your file.
Anything else on your mind? Chat with us or submit a request for further assistance.