Questions? We have answers.

Converting Negative Credit Values into Positives

Article author
Jonathon Plowman-Samson
  • Updated

Summary 

The following article would show how to convert the negative credit values into positives.


Resolution

If your data file contains separate Debit and Credit columns, all numbers in the file must be default positive balance before importing the file into MindBridge. 

Here is an example of a negative credit value that must be converted:

image_-_2021-01-07T125219.135.png

Note: if your data file contains a single "Amount" column, debits will be positive and credits will be negative. 

 

Begin by selecting the column for conversion by clicking the column's header/name. In this example, we are converting column G: 

2019-06-18_16-02-15.png

 

Hit Ctrl-C on PC or ⌘C on Mac to copy. Right click at the top of a blank column. Select Paste Special, then Subtract under Operation:

mceclip1.pngmceclip2.png

 

Rename the headers of your old and new columns as needed.

 
 

Re-save your file. 


Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


Related articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.